Welcome, Guest |
|
TOPIC: Migration from Drupal 6 to Drupal 7 - Part II
Migration from Drupal 6 to Drupal 7 - Part II 1 year 2 days ago #46251
| Hello oschampions, Thank you helping me in the migration process of my website to drupal7. At this present moment I upgraded all modules that were available in d7 and installed new ones that I need to for this new version of my website. It looks pretty cool! I found myself with a couple of error messages and looking around your video tutorials I saw that some of those error appeared but you didn't mentioned how to solve them. So I thought to ask you some help on how to fix these issues. Before anything I also want to say that I've looked everywhere in google and forums in drupal.org but wasn't able to find solutions, or I couldn't understand what was said. So, please break these thinks down for me if it's possible. 1) Views: They are not working!! I have tried to access some of the many views in my site, but I found different error messages, such as this: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM node node INNER JOIN taxonomy_index taxonomy_index_value_0 ON node.nid = t' at line 12) CCK and fields migration. I followed the tutorial you offered and everything seemed to work smoothly, but after I tried to migrate fields at the first time and everytime I go back in that page I find this message: Notice: Undefined index: default_image in content_migrate_filefield_field_alter() (line 25 of /sites/all/modules/cck/modules/content_migrate/modules/content_migrate.filefield.inc).Also in the fields list I find this message: Notice: Undefined index: comment_node_forum in _field_ui_bundle_admin_path() (line 325 of /usr/share/drupal6/modules/field_ui/field_ui.module).
Notice: Undefined index: comment_node_forum in field_ui_fields_list() (line 35 of /usr/share/drupal6/modules/field_ui/field_ui.admin.inc).3) Taxonomy image: I wasn't able to install it. When I tried to run the update.php I got this error message: Failed: FieldException: Attempt to create an instance of field taxonomy_image without a bundle. in field_create_instance() (line 464 of /usr/share/drupal6/modules/field/field.crud.inc).At this moment I don't see any picture in the website. Even in the image gallery. Now I wonder whether I need this module or if there's any alternative? WOW, that is a lot! But it's not all... I have a few more problems that I will post here below. I just don't want to make this post longer than this. I hope you will be able to give me a hand. Thank you! Best regards, Mariana :) |
Please become a member of OSTraining to reply to this post. |
Migration from Drupal 6 to Drupal 7 - Part II 1 year 2 days ago #46252
| Here it is: 4) Image: I am trying to run the convert fields batch, but when is about to finish the process this error appears: An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=1338&op=do StatusText: error ResponseText: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'public://images/08_02-cover_0_0.jpg' for key 'uri': INSERT INTO {file_managed} (uid, filename, uri, filemime, filesize, status, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6); Array ( [:db_insert_placeholder_0] => 3 [:db_insert_placeholder_1] => 08_02-cover_0_0.jpg [:db_insert_placeholder_2] => public://images/08_02-cover_0_0.jpg [:db_insert_placeholder_3] => image/jpeg [:db_insert_placeholder_4] => 18143 [:db_insert_placeholder_5] => 1 [:db_insert_placeholder_6] => 0 ) in image_legacy_field_convert_object_pre_load() (line 229 of sites/all/modules/image/image_legacy.field_convert.inc).I've read that it means Drupal is trying to import an image but I already have a image with the same name in the website. How does that really work? 5) Panels: in one page that I use panels there's this message bothering me... Notice: Undefined index: pipeline in panels_panel_context_render() (line 286 of /etc/drupal/6/sites/all/modules/panels/plugins/task_handlers/panel_context.inc).6) PHP: I found this error in the log reports page: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'public://images/08_02-cover_0_0.jpg' for key 'uri': INSERT INTO {file_managed} (uid, filename, uri, filemime, filesize, status, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6); Array ( [:db_insert_placeholder_0] => 3 [:db_insert_placeholder_1] => 08_02-cover_0_0.jpg [:db_insert_placeholder_2] => public://images/08_02-cover_0_0.jpg [:db_insert_placeholder_3] => image/jpeg [:db_insert_placeholder_4] => 18143 [:db_insert_placeholder_5] => 1 [:db_insert_placeholder_6] => 0 ) in image_legacy_field_convert_object_pre_load() (line 229 of /etc/drupal/6/sites/all/modules/image/image_legacy.field_convert.inc).7) Ubercart: I got this message when I tried to go to the product list page. Recoverable fatal error: Argument 2 passed to drupal_goto() must be an array, string given in drupal_goto() (line 668 of /usr/share/drupal6/includes/common.inc).Thank you for any advice you can give me!! Mariana :) |
Please become a member of OSTraining to reply to this post. |
Migration from Drupal 6 to Drupal 7 - Part II 1 year 2 days ago #46256
| Hi Mariana, Good to hear from you again. I hope you don't need immediate answers to all the questions! This is quite a laundry list of problems. I'll try to tackle one, and then whittle the list down a bit. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM node node INNER JOIN taxonomy_index taxonomy_index_value_0 ON node.nid = t' at line 1The word from has meaning in html. It would appear that one of your database tables columns is named with the word from in it. from is a keyword in SQL. You may not use it as a column name without quoting it. In MySQL, things like column names are quoted using backticks, i.e. `from`. - easiest fix - change the name. Let's start there. Ed |
Please become a member of OSTraining to reply to this post. |
Migration from Drupal 6 to Drupal 7 - Part II 1 year 2 days ago #46260
| I did a little research for you, and it looks like there is a common thread to all of these and it points to the data base. I'm not sure how to fix it or where to start yet, but getting the data base fixed looks like it would take care of quite a few problems. I'm not a data base expert. I'll ask the rest of the team to take a look and see if we someone can point you in the right direction. Cheers, Ed Notice: Undefined index: default_image in content_migrate_filefield_field_alter() (line 25 of /sites/all/modules/cck/modules/content_migrate/modules/content_migrate.filefield.inc). I don't know the answer yet, but this post deals with it. drupal.org/node/1100580 Seems it might be a bug, although there are a few suggestions in the post.Notice: Undefined index: pipeline in panels_panel_context_render() (line 286 of /etc/drupal/6/sites/all/modules/panels/plugins/task_handlers/panel_context.inc). The solution to this one may be here. drupal.org/node/1034822 Are you by any chance using an lots of extensions? Seems a lot of people have this problem. PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'public://images/08_02-cover_0_0.jpg' for key 'uri': INSERT INTO {file_managed} (uid, filename, uri, filemime, filesize, status, timestamp) VALUES This is a rather lengthy discussion and it might point in the right direction. drupal.org/node/1163740 or phpmysqltalk.com/1099-magento-1-6-upgrad...-with-solutions.html Notice: Undefined index: comment_node_forum in _field_ui_bundle_admin_path() (line 325 of /usr/share/drupal6/modules/field_ui/field_ui.module). Notice: Undefined index: comment_node_forum in field_ui_fields_list() (line 35 of /usr/share/drupal6/modules/field_ui/field_ui.admin.inc) drupal.org/node/1351506 |
Please become a member of OSTraining to reply to this post. |
Migration from Drupal 6 to Drupal 7 - Part II 1 year 2 days ago #46289
| Thanks Ed! |
Please become a member of OSTraining to reply to this post. |
Migration from Drupal 6 to Drupal 7 - Part II 1 year 2 days ago #46337
| Hi Mariana, I consulted with Nick and, if you haven't already done this, he suggests you first try to fix the database using cpanel or phpMyAdmin. Make a backup of the database first. That could fix some problems. After that, submit your questions one at time in separate posts and we'll try to tackle them. This is a little beyond the scope of what we do since we're teachers and coaches more than technical support. But we'll give you all the help we can, and if we can't we'll try to recommend someone. Post your most important question first. Looking forward to helping. Cheers, Ed |
Please become a member of OSTraining to reply to this post. |
Migration from Drupal 6 to Drupal 7 - Part II 1 year 1 day ago #46427
| Hi Ed, thank you for clarifying how to proceed. Two problems were solved: -The Views that had the sql error: I had to go to each view and delete the broken handler and then add a new field. -There are still few views that result in blank pages, but I think that is related to the taxonomy or image problems I have. I will think about them later. -For the panels error I followed the link you gave me and everything worked fine. Next thing I need to fix is the store. The message below I got when I tried to checkout a product using the test payment gateway: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'weight_units' in 'field list': INSERT INTO {uc_order_products} (order_id, nid, title, model, qty, cost, price, weight, weight_units, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 931 [:db_insert_placeholder_1] => 204 [:db_insert_placeholder_2] => Book on The Cube of Love [:db_insert_placeholder_3] => COL001 [:db_insert_placeholder_4] => 1 [:db_insert_placeholder_5] => 0.00000 [:db_insert_placeholder_6] => 12.95000 [:db_insert_placeholder_7] => 8 [:db_insert_placeholder_8] => oz [:db_insert_placeholder_9] => a:4:{s:10:"attributes";a:0:{}s:9:"shippable";s:1:"1";s:4:"type";s:4:"book";s:6:"module";s:10:"uc_product";} ) in drupal_write_record() (line 7013 of /usr/share/drupal6/includes/common.inc).I am using ubercart and installed all the modules it requires. Thank you, Ed! Mariana :) |
Please become a member of OSTraining to reply to this post. |
Migration from Drupal 6 to Drupal 7 - Part II 1 year 1 day ago #46434
| It looks like this is a pretty common problem, but no definitive answer yet. Here's what others have tried, with varying degrees of success. Clear cache manually, then run update.php again. Compare the database tables to the schema and manually create tables. Completely uninstall and reinstall the module, and run update.php. Remove the field that is causing the problem, and create it again. I haven't seen a clear answer anywhere yet. I have only checked the drupal forum. There may be an answer in the ubercart forum. Let me know if you have tried any of these already. Ed |
Please become a member of OSTraining to reply to this post. |
|
Site Navigation
Open Source Training is not affiliated with or endorsed by the Joomla, WordPress or Drupal projects.
All product names and trademarks are the property of their respective owners.
Copyright 2013 Open Source Training, LLC. All rights reserved.
