Raised This Month: $ Target: $400
 0% 

SQL SYNTAX ERROR[UPDATED]


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
davidto1995
Member
Join Date: Jul 2010
Location: hong kong
Old 08-03-2011 , 13:50   Re: SQL SYNTAX ERROR[UPDATED]
Reply With Quote #1

Quote:
Originally Posted by lucas_7_94 View Post
little array maybe?
what do you mean by little array?
davidto1995 is offline
fysiks
Veteran Member
Join Date: Sep 2007
Location: Flatland, USA
Old 08-03-2011 , 13:54   Re: SQL SYNTAX ERROR[UPDATED]
Reply With Quote #2

Quote:
Originally Posted by davidto1995 View Post
what do you mean by little array?
The output of your code is 3091 characters so you need an array big enough to handle that. So, you would need at least MSG[3092].
__________________
fysiks is offline
davidto1995
Member
Join Date: Jul 2010
Location: hong kong
Old 08-03-2011 , 14:27   Re: SQL SYNTAX ERROR[UPDATED]
Reply With Quote #3

Quote:
Originally Posted by fysiks View Post
The output of your code is 3091 characters so you need an array big enough to handle that. So, you would need at least MSG[3092].
array size changed.
btw
another error appeared
Code:
Plugin says: 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 '' at line 1
davidto1995 is offline
Exolent[jNr]
Veteran Member
Join Date: Feb 2007
Location: Tennessee
Old 08-03-2011 , 14:30   Re: SQL SYNTAX ERROR[UPDATED]
Reply With Quote #4

What do those "CN_BOOL_IsUserHaveNickname_%d ENUM('0', '1')" fields do?
__________________
No private work or selling mods.
Quote:
Originally Posted by xPaw View Post
I love you exolent!
Exolent[jNr] is offline
lucas_7_94
Leche Loco
Join Date: Mar 2009
Location: Argentina
Old 08-03-2011 , 15:00   Re: SQL SYNTAX ERROR[UPDATED]
Reply With Quote #5

new i doesnt should be new i = 0?
__________________
ATWWMH - MiniDuels
Madness is like gravity, just need a little push.
lucas_7_94 is offline
Send a message via Skype™ to lucas_7_94
Exolent[jNr]
Veteran Member
Join Date: Feb 2007
Location: Tennessee
Old 08-03-2011 , 15:20   Re: SQL SYNTAX ERROR[UPDATED]
Reply With Quote #6

Quote:
Originally Posted by lucas_7_94 View Post
new i doesnt should be new i = 0?
Default value is 0, setting it isn't required.
__________________
No private work or selling mods.
Quote:
Originally Posted by xPaw View Post
I love you exolent!
Exolent[jNr] is offline
lucas_7_94
Leche Loco
Join Date: Mar 2009
Location: Argentina
Old 08-03-2011 , 15:21   Re: SQL SYNTAX ERROR[UPDATED]
Reply With Quote #7

Quote:
Originally Posted by Exolent[jNr] View Post
Default value is 0, setting it isn't required.
ah okei.
__________________
ATWWMH - MiniDuels
Madness is like gravity, just need a little push.
lucas_7_94 is offline
Send a message via Skype™ to lucas_7_94
lucas_7_94
Leche Loco
Join Date: Mar 2009
Location: Argentina
Old 08-03-2011 , 15:09   Re: SQL SYNTAX ERROR[UPDATED]
Reply With Quote #8

PS : I execute the query in my phpmyadmin and the consult works perfect.
__________________
ATWWMH - MiniDuels
Madness is like gravity, just need a little push.
lucas_7_94 is offline
Send a message via Skype™ to lucas_7_94
ARES[ro]
Senior Member
Join Date: Apr 2010
Old 08-03-2011 , 15:30   Re: SQL SYNTAX ERROR[UPDATED]
Reply With Quote #9

By the way, I tried formating a huge query like this for SQLx when I was working on one of my projects and it was capped at a certain length.
__________________
okay
ARES[ro] is offline
davidto1995
Member
Join Date: Jul 2010
Location: hong kong
Old 08-03-2011 , 16:01   Re: SQL SYNTAX ERROR[UPDATED]
Reply With Quote #10

now , no error found

but the data will not save

i think it may be related to MySQL Server

how to create a MySQL Server?
It needs a software?

i am not sure what i should filled in the parameters(host, username, password, database)
davidto1995 is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 03:29.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode