News:

Wondering if this will always be free?  See why free is better.

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: