The vB Geek

The vB Geek (http://www.thevbgeek.com/index.php)
-   Geek Article and Review System (http://www.thevbgeek.com/forumdisplay.php?f=26)
-   -   Error message when trying to post and delete threads (http://www.thevbgeek.com/showthread.php?t=1956)

Shack Networks 08-21-2006 11:30 PM

Error message when trying to post and delete threads
 
The post is made and apears but I get this error when I try to either post or delete posts.

MySQL Error : Table 'shackVB.gars_custom_values' doesn't exist

I have reran the installer and its still not working

vBull 3.5

Anyhelp appreciated...

The Geek 08-22-2006 08:47 AM

I think this is an error from upgrading from a previous version that skipped another upgrade step. Try running this is phpmyadmin (insert your table prefix too):

CREATE TABLE `gars_custom_values` (
`custom_threadid` INT NOT NULL ,
PRIMARY KEY ( `custom_threadid` ));



CREATE TABLE `gars_custom_fields` (
`id` INT NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 50 ) NOT NULL ,
`description` VARCHAR( 250 ) NOT NULL ,
`required` TINYINT NOT NULL ,
`maxlength` SMALLINT NOT NULL ,
`displayorder` SMALLINT NOT NULL ,
`editable` TINYINT NOT NULL ,
`type` ENUM( 'input', 'select', 'radio', 'textarea', 'checkbox', 'select_multiple' ) NOT NULL ,
`default` SMALLINT NOT NULL ,
`allowhtml` TINYINT NOT NULL ,
PRIMARY KEY ( `id` )
)


ALTER TABLE `gars_custom_fields` ADD `bbcode` TINYINT NOT NULL

Shack Networks 08-22-2006 12:25 PM

CREATE TABLE `gars_custom_values` (
`custom_threadid` INT NOT NULL ,
PRIMARY KEY ( `custom_threadid` ));

Did the trick m8, for some reason it did not run the query in the install script..

I did a fresh install not an upgrade as I have just converted back from IPB to vBull for the 3rd time lol...

Thanks for the help your geekyness your a star...


All times are GMT. The time now is 07:07 AM.

Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.