Register or have you forgotten your password?
Get the most out of Surmunity, read our tips here! Need an interesting blog to read? You've got to read the Surpass Blog!
| Welcome! Please register to access all of our features.
September 1st, 2006, 12:46 AM
|
#1 (permalink) |
|
Registered User
Fresh Surpasser
Joined in Jul 2006
12 posts
Gave thanks: 2
Thanked 0 times
|
I need help with SQL
I am using the XMB forums for my website, and when I try to create a new sub-forum, I get this error:
MySQL encountered the following 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 ' mpnt, mpnp, mpfa ) VALUES ('sub', 'Requests', 'on', '', '', 0, '1', '', 'no', '' at line 1 In the following query: INSERT INTO xmb_forums ( type, name, status, lastpost, moderator, displayorder, private, description, allowhtml, allowsmilies, allowbbcode, userlist, theme, posts, threads, fup, postperm, allowimgcode, attachstatus, pollstatus, password, guestposting ) , mpnt, mpnp, mpfa ) VALUES ('sub', 'Requests', 'on', '', '', 0, '1', '', 'no', 'yes', 'yes', '', 0, 0, 0, 29, '1|1', 'yes', 'on', 'on', '', 'off', '0', '0', '0') Is this something that surpass can help me with, or should I ask over at the XMB forums' help center? Thanks! Website info: Domain: http://www.willandgracetv.net Forum's: http://www.willandgracetv.net/boards |
|
    
|
|
September 1st, 2006, 1:25 AM
|
#2 (permalink) |
|
after g, before i
Super #1
Joined in Jul 2004
Hosted on Gojira
7,903 posts
Gave thanks: 44
Thanked 127 times
|
There's some invalid syntax in the query. I'm not sure whether it's naturally there or cause by a mod. But anyways, the bug comes up because ', mpnt, mpnp, mpfa )' is out of place. There's a bracket closing the part where they should be. Definitely a bug in the software though.
|
|
|
|
|
September 1st, 2006, 11:45 AM
|
#3 (permalink) |
|
Race Surpass
Super #1
Joined in Jul 2006
Lives in Oklahoma City, OK
Hosted on sh102
1,211 posts
Gave thanks: 18
Thanked 86 times
|
Yep, that close parenthesis after guestposting should not be there. The number of field names within the first set of parenthesis should match the number of values in the second set after VALUES.
__________________
|
|
|
|
|
September 1st, 2006, 5:45 PM
|
#4 (permalink) |
|
Registered User
Fresh Surpasser
Joined in Jul 2006
12 posts
Gave thanks: 2
Thanked 0 times
|
Well yes, I have made a few mods to the boards, but I have 0 experience with MYSQL.
 Hmmmm, Well I'll try to look for more stuff on the net, but if anyone can help me on how to fix it, please do so. I will REALLY appreciate it. |
|
|
|
|
September 1st, 2006, 5:58 PM
|
#5 (permalink) |
|
Race Surpass
Super #1
Joined in Jul 2006
Lives in Oklahoma City, OK
Hosted on sh102
1,211 posts
Gave thanks: 18
Thanked 86 times
|
I did tell you how, or at least why the error is occuring. Need to search within the script that contains that MySQL statement and remove that extra ")" that is in between guestposting and mpnt: guestposting, ) mpnt.
Now, if this SQL statement is being dynamically created, that will make tracking it down a little more difficult. In any event, that is what is causing the error. I've never used that forum so I couldn't tell you what file or section to look for this snipet of code. Best of luck
__________________
|
|
|
|
