Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Aiheen aloitti: xt600 - toukokuu 02, 2006, 05:56:52 IP

Otsikko: Error: database error in SQL syntax ?
Kirjoitti: xt600 - toukokuu 02, 2006, 05:56:52 IP
SMF Version: SMF 1.1 RC2
HEllo', after a fresh installtion of SMF 1.1 RC2 on a new server with MySQL version 4.0.24, PHP versionĀ     4.3.11, Apache version 1.3.34 (Unix), Kernel version 5.4-RELEASE-p13, (and everything was OK during the installation...) and after creating my new boards if one attempts to write a new message he gets the error:
LainaaDatabase Error
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 9)' at line 3
File: /usr/home/motogasg/public_html/forum/Sources/MessageIndex.php
Line: 102
Can I do something to solve this? :-[ Thanks! ;)
Otsikko: Re: Error: database error in SQL syntax ?
Kirjoitti: xt600 - toukokuu 02, 2006, 06:01:54 IP
...this problem happens only if you are logged... ::)
Otsikko: Re: Error: database error in SQL syntax ?
Kirjoitti: jerm - toukokuu 02, 2006, 06:36:47 IP
MySQL server version for the right syntax to use near ' (http://www.simplemachines.org/community/index.php?topic=70038.msg483380#msg483380)

That thread should solve your problem
Otsikko: Re: Error: database error in SQL syntax ?
Kirjoitti: xt600 - toukokuu 03, 2006, 04:29:46 AP
Thanks a lot Electrohome! ;) After reading the links in http://www.simplemachines.org/community/index.php?topic=70038.msg483380#msg483380 (http://www.simplemachines.org/community/index.php?topic=70038.msg483380#msg483380) I've found the easiest way to correct this problem (uh, a little bug?) : without writing any new line of code and simply recounting all totals and statistics in admin panel maintenance section, this worked fine. ;D
I think also that this is the easiest way to follow for those that aren't very familiar with editors, codes and so on... Bye! Fabio