MySQL error

M

mikey4865

New Member
I havent had trouble with my computer in awhile but now i have this probel m that i cannot fix!

i try posting on a forum on www.crooklynclan.org and i get this:

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 ' '', '1145566775', '47eb3b03', '1', '0', '1', '0')' at line 1

INSERT INTO nuke_bbposts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig) VALUES ('1826', '2', , '', '1145566775', '47eb3b03', '1', '0', '1', '0')

Line : 272
File : functions_post.php


What is this? and how do i fix it?
 
mikey4865 said:
what does the administrator of the site have to do?
Click to expand...
Tell them to check the syntax of Line : 272 of the File functions_post.php They appear to have an opening bracket missing from the command.
 
texmex said:
Tell them to check the syntax of Line : 272 of the File functions_post.php They appear to have an opening bracket missing from the command.
Click to expand...

The problem is in red:

INSERT INTO nuke_bbposts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig) VALUES ('1826', '2', , '', '1145566775', '47eb3b03', '1', '0', '1', '0')


There needs to be two single quotes between the commas. (,'' ,)
 
Last edited:
i got a new error now!!

Could not obtain list of topic watchers

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 ' 1) AND tw.notify_statu

SELECT u.user_id, u.user_email, u.user_lang FROM nuke_bbtopics_watch tw, nuke_users u WHERE tw.topic_id = '1826' AND tw.user_id NOT IN (, 1) AND tw.notify_status = 0 AND u.user_id = tw.user_id

Line : 667
File : functions_post.php
 
Is this your site or someone elses.... cos they really need to sort this out. There should not be any errors like this...

dragon
 
You must log in or register to reply here.
Back
Top