Problem after update to 4.9.1

15.02.2015 18:52
#1
gunterpfeiffer
Joomshopping forum user no avatar
Name: Gunter
27.04.2014
Posts: 25
Quote
Problem after update to 4.9.1

Hi,
started update from 4.7.1 with the update link from the joomshopping info link.
Between the updates there was an error, but i forgott to notice the message.
Later the updates worked ok.
But now i have a problem when i call my catalog menu entrys. Always i get the error:
1054 - Unknown column 'G.name_de-DE' in 'field list' SQL=SELECT A.attr_id, A.`name_de-DE` as name, A.`description_de-DE` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_de-DE` as groupname FROM `ih7nj_jshopping_attr` as A left join `ih7nj_jshopping_attr_groups` as G on A.`group`=G.id ORDER BY G.ordering, A.attr_ordering

It seems there was an acident at the update, what can i do to solve this problem ?
Best regrads
Gunter


Joomla: 3.3.6
JoomShopping: 4.9.1
PHP: 5.3.10-1ubuntu3.15
MySQL: 5.5.41-0ubuntu0.12.04.1
Website Url: www.quad-trekking.com
 
15.02.2015 19:50
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: Problem after update to 4.9.1

http://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/forum/posts/7/286.html?lang=en

 
15.02.2015 21:15
#3
gunterpfeiffer
Joomshopping forum user no avatar
Name: Gunter
27.04.2014
Posts: 25
Quote
Aw: Problem after update to 4.9.1

OK,
i i have redone the update from version: JoomShopping-update-4.7.0-4.7.1
to Version 4.9.1. with the joomshopping update function.
but the error "Unknown column 'G.name_de-DE' in 'f...." comes again.
maybe the problem is step 4:
Update via ftp.

i am not sure what is to do here ?
what update file is to download ?

 
16.02.2015 07:56
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: Problem after update to 4.9.1

Try use

http://www.webdesigner-profi.de/joomla-webdesign/shop/addons/check-db-structure-table-shop.html?lang=en

 
16.02.2015 12:52
#5
gunterpfeiffer
Joomshopping forum user no avatar
Name: Gunter
27.04.2014
Posts: 25
Quote
Aw: Problem after update to 4.9.1

OK,
i installed: Check DB structure table shop 1.0.8 (Joomshopping 3.20.0 / 4.8.0)

and get this info:

Version Joom Shopping 4.9.1
# table name Column Column Type Fehler
1 config id int Ungültige Spalte, die Art muss -tinyint

What is now to do ?
Is it enough to change this field type with phpmyadmin or should i do anything else ?

 
17.02.2015 19:11
#6
gunterpfeiffer
Joomshopping forum user no avatar
Name: Gunter
27.04.2014
Posts: 25
Quote
Aw: Problem after update to 4.9.1

Because of now answer i tried to change the filed type.
Your table check says:
Version Joom Shopping 4.9.1
keine Fehler gefunden

that means all is ok ?

but the error is still alive:
also in the backend when i try to edit a product:
1054 Unknown column 'G.name_de-DE' in 'field list' SQL=SELECT A.attr_id, A.`name_de-DE` as name, A.attr_type, A.attr_ordering, A.independent, A.allcats, A.cats, G.`name_de-DE` as groupname FROM `ih7nj_jshopping_attr` as A left join `ih7nj_jshopping_attr_groups` as G on A.`group`=G.id ORDER BY A.attr_ordering asc

when i check table: ih7nj_jshopping_attr in phpmyadmin i can see 2 records.
but in table: ih7nj_jshopping_attr_groups there is no entry
maybe this is the problem ?

Any advice to solve this problem, please ???

best regards
Gunter

 
17.02.2015 19:16
#7
gunterpfeiffer
Joomshopping forum user no avatar
Name: Gunter
27.04.2014
Posts: 25
Quote
Aw: Problem after update to 4.9.1

Additional info:
error comes also when i call "attributes" under menu option.
"free attributes" is working.

 
17.02.2015 19:20
#8
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: Problem after update to 4.9.1

http://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/downloads/updates.html?lang=en
Install Update LangFix

 
17.02.2015 19:35
#9
gunterpfeiffer
Joomshopping forum user no avatar
Name: Gunter
27.04.2014
Posts: 25
Quote
Aw: Problem after update to 4.9.1

OK that was it.
Now it works again.
Thank you

 
20.02.2015 12:21
#10
tupymossoro
Joomshopping forum user no avatar
Name: FLÁVIO
25.07.2012
Posts: 9
Quote
Aw: Problem after update to 4.9.1

After upgrading to Version 4.9.1 Shop, was showing an error on the pages where it appears the bottom where it appears the number of pages, as on the page I'm only 6 products does not display the error, but that has more than 6 products it displays the following message:

“Warning: Illegal string offset 'active' in/home/tupymoss/public_html/templates/business/html/pagination.php on line89

Warning: Illegal string offset 'active' in/home/tupymoss/public_html/templates/business/html/pagination.php on line93

Warning: Illegal string offset 'active' in/home/tupymoss/public_html/templates/business/html/pagination.php on line89

Warning: Illegal string offset 'active' in/home/tupymoss/public_html/templates/business/html/pagination.php on line93”

Please check the examples below:

Page without error:
http://www.tupymossoro.com.br/index.php/component/jshopping/manufacturer/view/203

Page with error:
http://www.tupymossoro.com.br/index.php/component/jshopping/manufacturer/view/19


Joomla: Joomla! 3.3.6
JoomShopping: Version 4.9.1
PHP: Versão do PHP 5.4.36
MySQL: Versão do MySQL 5.5.41-cll-lve
Website Url: www.tupymossoro.com.br
 
20.02.2015 13:31
#11
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: Problem after update to 4.9.1

Your site not works.

 
20.02.2015 18:01
#12
tupymossoro
Joomshopping forum user no avatar
Name: FLÁVIO
25.07.2012
Posts: 9
Quote
Aw: Problem after update to 4.9.1

excuse think was the RSFirewall !, which was blocking access, please check novamete, and continue please send a print of what appears on screen.

 
20.02.2015 21:15
#13
babim
Joomshopping forum user no avatar
Name: babic mario
18.02.2013
Posts: 133
Quote
Aw: Problem after update to 4.9.1

http://www.joomlaportal.de/joomla-2-5-templates-und-design/289947-warning-illegal-string-offset-active.html

 
21.02.2015 14:30
#14
tupymossoro
Joomshopping forum user no avatar
Name: FLÁVIO
25.07.2012
Posts: 9
Quote
Aw: Problem after update to 4.9.1

Okay, this bias problem was corrected when I added this content in line 86, " foreach($list['pages'] as $page)
{
if (isset($page['data']['active']) && $page['data']['active']) {
$html .= '<strong>';
}

$html .= $page['data'];

if (isset($page['data']['active']) && $page['data']['active']) {
$html .= '</strong>';
}
} ".

Now try to solve a problem when I place to buy, in my Quote case, it's 404 Page not found, do not add the product to cart and redirects to the shopping cart.

Page example: http://www.tupymossoro.com.br/index.php/component/jshopping/product/view/1/83


Website Url: www.tupymossoro.com.br
 
Copyrights MAXXmarketing GmbH. All Rights Reserved