• twitter image
  • facebook image
  • youtube image
  • linkedin image
Language: CMS Made Simple Czech CMS Made Simple France CMS Made Simple Spain CMS Made Simple Hungary CMS Made Simple Russia CMS Made Simple Netherlands

All times are UTC




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Orders Module Error on Checkout
PostPosted: Mon Jan 21, 2019 2:59 pm 
Offline
Forum Members
Forum Members

Joined: Fri Sep 30, 2016 10:40 am
Posts: 16
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
----------------------------------------------


Top
  Profile  
 
Share On:
Share on Facebook Share on Twitter Share on Google+
 Post subject: Re: Orders Module Error on Checkout
PostPosted: Mon Jan 21, 2019 5:44 pm 
Offline
Dev Team Member
Dev Team Member
User avatar

Joined: Wed Feb 25, 2009 4:25 am
Posts: 780
Location: Victoria, BC
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


Top
  Profile  
 
Share On:
Share on Facebook Share on Twitter Share on Google+
 Post subject: Re: Orders Module Error on Checkout
PostPosted: Tue Jan 22, 2019 11:41 am 
Offline
Forum Members
Forum Members

Joined: Fri Sep 30, 2016 10:40 am
Posts: 16
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


Top
  Profile  
 
Share On:
Share on Facebook Share on Twitter Share on Google+
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
A2 Hosting