News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

SQL error when changing guest theme

Started by Skoen, March 14, 2004, 10:13:17 PM

Previous topic - Next topic

Skoen

I'm trying to change the guest theme for my forum.
I get this error:

QuoteYou 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


[Unknown]


Skoen

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


[Unknown]

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]

pulpitfire


[Unknown]

The comma at the end is what is causing the problem.

-[Unknown]

Skoen

Fixed, thanks. The value in my database was 1,, instead of 1,2
Alf Otto 'Skoen' Fagermo
Retired Norwegian translator


Advertisement: