Author Topic: upgrade from 1.6 to 1.7 error  (Read 5762 times)

0 Members and 1 Guest are viewing this topic.

Offline bgnm2000

  • Jr. Member
  • **
  • Posts: 56
    • View Profile
upgrade from 1.6 to 1.7 error
« on: May 07, 2003, 01:43:24 AM »
I'm getting this error code when I go to the update_1.6.1_to_1.7.php?action=updatesettings file.

Code: [Select]
DB Error: Bad SQL Query: INSERT INTO 4images_settings (setting_name, setting_value) VALUES ('auto_thumbnail_resize_type', '1')
Duplicate entry 'auto_thumbnail_resize_type' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings (setting_name, setting_value) VALUES ('user_edit_image', '0')
Duplicate entry 'user_edit_image' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings (setting_name, setting_value) VALUES ('user_delete_image', '0')
Duplicate entry 'user_delete_image' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings (setting_name, setting_value) VALUES ('user_edit_comments', '0')
Duplicate entry 'user_edit_comments' for key 1

DB Error: Bad SQL Query: INSERT INTO 4images_settings (setting_name, setting_value) VALUES ('user_delete_comments', '0')
Duplicate entry 'user_delete_comments' for key 1
An error occured while updating settings


any help would be greatly appreciated

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
upgrade from 1.6 to 1.7 error
« Reply #1 on: May 07, 2003, 02:14:27 AM »
but after that is your 4images running ok?
if ok, then dont worry about those errors.
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline bgnm2000

  • Jr. Member
  • **
  • Posts: 56
    • View Profile
upgrade from 1.6 to 1.7 error
« Reply #2 on: May 07, 2003, 02:21:57 AM »
its running but there are problems in the settings page of the control panel. it says this: next to account activation by e-mail for example. I'm getting similar errors in other parts of the settings page.

Code: [Select]

Warning: Invalid argument supplied for foreach() in /home/ejnash/public_html/bp3/admin/settings.php on line 136

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
upgrade from 1.6 to 1.7 error
« Reply #3 on: May 07, 2003, 02:32:56 AM »
did u replace all .php files with new ones?
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline bgnm2000

  • Jr. Member
  • **
  • Posts: 56
    • View Profile
upgrade from 1.6 to 1.7 error
« Reply #4 on: May 07, 2003, 03:03:50 AM »
I think so, just to be sure I can upload them again, but I don't want mess anything up, so which specific files?

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
upgrade from 1.6 to 1.7 error
« Reply #5 on: May 07, 2003, 03:16:07 AM »
well...about ALL...:? (*.php)
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline bgnm2000

  • Jr. Member
  • **
  • Posts: 56
    • View Profile
upgrade from 1.6 to 1.7 error
« Reply #6 on: May 07, 2003, 03:16:38 AM »
ok, did it, apparently the files weren't replaced during the first upload... not sure why. it works now.  :oops: