Author Topic: vmError: Couldn't create order items  (Read 16028 times)

jcooper1984

  • Beginner
  • *
  • Posts: 2
Re: vmError: Couldn't create order items
« Reply #15 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!!!!!

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3486
  • using Matomo instead of Google Analytics
Re: vmError: Couldn't create order items
« Reply #16 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.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

sammysumer

  • Beginner
  • *
  • Posts: 1
  • Skype Name: sammysumer
Re: vmError: Couldn't create order items
« Reply #17 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.

HugoCZ

  • Beginner
  • *
  • Posts: 2
Re: vmError: Couldn't create order items
« Reply #18 on: March 14, 2013, 11:17:49 am »
Thanks sammysumer! Great job.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9856
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: vmError: Couldn't create order items
« Reply #19 on: March 16, 2013, 00:41:15 am »
Often clicking "Install or if necessary update tables " in the Tools & Migration tab solves this kind of problem.
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?
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Sonik

  • Beginner
  • *
  • Posts: 2
Re: vmError: Couldn't create order items
« Reply #20 on: December 14, 2013, 07:07:29 am »
Often clicking "Install or if necessary update tables " in the Tools & Migration tab solves this kind of problem.
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?

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9856
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: vmError: Couldn't create order items
« Reply #21 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.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Sonik

  • Beginner
  • *
  • Posts: 2
Re: vmError: Couldn't create order items
« Reply #22 on: December 14, 2013, 20:08:08 pm »
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

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9856
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: vmError: Couldn't create order items
« Reply #23 on: December 14, 2013, 20:32:23 pm »
ah yes, 2.0.26

link?
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

kigri

  • Beginner
  • *
  • Posts: 5
Re: vmError: Couldn't create order items
« Reply #24 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....

kigri

  • Beginner
  • *
  • Posts: 5
Re: vmError: Couldn't create order items
« Reply #25 on: February 20, 2015, 22:14:59 pm »