CartThrob Forums | Orders Not Saving Correctly - Nothing saves to exp_channel

Orders Not Saving Correctly - Nothing saves to exp_channel_data

Jaxbulls

Posted: 18 July 2012 03:30 PM

[ Ignore ]

Is a Really Great Dancer

Total Posts: 57

Joined 2010-04-01

I have a 2 site MSM install. I have the latest MSM, EE and CartThrob (although the problem happened in 2.13 prompting me to install 2.14).

For some reason I place the order and everything seems to go correctly.
It creates an order and sends out an email (email is just blank at the moment). However in EE when I go to click on the order it says “You have tried to access a channel that does not exist.”

I checked the database and in exp_channel_titles and there is an entry for this order. However in exp_channel_data there isn’t a row for this order.

In the CartThrob settings it’s set to save orders to the Orders channel and I have my custom fields all mapped.

I’m not sure what is going on. This is about my 5th CartThrob site and I’ve never seen this one before.

Profile

Jaxbulls

Posted: 18 July 2012 04:18 PM

[ Ignore ] [ # 1 ]

Is a Really Great Dancer

Total Posts: 57

Joined 2010-04-01

I should have turned on debugging at first but it’s giving me some errors:

A PHP Error was encountered
Severity: Notice
Message: Array to string conversion
Filename: mysql/mysql_driver.php
Line Number: 557

Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /Users/jonathan/Sites/DrYin/system/codeigniter/system/core/Exceptions.php:170)
Filename: core/Common.php
Line Number: 412

A Database Error Occurred
Error Number: 1054
Unknown column 'Array' in 'field list'

INSERT INTO `exp_channel_data` (`entry_id`, `channel_id`, `site_id`, `field_id_138`, `field_ft_138`, `field_id_139`, `field_ft_139`, `field_id_140`, 
`field_ft_140`, `field_id_141`, `field_ft_141`, `field_id_157`, `field_ft_157`, `field_id_158`, `field_ft_158`, `field_id_156`, `field_ft_156`, `field_id_142`, 
`field_ft_142`, `field_id_143`, `field_ft_143`, `field_id_144`, `field_ft_144`, `field_id_145`, `field_ft_145`, `field_id_146`, `field_ft_146`, `field_id_147`, 
`field_ft_147`, `field_id_148`, `field_ft_148`, `field_id_149`, `field_ft_149`, `field_id_150`, `field_ft_150`, `field_id_151`, `field_ft_151`, `field_id_152`, 
`field_ft_152`, `field_id_153`, `field_ft_153`, `field_id_159`, `field_ft_159`, `field_id_154`, `field_ft_154`) VALUES (1093, '38', '2', 'First', 'none', 'Last', 'none', '', 
'none', 'Company', 'none', '', 'none', '', 'none', 'USA', 'none', 'Address', 'none', 'Akron', 'none', 'OH', 'none', '44313', 'none', 'mail@mail.com', 'none', '111-111-1111', 
'none', 'sdf', 'none', 'New Customer', 'none', '', 'br', '71.85', 'none', '0.00', 'none', '76.85', 'none', 'Bookstore', 'none', Array, 'none')

Filename: /Users/jonathan/Sites/DrYin/third_party/cartthrob/models/cartthrob_entries_model.php

Line Number: 294 

Profile

Jaxbulls

Posted: 18 July 2012 06:50 PM

[ Ignore ] [ # 2 ]

Is a Really Great Dancer

Total Posts: 57

Joined 2010-04-01

After I searched on the error from EE’s debug I was able to find that the problem was my Order Items field being named {items}. Apparently that goofs things up.

Found that here: http://cartthrob.com/forums/viewthread/5261/

Profile

Chris Newton

Posted: 20 July 2012 08:35 AM

[ Ignore ] [ # 3 ]

Administrator

Total Posts: 10240

Joined 2008-09-29

I’m sorry about that man. That’s annoying. I’ve added it to the docs. I’ve also added validation to the field itself so this won’t happen again.

Signature

We’re moving away from the forums, though not entirely and not immediately. Lack of support lately is coincidental to that. Unfortunately we’ve had a bad month with it, but we do not forsee that we will have any continued problems with support through our portal going forward, or on forums while we’re still transitioning. We will send out a newsletter and make additional notifications through twitter and other outlets over the coming weeks.

Moving forward; things returning to normal.

Profile

Jaxbulls

Posted: 20 July 2012 08:36 AM

[ Ignore ] [ # 4 ]

Is a Really Great Dancer

Total Posts: 57

Joined 2010-04-01

Sweet! Sounds like good changes.

Profile

‹‹ PayPal: The totals of the cart item amounts do not match order amounts. 10413 Is it possible to do this Faceted Search in CT? ››