1054 Error Unknown column 'basicprice' in 'field list'

21.08.2021 16:40
#1
mazenarafat
User mazenarafat
Name: mazen
06.09.2014
Posts: 18
Quote
1054 Error Unknown column 'basicprice' in 'field list'

Hello,
I have a problem when I do the last payment step URL : /products/checkout/step5save
I get 1054 Error Unknown column 'basicprice' in 'field list'.
Now I have 2 payment methods:
1- Pay Cash
2- Pay by Credit Card - Paypal elc...
In both options, I get that error page.. 1054, but in the method [Pay Cash], I get the order in the admin page.
In the Pay by Credit Card - Paypal elc... I don't get any orders.
Please help me to fix this.
Thank you


Joomla: Joomla! 3.10.0 Stable 14-August-2021
JoomShopping: 4.18.7
PHP: 7.0.33
MySQL: 5.5.5-10.3.28-MariaDB-cll-lve
Website Url: https://ital-parts.it/
 
21.08.2021 18:58
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
Quote
Aw: 1054 Error Unknown column 'basicprice' in 'field list'

Problem in joomshopping update or ...

Add
`basicprice` DECIMAL(12,2) NOT NULL,
in table
..._jshopping_order_item

Use phpMyAdmin.

 
22.08.2021 17:06
#3
mazenarafat
User mazenarafat
Name: mazen
06.09.2014
Posts: 18
Quote
Aw: 1054 Error Unknown column 'basicprice' in 'field list'

Hello,
Thank you for the fast reply..
I have added it, but it appears another error :
Unknown column 'basicpriceunit' in 'field list'
Please check the following video:
https://www.loom.com/share/a4e0d0040fd74f2ba2145da9ee8191d1
Attached photo of adding the basicprice in Phpmyadmin
I added basicpriceunit in the same table.. The pay later it worked fine but the Credit Card has error :
API call failed: Error executing API call (request): Your account is not activated yet.
Please help

Thank you
Aw: 1054 Error Unknown column 'basicprice' in 'field list'


Last change: 22.08.2021 18:56
 
22.08.2021 19:26
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
Quote
Aw: 1054 Error Unknown column 'basicprice' in 'field list'

1 .Add
`basicpriceunit` varchar(255) NOT NULL,
in table
..._jshopping_order_item



See structure tables:
administrator\components\com_jshopping\install\install.sql

2. API call failed: Error executing API call (request): Your account is not activated yet.
Problem in configuration your payment system


Last change: 22.08.2021 19:29
 
22.08.2021 20:29
#5
mazenarafat
User mazenarafat
Name: mazen
06.09.2014
Posts: 18
Quote
Aw: 1054 Error Unknown column 'basicprice' in 'field list'

Hello,
Thank you very much..
I will try ...
Kind Regards
Mazen

 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.