You last visited: Today at 23:55
Advertisement
ERROR in MySql
Discussion on ERROR in MySql within the CO2 Private Server forum part of the Conquer Online 2 category.
08/23/2010, 16:59
#1
elite*gold: 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
08/23/2010, 17:39
#2
elite*gold: 28
Join Date: Jun 2010
Posts: 2,226
Received Thanks: 868
Biniarys?
08/23/2010, 18:04
#3
elite*gold: 0
Join Date: Jun 2008
Posts: 94
Received Thanks: 6
yea
08/23/2010, 19:27
#4
elite*gold: 20
Join Date: Aug 2005
Posts: 1,734
Received Thanks: 1,001
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.
08/23/2010, 20:05
#5
elite*gold: 28
Join Date: Jun 2010
Posts: 2,226
Received Thanks: 868
Quote:
Originally Posted by
fotis007
yea
Not many people like to help people if they are using biniarys
08/24/2010, 00:00
#6
elite*gold: 0
Join Date: Jun 2008
Posts: 94
Received Thanks: 6
and now what we do? =]
08/24/2010, 01:49
#7
elite*gold: 20
Join Date: Mar 2006
Posts: 6,126
Received Thanks: 2,518
Quote:
Originally Posted by
tanelipe
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);
08/24/2010, 15:14
#8
elite*gold: 0
Join Date: Jun 2008
Posts: 94
Received Thanks: 6
Quote:
Originally Posted by
Korvacs
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? =[
08/24/2010, 16:18
#9
elite*gold: 20
Join Date: Mar 2006
Posts: 6,126
Received Thanks: 2,518
Quote:
Originally Posted by
fotis007
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.
08/24/2010, 18:47
#10
elite*gold: 0
Join Date: Jun 2008
Posts: 94
Received Thanks: 6
Ok let me try =] thx anw
08/25/2010, 13:35
#11
elite*gold: 0
Join Date: May 2006
Posts: 1,190
Received Thanks: 516
Quote:
Originally Posted by
fotis007
Ok let me try =] thx anw
Quote:
Originally Posted by
fotis007
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.
08/25/2010, 14:39
#12
elite*gold: 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
08/25/2010, 20:52
#13
elite*gold: 0
Join Date: May 2006
Posts: 1,190
Received Thanks: 516
Quote:
Originally Posted by
fotis007
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.
08/25/2010, 22:51
#14
elite*gold: 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
08/25/2010, 23:19
#15
elite*gold: 0
Join Date: May 2006
Posts: 1,190
Received Thanks: 516
Quote:
Originally Posted by
fotis007
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.
[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 23:55 .
