By juanma0110 on

Hi everybody!. I don't know if it's the best forum to ask it but i hope u can help me. I'm installing the Sections Module but when i active it in modules it appears up in the admin page:

user error: Table 'drupal.sections_data' doesn't exist
query: SELECT * FROM sections_data in C:\AppServ\www\includes\database.mysql.inc on line 66.

user error: Table 'drupal.sections_data' doesn't exist
query: SELECT path, status, visibility, template, weight FROM sections_data WHERE status=1 ORDER BY weight in C:\AppServ\www\includes\database.mysql.inc on line 66.

I have the last version of Sections but i don't know why the .install file doesn't create the table. I hope u can help me and sorry for my english ;)

Comments

zeitenflug’s picture

zeitenflug commented

Use SSH to log on to your server, look for a *.sql file, edit it to fit your needs (e.g. add prefixes as needed) and run

mysql -u me -p database_name < filename.sql

If you can't log on, use phpMyAdmin to upload the edited sql file. It will create the tables.

juanma0110’s picture

juanma0110 commented

Thanks for your answer but my problem is that the sections module doesn't have a mysql archive so i don't know how i must to create the tables... any idea?. Thanks

clandmeter’s picture

clandmeter commented

I guess you are running a drupal version prior to 4.7 which does not (AFAIK) automaticly create the database entry's with the install file. Here is my export of my 4.7 version. Make sure you specify the correct database.

-- 
-- Table structure for table `sections_data`
-- 

CREATE TABLE `sections_data` (
  `sid` int(10) default NULL,
  `name` text,
  `status` smallint(1) default '0',
  `path` text,
  `template` text,
  `visibility` smallint(1) default '0',
  `weight` int(10) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Good luck.