Moderators: John, Sharon, Fossil, Lucky Poet, crusty_bint, Jazza, dazza
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
-
Some Guy
- Busy bunny
-
- Posts: 38
- Joined: Mon Oct 20, 2003 9:08 am
- Location: Glasgow
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.
-
duncan
- Third Stripe
-
- Posts: 1150
- Joined: Tue Aug 27, 2002 9:54 am
- Location: Glasgow
-
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
Eat a ham for Jesus.
-
kn0wledge
- Third Stripe
-
- Posts: 936
- Joined: Tue Feb 24, 2004 8:30 pm
- Location: Bonkle (seriously)
-
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.
-
Some Guy
- Busy bunny
-
- Posts: 38
- Joined: Mon Oct 20, 2003 9:08 am
- Location: Glasgow
by Sharon » Mon Mar 22, 2004 4:09 pm
ignore those 2!!!
Are you still getting errors?
Beware of yawning dogs.
-
Sharon
- Site Admin
-
- Posts: 7495
- Joined: Fri Mar 22, 2002 11:30 am
- Location: Galloway
-
by Ronnie » Tue Mar 23, 2004 2:36 pm
PHP = pot head pixie? Anyone remember the band (not the restaurant) Gong?
upupdowndownleftrightleftrightbastart
-
Ronnie
- Third Stripe
-
- Posts: 1983
- Joined: Sat Jan 17, 2004 11:22 pm
- Location: Glasgow
Return to Forum Help and Issues
Who is online
Users browsing this forum: No registered users and 11 guests