I have the full version of this installed and i'm getting the following SQL error when i access the vbprojects file:
Code:
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT COUNT(pid) AS nb_proj FROM mgc_vbprojets;
MySQL Error : Table 'website.mgc_vbprojets' doesn't exist
Error Number : 1146
Date : Thursday, August 2nd 2007 @ 01:16:28 PM
Script : http://www.reckoning-day.org/mgc_vbprojets.php
Referrer : http://www.reckoning-day.org/forums.php
IP Address : 65.209.65.242
Username : DeMiNe0
Classname : vB_Database
I have the product installed, and i have tried reinstalling it as well. I tried to manually run the SQL query that creates this table, but get the following error:
Code:
CREATE TABLE mgc_vbprojets (
`pid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`chefprojetid` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ,
`titre` VARCHAR( 250 ) NOT NULL ,
`description` MEDIUMTEXT DEFAULT NULL ,
`statut` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL ,
`priorite` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL ,
`progression` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL ,
`datecreation` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ,
`datemaj` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ,
PRIMARY KEY ( `pid` ) ,
INDEX ( `chefprojetid` , `datecreation` ) ,
FULLTEXT (
`titre`,`description`
))
Code:
Error Code : 1214
The used table type doesn't support FULLTEXT indexes
(0 ms taken)