Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: ERROR  (Read 7582 times)

0 Members and 1 Guest are viewing this topic.

alabee

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
ERROR
« 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.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: ERROR
« Reply #1 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.
Logged

alabee

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: ERROR
« Reply #2 on: September 20, 2011, 12:06:30 pm »

ok, am trying it right away. will give you feedback right after. thanks.
Logged

alabee

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Re: ERROR
« Reply #3 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.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: ERROR
« Reply #4 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 20 queries.