forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 install => Topic started by: alabee on September 20, 2011, 04:57:59 am

Title: ERROR
Post by: alabee on September 20, 2011, 04:57:59 am
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.
Title: Re: ERROR
Post by: Α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.
Title: Re: ERROR
Post by: alabee on September 20, 2011, 12:06:30 pm
ok, am trying it right away. will give you feedback right after. thanks.
Title: Re: Re: ERROR
Post by: alabee on September 20, 2011, 03:23:30 pm
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.
Title: Re: ERROR
Post by: Αndré on September 20, 2011, 03:51:01 pm
Please
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.