[r0ssta]

Hello,

I'm installing Pligg for the first time and I'm really excited about it. I downloaded the new nightly release beta 7 build 278, and it successfully installed.

Everything seems to be working, but I get the error SQL/DB Error -- [Table 'frat.links' doesn't exist]. I've checked through PHPmyAdmin and noticed that the links table does in fact not exist. I looked in the createtables.php file, copied the SQL code to create the links table, and tried to run it, but got the following error.

SQL-query :

$sql = "CREATE TABLE `links` ( `link_id` int(20) NOT NULL auto_increment, `link_author` int(20) NOT NULL default '0', `link_blog` int(20) default '0', `link_status` enum('discard','queued','published','abuse','dupli cated') NOT NULL default 'discard', `link_randkey` int(20) NOT NULL default '0', `link_votes` int(20) NOT NULL default '0', `link_karma` decimal(10,2) NOT NULL default '0.00', `link_modified` timestamp NOT NULL, `link_date` timestamp NOT NULL default '0000-00-00 00:00:00', `link_published_date` timestamp NOT NULL default '0000-00-00 00:00:00', `link_category` int(11) NOT NULL default '0', `link_lang` int(11) NOT NULL default '1', `link_url` varchar(200) NOT NULL default '', `link_url_title` text, `link_title` text NOT NULL, `link_title_url` varchar(255) default NULL, `link_content` text NOT NULL, `link_summary` varchar(255) default NULL, `link_tags` text, `link_field1` varchar(255) NOT NULL default '', `link_field2` varchar(255) NOT NULL default '', `link_field3` varchar(255) NOT NULL default '', `link_field4` varchar(255) NOT NULL default '', `link_field5` varchar(255) NOT NULL default '', `link_field6` varchar(255) NOT NULL default '', `link_field7` varchar(255) NOT NULL default '', `link_field8` varchar(255) NOT NULL default '', `link_field9` varchar(255) NOT NULL default '', `link_field10` text NOT NULL default '', `link_field11` text NOT NULL default '', `link_field12` text NOT NULL default '', `link_field13` text NOT NULL default '', `link_field14` text NOT NULL default '', `link_field15` text NOT NULL default '', PRIMARY KEY (`link_id`), KEY `link_author` (`link_author`), KEY `link_url` (`link_url`), KEY `link_date` (`link_date`), KEY `link_published_date` (`link_published_date`), FULLTEXT KEY `link_url_2` (`link_url`,`link_url_title`,`link_title`,`link_co ntent`,`link_tags`), FULLTEXT KEY `link_tags` (`link_tags`) ) AUTO_INCREMENT=15 ;"

MySQL said:

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 '$sql = "CREATE TABLE `links` (
`link_id` int(20) NOT NULL aut


Can anyone please help?? Thanks!

[kbeeveer46]

try running www.<yoursite>.com/install/upgrade.php and see if that helps. If not, the beta 8 RC1 was just released if you want to downlaod that.

[r0ssta]

Thanks - I tried upgrade and it didn't work. I will definitely be trying out Beta 8..

But I found my error, and not sure how to check it.

When running the SQL statement for the Links table, I get the following error from MySQL:

The used table type doesn't support FULLTEXT indexes.

This looks like it's referring to the two Fulltext keys... does anyone have any idea how to fix this or a hack for it?

Thanks!

[kbeeveer46]

Make sure that you delete everything inside your database (even all the tables) before installing beta 8 RC1.

[Jeffy]

Hi,

The problem seems to be that your MySQL server is setup to create as different type as MyISAM when you create a new table. FULLTEXT KEYS just work when your table type is MyISAM. So you just need to add TYPE=MyISAM in the end of the query and everything should run fine.

[kbeeveer46]

This is the fix for that problem http://svn.sourceforge.net/viewvc/pl...v&revision=140

[Jason Stockman]

Thanks for the fix. I'm having the same problem with the link table not being created with the install. Could you explain how to make use of the "fix"? Do we upload it somewhere?

[kbeeveer46]

http://svn.sourceforge.net/viewvc/*c...40&pathrev=140

You need to replace the code in your install/createtables.php with the one above. Delete your database and install Pligg again.

[Jason Stockman]

Worked 100%. Thanks so much. I look forward to using and learning about Pligg when theres such a quick and responsive community.