VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: rizwanshaikh on April 14, 2012, 07:50:20 AM

Title: vmError: Couldn't create order items
Post by: rizwanshaikh on April 14, 2012, 07:50:20 AM
Hello this is rizwan. i have my site running in joomla 2.5.4 version, everything is running successfully in vertuemart exept payment method. When i am goint to confirm order this is showing this error...


                     
                            vmError:

        vmError: Couldn't create order items
                     
                      No order created

Can anyone help me what is the problem in this...

Thanks in advance.

Mo. Rizwan (rizwan@widevision.co.in)
Title: Re: vmError: Couldn't create order items
Post by: Milbo on April 14, 2012, 12:12:56 PM
Which virtuemart version? Which payment plugin do you use? and how many paymentmethods are configured?
Title: Re: vmError: Couldn't create order items
Post by: XTremo54 on May 01, 2012, 14:04:54 PM
I have exactly the same problem.....VM2.02 and Joomla 2.54. PayPal is the only payment gateway set up.
Title: Re: vmError: Couldn't create order items
Post by: jooohnn on May 14, 2012, 16:51:38 PM
Same problem here. I have Joomla 2.5.4 and Virtuemart 2.0.2 and the same error happens, when I try to checkout it says "Couldn't create order - No order created".

Everything seems to be configured properly. Any idea what could be wrong ? Would it be some compatibility issue between 2.5.2 and Virtuemart 2.0.2 ?
Title: Re: vmError: Couldn't create order items
Post by: Milbo on May 14, 2012, 23:59:06 PM
You should update to 2.0.6, just read this http://virtuemart.net/news/list-all-news/416
Title: Re: vmError: Couldn't create order items
Post by: spendy on June 15, 2012, 12:30:54 PM
Hello,

I have the same issue, meaning at checkout step 4 (order confirmation), it appears the "Couldn't create order/No order created" message.

I am running Joomla 1.7  and Virtuemart 2.0.6 ..Do you have any idea what could be wrong? this issue is very annoying and i don't know what to do about it..

Any help would be much appreciated!

Thanks, Sandra
Title: Re: vmError: Couldn't create order items
Post by: Milbo on June 16, 2012, 11:04:34 AM
Did you tried "Install tables or if necessary update them" in the tools page? Why do you run j1.7? we support officially only the latest j1.5 and j2.5.
Title: Re: vmError: Couldn't create order items
Post by: spendy on June 18, 2012, 20:05:28 PM
Thank you for your suggestion ! Well, to be honest, i haven't tried "Install tables or if necessary update them", because i was afraid it will mess up my store somehow...yes, i am a heart fainter :)

On the other hand, i haven't researched enough regarding the compatibility of Virtuemart  2.0.6 with Joomla 1.7. I will try this first, meaning upgrading to 2.5 and hopefully the orders will be created.

Thank you again!
Title: Re: vmError: Couldn't create order
Post by: angelo on September 16, 2012, 17:07:13 PM
Hello Milbo,

we searched but could not find a solution for the following error, when confirming the order the client is not redirected to the payment page (like PayPal). Instead he gets an error:

        "Couldn't create order history - No order created'

However if you look in the backend the orders are there.
We tried Paypal and a new payment method COD.

Using Joomla 2.5.7 and VM 2.0.11.a

Thanks in advance.

Angelo

Title: Re: vmError: Couldn't create order items
Post by: Milbo on September 17, 2012, 11:37:20 AM
http://forum.virtuemart.net/index.php?topic=107541.0

and we know already that the shipment is not added to the final, is fixed in svn and will be released today
Title: Re: vmError: Couldn't create order items
Post by: angelo on September 17, 2012, 13:28:20 PM
Hello Milbo,

thanks for your quick reply and yes it is fixed!
Title: Re: vmError: Couldn't create order items
Post by: RoCoART on November 27, 2012, 16:35:18 PM
Hi there guys
I have the same problem!
I'm running Joomla 2.5.6 with VirtueMart 2.0.14 (PHP 5.3.18) and when I'm about to finalize the order I get this error:
"vmError: _createOrderCalcRules store payment rule
vmError: Couldn't create order items
No order created"
There is no difference if I check the SHOW CHECKOUT STEPS box, or allowing the customer to select shipment and payment method, the result is the same. I have only 1 shipment option and only 1 payment option and still get the same message all the time. And in the back end I get the orders.
I read that this problem was fixed in an earlier version but.... can't find a solution
Any advice would be great

Thank You
Title: Re: vmError: Couldn't create order items
Post by: Just_VDL on January 03, 2013, 09:29:57 AM
I am experiencing the same issue I am running VM 2.02.12f and Joomla 2.5.7

At the point of check-out at step 4 "confirmation purchase" this same error comes up.
"Couldn't create order items
No order created"

Any suggestions would be welcome
Title: Re: vmError: Couldn't create order items
Post by: Milbo on January 03, 2013, 14:03:46 PM
Which payment and shipment plugin do you use? Did you also install the latest aio?
Title: Re: vmError: Couldn't create order items
Post by: ludekk on January 05, 2013, 00:47:30 AM
Quote from: Milbo on January 03, 2013, 14:03:46 PM
Which payment and shipment plugin do you use? Did you also install the latest aio?

Hi, I have the same problem on J2.5.8, VM2.0.12f.
I run:
vmpaymentstandard:  * @version $Id: standard.php 5122 2011-12-18 22:24:49Z alatak $
vmshipment weight_countries: * @version $Id: weight_countries.php 6542 2012-10-15 17:55:59Z alatak $

I cannot update to newer versions due to other extensions and template incompatibility with newer version (VM2.0.16). So, I have to patched somehow my 12f to keep it running with extensins and template we have.
Could you help me please?
Title: Re: vmError: Couldn't create order items
Post by: jcooper1984 on February 27, 2013, 23:26:25 PM
I also have the same problem:-

        vmError: _createOrderCalcRules store payment rule
        vmError: Couldn't create order items
        No order created

VM 2.0.18a
Joomla! 2.5.7
PHP 5.2.17

Please help!!!!!
Title: Re: vmError: Couldn't create order items
Post by: jjk on March 12, 2013, 14:51:20 PM
Often clicking "Install or if necessary update tables " in the Tools & Migration tab solves this kind of problem.
Title: Re: vmError: Couldn't create order items
Post by: sammysumer on March 13, 2013, 07:33:46 AM
I solved this problem by droping jos_virtuemart_order_calc_rules table and recreated it using the latest virtuemart component.

If you compare the tables you will notice that jos_virtuemart_order_calc_rules is missing few column fields.
Title: Re: vmError: Couldn't create order items
Post by: HugoCZ on March 14, 2013, 11:17:49 AM
Thanks sammysumer! Great job.
Title: Re: vmError: Couldn't create order items
Post by: Milbo on March 16, 2013, 00:41:15 AM
Quote from: jjk on March 12, 2013, 14:51:20 PM
Often clicking "Install or if necessary update tables " in the Tools & Migration tab solves this kind of problem.
Quote from: HugoCZ on March 14, 2013, 11:17:49 AM
Thanks sammysumer! Great job.

The hint of jjk should exactly do the same. The table updater checks for missing columns and is adding them.
Question: Why the upgrade did not work correctly for you?
Title: Re: vmError: Couldn't create order items
Post by: Sonik on December 14, 2013, 07:07:29 AM
Quote from: Milbo on March 16, 2013, 00:41:15 AM
Quote from: jjk on March 12, 2013, 14:51:20 PM
Often clicking "Install or if necessary update tables " in the Tools & Migration tab solves this kind of problem.
Quote from: HugoCZ on March 14, 2013, 11:17:49 AM
Thanks sammysumer! Great job.

The hint of jjk should exactly do the same. The table updater checks for missing columns and is adding them.
Question: Why the upgrade did not work correctly for you?

Hello,

somethingh happened and now I have totally the same problem (Virtue mart 2.0.14, joom;a 2.5.4)

On the step of comfirmation I see
"Couldn't create order items
No order created"
And shows again last step of ordering.
But really in the back end I can see order, but all fields are empty, I can see only goodies and prices. No user info, or shipping/payment info.
I didn't use any special shipping pluggins or addons only standart.

I try to update only tables via AIO - but there is no effect
Upgrading virtue mart to latest version via AIO - crash my template,
But it works, if I completely delete VirtueMart and install if again, but in this case I need to readd all goodies to store (for some reason import dont want to accept items)

Can you advise me, how can I solve this?
Title: Re: vmError: Couldn't create order items
Post by: Milbo on December 14, 2013, 10:56:48 AM
First of course you should update your 2.0.24. Just disable the overrides given by your template (rename the com_virtuemart folder OF your template). Then it should work.
Title: Re: vmError: Couldn't create order items
Post by: Sonik on December 14, 2013, 20:08:08 PM
Quote from: Milbo on December 14, 2013, 10:56:48 AM
First of course you should update your 2.0.24. Just disable the overrides given by your template (rename the com_virtuemart folder OF your template). Then it should work.

To version 2.0.26
Template breaks even after renaming
Title: Re: vmError: Couldn't create order items
Post by: Milbo on December 14, 2013, 20:32:23 PM
ah yes, 2.0.26

link?
Title: Re: vmError: Couldn't create order items
Post by: kigri on February 20, 2015, 21:17:19 PM
Hello,

I updated vm2.0.10 to 2.6.14 and I have this error:
Couldn't create order
No order created

I did this "Install tables or if necessary update them" and I' getting all these error messages:

vmError: alterTable CHANGE dij5m_virtuemart_customs.custom_value :
vmError: alterTable ADD dij5m_virtuemart_customs.custom_field_desc : Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `dij5m_virtuemart_customs` CHANGE COLUMN `custom_value` `custom_value` VARCHAR(8000) COMMENT 'DEFAUT VALUE'
vmError: alterTable ADD dij5m_virtuemart_orders.customer_note :
vmError: Tableupdater updating table dij5m_virtuemart_orders throws error Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `dij5m_virtuemart_orders` ADD customer_note varchar(20000) AFTER virtuemart_vendor_id
vmError: alterTable ADD dij5m_virtuemart_product_customfields.custom_value :
vmError: alterTable ADD dij5m_virtuemart_product_customfields.custom_price : Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `dij5m_virtuemart_product_customfields` ADD custom_value varchar(8000) COMMENT 'field value' FIRST
vmError: alterTable ADD dij5m_virtuemart_product_customfields.custom_param : Unknown column 'custom_value' in 'dij5m_virtuemart_product_customfields' SQL=ALTER TABLE `dij5m_virtuemart_product_customfields` ADD custom_price decimal(15,5) COMMENT 'price' AFTER custom_value
vmError: Tableupdater updating table dij5m_virtuemart_product_customfields throws error Unknown column 'custom_price' in 'dij5m_virtuemart_product_customfields' SQL=ALTER TABLE `dij5m_virtuemart_product_customfields` ADD custom_param varchar(12800) COMMENT 'Param for Plugins' AFTER custom_price
vmError: alterTable ADD dij5m_virtuemart_userfields.params :
vmError: Tableupdater updating table dij5m_virtuemart_userfields throws error Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `dij5m_virtuemart_userfields` ADD params varchar(17000) FIRST


What should I do? Please help me....
Title: Re: vmError: Couldn't create order items
Post by: kigri on February 20, 2015, 22:14:59 PM
I found the answer from here:
http://forum.virtuemart.net/index.php?topic=127570.0