Register for your free account! | Forgot your password?

You last visited: Today at 02:45

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

ERROR in MySql

Discussion on ERROR in MySql within the CO2 Private Server forum part of the Conquer Online 2 category.

Reply
Page 1 of 2 1 2
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2008
Posts: 94
Received Thanks: 6
ERROR in MySql

Code:
REPLACE INTO `cq_action` VALUES ('950000', '950001', '0000', '0101', '0', 'Hello~There~%user_name~Its~Casino~Time!');
REPLACE INTO `cq_action` VALUES ('950001', '15003', '0000', '0102', '0', 'Are~You~New? 950002');
REPLACE INTO `cq_action` VALUES ('950002', '950003', '0000', '0101', '0', 'Why~Yes~I~Am!~I've~Come~To~Make~You~Rich');
REPLACE INTO `cq_action` VALUES ('950003', '15003', '0000', '0102', '0', 'How~Do~I~Become~Rich? 950004');
REPLACE INTO `cq_action` VALUES ('950004', '950005', '0000', '0101', '0', 'Well~I~Get~10,000kcps~From~There~You~Have~Chaince~To~Lose~It~All,~Gain~Half,~Gain~Doubl,~Or~Hopefully~Hit~JackPot!');
REPLACE INTO `cq_action` VALUES ('950005', '15003, '0000', '0102', '0', 'Can~I~Try? 950006');
REPLACE INTO `cq_action` VALUES ('950006', '950007', '0000', '0101', '0', 'Sure~Thing~%user_name~Hand~Over~10,000[CPS]');
REPLACE INTO `cq_action` VALUES ('950007', '15003', '0000', '0102', '0', 'Here~You~Go! 950008');
REPLACE INTO `cq_action` VALUES ('950008', '950009', '951000', '1001', '0', 'e_money += -10000');
REPLACE INTO `cq_action` VALUES ('950009', '950010', '950011', '0121', '0', '25 125');
REPLACE INTO `cq_action` VALUES ('950010', '951002', '0000', '1001', '0', 'e_money += 50000');
REPLACE INTO `cq_action` VALUES ('950011', '950012', '950013', '0121', '0', '25 100');
REPLACE INTO `cq_action` VALUES ('950012', '0000', '0000', '1001', '0', 'e_money += 20000');
REPLACE INTO `cq_action` VALUES ('951000', '951001', '0000', '0101', '0', 'Ha!~You~Cant~Deceive~Me~%user_name~!~Come~Back~When~You~Have~Enough~[CPS]');
REPLACE INTO `cq_action` VALUES ('951001', '15003', '0000', '0102', '0', 'Sorry~Mr.Casino~Clerk 951003');
REPLACE INTO `cq_action` VALUES ('951002', '958000', '0000', '0125', '2011', 'Wow! %user_name Was So Lucky To Hit The JackPot Of 50,000 [CPS] At The Casino Clerk In Twin City (427,361)');
REPLACE INTO `cq_action` VALUES ('950013', '950014', '950015', '0121, '0', '25 40');
REPLACE INTO `cq_action` VALUES ('950014', '0000', '0000', '1001', '0', 'e_money += 5000');
REPLACE INTO `cq_action` VALUES ('950015', '950016', '950011', '0121', '0', '25 5');
REPLACE INTO `cq_action` VALUES ('950016', '0000', '0000', '1001', '0', 'e_money += 2500');
REPLACE INTO `cq_action` VALUES ('951003', '951004', '0000', '1003', '0', '1002 429 378');
REPLACE INTO `cq_action` VALUES ('951004', '951005', '0000', '0101', '0', 'This~Is~What~You~Get~For~Trying~To~Deceive~Me!~Get~To~Walking!');
REPLACE INTO `cq_action` VALUES ('951005', '15003', '0000', '0102', '0', 'It's~So~Hot! 0');
REPLACE INTO `cq_action` VALUES ('958000', '0000', '0000', '0314', '0', '');

REPLACE INTO `cq_npc` VALUES ('950100', '0', '0', 'Casino9', '0002', '4550', '-1', '1860', '0069', '0068', '950000', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '?®?‚', '0000', '00', '00', '0000', '00', '0000');

REPLACE INTO `cq_task` VALUES ('950000, 950000, 0000, '', '', 0, 0, 0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950001', '950001', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950002', '950002', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950003', '950003', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950004', '950004', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950005', '950005', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950006', '950006', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950007', '950007', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950008', '950008', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950009', '950009', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950010', '950010', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950011', '950011', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950012', '950012', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950013', '950013', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950014', '950014', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950015', '950015', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950016', '950016', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('951000', '951000', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('951001', '951001', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('951002', '951002', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('951003', '951003', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('951004', '951004', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('951005', '951005', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('958000', '958000', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);

Error:
Code:
[Err] 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 've~Come~To~Make~You~Rich');
REPLACE INTO `cq_action` VALUES ('
[Err] REPLACE INTO `cq_action` VALUES ('950002', '950003', '0000', '0101', '0', 'Why~Yes~I~Am!~I've~Come~To~Make~You~Rich');
REPLACE INTO `cq_action` VALUES ('950003', '15003', '0000', '0102', '0', 'How~Do~I~Become~Rich? 950004');
REPLACE INTO `cq_action` VALUES ('950004', '950005', '0000', '0101', '0', 'Well~I~Get~10,000kcps~From~There~You~Have~Chaince~To~Lose~It~All,~Gain~Half,~Gain~Doubl,~Or~Hopefully~Hit~JackPot!');
REPLACE INTO `cq_action` VALUES ('950005', '15003, '0000', '0102', '0', 'Can~I~Try? 950006');
[Msg] Finished - Unsuccessfully
fotis007 is offline  
Old 08/23/2010, 17:39   #2
 
_DreadNought_'s Avatar
 
elite*gold: 28
The Black Market: 0/0/0
Join Date: Jun 2010
Posts: 2,223
Received Thanks: 867
Biniarys?
_DreadNought_ is offline  
Old 08/23/2010, 18:04   #3
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2008
Posts: 94
Received Thanks: 6
yea
fotis007 is offline  
Old 08/23/2010, 19:27   #4
 
elite*gold: 20
The Black Market: 0/0/0
Join Date: Aug 2005
Posts: 1,734
Received Thanks: 1,000
I'm pretty sure the problem is at

PHP Code:
'Why~Yes~I~Am!~I've~Come~To~Make~You~Rich'); 
and the "I've part" since it's using 's for strings. Thus cutting the string at 'Why~Yes~I~Am!~I' and the rest of the line gives the error.
tanelipe is offline  
Old 08/23/2010, 20:05   #5
 
_DreadNought_'s Avatar
 
elite*gold: 28
The Black Market: 0/0/0
Join Date: Jun 2010
Posts: 2,223
Received Thanks: 867
Quote:
Originally Posted by fotis007 View Post
yea
Not many people like to help people if they are using biniarys
_DreadNought_ is offline  
Thanks
1 User
Old 08/24/2010, 00:00   #6
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2008
Posts: 94
Received Thanks: 6
and now what we do? =]
fotis007 is offline  
Old 08/24/2010, 01:49   #7


 
Korvacs's Avatar
 
elite*gold: 20
The Black Market: 1/0/0
Join Date: Mar 2006
Posts: 6,125
Received Thanks: 2,518
Quote:
Originally Posted by tanelipe View Post
I'm pretty sure the problem is at

PHP Code:
'Why~Yes~I~Am!~I've~Come~To~Make~You~Rich'); 
and the "I've part" since it's using 's for strings. Thus cutting the string at 'Why~Yes~I~Am!~I' and the rest of the line gives the error.
And not only that but all of these:

PHP Code:
REPLACE INTO `cq_task` VALUES ('950001', '950001', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0); 
Korvacs is offline  
Old 08/24/2010, 15:14   #8
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2008
Posts: 94
Received Thanks: 6
Quote:
Originally Posted by Korvacs View Post
And not only that but all of these:

PHP Code:
REPLACE INTO `cq_task` VALUES ('950001', '950001', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0); 

What i have to change then? =[
fotis007 is offline  
Old 08/24/2010, 16:18   #9


 
Korvacs's Avatar
 
elite*gold: 20
The Black Market: 1/0/0
Join Date: Mar 2006
Posts: 6,125
Received Thanks: 2,518
Quote:
Originally Posted by fotis007 View Post
What i have to change then? =[
Here i googled the phrase "mysql replace syntax" for you and this was first on the list:



Please learn to use google, its not that hard.
Korvacs is offline  
Thanks
1 User
Old 08/24/2010, 18:47   #10
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2008
Posts: 94
Received Thanks: 6
Ok let me try =] thx anw

Cant Fix it =[ who can fix for me take thanks =[
fotis007 is offline  
Old 08/25/2010, 13:35   #11
 
.Beatz's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: May 2006
Posts: 1,190
Received Thanks: 516
Quote:
Originally Posted by fotis007 View Post
Ok let me try =] thx anw
Quote:
Originally Posted by fotis007 View Post
Cant Fix it =[ who can fix for me take thanks =[
#Reported - Double Posting

There is a handy button that says "edit" please use it next time.
.Beatz is offline  
Old 08/25/2010, 14:39   #12
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2008
Posts: 94
Received Thanks: 6
Sry =[ my accident Who can fix the npc for me? i tryed but didnt make it
fotis007 is offline  
Old 08/25/2010, 20:52   #13
 
.Beatz's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: May 2006
Posts: 1,190
Received Thanks: 516
Quote:
Originally Posted by fotis007 View Post
Sry =[ my accident Who can fix the npc for me? i tryed but didnt make it
Well this is not me telling you how to do it. But make a new Table add some names like UID, EXP, 1, 2, 3, 4 etc or whatever.
Once you have done this dump the Sql and have a look at the dumped file and compare it to your Sql file that will not execute.
You should see some changes ^^^ As above.
Use your brain a little bit and you can figure it out.
.Beatz is offline  
Old 08/25/2010, 22:51   #14
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2008
Posts: 94
Received Thanks: 6
i tried all ' " and all this thinks and still broke my brain is going to BOOM
fotis007 is offline  
Old 08/25/2010, 23:19   #15
 
.Beatz's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: May 2006
Posts: 1,190
Received Thanks: 516
Quote:
Originally Posted by fotis007 View Post
i tried all ' " and all this thinks and still broke my brain is going to BOOM
Read my post again....... It is not difficult to figure out.
.Beatz is offline  
Reply
Page 1 of 2 1 2

« ninja | how i can make my own Anti cheat? »

Similar Threads Similar Threads
[ERROR] Mysql can't connect to local Mysql server through socket
11/06/2010 - Metin2 Private Server - 5 Replies
I just recently tried to configure a DNS server for MT2.. It came up with this error ERROR: 2002 (HY000): Can't connect to local Mysql server through socket '/tmp/mysql.sock' (2) Do I need to do a fresh installation of FBSD? :S Thanks.
MYSQL Error
09/05/2010 - Technical Support - 1 Replies
Hallo, ich bekomme bei der Configuration von MYSQL immer einen Fehler ;( http://img225.imageshack.us/img225/4771/fehleri.j pg Ich Hoffe, mir kann da einer Helfen mit dem CMD Befeh "sc delete MySQL" Geht das auch net Wirklich. Und wenn ich Mysql 4 oder so nehme kommt da genau dasselbe. Deinstalieren und Wieder Instalieren geht auch net, das ist dann da immer noch. MFG evo
[Help] Wamp error or mysql error
09/27/2009 - EO PServer Hosting - 1 Replies
Notice: Undefined variable: myaccount in C:\wamp\www\pages\register.php on line 17 Warning: mysql_select_db() : Connecting to 3.22, 3.23 & 4.0 is not supported. Server is 4.0.18-nt in C:\wamp\www\pages\register.php on line 17 Warning: mysql_select_db() : Connecting to 3.22, 3.23 & 4.0 servers is not supported in C:\wamp\www\pages\register.php on line 17 Warning: mysql_select_db() : A link to the server could not be established in C:\wamp\www\pages\register.php on line 17 Warning:...
mysql error
12/08/2008 - EO PServer Hosting - 1 Replies
I am using wamp and when I start the winmysqladmin it is not show the databases in the the database tab can anyone give me a hand with this. It would be greatly appreciated.
mySQl error
06/27/2006 - Main - 5 Replies
waaaaaaaaah das kam grad als ich ins forum wollte



All times are GMT +2. The time now is 02:45.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.