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: 16472
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: 16472
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: 16472
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: 16472
Quote
Aw: error after updating to 4.8.0

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

 
Copyrights MAXXmarketing GmbH. All Rights Reserved