problem with shipping free

29.01.2017 10:16
#1
superpica
Joomshopping forum user no avatar
Name: Conti
22.10.2016
Posts: 34
Quote
problem with shipping free

I included free shipping on orders over a certain amount but I would avoid that free shipping is also applied to foreign shipping.
I decided to install the extension "Calculate for state / weight / price" for applying a specific shipping cost to foreign countries based on weight but probably wrong to set it up because I get off the following error message "
1054 Unknown column 'name_it-IT' in 'field list' SQL = SELECT state_id, `name_it-IT` as name FROM` #__ jshopping_states` WHERE country_id = '204' AND state_publish = 1 ORDER BY name "

How should I proceed to set the price of foreign shipping different from the national one?

 
29.01.2017 12:25
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25941
Quote
Aw: problem with shipping free

* Need install (Addon States)
https://www.webdesigner-profi.de/joomla-webdesign/shop/shippings/calculate-for-stateweightprice.html

OR

try reinstall Addon States

 
29.01.2017 13:03
#3
superpica
Joomshopping forum user no avatar
Name: Conti
22.10.2016
Posts: 34
Quote
Aw: problem with shipping free

I installed the addon states but once you've configured the settings gives me the above mentioned error message and then not the ability to change, and I am compelled to remediate the site by backing up to the point before the change

 
29.01.2017 13:37
#4
superpica
Joomshopping forum user no avatar
Name: Conti
22.10.2016
Posts: 34
Quote
Aw: problem with shipping free

if I go on option / province comes out the following error
"1054 Unknown column 'S.name_it-IT' in 'field list' SQL = SELECT S.state_id, S.country_id, S.state_publish, S.ordering, S.` name_it-IT` as name, C.`name_it-IT` as country FROM `#__ jshopping_states` as S left join #__jshopping_countries as C on C.country_id = S.country_id S.ordering ORDER BY LIMIT 0, 20"

 
30.01.2017 07:49
#5
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25941
Quote
Aw: problem with shipping free

Ok. Add field name_it-IT.
use php myadmin.

 
01.02.2017 15:23
#6
superpica
Joomshopping forum user no avatar
Name: Conti
22.10.2016
Posts: 34
Quote
Aw: problem with shipping free

So I have to add a column to the database?

It seems a little absurd because I paid to buy this extension and I find myself in order not to use it at the risk of doing damage if I'll change it to

you may not update the extension so other potential customers not found the same problem?


Letzte Änderung: 01.02.2017 15:23
 
01.02.2017 16:17
#7
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25941
Quote
Aw: problem with shipping free

For all user not bug.
After install field added to BD.

1. For addon install use 'Joomshopping / install& update'

For test your site.
url?
admin login?
ftp?
(forum privat message)


Letzte Änderung: 01.02.2017 16:27
 


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.