i got this error while installing:
ERROR
The following errors were encountered and need to be corrected first:
MySQL 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 'INSEREPLACE INTO photo_config VALUES ('thumb_method', 'im')' at line 1 on query ' INSEREPLACE INTO photo_config VALUES ('thumb_method', 'im')'
Trying to insert data in the database.
Creating table 'photo_albums' Status:... OK
Creating table 'photo_banned' Status:... OK
Creating table 'photo_bridge' Status:... OK
Creating table 'photo_categories' Status:... OK
Creating table 'photo_categorymap' Status:... OK
Creating table 'photo_comments' Status:... OK
Creating table 'photo_config' Status:... OK
Creating table 'photo_dict' Status:... OK
Creating table 'photo_ecards' Status:... OK
Creating table 'photo_exif' Status:... OK
Creating table 'photo_favpics' Status:... OK
Creating table 'photo_filetypes' Status:... OK
Creating table 'photo_hit_stats' Status:... OK
Creating table 'photo_languages' Status:... OK
Creating table 'photo_pictures' Status:... OK
Creating table 'photo_plugins' Status:... OK
Creating table 'photo_sessions' Status:... OK
Creating table 'photo_temp_messages' Status:... OK
Creating table 'photo_usergroups' Status:... OK
Creating table 'photo_users' Status:... OK
Creating table 'photo_votes' Status:... OK
Creating table 'photo_vote_stats' Status:... OK
any help pls. thanks.
Replace sql/basic.sql with a fresh copy from the Coppermine package on your server and try again.
ok, am trying it right away. will give you feedback right after. thanks.
Quote from: Αndré on September 20, 2011, 10:20:17 AM
Replace sql/basic.sql with a fresh copy from the Coppermine package on your server and try again.
i did just dat and bingo! everything went through successfully. Thanks.
Please
Quote from: Joachim Müller on September 28, 2008, 12:46:26 PM
tag your answer as "solved" by clicking on the "Topic Solved" button on the bar at the left hand side at the bottom of your thread.