localhost/phpmyadmin for conqueremu database

11/18/2009 04:55 Arcо#1
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??',
  
`typeint(4unsigned 
Anybody know whats the deal?
I've reinstalled appserv many times and it does not help.
11/18/2009 09:59 Korvacs#2
Which version of Sql is it? SQL Server 2005 doesnt support unsigned variables unless you write a custom server.
11/19/2009 15:56 Basser#3
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 Korvacs#4
Quote:
Originally Posted by Smythe94 View Post
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.