Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

asapcustoms

Archived
  • Posts

    18
  • Joined

  • Last visited

About asapcustoms

  • Birthday 04/17/1976

Profile Information

  • Real Name
    Steve
  • Location
    East Coast
  • Interests
    Web development, Search Marketing, Family and Custom Cars.
  • Website

asapcustoms's Achievements

  1. 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) );
  2. 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(); } ?>
  3. 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
  4. I do not do wholesale yet, because that would require a w-9 and another form which I am not set-up to do just yet. However if you order in bulk I can offer discount on some items

  5. We should hookup? Do you offer wholesale on your neon? We have asapcustoms which has 16K+ items. Our cart is being worked on tonight but should be back up tomorrow. I just posted for some help here as well with our little db issue.

  6. I updated to V1.2 and everything is good now. Nice work :-)
  7. I am getting a simalar error on my V 1.0 install? http://www.asapcustoms.com/catalog/rss.xml http://www.asapcustoms.com/catalog/news.php Please help - see error - I created no whitespace? Whitespace is not allowed at this location. Line: 3 Character: 271 fwrite (Resource id #39, “<title>Your Title</title><link>http://www.asapcustoms.com</link><description>Your description</description><language>en-us</language><docs>http://www.asapcustoms.com/catalog/rss.xml</docs><item><title>Did you know we offer shop equipment & work tools at asapcustoms</title><pubDate>Date: 01/01/2007</pubDate><description>ASAP Customs not only offers performance and body parts but also hundreds of popular tools. From now until 04/01/07 get 10% off all the items in our air tools category.</description><link>http://www.asapcustoms.com/catalog/news.php?article=1</link></item></channel></rss>
×
×
  • Create New...