asapcustoms Posted December 11, 2007 Share Posted December 11, 2007 In our cart our data is doubling on the checkout_confirmation.php ? Has anyone seen this before or know of a fix? Thank you for any feedback or tips. Billing Information Sub-Total: $154.49 Sub-Total: $154.49 Flat Rate (Best Way): $5.00 Flat Rate (Best Way): $5.00 NJ TAX 7.0%: $10.81 NJ TAX 7.0%: $10.81 Total: $170.30 Total: $170.30 Quote Link to comment Share on other sites More sharing options...
Guest Posted December 12, 2007 Share Posted December 12, 2007 In our cart our data is doubling on the checkout_confirmation.php ? Has anyone seen this before or know of a fix? Thank you for any feedback or tips. Billing Information Sub-Total: $154.49 Sub-Total: $154.49 Flat Rate (Best Way): $5.00 Flat Rate (Best Way): $5.00 NJ TAX 7.0%: $10.81 NJ TAX 7.0%: $10.81 Total: $170.30 Total: $170.30 Did you install something where you had to edit files used in the checkout process? Quote Link to comment Share on other sites More sharing options...
asapcustoms Posted December 12, 2007 Author Share Posted December 12, 2007 I have added a few contributions. The code that I found in checkout_confirmation.php that seems to give me the double is below. Is this in anyone elses page as well? anyone know why this would double up the subtotals? Anyone know how to write this code below to not double the output? <?php if (MODULE_ORDER_TOTAL_INSTALLED) { // $order_total_modules->process(); echo $order_total_modules->output(); } ?> Quote Link to comment Share on other sites More sharing options...
Guest Posted December 12, 2007 Share Posted December 12, 2007 I have added a few contributions. The code that I found in checkout_confirmation.php that seems to give me the double is below. Is this in anyone elses page as well? anyone know why this would double up the subtotals? Anyone know how to write this code below to not double the output? <?php if (MODULE_ORDER_TOTAL_INSTALLED) { // $order_total_modules->process(); echo $order_total_modules->output(); } ?> No, that is standard. Check the few contribs that you have installed. Quote Link to comment Share on other sites More sharing options...
asapcustoms Posted December 12, 2007 Author Share Posted December 12, 2007 No, that is standard. Check the few contribs that you have installed. I think I get the error from contribution held orders 2.1 http://addons.oscommerce.com/info/1153 This seems to be the only changes I did with that file. It had DB changes but I added like 30+ mods since so installing a backup will wipe out the last 2 weeks of work. Can someone tell me what to change to remove the SQL DB queries for this mod instead of the install directions? Basically reversing the procedure below? # MySQL-Front Dump 1.19 beta # # Host: localhost Database: puddled_biz #-------------------------------------------------------- # Server version 4.0.0-alpha-nt # # Table structure for table 'holding_orders' # CREATE TABLE /*!32300 IF NOT EXISTS*/ holding_orders ( orders_id int(11) NOT NULL auto_increment, customers_id int(11) NOT NULL DEFAULT '0' , customers_name varchar(64) NOT NULL DEFAULT '' , customers_company varchar(32) , customers_street_address varchar(64) NOT NULL DEFAULT '' , customers_suburb varchar(32) , customers_city varchar(32) NOT NULL DEFAULT '' , customers_postcode varchar(10) NOT NULL DEFAULT '' , customers_state varchar(32) , customers_country varchar(32) NOT NULL DEFAULT '' , customers_telephone varchar(32) NOT NULL DEFAULT '' , customers_email_address varchar(96) NOT NULL DEFAULT '' , customers_address_format_id int(5) NOT NULL DEFAULT '0' , delivery_name varchar(64) NOT NULL DEFAULT '' , delivery_company varchar(32) , delivery_street_address varchar(64) NOT NULL DEFAULT '' , delivery_suburb varchar(32) , delivery_city varchar(32) NOT NULL DEFAULT '' , delivery_postcode varchar(10) NOT NULL DEFAULT '' , delivery_state varchar(32) , delivery_country varchar(32) NOT NULL DEFAULT '' , delivery_address_format_id int(5) NOT NULL DEFAULT '0' , billing_name varchar(64) NOT NULL DEFAULT '' , billing_company varchar(32) , billing_street_address varchar(64) NOT NULL DEFAULT '' , billing_suburb varchar(32) , billing_city varchar(32) NOT NULL DEFAULT '' , billing_postcode varchar(10) NOT NULL DEFAULT '' , billing_state varchar(32) , billing_country varchar(32) NOT NULL DEFAULT '' , billing_address_format_id int(5) NOT NULL DEFAULT '0' , payment_method varchar(32) NOT NULL DEFAULT '' , cc_type varchar(20) , cc_owner varchar(64) , cc_number varchar(32) , cc_expires varchar(4) , last_modified datetime , date_purchased datetime , orders_status int(5) NOT NULL DEFAULT '1' , orders_date_finished datetime , currency char(3) , currency_value decimal(14,6) , ip_address varchar(50) NOT NULL DEFAULT '' , PRIMARY KEY (orders_id) ); # # Table structure for table 'holding_orders_products' # CREATE TABLE /*!32300 IF NOT EXISTS*/ holding_orders_products ( orders_products_id int(11) NOT NULL auto_increment, orders_id int(11) NOT NULL DEFAULT '0' , products_id int(11) NOT NULL DEFAULT '0' , products_model varchar(12) , products_name varchar(64) NOT NULL DEFAULT '' , products_price decimal(15,4) NOT NULL DEFAULT '0.0000' , final_price decimal(15,4) NOT NULL DEFAULT '0.0000' , products_tax decimal(7,4) NOT NULL DEFAULT '0.0000' , products_quantity int(2) NOT NULL DEFAULT '0' , products_returned tinyint(2) unsigned DEFAULT '0' , products_exchanged tinyint(2) NOT NULL DEFAULT '0' , products_exchanged_id int(11) NOT NULL DEFAULT '0' , PRIMARY KEY (orders_products_id) ); # # Table structure for table 'holding_orders_products_attributes' # CREATE TABLE /*!32300 IF NOT EXISTS*/ holding_orders_products_attributes ( orders_products_attributes_id int(11) NOT NULL auto_increment, orders_id int(11) NOT NULL DEFAULT '0' , orders_products_id int(11) NOT NULL DEFAULT '0' , products_options varchar(32) NOT NULL DEFAULT '' , products_options_values varchar(32) NOT NULL DEFAULT '' , options_values_price decimal(15,4) NOT NULL DEFAULT '0.0000' , price_prefix char(1) NOT NULL DEFAULT '' , PRIMARY KEY (orders_products_attributes_id) ); # # Table structure for table 'holding_orders_products_download' # CREATE TABLE /*!32300 IF NOT EXISTS*/ holding_orders_products_download ( orders_products_download_id int(11) NOT NULL auto_increment, orders_id int(11) NOT NULL DEFAULT '0' , orders_products_id int(11) NOT NULL DEFAULT '0' , orders_products_filename varchar(255) NOT NULL DEFAULT '' , download_maxdays int(2) NOT NULL DEFAULT '0' , download_count int(2) NOT NULL DEFAULT '0' , PRIMARY KEY (orders_products_download_id) ); # # Table structure for table 'holding_orders_status_history' # CREATE TABLE /*!32300 IF NOT EXISTS*/ holding_orders_status_history ( orders_status_history_id int(11) NOT NULL auto_increment, orders_id int(11) NOT NULL DEFAULT '0' , orders_status_id int(5) NOT NULL DEFAULT '0' , date_added datetime NOT NULL DEFAULT '0000-00-00 00:00:00' , customer_notified int(1) DEFAULT '0' , comments text , PRIMARY KEY (orders_status_history_id) ); # # Table structure for table 'holding_orders_total' # CREATE TABLE /*!32300 IF NOT EXISTS*/ holding_orders_total ( orders_total_id int(10) unsigned NOT NULL auto_increment, orders_id int(11) NOT NULL DEFAULT '0' , title varchar(255) NOT NULL DEFAULT '' , text varchar(255) NOT NULL DEFAULT '' , value decimal(15,4) NOT NULL DEFAULT '0.0000' , class varchar(32) NOT NULL DEFAULT '' , sort_order int(11) NOT NULL DEFAULT '0' , PRIMARY KEY (orders_total_id), INDEX idx_orders_total_orders_id (orders_id) ); 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.