Drupal 6.19 setup

I am involved in D6 usage by biodiversity community in UK where Drupal taxonomy is frequently used to hold biological taxonomy. So, my small test site has a taxonomy containing the biological classification of a couple of families of flies: 423 terms, 66 synonyms and mostly at 5 levels of nesting (representing: family, subfamily, tribe, genus, species). I have run this through update to D7 from time to time (mostly with plenty of upgrade failures - until now!).

If I go to /admin/taxonomy in D6 and click the "list terms" link for the vocabulary, it takes 13.4 seconds to come back with the list shown in screen shot taxonomy_drupal6.png. I can click any of the edit links to edit a term with no problem.

Upgrading from D6.16 to latest HEAD (as of 20/09/2010) worked! update.php reported 108 operations and no errors.

Drupal 7 problems

If I open the upgraded site in D7 and go to /admin/structure/taxonomy and click the "list terms" link for the vocabulary, it takes 3min 41 seconds to produce the list in the screenshot Drupal_7_list_terms.png. This lacks any D7 styling (default theme) as you can see. Clicking one of the "edit" links next to a term produces an error (screenshot attached):

PDO Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause': SELECT ff.* FROM {filter_format} ff WHERE {status = :db_condition_placeholder_0) ORDER BY weight ASC; Array ( [:db_condition_placeholder_0] => 1 ) in filter_formats() (line 382 of C:\WebStuff\www\drupal7\modules\filter\filter.module).

The information from the D6 term_ tables seems to have been trsnferred correctly to the D7 taxonomy_ tables as far as I can see. I attach SQL dumps of these tables.

So, the issues are:

  1. The display of "List terms" is not working properly,
  2. It is taking over 16x longer, compared to D6, too produce the list - such as it is,
  3. Editing a term appears to be broken.

My environment

Windows XP SP3, running in a virtual box in an old Athlon 1800+, 1.5GHz (so it is quite slooow!). The virtual machine has 512Mb RAM. Apache 2.2.15, PHP 5.2.13, MySQL 5.1.45.

CommentFileSizeAuthor
#18 d6_system.sql_.zip11.27 KBStuartJNCC
taxonomy_d7_update.sql_.zip9.93 KBStuartJNCC
taxonomy_d6.sql_.zip9.81 KBStuartJNCC
edit taxonomy term.png41.42 KBStuartJNCC
Drupal_7_list_terms.png15.83 KBStuartJNCC
taxonomy_drupal6.png44.58 KBStuartJNCC
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Anonymous’s picture

Anonymous (not verified) CreditAttribution: Anonymous commented
Status: Active » Postponed (maintainer needs more info)

The update hook filter_update_7000() is supposed to add a status column to the filter_format table, but the error shows that this column is missing.

I suspect if you edited a node, you would have the same issues. I don't think this is a taxonomy problem. Are you sure there were no errors in the upgrade?

StuartJNCC’s picture

StuartJNCC CreditAttribution: StuartJNCC commented

I confirm that the filter_format table doesn't have a status field. Its fields are: format, name, cache and weight.

I tried editing other nodes and didn't get the error. Since most of the content is in types created by CCK and, consequently most of the fields are sitting in content_ tables that aren't accessed by D7 - all I see in the edit screens is the title and the taxonomy tag - but nevertheless it does work that far,

I checked Reports - Recent log messages and can only find three reports that seem relevant to the upgrade from D6 and they concern system_update_7060():

  • A php Warning Location http://localhost/drupal7/update.php?id=2&op=do, Warning: Invalid argument supplied for foreach() in system_update_7060() (line 2827 of C:\WebStuff\www\drupal7\modules\system\system.install).
  • Two instances of a php Notice from the same location: Notice: Undefined variable: node_revisions in system_update_7060() (line 2818 of C:\WebStuff\www\drupal7\modules\system\system.install).

The is no mention of filter_update_7000() that I can find.

Would it help if I ran the upgrade again?

Anonymous’s picture

Anonymous (not verified) CreditAttribution: Anonymous commented

You should run the update again, and probably if you seek support in IRC this upgrade issue may be easier to pin point.

Damien Tournoud’s picture

Damien Tournoud CreditAttribution: Damien Tournoud commented
Title: Multiple problems accessing taxonomy after upgrade from D6 » PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status', ...line 382 of /modules/filter/filter.module
Component: taxonomy.module » filter.module
Category: bug » support
Status: Postponed (maintainer needs more info) » Active

@klonos that's a different issue: alpha to alpha updates are not supported.

@StuartJNCC: one update probably failed, preventing all the updates that depend on it from running. I'm moving this to a support request until you figure out what precise update failed. My guess would be that we have fixed most of the issues of the upgrade path by now.

chx’s picture

chx CreditAttribution: chx commented

@klonos, I deleted your spam from this issue. Damien clearly warned you, repeat offense will result in your ban.

StuartJNCC please dump your system table and attach. Thanks.

StuartJNCC’s picture

StuartJNCC CreditAttribution: StuartJNCC commented
FileSize
d6_system.sql_.zip11.27 KB

OK, here is a dump of the system table from D6 updated to D7.

sun’s picture

sun
Primary language German
Location Karlsruhe
CreditAttribution: sun commented
Status: Active » Postponed (maintainer needs more info)

Looks like filter updates ran.

('modules/filter/filter.module', 'filter', 'module', '', 1, 0, 7009, 0,

Can you try the upgrade once more?

Anonymous’s picture

Anonymous (not verified) CreditAttribution: Anonymous commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

No response from OP.

warmth’s picture

warmth CreditAttribution: warmth commented

I'm getting this:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'where clause': SELECT reg_code FROM {invite} WHERE email = :mail; Array ( [:mail] => EMAILADDRESS ) en invite_find_invite() (línea 713 de /home/MYSITE/www/SUBFOLDER/sites/all/modules/invite/invite.module).

Is this related?

bennos’s picture

bennos CreditAttribution: bennos commented

Getting the same problem as posted in comment #21.
Invite module is activated.
Maybe wrong place here, think this is a problem with the invite module and not updated drupal functions.

khli7’s picture

khli7 CreditAttribution: khli7 commented
Assigned: Unassigned » khli7
Status: Closed (cannot reproduce) » Closed (won't fix)

Dear Sir/Madam,

I have just downloaded and and am now going to install a nice design theme Designmd01 - Responsive Drupal 7" from themeforest webpage.

Just come across the problem when I upgrade the website.

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'expire' in 'field list': SELECT expire, value FROM {semaphore} WHERE name = :name; Array [:name] => variable_init in lock_may_be_available line 167 of /home/mattscom/public_html/includes/lock.inc.

Uncaught exception thrown in shutdown function.

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'value' in 'where clause': DELETE FROM {semaphore} WHERE value = :db_condition_placeholder_0 ; Array [:db_condition_placeholder_0] => 377660395184e535493769.99858540 in lock_release_all line 269 of /home/mattscom/public_html/includes/lock.inc.

It would be much appreciated if you can teach me how to solve these problems.

My webpage is http://www.mattcreations.com

Thanks very much,
Matthew