Product Creation Help

[Crimm]

I need some help with my first product.

I read the vb.com docs, but I'm having trouble with creating tables in the installation code. Here's what I'm doing:

$db->hide_errors();
$db->query_write("
CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "TABLENAME
(
tableid int(32) NOT NULL,
PRIMARY KEY (tableid)
) TYPE=MyISAM

");

$db->show_errors();

I have tried a few variations of that based off other products I have seen.

It just won't create the table.

Can anyone point out my mistake?

Please?

[Bilderback]

If your talking about the <installcode></installcode> in product xml...
$vbulletin->db->query_write

I am still new to vb database but maybe one of these below?
~pulled the code from installed mods.


<installcode>
<![CDATA[
$db->hide_errors();
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "TABLENAME
(
`tableid` int(32) NOT NULL default '0',
PRIMARY KEY (`tableid`)
) TYPE=MyISAM
");
]]></installcode>


with auto_increment

<installcode>
<![CDATA[
$db->hide_errors();
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "TABLENAME
(
`tableid` int(32) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
) TYPE=MyISAM
");
]]></installcode>

[Crimm]

That didn't work either... So I started randomly looking at mods here and I took out:

$db->hide_errors();

... Something that I didn't think of before ... DOH! ;) That way the SQL errors would show LOL

It ended up being a ) out of place.

Thank you for your help.