Hi,

During install i got the following error:

Specified key was too long; max key length is 767 bytes query: ALTER TABLE content_node_field MODIFY field_name VARCHAR(256) in /Users/beheer/Sites/mm/sites/all/modules/magento/modules/magento_stores/magento_stores.install op regel 118.

Installation went on but now i get the following error:

Unknown column 'field__last_autosynch_magento_id_value' in 'field list' query: INSERT INTO content_type_magento_store (vid, nid, field_store_code_value, field_store_is_active_value, field_store_sort_order_value, field__autosynch___value, field__last_autosynch_magento_id_value, field__last_autosynch_time___value, field__store_group___nid) VALUES (3, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL) in /Users/beheer/Sites/mm/sites/all/modules/cck/content.module op regel 1213.

I can see that the field is named field__last_autosynch_magento_id instead of field__last_autosynch_magento_id_value under field settings....

Help?

Cheers,
Henk

Comments

itsekhmistro’s picture

itsekhmistro commented

Hi,

you have a problems with you SQL DB. (probably, due to default collation and charset encoding used in your MySQL server installation)

Please, specify what collation and charset encoding is used in the DB for `content_node_field` table and column `field_name` and what version of MySQL server is used.

itsekhmistro’s picture

itsekhmistro commented
Assigned: Unassigned » itsekhmistro
Status: Active » Fixed

Hi, Henk

we have fixed this issue with InnoDB tables, please apply following patch:

--- /magento/modules/magento_stores/magento_stores.install
+++ /magento/modules/magento_stores/magento_stores.install
@@ -115,8 +115,8 @@ function magento_stores_install() {
   drupal_install_schema('magento_stores');

   /* WARNING! update existing tables because 32 characters is not enough for our attributes */
-  update_sql('ALTER TABLE {content_node_field} MODIFY field_name VARCHAR(256)');
-  update_sql('ALTER TABLE {content_node_field_instance} MODIFY field_name VARCHAR(256)');
+  update_sql('ALTER TABLE {content_node_field} MODIFY field_name VARCHAR(255)');
+  update_sql('ALTER TABLE {content_node_field_instance} MODIFY field_name VARCHAR(255)');
 }
henkit’s picture

henkit commented

Thanx for the very fast reply! Synchronization works again! :)

Can go forward with testing again

Thanx again!

Henk

itsekhmistro’s picture

itsekhmistro commented
Status: Fixed » Closed (fixed)

Patch applied into 6.x-2.x