help formulating a install query.

[Vaupell]

Im stuck so many places, gotta debug one point at a time.
gonna start with installation.

need to create a table with some content

allright home/local i use navicat lite (free and lovely)
and goto the vbulletin table i made named vbinvitationcode + prefix ofc
and click dump a backup. i open the backup to get the "ordenary" query
and want to convert that into something usefull for vb..

DROP TABLE IF EXISTS `vbinvitationcode`;
CREATE TABLE `vbinvitationcode` (
  `codedbID` int(10) NOT NULL AUTO_INCREMENT,
  `InvitationCODE` longtext,
  `NewusergroupID` int(2) DEFAULT NULL,
  PRIMARY KEY (`codedbID`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

Now for vb i then make it into :

$db->hide_errors();
$db->query_write("CREATE TABLE IF NOT EXISTS `" .  TABLE_PREFIX . "vbinvitationcode` (
  `codedbID` int(10) NOT NULL AUTO_INCREMENT  PRIMARY KEY,
  `InvitationCODE` longtext,
  `NewusergroupID` int(2) DEFAULT NULL,
$db->show_errors();

and with a blink of an eye it appears everything is normal, but infact
it never made the table..

whats wrong ? :up:


allready reported myself for wrong category

[Lynne]

Maybe..

PHP Code:

$db->hide_errors();
$db->query_write("CREATE TABLE IF NOT EXISTS `" .  TABLE_PREFIX . "vbinvitationcode` (
  `codedbID` int(10) NOT NULL AUTO_INCREMENT  PRIMARY KEY,
  `InvitationCODE` longtext,
  `NewusergroupID` int(2) DEFAULT NULL)
");
$db->show_errors(); 


[Vaupell]

OMG Lynne youre a lifesaver,,

Thank you soooo much, you made my day.. :up:

[Dismounted]

You may want to get an editor that includes PHP highlighting. This would reveal "silly" mistakes like this.

[Marco van Herwaarden]

You are also missing the key:

[sql]PRIMARY KEY (`codedbID`)[/sql]
Also next time, remove the hide_errors to see why it fails.

[Vaupell]

Originally Posted by Dismounted

You may want to get an editor that includes PHP highlighting. This would reveal "silly" mistakes like this.

any particular recommended ? :up:

Originally Posted by Marco van Herwaarden

You are also missing the key:

[sql]PRIMARY KEY (`codedbID`)[/sql]
Also next time, remove the hide_errors to see why it fails.

Well ofcourse i removed the hide_errors to test, but didnt show anything
now ewen a sql error, just blinked twice then refresh and nothing. :P

[Dismounted]

Originally Posted by Vaupell

any particular recommended ?

I use Komodo IDE. However, the same company (ActiveState) also releases an open-source version called Komodo Edit. It just drops a few of the debugging/advanced features.

[Vaupell]

@Dismounted > yes Komodo yes great, tx using the free one now..