error after updating to 4.8.0

31.12.2014 09:29
#1
chkms
Joomshopping forum user no avatar
Name: Andreas
01.10.2014
Posts: 3
Quote
error after updating to 4.8.0

hi community.
we made an update from 4.7.1 to 4.8.0

the following errors occurred:
1060 Duplicate column name 'lang' SQL=ALTER TABLE `xxxxx_jshopping_users` ADD `lang` VARCHAR(5) NOT NULL;

does anyone have a solution for us?
thanks for helping
Andreas

 
31.12.2014 10:02
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 19075
Quote
Aw: error after updating to 4.8.0

You did it 2 times?


If no:

Need execute query (use phpmyadmin)

ALTER TABLE `#__jshopping_users` ADD `lang` VARCHAR(5) NOT NULL;
ALTER TABLE `#__jshopping_usergroups` ADD `name_en-GB` varchar(255) NOT NULL;
ALTER TABLE `#__jshopping_usergroups` ADD `name_de-DE` varchar(255) NOT NULL;
ALTER TABLE `#__jshopping_orders` ADD `shipping_params` text NOT NULL;
ALTER TABLE `#__jshopping_orders` ADD `shipping_params_data` text NOT NULL;
ALTER TABLE `#__jshopping_orders` ADD `product_stock_removed` tinyint(1) NOT NULL;
ALTER TABLE `#__jshopping_attr` ADD `group` tinyint(4) NOT NULL;
ALTER TABLE `#__jshopping_attr` ADD INDEX(`group`);
ALTER TABLE `#__jshopping_products_extra_fields` ADD INDEX(`group`);

CREATE TABLE IF NOT EXISTS `#__jshopping_attr_groups`(
`id` int(11) NOT NULL AUTO_INCREMENT,
`ordering` int(6) NOT NULL,
PRIMARY KEY (`id`)
) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;


DELETE FROM `#__jshopping_languages`;
update `#__jshopping_usergroups` set `name_en-GB`=`usergroup_name`, `name_de-DE`=`usergroup_name`;
update `#__jshopping_orders` set `product_stock_removed`=1 where order_created=1 and order_status not in (3, 4);




OR
Install
Check DB structure table shop 1.0.6
http://www.webdesigner-profi.de/joomla-webdesign/shop/addons/check-db-structure-table-shop.html?lang=de


Letzte Änderung: 31.12.2014 10:03
 
31.12.2014 14:26
#3
chkms
Joomshopping forum user no avatar
Name: Andreas
01.10.2014
Posts: 3
Quote
Aw: error after updating to 4.8.0

hi Admin,
thank you very much for your informations.

we run this SQL-queries. after that
we run the file "check-db" (addon), the following message comes (see picture)
then run "fix", the following message we have:
1068 Multiple primary key defined SQL=ALTER TABLE `azzdx_jshopping_config` CHANGE `id` `id` tinyint(1) NOT NULL PRIMARY KEY

any ideas?
Aw: error after updating to 4.8.0

 
31.12.2014 14:50
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 19075
Quote
Aw: error after updating to 4.8.0

Not bug.

Database ok.

 
31.12.2014 16:53
#5
chkms
Joomshopping forum user no avatar
Name: Andreas
01.10.2014
Posts: 3
Quote
Aw: error after updating to 4.8.0

ok, thank you for your helping.

 
01.01.2015 12:39
#6
newalex
Joomshopping forum user no avatar
Name: newalex
24.01.2012
Posts: 1
Quote
Aw: error after updating to 4.8.0

After update from 4.7.1 to 4.8.0 big error!

Receive a message when the switch into the "Attributes" and not working yet and editing products.:
1054 Unknown column 'G.name_ru-RU' in 'field list' SQL=SELECT A.attr_id, A.`name_ru-RU` as name, A.attr_type, A.attr_ordering, A.independent, A.allcats, A.cats, G.`name_ru-RU` as groupname FROM `sfs_jshopping_attr` as A left join `sfs_jshopping_attr_groups` as G on A.`group`=G.id ORDER BY A.attr_ordering asc


Joomla: 3.3.6
JoomShopping: 4.8.0
PHP: 5.6.0beta1
MySQL: 5.5.35-33.0
 
01.01.2015 15:33
#7
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 19075
Quote
Aw: error after updating to 4.8.0

1. install
Update LangFix
http://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/downloads/updates.html?lang=en
2. Install
http://www.webdesigner-profi.de/joomla-webdesign/shop/addons/check-db-structure-table-shop.html?lang=en

 
04.02.2015 16:47
#8
irkshoper
Joomshopping forum user no avatar
Name: Anton
03.02.2015
Posts: 1
Quote
Aw: error after updating to 4.8.0

У меня вот что после проверки что дальше делать!
Как это исправить.
Я так понимаю нужно добавить эти таблицы.
Если да то как сделать это. Желательно наглядно показать.
Я попробовал сам добавить но у меня все те же ошибки.
Aw: error after updating to 4.8.0


Joomla: 3.3.6
JoomShopping: 4,9,0
 
04.02.2015 18:17
#9
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 19075
Quote
Aw: error after updating to 4.8.0

Выберите и нажмите исправить.

 


Copyrights MAXXmarketing GmbH. All Rights Reserved
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.