Can't access configuration.

[AJH]

I've searched the entire forum for this problem, but I could not find anything.
So here's the problem. In the admin panel, when I try to open the configuration page I get the following error:

SQL/DB Error -- [Unknown column 'var_page' in 'field list']
nothing found

I don't get to see the config page at all. Just the error and that's it.

[kbeeveer46]

Do you have a config table in your Pligg database? Var_page is a field in that table.

[AJH]

Yes, I do have a config table. But it only contains the fields name and value. So I'm guessing that not all required fields are in my config table. So, as soon as I get home I will check the sql in the install files for the correct fields.

[kbeeveer46]

Drop your config table and insert and run this mysql query

CREATE TABLE `config` (
  `var_id` int(11) NOT NULL auto_increment,
  `var_page` varchar(50) NOT NULL,
  `var_name` varchar(100) NOT NULL,
  `var_value` varchar(50) NOT NULL,
  `var_defaultvalue` varchar(50) NOT NULL,
  `var_optiontext` varchar(200) NOT NULL,
  `var_title` varchar(200) NOT NULL,
  `var_desc` text NOT NULL,
  `var_method` varchar(10) NOT NULL,
  `var_enclosein` varchar(5) default NULL,
  PRIMARY KEY  (`var_id`)
) TYPE = MyISAM;

[AJH]

Did that, now the error is gone. But the config page is still empty. All i get to see is: "nothing found".

[kbeeveer46]

That's because there's nothing inside of the table. Run this SQL code to insert the data http://pligg.svn.sourceforge.net/vie...nfig_table.sql

[AJH]

Problem solved. Thanks!