Creating the links table with InnoDB

Register an Account
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 05-23-2006, 04:08 PM
New Pligger
 
Join Date: May 2006
Posts: 1
On a MySQL configured to use InnoDB by default, the install script fails to create the links table. Due to fulltext indexes, it seems that table needs to be created as myisam.

The suggested bugfix:

In createtables.php file, the fillowing should be changed from -

FULLTEXT KEY `link_tags` (`link_tags`)
) AUTO_INCREMENT=15 ;";
echo 'Creating table: \'links\'....<BR/>';

to -

FULLTEXT KEY `link_tags` (`link_tags`)
) AUTO_INCREMENT=15, TYPE=MYISAM;";
echo 'Creating table: \'links\'....<BR/>';
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Table 'pligg.table_prefixconfig' doesn't exist guarriman Questions and Comments 5 01-27-2011 01:47 PM
Warning: Table 'tucknet_newqian_digg.pligg_groups' doesn't exist in seanli Questions and Comments 0 04-23-2009 03:35 AM
Installation error at step 4 beginner Questions and Comments 2 03-17-2009 04:12 PM
9.1 :: Errors keep pouring in after succesfully Creating Tables The Edifier Questions and Comments 1 05-01-2007 02:15 PM
installed successfully but one table is not exist oodbqpoo Questions and Comments 2 03-16-2007 03:22 PM


Pligg Modules and Pligg Templates from Pligg Pro Find support on the Pligg CMS Forum - 24 hours a day! Make a donation to support Pligg CMS development