CCK upgarde issue with UTF-8
holydrupal - January 16, 2008 - 08:14
| Project: | Content Construction Kit (CCK) |
| Version: | 5.x-1.6-1 |
| Component: | General |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
I am using:
Drupal 5.6
CCK latest stable version.
after I ran update.php I received the below error:
* user warning: Unknown column 'description' in 'field list' query: UPDATE node_group SET settings = 'a:2:s:4:\"form\";a:2:s:7:\"display\";a:3:s:5:\"label\";s:5:\"above\";s:6:\"teaser\";s:20:\"fieldset_collapsible\";s:4:\"full\";s:20:\"fieldset_collapsible\";s:11:\"description\";N;s:7:\"display\";a:3:s:11:\"collapsible\";i:0;s:9:\"collapsed\";i:0;s:11:\"description\";s:0:\"\";', description = '' WHERE group_name = 'group____86' in C:\xampp\htdocs\intranet\includes\database.mysql.inc on line 172.
* user warning: Unknown column 'description' in 'field list' query: UPDATE node_group SET settings = 'a:2:s:4:\"form\";a:1:s:11:\"description\";N;s:7:\"display\";a:3:s:11:\"collapsible\";i:0;s:9:\"collapsed\";i:0;s:11:\"description\";s:0:\"\";', description = '' WHERE group_name = 'group____85' in C:\xampp\htdocs\intranet\includes\database.mysql.inc on line 172.
* user warning: Unknown column 'description' in 'field list' query: UPDATE node_group SET settings = 'a:2:s:4:\"form\";a:1:s:11:\"description\";N;s:7:\"display\";a:3:s:11:\"collapsible\";i:0;s:9:\"collapsed\";i:0;s:11:\"description\";s:0:\"\";', description = '' WHERE group_name = 'group____' in C:\xampp\htdocs\intranet\includes\database.mysql.inc on line 172.
* user warning: Unknown column 'description' in 'field list' query: UPDATE node_group SET settings = 'a:2:s:4:\"form\";a:1:s:11:\"description\";N;s:7:\"display\";a:3:s:11:\"collapsible\";i:0;s:9:\"collapsed\";i:0;s:11:\"description\";s:0:\"\";', description = '' WHERE group_name = 'group___' in C:\xampp\htdocs\intranet\includes\database.mysql.inc on line 172.
* user warning: Unknown column 'description' in 'field list' query: UPDATE node_group SET settings = 'a:2:s:4:\"form\";a:1:s:11:\"description\";N;s:7:\"display\";a:3:s:11:\"collapsible\";i:0;s:9:\"collapsed\";i:0;s:11:\"description\";s:0:\"\";', description = '' WHERE group_name = 'group__' in C:\xampp\htdocs\intranet\includes\database.mysql.inc on line 172.
* user warning: Unknown column 'description' in 'field list' query: UPDATE node_group SET settings = 'a:2:s:4:\"form\";a:2:s:7:\"display\";a:3:s:5:\"label\";s:5:\"above\";s:6:\"teaser\";s:20:\"fieldset_collapsible\";s:4:\"full\";s:20:\"fieldset_collapsible\";s:11:\"description\";N;s:7:\"display\";a:3:s:11:\"collapsible\";i:0;s:9:\"collapsed\";i:0;s:11:\"description\";s:0:\"\";', description = '' WHERE group_name = 'group_' in C:\xampp\htdocs\intranet\includes\database.mysql.inc on line 172.
* user warning: Can't DROP 'description'; check that column/key exists query: ALTER TABLE node_group DROP description in C:\xampp\htdocs\intranet\includes\database.mysql.inc on line 172.The following queries were executed
content module
Update #1004
* DELETE FROM {node_field} WHERE field_name NOT IN ('field_contract_category', 'field_contract_date', 'field_contract_subject', 'field_contract_with', 'field_enddate_contract', 'field_no_report', 'field_stratdate_contract', 'field__', 'field___', 'field___0', 'field____', 'field____0', 'field____1', 'field____2', 'field____3', 'field____4', 'field____5', 'field____6')
* DROP TABLE {content_type_}
Update #1005
* No queries
Update #1006
* The text field field__ has been updated to accept NULL values.
* The text field field____6 has been updated to accept NULL values.
* The text field field____ has been updated to accept NULL values.
* The text field field____5 has been updated to accept NULL values.
* The text field field_contract_subject has been updated to accept NULL values.
* The text field field___0 has been updated to accept NULL values.
* The text field field_contract_date has been updated to accept NULL values.
* The text field field_contract_with has been updated to accept NULL values.
* The text field field_stratdate_contract has been updated to accept NULL values.
* The text field field_enddate_contract has been updated to accept NULL values.
* The text field field_no_report has been updated to accept NULL values.
Update #1007
* No queries
Update #1008
* No queries
fieldgroup module
Update #2
* ALTER TABLE {node_group} CHANGE settings settings mediumtext NOT NULL
* Failed: UPDATE {node_group} SET settings = 'a:2:{s:4:\"form\";a:2:{s:7:\"display\";a:3:{s:5:\"label\";s:5:\"above\";s:6:\"teaser\";s:20:\"fieldset_collapsible\";s:4:\"full\";s:20:\"fieldset_collapsible\";}s:11:\"description\";N;}s:7:\"display\";a:3:{s:11:\"collapsible\";i:0;s:9:\"collapsed\";i:0;s:11:\"description\";s:0:\"\";}}', description = '' WHERE group_name = 'group____86'
* Failed: UPDATE {node_group} SET settings = 'a:2:{s:4:\"form\";a:1:{s:11:\"description\";N;}s:7:\"display\";a:3:{s:11:\"collapsible\";i:0;s:9:\"collapsed\";i:0;s:11:\"description\";s:0:\"\";}}', description = '' WHERE group_name = 'group____85'
* Failed: UPDATE {node_group} SET settings = 'a:2:{s:4:\"form\";a:1:{s:11:\"description\";N;}s:7:\"display\";a:3:{s:11:\"collapsible\";i:0;s:9:\"collapsed\";i:0;s:11:\"description\";s:0:\"\";}}', description = '' WHERE group_name = 'group____'
* Failed: UPDATE {node_group} SET settings = 'a:2:{s:4:\"form\";a:1:{s:11:\"description\";N;}s:7:\"display\";a:3:{s:11:\"collapsible\";i:0;s:9:\"collapsed\";i:0;s:11:\"description\";s:0:\"\";}}', description = '' WHERE group_name = 'group___'
* Failed: UPDATE {node_group} SET settings = 'a:2:{s:4:\"form\";a:1:{s:11:\"description\";N;}s:7:\"display\";a:3:{s:11:\"collapsible\";i:0;s:9:\"collapsed\";i:0;s:11:\"description\";s:0:\"\";}}', description = '' WHERE group_name = 'group__'
* Failed: UPDATE {node_group} SET settings = 'a:2:{s:4:\"form\";a:2:{s:7:\"display\";a:3:{s:5:\"label\";s:5:\"above\";s:6:\"teaser\";s:20:\"fieldset_collapsible\";s:4:\"full\";s:20:\"fieldset_collapsible\";}s:11:\"description\";N;}s:7:\"display\";a:3:{s:11:\"collapsible\";i:0;s:9:\"collapsed\";i:0;s:11:\"description\";s:0:\"\";}}', description = '' WHERE group_name = 'group_'
* Failed: ALTER TABLE {node_group} DROP description
Update #3
* UPDATE {node_group} SET settings = 'a:2:{s:7:\"display\";a:4:{s:5:\"label\";s:5:\"above\";s:6:\"teaser\";s:20:\"fieldset_collapsible\";s:4:\"full\";s:20:\"fieldset_collapsible\";s:5:\"style\";s:8:\"fieldset\";}s:4:\"form\";a:1:{s:5:\"style\";s:8:\"fieldset\";}}' WHERE group_name = 'group____86'
* UPDATE {node_group} SET settings = 'a:2:{s:4:\"form\";a:1:{s:5:\"style\";s:8:\"fieldset\";}s:7:\"display\";a:1:{s:5:\"style\";s:8:\"fieldset\";}}' WHERE group_name = 'group____85'
* UPDATE {node_group} SET settings = 'a:2:{s:4:\"form\";a:1:{s:5:\"style\";s:8:\"fieldset\";}s:7:\"display\";a:1:{s:5:\"style\";s:8:\"fieldset\";}}' WHERE group_name = 'group____'
* UPDATE {node_group} SET settings = 'a:2:{s:4:\"form\";a:1:{s:5:\"style\";s:8:\"fieldset\";}s:7:\"display\";a:1:{s:5:\"style\";s:8:\"fieldset\";}}' WHERE group_name = 'group___'
* UPDATE {node_group} SET settings = 'a:2:{s:4:\"form\";a:1:{s:5:\"style\";s:8:\"fieldset\";}s:7:\"display\";a:1:{s:5:\"style\";s:8:\"fieldset\";}}' WHERE group_name = 'group__'
* UPDATE {node_group} SET settings = 'a:2:{s:7:\"display\";a:4:{s:5:\"label\";s:5:\"above\";s:6:\"teaser\";s:20:\"fieldset_collapsible\";s:4:\"full\";s:20:\"fieldset_collapsible\";s:5:\"style\";s:8:\"fieldset\";}s:4:\"form\";a:1:{s:5:\"style\";s:8:\"fieldset\";}}' WHERE group_name = 'group_'
Update #4
* UPDATE {system} SET weight = 9 WHERE name = 'fieldgroup'May someone help me with the error log?
the drupal no longer recognizes my cck content :(
urgent help needed
#1
I forgot to say that the descriptions are written in Persian.