Hello,
I'm trying to install the Panels module and keep getting these errors:

In /admin/build/modules:

* user warning: Table 'database_name.panels_info' doesn't exist query: SELECT * FROM panels_info in /home/content/s/h/a/shadimd07/html/includes/database.mysql.inc on line 172.
* user warning: Table 'database_name.panels_info' doesn't exist query: SELECT * FROM panels_info in /home/content/s/h/a/shadimd07/html/includes/database.mysql.inc on line 172.
* user warning: Table 'database_name.panels_info' doesn't exist query: SELECT * FROM panels_info in /home/content/s/h/a/shadimd07/html/includes/database.mysql.inc on line 172.

In /admin/build/panels

user warning: Table 'database_name.panels_info' doesn't exist query: SELECT * FROM panels_info ORDER BY title in /home/content/s/h/a/shadimd07/html/includes/database.mysql.inc on line 172.

I got this message in Status report:

Database schema Out of date
Some modules have database schema updates to install. You should run the database update script immediately.

I ran the update script - it gave me an option to update Panels. When I did that I got these two errors:

Location /index.php?q=admin/logs/watchdog
Table 'database_name.panels_info' doesn't exist query: SELECT * FROM panels_info in /home/content/s/h/a/shadimd07/html/includes/database.mysql.inc on line 172.

Location /admin/build/panels
user warning: Table 'database_name.panels_info' doesn't exist query: SELECT * FROM panels_info ORDER BY title in /home/content/s/h/a/shadimd07/html/includes/database.mysql.inc on line 172.

When I refreshed Status report - no errors were there.
When I refreshed /admin/build/panels : still the same error as before

Drupal - 5.2
MySQL database - 5.0.45
PHP - 5.1.4

I'm using these contributed modules:
Views, CCK, Pathauto, Tokens, Forward, Printer-Friendly, Five Star, Voting API, TinyMCE, Image, Image assist, Automated Logout, Frontpage

Should I create the table panels_info manually? If so - what's the SQL code?

Comments

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Fixed

Try uninstalling and reinstalling panels; that should create the tables for you.

housemd’s picture

housemd commented

I already tried - same result.

merlinofchaos’s picture

merlinofchaos commented

Hmm. The problem seems likely to be the record for your module in the system table.

Try executing this query in your database, after you've uninstalled panels.

DELETE FROM system WHERE name = 'panels';

Then install panels normally.

The key here is that you're getting the 'out of date' which suggests bad information in that table is causing it to think that your installation level is not where it actually is.

housemd’s picture

housemd commented

YOYOYO! You are the Man! Great work!
Thank you, thank you, and thank you. :)

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)