The Hidden Glasgow Forums

by **Some Guy** » Thu Mar 18, 2004 4:00 pm

Why, do I keep getting this error when I try to post in the “Forum Help” section:

Error in posting

DEBUG MODE

SQL Error : 1064 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 ' forum_topics = forum_topics + 1 WHERE forum_id = 4' at lin

UPDATE hiddenglasgow_forums SET forum_posts = forum_posts + 1, forum_last_post_id = , forum_topics = forum_topics + 1 WHERE forum_id = 4

Line : 460
File : /homepages/12/d40807057/htdocs/hiddenglasgow/forums/includes/functions_post.php

and why hasn't this thread updated itself (on the main page) since my post?

http://www.hiddenglasgow.com/forums/viewtopic.php?t=7&start=50

by **duncan** » Thu Mar 18, 2004 4:54 pm

well it's obvious really, you haven't passed a value for the forum_last_post_id. it's expecting a numeric value; if you don't have one, use zero instead.

by **kn0wledge** » Thu Mar 18, 2004 4:57 pm

don't you just love SQL.

select * FROM users WHERE clue > 0

Actually, I think I'll make that my .sig =P

by **Some Guy** » Mon Mar 22, 2004 1:29 pm

Ah, but I wasn't enetering any SQL, t'was this php board that was doing that.... The error box was not editable.

by **Sharon** » Mon Mar 22, 2004 4:09 pm

ignore those 2!!!

Are you still getting errors?

by **Ronnie** » Tue Mar 23, 2004 2:36 pm

PHP = pot head pixie? Anyone remember the band (not the restaurant) Gong?

The Hidden Glasgow Forums

Some forum bugs

Some forum bugs

Who is online