Orders Module Error on Checkout
Posted: Mon Jan 21, 2019 2:59 pm
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
----------------------------------------------
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
----------------------------------------------