Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By shah.arpita85 on
I have installed "cck_address" and "cck_address_extensions" module after upgrading them to Drupal 6.x.
When I create a field of type "address", I get the error:
* user warning: 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 'NOT NULL DEFAULT ''''' at line 1 query: ALTER TABLE content_type_test ADD `field_3_street1` NOT NULL DEFAULT '''' in E:\root\drupal-6.10\includes\database.mysql-common.inc on line 298.
* user warning: 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 'DEFAULT NULL' at line 1 query: ALTER TABLE content_type_test ADD `field_3_street2` DEFAULT NULL in E:\root\drupal-6.10\includes\database.mysql-common.inc on line 298.
* user warning: 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 'NOT NULL DEFAULT ''''' at line 1 query: ALTER TABLE content_type_test ADD `field_3_city` NOT NULL DEFAULT '''' in E:\root\drupal-6.10\includes\database.mysql-common.inc on line 298.
* user warning: 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 'DEFAULT NULL' at line 1 query: ALTER TABLE content_type_test ADD `field_3_other` DEFAULT NULL in E:\root\drupal-6.10\includes\database.mysql-common.inc on line 298.
* warning: Invalid argument supplied for foreach() in E:\root\drupal-6.10\includes\form.inc on line 1197.
Kindly help me out with this.
Comments
.
I don't know the whole chain of events referring to upgrading to D6. I did notice D6.10 rather than D6.11
sounds like something not talking nicely... did you run updates after upgrading the modules to bring the database up to speed with the newly upgraded modules?
MySQL error after installing modules
I downloaded the 5.x versions of cck_address and cck_address_extensions modules. Then I upgraded the two modules to 6.x versions using automatic upgradation available at http://boombatower.com/tools/deadwood
After installing the modules, I ran update.php.
Still when I create a field of type "address", I get the above mentioned error.
I really need urgent help on this.
.
I personally haven't used anything that was outside of drupal for modules..
As far as writing modules or porting them, I am not able..
I looked at the cck_address field module and it's only listed for D5.
You might try adding a feature request for the module maintainers to port it to D6 or check with the site that provided the upgrade to D6.
ok thanks :)
ok thanks :)