joyces Posted August 2, 2008 Share Posted August 2, 2008 Hi What a way to spend a weekend - pulling my hair out!! I have added the PAW contribution osCommerce v2.2rc2a - Purchase Without Account v2.0e When I try to add the common.sql to the database I get this error Error SQL-query : ALTER TABLE `customers` MODIFY COLUMN `customers_password` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_general_ci MySQL said: You have an error in your SQL syntax near 'CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1 When I then try to do a test order I get the following message 1048 - Column 'customers_password' cannot be null insert into customers (customers_firstname, customers_lastname, customers_email_address, customers_telephone, customers_fax, customers_newsletter, customers_password, guest_account, customers_gender, customers_dob) values ('Andrea', 'Joyce', '[email protected]', '0111111111', '', '', null, '1', 'f', '19610827') The only post I can find which seems to refer to this, but not exactly, says 1048 - Column 'guest_account' cannot be null NOT 'customer_password' cannot be null I tried making the amendments suggested to create_account.php (http://www.oscommerce.com/forums/index.php?showtopic=309382&pid=1282724&mode=threaded&start=0#entry1282724) but still the same problem. Please can anyone help me out - would be eternally grateful cheers Andrea Quote Link to comment Share on other sites More sharing options...
F0l2saken Posted September 22, 2008 Share Posted September 22, 2008 (edited) HiWhat a way to spend a weekend - pulling my hair out!! I have added the PAW contribution osCommerce v2.2rc2a - Purchase Without Account v2.0e When I try to add the common.sql to the database I get this error Error SQL-query : ALTER TABLE `customers` MODIFY COLUMN `customers_password` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_general_ci MySQL said: You have an error in your SQL syntax near 'CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1 When I then try to do a test order I get the following message 1048 - Column 'customers_password' cannot be null insert into customers (customers_firstname, customers_lastname, customers_email_address, customers_telephone, customers_fax, customers_newsletter, customers_password, guest_account, customers_gender, customers_dob) values ('Andrea', 'Joyce', '[email protected]', '0111111111', '', '', null, '1', 'f', '19610827') The only post I can find which seems to refer to this, but not exactly, says 1048 - Column 'guest_account' cannot be null NOT 'customer_password' cannot be null I tried making the amendments suggested to create_account.php (http://www.oscommerce.com/forums/index.php?showtopic=309382&pid=1282724&mode=threaded&start=0#entry1282724) but still the same problem. Please can anyone help me out - would be eternally grateful cheers Andrea I have the exact same problem, it broke my site and now I have to go undo all those hour long changes I had to make to my script. Does anyone know how to fix this problem? Edited September 22, 2008 by F0l2saken Quote Link to comment Share on other sites More sharing options...
susan2008 Posted December 6, 2008 Share Posted December 6, 2008 HI , I have fixed this problem open phpMyAdmin choose your database /customers ,edit guest_account table change not null to null ,everything is ok . Quote Link to comment Share on other sites More sharing options...
bjhampe Posted October 6, 2009 Share Posted October 6, 2009 Was there ever a fix for the customers_password portion of this? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.