Trying to restore from database - original problem SOLVED

RichardB Member
edited January 6 in General support

Following on my posting below where I was unable to add a second user, I am now trying to reconstitute this zenphoto installation with a new installation (which can - I have checked - add a second, third, fourth or whatever user) but with the old albums and database.
I tried following your restore instructions to a certain extent.
I uploaded the current version 1.5.7 -
I copied into this location the existing album folder with its contents
I copied the cache and the cache-html
I copied the backup folder with the database backup
I ran setup - specified a new database - I was given the opportunity to restore
When I clicked on the restore link the process started but all I got was a blank screen.
When I checked the debug log it contained the error below (a second attempt as above produced the same error message)

Any help would be appreciated.

Thank you,

{19587:Wed, 06 Jan 2021 14:05:57 GMT}
USER ERROR: MySQLi Error: ( SHOW INDEX FROM [DB].[name_of_folder]_admin_to_object ) failed. MySQLi returned the error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-new_admin_to_object' at line 1 in /home/folder/folder/folder/zp-core/functions-db-MySQLi.php on line 95
trigger_error called from query (functions-db-MySQLi.php [95])
from query_full_array (functions-db-MySQLi.php [130])
from db_show (functions-db-MySQLi.php [327])
from backup_restore.php [288]


Sign In or Register to comment.