Could someone please shine some (any?) light on the following rather scary (as hell) error messages I got when running update.php on the latest dev of 25/3/09 please...? Eeeeeek.

user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: ALTER TABLE panels_pane DROP PRIMARY KEY in /home/virtual/site32/fst/var/www/html/includes/database.mysql-common.inc on line 386.
user warning: Multiple primary key defined query: ALTER TABLE panels_pane CHANGE pid `pid` INT NOT NULL auto_increment, ADD PRIMARY KEY (pid) in /home/virtual/site32/fst/var/www/html/includes/database.mysql-common.inc on line 520.
user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: ALTER TABLE panels_display DROP PRIMARY KEY in /home/virtual/site32/fst/var/www/html/includes/database.mysql-common.inc on line 386.
user warning: Multiple primary key defined query: ALTER TABLE panels_display CHANGE did `did` INT NOT NULL auto_increment, ADD PRIMARY KEY (did) in /home/virtual/site32/fst/var/www/html/includes/database.mysql-common.inc on line 520.
user warning: Unknown table 'panels_object_cache' query: DROP TABLE panels_object_cache in /home/virtual/site32/fst/var/www/html/includes/database.mysql-common.inc on line 261.

Updates were attempted. If you see no failures below, you may proceed happily to the administration pages. Otherwise, you may need to update your database manually. All errors have been logged.

Main page
Administration pages


The following queries were executed


panels module


Update #6004


Failed: ALTER TABLE {panels_pane} DROP PRIMARY KEY
Failed: ALTER TABLE {panels_pane} CHANGE pid `pid` INT NOT NULL auto_increment, ADD PRIMARY KEY (pid)
Failed: ALTER TABLE {panels_display} DROP PRIMARY KEY
Failed: ALTER TABLE {panels_display} CHANGE did `did` INT NOT NULL auto_increment, ADD PRIMARY KEY (did)
ALTER TABLE {panels_pane} CHANGE access `access` LONGTEXT DEFAULT NULL
ALTER TABLE {panels_pane} ADD `style` LONGTEXT DEFAULT NULL
ALTER TABLE {panels_pane} ADD `css` LONGTEXT DEFAULT NULL
ALTER TABLE {panels_pane} ADD `extras` LONGTEXT DEFAULT NULL
Failed: DROP TABLE {panels_object_cache}

Comments

merlinofchaos’s picture

Category: support » bug

These errors are harmless. I need to add a message stating them, or figure out a way to test whether or not I need to perform that update.

merlinofchaos’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.