Go Back   Pligg CMS Forum > Pligg Development > Bug Report

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 05-23-2006, 03:08 PM
New Pligger
 
Join Date: May 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Creating the links table with InnoDB

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
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Similar Threads
Thread Thread Starter Forum Replies Last Post
Error message after installation: dragan Installation and Upgrade Help 1 09-09-2007 07:29 PM
9.1 :: Errors keep pouring in after succesfully Creating Tables The Edifier Installation and Upgrade Help 1 05-01-2007 01:15 PM
installed successfully but one table is not exist oodbqpoo Installation and Upgrade Help 2 03-16-2007 02:22 PM
Table 'pligg.table_prefixconfig' doesn't exist guarriman Installation and Upgrade Help 2 02-08-2007 03:37 PM
Table not getting created webdevil2003 Installation and Upgrade Help 1 11-30-2006 08:54 PM


Search Engine Friendly URLs by vBSEO 3.2.0