Best of Joomla! - Re:SQL / databse error when trying to post new mes

Welcome, Guest
Please Login or Register. Lost Password?

FireBoard Manual Latest release discussions Download FireBoard

Community

FireBoard Forum

Latest Release

Solved IssuesThreads

SQL / databse error when trying to post new mes (1 viewing) (1) Guest

Page:
<< Start < Prev 1 2 Next > End >>

TOPIC: SQL / databse error when trying to post new mes

Forum Tools

#38093

Re:SQL / databse error when trying to post new mes 12 Months ago

i'm getting this issue with joomla 1.0.13, fireboard 1.0.4 and mysql 4.1.22

Serious db problem: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 'where userid=0' at line 1 SQL=UPDATE mos_fb_sessions SET allowed='na', readtopics='', lasttime= where userid=0

is this the same and does anyone know a quick fix?

i dont want to go to fireboard 1.0.4 because i've seen loads of issues and it took me a while to fix the ones with 1.0.3 ... so i was going to wait a while

any help would be appreciated and if it helps - i dont see this issue, only a few users - most dont

damo (User)

Junior Boarder

Posts: 42

Logged

Last Edit: 2008/01/09 17:37 By damo.

Joomla Themes

#38094

Re:SQL / databse error when trying to post new mes 12 Months ago
I think your problem is in missing value of LASTTIME... Try to change SQL query to : UPDATE mos_fb_sessions SET allowed='na', readtopics='', lasttime='' where userid=0 with empty value...or you have to try find out why FB is not able to write correct value