PDA

View Full Version : need help formulating a sql query - SOLVEd


Vaupell
01-01-2010, 08:02 PM
Trying to add a new table dureing install, but cant get it installing proberly.
product installs fine, but it does not create the table needed, so cant fill it with
content..

upgraded a little from a old vb3 where it was working,
changed $db to $vbulletin but thinking the sql syntax should be fine
i dot see it.

help me, im blind to what i am missing.


$vbulletin->hide_errors();
$vbulletin->query_write("
CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX ."Tabletest` (
`TID` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`TUD` int(11),
`TAK` int(11),
`TOL` int(11)
) TYPE=MyISAM");
$vbulletin->show_errors();


tryed removing hide_errors but no errors produced...

--------------- Added 1262392773 at 1262392773 ---------------

solved ! aparently line breaks is not allowed anymore,
so putting it all into 1 single line, then it works without change..