Hello,
Here are my steps to transfer my gallery to a new host:
1. copy all the files under 4image to the new space
2. use "Download a MySQL Database Backup" in "Backups in Cpanel" and restore the backup file to the new site
3. add the datebase user name and add it to the database restored in step 2 (the username is different the one in the old host, but I've modified it in config.php)
4. Then, I saw the following error message in the frontpage:
An unexpected error occured. Please try again later.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sleepy7/public_html/album/includes/db_mysql.php on line 116After I logged in, the error message became:
DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0, 16, 2, 1, 11, 3, 17, 5, 9, 7, 8, 18, 6, 10, 19, 12, 13, 14, 4, 15) ORDER BY RAND() LIMIT 4
Unknown column 'i.user_id' in 'on clause'
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sleepy7/public_html/album/includes/db_mysql.php on line 116Except for the frontpage, other pages worked fine without any problem.
Does anyone know what happened to my gallery??? The mod I used in the frontpage is only "add more random images".
Here's the correct album:
http://album.sleepy.tw/Here's the new one with problem:
http://garm.lunarservers.com/~sleepy7/album/Thank you very much...