ZenphotoCMS Forum
Problem after upgrading 1.4.5.6 - Printable Version

+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: Problem after upgrading 1.4.5.6 (/thread-11452.html)



Problem after upgrading 1.4.5.6 - EricBD - 2013-11-03

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...




Problem after upgrading 1.4.5.6 - sbillard - 2013-11-03

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.




Problem after upgrading 1.4.5.6 - EricBD - 2013-11-04

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




Problem after upgrading 1.4.5.6 - sbillard - 2013-11-04

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.




Problem after upgrading 1.4.5.6 - EricBD - 2013-11-06

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




Problem after upgrading 1.4.5.6 - sbillard - 2013-11-06

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




Problem after upgrading 1.4.5.6 - EricBD - 2013-11-07

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