|
You last visited: Today at 15:22
Advertisement
localhost/phpmyadmin for conqueremu database
Discussion on localhost/phpmyadmin for conqueremu database within the CO2 Private Server forum part of the Conquer Online 2 category.
11/18/2009, 04:55
|
#1
|
elite*gold: 0
Join Date: Oct 2009
Posts: 8,765
Received Thanks: 5,291
|
localhost/phpmyadmin for conqueremu database
Alright so I did some shiz in appserv.
Here's what I did.
I went to SQL and put this.
Code:
CREATE TABLE `cq_npc` (
`id` int(4) unsigned zerofill NOT NULL default '0000',
`ownerid` int(4) unsigned default '0',
`playerid` int(4) unsigned default '0',
`name` char(15) character set utf8 collate utf8_bin default '????¡§1??',
`type` int(4) unsigned zerofill default '0000',
`lookface` int(4) unsigned zerofill default '0000',
`idxserver` int(4) default '-1',
`mapid` int(4) unsigned zerofill default '0000',
`cellx` int(4) unsigned zerofill default '0000',
`celly` int(4) unsigned zerofill default '0000',
`task0` int(4) unsigned zerofill default '0000',
`task1` int(4) unsigned zerofill default '0000',
`task2` int(4) unsigned zerofill default '0000',
`task3` int(4) unsigned zerofill default '0000',
`task4` int(4) unsigned zerofill default '0000',
`task5` int(4) unsigned zerofill default '0000',
`task6` int(4) unsigned zerofill default '0000',
`task7` int(4) unsigned zerofill default '0000',
`data0` int(4) NOT NULL default '0',
`data1` int(4) NOT NULL default '0',
`data2` int(4) NOT NULL default '0',
`data3` int(4) NOT NULL default '0',
`datastr` char(15) character set utf8 collate utf8_bin default '?T',
`linkid` int(4) unsigned zerofill NOT NULL default '0000',
`life` smallint(2) unsigned zerofill NOT NULL default '00',
`maxlife` smallint(2) unsigned zerofill NOT NULL default '00',
`base` int(4) unsigned zerofill NOT NULL default '0000',
`sort` smallint(2) unsigned zerofill NOT NULL default '00',
`itemid` int(4) unsigned zerofill default NULL,
PRIMARY KEY (`id`)
)
and I get the error
PHP Code:
#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 'collate utf8_bin default '????¡§1??', `type` int(4) unsigned
Anybody know whats the deal?
I've reinstalled appserv many times and it does not help.
|
|
|
11/18/2009, 09:59
|
#2
|
elite*gold: 20
Join Date: Mar 2006
Posts: 6,125
Received Thanks: 2,518
|
Which version of Sql is it? SQL Server 2005 doesnt support unsigned variables unless you write a custom server.
|
|
|
11/19/2009, 15:56
|
#3
|
elite*gold: 0
Join Date: Sep 2008
Posts: 1,683
Received Thanks: 505
|
Ehm, try making the value 5 instead of 4, don't think that will work, but just try it.
At first I thought it was because an Int can't be unsigned, but that's not it, since MySQL does call UInts Usigned Ints.
|
|
|
11/19/2009, 16:01
|
#4
|
elite*gold: 20
Join Date: Mar 2006
Posts: 6,125
Received Thanks: 2,518
|
Quote:
Originally Posted by Smythe94
Ehm, try making the value 5 instead of 4, don't think that will work, but just try it.
At first I thought it was because an Int can't be unsigned, but that's not it, since MySQL does call UInts Usigned Ints.
|
Microsoft SQL Server doesnt support Unsigned ints of any kind, unless you write a custom server.
|
|
|
|
Similar Threads
|
[HELP]phpmyadmin #1045
03/21/2010 - Technical Support - 2 Replies
Heey
ich habe diesen fehler wenn ich auf phpmyadmin connecte:
http://img191.imageshack.us/img191/1903/aufzeichn enm.png
ich weiss aber nicht woher er kommt.
dachte es kommt daher das ich das pw vom server geändert habe aber es hat damit nichts zu tun da ich das alte jetzt wieder drin habe.
sonst habe nicht ncihts an myphpadmin verändert
gruß azio
|
[help] phpmyadmin
06/15/2009 - CO2 Private Server - 1 Replies
Basically what the title says. I installed appserver which has php, phpmyadmin, mysql, and apache. When I try to go to localhost/phpmyadmin, basically it doesn't work (fails to connect). As for reading the documentations, in the phpmyadmin, I don't really get what it's saying on how to config the files in order to get it work and etc. So if anyone can help me, it would be appreciated.
|
[Help] PHPMYADMIN
06/10/2009 - CO2 Private Server - 3 Replies
i cant find out why, it worked for me before. I reinstalled phpmyadmin and i typed in the address bar 5.78.241.48/phpmyadmin and it asks for the password and i give it my password, and it doesnt do anything, its just blank. ne1 have a solution?
|
PhpMyAdmin Help Me!
12/06/2008 - CO2 Private Server - 0 Replies
err i cant get PhPMyAdmin To work anymore...it was working this morning but now it just doesnt work...i tried everyhting...starting it from service and all that...It just doesnt work.
Any Ideas plz?
|
phpmyadmin
08/12/2008 - Conquer Online 2 - 1 Replies
Any1 know why when i install Appserver i cant access Http://localhost/phpmyadmin until a day after i install it.
Any1 know why this happens.Or a way to fix it
|
All times are GMT +2. The time now is 15:22.
|
|