| Author |
 Topic  |
|
|
cparkes
Starting Member
4 Posts |
 Posted - 27 March 2001 : 21:42:01
|
Howdy do,
I've just downloaded Snitz and installed it on my system. What beautiful code! Everything has worked like a charm... until this very moment.
I've been tweaking the colors in the Font/Table Color Code Configuration area. For a while it worked, but all of a sudden I began getting this error:
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/forum/admin_config_colors.asp, line 92
Any clues?
Many thanks to any brave genius who can help!
Clara |
|
|
RaiderUK
Average Member
United Kingdom
577 Posts |
Posted - 28 March 2001 : 06:53:45
|
what are the lines of code on line 92?
|
 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 28 March 2001 : 09:39:02
|
Clara, right before line 92 of your admin_config_colors.asp file, put this code: Response.Write(strSql).
Then when you click Submit and you get the error, copy and paste the code that you see appear above the error, here.
|
|
|
|
cparkes
Starting Member
4 Posts |
Posted - 28 March 2001 : 10:59:17
|
quote:
Clara, right before line 92 of your admin_config_colors.asp file, put this code: Response.Write(strSql).
Then when you click Submit and you get the error, copy and paste the code that you see appear above the error, here.
Hi - thanks for the quick reply! Here goes:
UPDATE FORUM_CONFIG SET C_STRDEFAULTFONTFACE = 'Verdana, Arial, Helvetica', C_STRDEFAULTFONTSIZE = '2',
C_STRHEADERFONTSIZE = '4', C_STRFOOTERFONTSIZE = '1', C_STRPAGEBGCOLOR = 'white',
C_STRDEFAULTFONTCOLOR = 'black', C_STRLINKCOLOR = 'darkblue', C_STRLINKTEXTDECORATION = 'underline',
C_STRVISITEDLINKCOLOR = 'blue', C_STRVISITEDTEXTDECORATION = 'underline', C_STRACTIVELINKCOLOR = 'red',
C_STRHOVERFONTCOLOR = 'red', C_STRHOVERTEXTDECORATION = 'underline', C_STRHEADCELLCOLOR = 'darkgray',
C_STRHEADFONTCOLOR = 'black', C_STRCATEGORYCELLCOLOR = 'wheat', C_STRCATEGORYFONTCOLOR = 'black',
C_STRFORUMFIRSTCELLCOLOR = 'blanchedalmond', C_STRFORUMCELLCOLOR = 'blanchedalmond',
C_STRALTFORUMCELLCOLOR = 'gainsboro', C_STRFORUMFONTCOLOR = 'midnightblue', C_STRFORUMLINKCOLOR =
'darkblue', C_STRTABLEBORDERCOLOR = 'white', C_STRPOPUPTABLECOLOR = 'wheat', C_STRPOPUPBORDERCOLOR =
'oldlace', C_STRNEWFONTCOLOR = 'blue', C_STRTOPICWIDTHLEFT = '100', C_STRTOPICNOWRAPLEFT = 1, 0,
C_STRTOPICWIDTHRIGHT = '100%', C_STRTOPICNOWRAPRIGHT = 0 WHERE CONFIG_ID = 1
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 28 March 2001 : 20:03:42
|
I see the problem. This code C_STRTOPICNOWRAPLEFT = 1, 0, should either be 1 or 0, not both. I tested it on my server but couldn't reproduce it.
Could you send me your admin_config_colors.asp file so i can take a look at it?
Edited by - Davio on 28 March 2001 20:05:03 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 30 April 2001 : 01:36:56
|
Do you have a URL where we can look at your forum?
Also, if you don't mind, could you change the Admin password back to admin so we can access admin_config_colors.asp ?
|
|
|
|
AR
Starting Member
17 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 30 April 2001 : 01:49:42
|
| continued in your other thread.... |
|
|
| |
Topic |
|
|
|
Topic Locked
