[haelen]

Hi, I successfully installed Pligg (apparently) but got the following error:

SQL/DB Error -- [Table 'trowe.table_prefixconfig' doesn't exist]


Warning: Invalid argument supplied for foreach() in /home/trowe/html/troweco/libs/settings_from_db.php on line 9

SQL/DB Error -- [Table 'trowe.modules' doesn't exist]


Warning: Cannot modify header information - headers already sent by (output started at /home/trowe/html/troweco/libs/db.php:117) in /home/trowe/html/troweco/libs/html1.php on line 167


I'm using Pligg Beta 9.0


TIA,
Tim

[cent]

haelen,

you can install the modules table manually if you have phpMyAdmin. if so, just run these SQL statements:

CREATE TABLE `pligg_modules` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `version` float NOT NULL,
  `folder` varchar(50) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

INSERT INTO `pligg_modules` VALUES (1, 'Javascript Effects Pack', 0.1, 'scriptaculous', 1);
INSERT INTO `pligg_modules` VALUES (2, 'Admin Modify Language', 0.1, 'admin_language', 1);

If you do not have a table prefix set to the default of "pligg_" then remove that and replace with the table prefix you are using. If there isn't a table prefix than it should just read `modules`

Best,
Cent

[haelen]

Hi Cent,

Thanks for the quick response.

I did as you suggested and got the same errors:

SQL/DB Error -- [Table 'trowe.table_prefixconfig' doesn't exist]


Warning: Invalid argument supplied for foreach() in /home/trowe/html/troweco/libs/settings_from_db.php on line 9

SQL/DB Error -- [Table 'trowe.modules' doesn't exist]


Warning: Cannot modify header information - headers already sent by (output started at /home/trowe/html/troweco/libs/db.php:117) in /home/trowe/html/troweco/libs/html1.php on line 167

Here's a snapshot from phpMyAdmin:

[cent]

Hi, from inside phpMyAdmin...

Empty the config table (don't drop it). From the looks of it, there's only 1 entry and it probably has a id # of 63 or something. Happened to me as well.

You'll need to open (install/upgrade_config_table.sql) and (not sure why this worked), but uncomment out the following line (around line 45) by removing the /* */.

/* INSERT INTO `config` VALUES (44, 'Anonymous', 'allow_anonymous_reporting', '0', '0', '0 or 1', 'Allow anonymous reporting', '<b>0</b> = disabled, <b>1</b> = enabled. Shows the problem form to anonymous users', 'define', NULL); */

Upload the file and try again. Be sure to check your DB, especially the config table as it should have about 68 records.

let me know how it goes.

Best,
Cent

[haelen]

Hi Cent,

Unfortunately, the following occurred :

SQL/DB Error -- [Table 'trowe.table_prefixconfig' doesn't exist]


Warning: Invalid argument supplied for foreach() in /home/trowe/html/troweco/libs/settings_from_db.php on line 9

SQL/DB Error -- [Table 'trowe.modules' doesn't exist]

SQL/DB Error -- [Table 'trowe.links' doesn't exist]

ERROR: my_base_url is not set. Please correct this using the admin panel. Then refresh this page.

SQL/DB Error -- [Table 'trowe.categories' doesn't exist]


Warning: Invalid argument supplied for foreach() in /home/trowe/html/troweco/libs/html1.php on line 119

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/trowe/html/troweco/libs/dbtree.php on line 316

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/trowe/html/troweco/libs/dbtree.php on line 322

SQL/DB Error -- [Table 'trowe.links' doesn't exist]


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/trowe/html/troweco/libs/html1.php on line 145

Fatal error: TPL: [in line 0]: syntax error: file '/pligg.tpl' does not exist in /home/trowe/html/troweco/class.template.php on line 898

I was thinking maybe I should star over from scratch. However, I''m still likely to end up with the same result I think.

I'm off to bed now (I'm in London, England)

Best,
Tim