Simple Machines Community Forum

Customizing SMF => SMF Coding Discussion => Topic started by: Skoen on March 14, 2004, 10:13:17 PM

Title: SQL error when changing guest theme
Post by: Skoen on March 14, 2004, 10:13:17 PM
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
Title: Re: SQL error when changing guest theme
Post by: [Unknown] on March 14, 2004, 10:40:06 PM
Fixed... dumb typo...

-[Unknown]
Title: Re: SQL error when changing guest theme
Post by: Skoen 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
Title: Re: SQL error when changing guest theme
Post by: [Unknown] 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]
Title: Re: SQL error when changing guest theme
Post by: pulpitfire on March 15, 2004, 12:53:33 AM
Quote from: [Unknown] on March 14, 2004, 11:20:37 PM
... "1,2,3,4" instead of "1,2,3,4,"... :-\
Title: Re: SQL error when changing guest theme
Post by: [Unknown] on March 15, 2004, 01:03:40 AM
The comma at the end is what is causing the problem.

-[Unknown]
Title: Re: SQL error when changing guest theme
Post by: Skoen on March 15, 2004, 08:22:47 AM
Fixed, thanks. The value in my database was 1,, instead of 1,2