Member
Member
EricBD   2013-11-03, 11:14
#1

Error below after trying to do a restore :

ERREUR GÉNÉRÉE PAR L’UTILISATEUR : Erreur MySQLi : SHOW FULL COLUMNS FROM [Préfixe]admintoobject a échoué. MySQLi a renvoyé l’erreur Table 'mytable._admintoobject' doesn't exist dans /home/users3/b/espacet/www/globaux/zp-core/functions-db-MySQLi.php à la ligne 78

trigger_error called from query (functions-db-MySQLi.php [78])

from db_show (functions-db-MySQLi.php [298])

from db_list_fields (functions-db-MySQLi.php [309])

from backup_restore.php [282]

All is working correctly except a restore...

Member
Member
sbillard   2013-11-03, 19:00
#2

Something is wrong with the tables. The actual table name would be [i]prefix[/i]admin_to_object. The query you show has left out the underscores.
I have no clue as to why the name would be wrong in the backup, but the only side-effect might be that some user "managed objects" would be lost. If you have not used that feature then no harm is done.

Member
Member
EricBD   2013-11-04, 11:38
#3

I found, i have no prefix for the table, then the table name begin with _ (underscore)

Member
Member
sbillard   2013-11-04, 17:27
#4

It was the missing underscores WITHIN the table name that was the issue. And anyway, if there is an underscore in front of the table name then underscore is the prefix.

Member
Member
EricBD   2013-11-06, 08:46
#5

There is the _ in the table name, but the restore does not work in that case.

Member
Member
sbillard   2013-11-06, 17:53
#6

Ok. there is a fix in the support build for this.

Member
Member
EricBD   2013-11-07, 09:56
#7

Thanks Stephen, on my test system i don't put the prefix, i thinks that he needs to be mandatory during the installation.

  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.