Orders Module Error on Checkout

Have a question or a suggestion about a 3rd party addon module or plugin?
Let us know here.
Post Reply
joshj
Forum Members
Forum Members
Posts: 16
Joined: Fri Sep 30, 2016 10:40 am

Orders Module Error on Checkout

Post by joshj »

I've created a copy of a website and upgraded to the latest CMS and modules.

I've been using the Orders module successfully, but now I'm receiving an error during the checkout process. The error appears when clicking "Next" after entering the checkout details:

DEBUG: INSERT INTO cms_module_orders (feu_user_id,invoice, billing_company,billing_first_name,billing_last_name, billing_address1,billing_address2,billing_city, billing_state,billing_postal,billing_country, billing_phone,billing_fax,billing_email, status, order_notes, extra, create_date, modified_date) VALUES (-1,'NOTSET','TestCompany','TestFirstName','TestSurname','Test 1, Test 2','Test 2','TestTown','AL','W1A 1AA','GB','01234567891','','test@test.co.uk','proposed','',NULL,'2019-01-21 14:51:18','2019-01-21 14:51:18')
Unknown column 'extra' in 'field list'

I see that the error mentions the 'extra' field, which I've removed from the template, as it wasn't being used. The error appeared both with the field and without.

Any help would be appreciated.

Server Info:

----------------------------------------------
Cms Version: 1.11.7

Installed Modules:

CMSMailer: 5.2.2
CMSPrinting: 1.0.5
FileManager: 1.4.5
MenuManager: 1.8.7
ModuleManager: 1.5.8
News: 2.15.2
Search: 1.7.13
ThemeManager: 1.1.8
DocumentSearch: 1.4.4
CGSimpleSmarty: 1.7
CGExtensions: 1.37.3
CGEcommerceBase: 1.4.3
JQueryTools: 1.2.5
Products: 2.19.6
Cart: 1.10
MicroTiny: 1.2.9
FormBuilder: 0.7.3
Captcha: 0.4.6
FrontEndUsers: 1.21.17
CGPaymentGatewayBase: 1.2.2
Orders: 1.15.2
ECB: 1.5
GBFilePicker: 1.3.3

Config Information:

php_memory_limit:
process_whole_template: 1
max_upload_size: 100000000
url_rewriting: mod_rewrite
page_extension: /
query_var: page
image_manipulation_prog: GD
auto_alias_content: true
locale:
default_encoding: utf-8
admin_encoding: utf-8
set_names: true

Php Information:

phpversion: 5.6.37
md5_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_STRICT: 2048
E_DEPRECATED: 8192
memory_limit: 128M
max_execution_time: 60
output_buffering: On
safe_mode: Off (False)
file_uploads: On (True)
post_max_size: 100M
upload_max_filesize: 100M
session_save_path: No check because OS path
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)

Server Information:

Server Api: cgi-fcgi
Server Db Type: MySQL (mysqli)
Server Db Version: 5.7.16
Server Db Grants: Found a "GRANT ALL" statement that appears to be suitable
----------------------------------------------
User avatar
DIGI3
Dev Team Member
Dev Team Member
Posts: 1609
Joined: Wed Feb 25, 2009 4:25 am
Location: Victoria, BC

Re: Orders Module Error on Checkout

Post by DIGI3 »

It sounds like the column 'extra' was perhaps added in an interim upgrade step and wasn't accounted for in later versions. You may be able to manually add that column. If you haven't made significant changes you could also revert to backup and upgrade the Orders module version by version.

Probably a bug, but would be good to narrow it down to something reproducible before you file a bug report.
Not getting the answer you need? CMSMS support options
joshj
Forum Members
Forum Members
Posts: 16
Joined: Fri Sep 30, 2016 10:40 am

Re: Orders Module Error on Checkout

Post by joshj »

Thanks for the reply DIGI3, it seems from reading the module release notes (http://dev.cmsmadesimple.org/project/fi ... ackage-493) that in release 1.18.2 there was a field added to the table and other additions relating to the Extra field.

Unfortunately I've made significant changes now that the CMS has been upgraded and so I can't really carry out a new install.

Does anyone have any ideas what may need to be added to the database etc.?

Thanks
Post Reply

Return to “Modules/Add-Ons”