Closed (fixed)
Project:
Panels
Version:
6.x-3.x-dev
Component:
Miscellaneous
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
25 Mar 2009 at 12:35 UTC
Updated:
14 May 2009 at 22:20 UTC
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
Comment #1
merlinofchaos commentedThese 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.
Comment #2
merlinofchaos commented