Ausgirl Posted March 28, 2008 Share Posted March 28, 2008 Hello, Ive installed the latest Oscommerce 2rc2a. When I go through checkout, I get the dreaded 1054 error?? Being the latest download of OSC I figure I shouldnt get this error. Im obviously missing a product table in the database but have no idea which one. The error appears on the http://www.wepersonaliseit.com/checkout_process.php page. I installed the AusPost mod, thinking I may have left part of the SQL out, I reinstalled it and still get the error. I also installed the DLY shipping mod. Thought that might have something to do with it so I unistalled that & still get the error. (that doesnt require to run on a SQL command anyway) It doesnt matter which shipping method I use I get this error. Could someone please tell me how to fix this. 1054 - Unknown column 'shipping_module' in 'field list' insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, shipping_module, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value) values ('4', 'Joe Blow', '', '123 Test St', 'Home', 'Sydney', '2000', 'New South Wales', 'Australia', '123456789', '[email protected]', '1', 'Joe Blow', '', '123 Test St', 'Home', 'Sydney', '2000', 'New South Wales', 'Australia', '1', 'Joe Blow', '', '123 Test St', 'Home', 'Sydney', '2000', 'New South Wales', 'Australia', '1', 'Bank Transfer or Deposit', 'flat_flat', '', '', '', '', now(), '1', 'AUD', '1.00000000') [TEP STOP] Thanks Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2008 Share Posted March 28, 2008 HI Ruth Have you made changes to the checkout_process.php, or installed other contribs? The default setup does not generate errors (but I have not tried local or aust post in this version of osc). I also got on the bottom of the log in page: Fatal error: Call to undefined function tep_banner_exists() in /home/weperson/public_html/includes/footer.php on line 80 Link to comment Share on other sites More sharing options...
Ausgirl Posted March 28, 2008 Author Share Posted March 28, 2008 Hi Les, The only modification Ive made to the checkout_process.php page (that I can think of, Ive installed heaps of contibutions) is the Blacklist mod. I dont think that would affect it though, would it? Link to comment Share on other sites More sharing options...
Ausgirl Posted March 28, 2008 Author Share Posted March 28, 2008 I also got on the bottom of the log in page: Fatal error: Call to undefined function tep_banner_exists() in /home/weperson/public_html/includes/footer.php on line 80 Thats gone now, I was just getting rid of the banner on the bottom, the banner problem is all fixed now. Still have the other problem though Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2008 Share Posted March 28, 2008 Hi Les, The only modification Ive made to the checkout_process.php page (that I can think of, Ive installed heaps of contibutions) is the Blacklist mod. I dont think that would affect it though, would it? Don't know him. Try some of the stock payment and shipping options to try to isolate the cause. Link to comment Share on other sites More sharing options...
Ausgirl Posted March 28, 2008 Author Share Posted March 28, 2008 None of the Paypal options show when installed. (I dont even know what 1/2 the information is (nor do I have it) that its asking you for, so its no good to me anyway. I uploaded another Paypal that I found in the contributions section call osc2rc2aAUS it said it was an Aussie Version. I only uploaded the Paypal & nothing else. I deleted this new Paypal & still got the error, so I reinstalled it. This Paypal is the only one that works (up until the checkout process page anyway). I took out the Blacklist code & still got the error, Ive got the "must agree to terms" mod installed, but by memory I dont think any of that code is in the checkout_process.php (cant see any) I uninstalled all the payment mods I added (Paymate, Bank Transfer) still got the error. This is driving me nuts! :wacko: Its probably something simple but I dont know what it is. It might be the Auspost shipping mod but I dont know what the original code was for the SQL for the shipping as the SQL for the Auspost starts with drop table if exists ect... Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2008 Share Posted March 28, 2008 None of the Paypal options show when installed. (I dont even know what 1/2 the information is (nor do I have it) that its asking you for, so its no good to me anyway. I uploaded another Paypal that I found in the contributions section call osc2rc2aAUS it said it was an Aussie Version. I only uploaded the Paypal & nothing else. I deleted this new Paypal & still got the error, so I reinstalled it. This Paypal is the only one that works (up until the checkout process page anyway). I took out the Blacklist code & still got the error, Ive got the "must agree to terms" mod installed, but by memory I dont think any of that code is in the checkout_process.php (cant see any) I uninstalled all the payment mods I added (Paymate, Bank Transfer) still got the error. This is driving me nuts! :wacko: Its probably something simple but I dont know what it is. It might be the Auspost shipping mod but I dont know what the original code was for the SQL for the shipping as the SQL for the Auspost starts with drop table if exists ect... That sql was just to add the zone information. Was that paymate spi? Did you try the stock flat rate shipping? You can email me the checkout_process.php file if you want. Link to comment Share on other sites More sharing options...
Ausgirl Posted March 28, 2008 Author Share Posted March 28, 2008 Yep, I tried flat and per item. I downloaded the Paymate Express, I couldnt remember the name of the one you told me to redo a few months back :- Link to comment Share on other sites More sharing options...
Ausgirl Posted March 29, 2008 Author Share Posted March 29, 2008 Just in case anyone else may have this problem with checkout using the OSC 2rc2a. Thanks to Les, this did the trick! Remove this line (about line 114) in catalog -> checkout_process.php 'shipping_module' => $shipping['id'], Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.