HELP!!! Table 'pligg.pligg_links' doesn't exist

[bittermoon1]

I have tried installing Pligg over 3 times now and I get the same error message each time when I try to log into the admin page.

"Table 'pligg.pligg_links' doesn't exist". The installation showed no errors!

I have tried this with v 8.0, 9.0 and now 9.1. I'm ready to give up. Can anybody help me?

[savant]

First check you mysql db to see if the pligg_links table exists.

if it does check in settings.php that the table prefix is pligg_

[bittermoon1]

Originally Posted by savant

First check you mysql db to see if the pligg_links table exists.

if it does check in settings.php that the table prefix is pligg_

Hey,
Thanks for the response.
The table does not exist in the database. But settings.php has the table prefix set to "pligg_"

This is what i see.

mysql> use pligg;
Database changed
mysql> show tables;
+------------------+
| Tables_in_pligg |
+------------------+
| pligg_blogs |
| pligg_categories |
| pligg_comments |
| pligg_config |
| pligg_friends |
| pligg_languages |
| pligg_messages |
| pligg_modules |
| pligg_pageviews |
| pligg_tags |
| pligg_trackbacks |
| pligg_users |
| pligg_votes |
+------------------+
13 rows in set (0.03 sec)

mysql>

[savant]

CREATE TABLE pligg_links (
  `link_id` int(20) NOT NULL auto_increment,
  `link_author` int(20) NOT NULL default '0',
  `link_status` enum('discard','queued','published','abuse','duplicated') NOT NULL default 'discard',
  `link_randkey` int(20) NOT NULL default '0',
  `link_votes` int(20) NOT NULL default '0',
  `link_reports` int(20) NOT NULL default '0',
  `link_comments` 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,
  `link_published_date` timestamp NOT NULL,
  `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` text 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_content`,`link_tags`),
  FULLTEXT KEY `link_tags` (`link_tags`)
) TYPE = MyISAM;