Error on checkout before finishing, database crashed...

[dglite]

Hi: I am using Virtuemart 2.014 and also 3.0.16 and Joomla 3.5

When I go to checkout, the site crashes and we see this message...

You have an error in your SQL syntax; check the manual that corresponds to your xxx server version for the right syntax to use near '' at line 1 SQL=SELECT state_name FROM xxxxx_virtuemart_states WHERE virtuemart_state_id=

It has been happening lots of times, I had searched lots of forum, also made fresh installations, repaired DB, clean it... I had been VM user for years but this is the first time I cannot fix it, any suggestion?

[GJC Web Design]

thats not all the message but assume because the state id is missing

virtuemart_state_id=

so backtrack from there to find this query and why it isn't finding the state id or at least not checking that it is valid before forming and setting the query

[dglite]

Hi: I had been working with this for days.
The _states db table is ok, I had tried uploading it again, a working one, also repair table, optimize table, etc.. but still same message, the db crashed.
I had also tried on other servers and configurations and removing oveerides and it happens again, it is difficult to guess where is the origin of the error, any tip?

[dglite]

Now we also see this error, instead of previous one...

Unknown column 'cost_min_transaction' in 'field list' SQL=INSERT INTO `#__virtuemart_payment_plg_standard` (`id`,`virtuemart_order_id`,`order_number`,`virtuemart_paymentmethod_id`,`payment_name`,`payment_order_total`,`payment_currency`,`email_currency`,`cost_per_transaction`,`cost_min_transaction`,`cost_percent_total`,`tax_id`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('0','4','Y43Q06','9',' ','364000','ARS','7','','','','-1','2016-05-11 13:08:16','404','2016-05-11 13:08:16','404')

It seems that the message that appears is random, and on each checkout database crases always indicating DB tables missing, but the tables are there.... any tip?

[GJC Web Design]

I am using Virtuemart 2.014 and also 3.0.16 and Joomla 3.5

what on earth does that statement mean??  Try a fresh copy as it sounds like you have corrupted DB tables

or try the VM admin table updater etc

AOI same version as core etc?

[dglite]

Hi: sorry for the few information sent, here it is more clear...

Joomla: 3.4.5
Virtuemart: 3.0.16 (also tried with 3.0.14 but same problem)

cPanel Version    54.0 (build 21)
Apache Version    2.2.24
PHP Version    5.3.26
MySQL Version    5.5.31-30.3-log
Operating System    linux

I had also tried...

- VM Database Table Updater
- over the same site, reinstall VM both versions
- repair and optimize tables

Components Installed...

Acymailing
Breezingforms
Favorites and Whishlist
Layer Slider
Phoca PDF

I keep having database messages all the time, random tables, after checkout, I can not finish the process...
The tables are there, so no DB bug...

Some other messages...


--------------------------
Invalid address: site.com

--------------------------
Unknown column 'order_create_invoice_pass' in 'field list' SQL=INSERT INTO `xxx_virtuemart_orders` (`virtuemart_order_id`,`virtuemart_user_id`,`virtuemart_vendor_id`,`order_number`,`order_pass`,`order_create_invoice_pass`,`customer_number`,`order_total`,`order_salesPrice`,`order_billTaxAmount`,`order_billTax`,`order_billDiscountAmount`,`order_discountAmount`,`order_subtotal`,`order_tax`,`order_shipment`,`order_shipment_tax`,`order_payment`,`order_payment_tax`,`coupon_discount`,`order_discount`,`order_currency`,`order_status`,`user_currency_id`,`user_currency_rate`,`virtuemart_paymentmethod_id`,`virtuemart_shipmentmethod_id`,`ip_address`,`order_language`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('0','404','1','VUGA08026','p_X9qpTvtX','szrqgv2p','294228dbca14b20d3a7f8d206589c185','19500','19500','0','0','0','0','19500','0','0','0','0','0','0','0','7','P','7','1','6','162','186.19.220.xx','es-ES','2016-05-11 14:23:56','404','2016-05-11 14:23:56','404')


1146 - Table 'xxx.#__virtuemart_categories_' doesn't exist SQL=SELECT category_name FROM #__virtuemart_categories_, #__virtuemart_product_categories WHERE #__virtuemart_product_categories.virtuemart_product_id=9379 AND #__virtuemart_categories_.virtuemart_category_id=#__virtuemart_product_categories.virtuemart_category_id

[GJC Web Design]

well .. either your tables are not up to date OR you have extensions trying to query table columns that aren't there .. i.e. out of date scripts

have u done the basics.. check if a column really isn't there and if not should it be?
Switched to Protostar template and switched all 3rd party stuff off?

[dglite]

Hi: I really appreciate your excellent support. I am performing the recommended operations, you had been very helpul!!!