Problems with Registration [Solved]

Hello, we seem to be having an issue with our Registrations, when a user completes a registration and clicks "Process Registration" they receive the following error...

1054 Unknown column 'payment_currency' in 'field list' SQL=UPDATE `#__eb_registrants` SET `event_id`='23',`user_id`='0',`group_id`='0',`first_name`='TEST',`last_name`='TEST',`address`='TEST',`address2`='TEST',`city`='TEST',`zip`='TEST',`phone`='416-777-8888',`email`='craiglaura@sympatico.ca',`number_registrants`='1',`total_amount`='109',`discount_amount`='0',`amount`='109',`register_date`='2017-03-27 13:04:47',`payment_method`='os_paypal',`transaction_id`='7XOYJKJ8',`comment`='test',`published`='0',`payment_processing_fee`='0',`coupon_discount_amount`='0',`late_fee`='0',`deposit_amount`='0',`payment_status`='1',`tax_amount`='0',`registration_code`='S4LFJdc739',`user_ip`='76.66.140.108',`language`='*',`payment_currency`='CAD',`payment_amount`='109' WHERE `id`='47'

Are you able to provide a solution to this problem ?

Thank you in advance.

Craig

Hello Craig

Look like the update was not success for some reasons. Please use this tool eventbookingdoc.joomservices.com/tools#t...-fix-database-schema and the error should be fixed

Tuan

Hi Tuan, yes, that solved the issue.

Thank you very much !

Great. Thanks for confirming

Tuan