Advertisement:

Author Topic: SQL error when changing guest theme  (Read 14200 times)

Offline Skoen

  • Language Moderator
  • SMF Friend
  • Sr. Member
  • *
  • Posts: 872
  • Gender: Male
  • I'm a shoe, so don't step on me ;)
    • Radio 3 Norge
SQL error when changing guest theme
« on: March 14, 2004, 10:13:17 PM »
I'm trying to change the guest theme for my forum.
I get this error:

Quote
You have an error in your SQL syntax near ')
LIMIT 12' at line 5
Fil: /hsphere/local/home/dataport/dataportalen.com/forum/Sources/Themes.php
Linje: 397
Alf Otto 'Skoen' Fagermo
Retired Norwegian translator


Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: SQL error when changing guest theme
« Reply #1 on: March 14, 2004, 10:40:06 PM »
Fixed... dumb typo...

-[Unknown]

Offline Skoen

  • Language Moderator
  • SMF Friend
  • Sr. Member
  • *
  • Posts: 872
  • Gender: Male
  • I'm a shoe, so don't step on me ;)
    • Radio 3 Norge
Re: SQL error when changing guest theme
« Reply #2 on: March 14, 2004, 11:03:29 PM »
Then I need to re-download the sql file and run upgrade.php again, or do I just have to re-download to get the correct Sources/Themes.php
Alf Otto 'Skoen' Fagermo
Retired Norwegian translator


Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: SQL error when changing guest theme
« Reply #3 on: March 14, 2004, 11:20:37 PM »
I haven't uploaded it yet...

To fix it, you can go into your settings table and find the value of the "knownThemes" row.  Change it so it looks like a normal comma separated list - like "1,2,3,4" instead of "1,2,3,4,".

-[Unknown]

Offline pulpitfire

  • Sophist Member
  • *****
  • Posts: 1,132
  • Gender: Male
  • This is what the php parser looks like.
    • Pulpitfire Devotionals
Re: SQL error when changing guest theme
« Reply #4 on: March 15, 2004, 12:53:33 AM »
... "1,2,3,4" instead of "1,2,3,4,"... :-\

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: SQL error when changing guest theme
« Reply #5 on: March 15, 2004, 01:03:40 AM »
The comma at the end is what is causing the problem.

-[Unknown]

Offline Skoen

  • Language Moderator
  • SMF Friend
  • Sr. Member
  • *
  • Posts: 872
  • Gender: Male
  • I'm a shoe, so don't step on me ;)
    • Radio 3 Norge
Re: SQL error when changing guest theme
« Reply #6 on: March 15, 2004, 08:22:47 AM »
Fixed, thanks. The value in my database was 1,, instead of 1,2
Alf Otto 'Skoen' Fagermo
Retired Norwegian translator