PDA

View Full Version : SOLVED - Problem executing a install query adding a table - SOLVED


Vaupell
02-19-2009, 11:09 AM
trying to add a table, and my first query didnt work
so i copyed a "working" install query and replaced the
names with my own. :D :up:

well that didnt work either


$db->query_write("CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX ."elinkscat` (
`Cid` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`Cname` text,
`Cright` text,)
");


my usual error is i forget 1 ) at the end, but that is ok. :erm:

--------------- Added 1235049106 at 1235049106 ---------------

OMG EDIT LOL.. .

Im using a EXTRA , AT the end, before the ) roflmao.. DOH!!

Marco van Herwaarden
02-19-2009, 11:43 AM
I always format my queries like below. If you make a mistake, it will quickly show:

$db->query_write("CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX ."elinkscat`
(
`Cid` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`Cname` text,
`Cright` text,
");