Installation Error - Database

[ShaanuJaanu]

Database error in vBulletin 3.0.3:

Invalid SQL: CREATE TABLE adv_gallery_customfields_entries (
imgid int(10) unsigned NOT NULL default '0'
PRIMARY KEY (imgid)
) TYPE=MyISAM
mysql error: 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 '(imgid)
) TYPE=MyISAM' at line 3

mysql error number: 1064

[ShaanuJaanu]

well..nvm..I figured u were missing a comma

$DB_site->query("CREATE TABLE " . TABLE_PREFIX . "adv_gallery_customfields_entries (
imgid int(10) unsigned NOT NULL default '0',
PRIMARY KEY (imgid)
) TYPE=MyISAM");

Please download the package again and upload the install file from the new zip. Select the option to un-install (it will probably give you a db error on the last step, but shouldn't be anything to worry about), and then go back and try installing again.

[ShaanuJaanu]

is there anyhting other than the comma fixed in the new zip?

I deleted teh table..manually..and reinstalled.

Nope, that was all.

[phlogiston]

whoo! that one was my fault!

I helped make a bug, I'm so proud

Apologies, should have checked my cut & pastes before posting my fix earlier.

Actually I think that was my fault... I just removed that line, not thinking about the comma.

[ShaanuJaanu]

thank you....why isnt there instruction to add a link on the navbar....

im not using the portal btw..just regular forum - ama try add a link

[phlogiston]

Originally Posted by Brian

Actually I think that was my fault... I just removed that line, not thinking about the comma.

that's exactly what I did as well!

Originally Posted by ShaanuJaanu

thank you....why isnt there instruction to add a link on the navbar....

Because a link to the gallery could be added anywhere. It's up to you where to put it.