15.02.2015 18:52
|
|
gunterpfeiffer
Name: Gunter
27.04.2014
Сообщения: 35
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25857
|
|
|
15.02.2015 21:15
|
|
gunterpfeiffer
Name: Gunter
27.04.2014
Сообщения: 35
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25857
|
|
|
16.02.2015 12:52
|
|
gunterpfeiffer
Name: Gunter
27.04.2014
Сообщения: 35
|
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
|
|
gunterpfeiffer
Name: Gunter
27.04.2014
Сообщения: 35
|
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
|
|
gunterpfeiffer
Name: Gunter
27.04.2014
Сообщения: 35
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25857
|
|
|
17.02.2015 19:35
|
|
gunterpfeiffer
Name: Gunter
27.04.2014
Сообщения: 35
|
Aw: Problem after update to 4.9.1
OK that was it.
Now it works again.
Thank you
|
|
20.02.2015 12:21
|
|
tupymossoro
Name: FLÁVIO
25.07.2012
Сообщения: 9
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25857
|
Aw: Problem after update to 4.9.1
Your site not works.
|
|
20.02.2015 18:01
|
|
tupymossoro
Name: FLÁVIO
25.07.2012
Сообщения: 9
|
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
|
|
babim
Name: babic mario
18.02.2013
Сообщения: 145
|
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
|
|
tupymossoro
Name: FLÁVIO
25.07.2012
Сообщения: 9
|
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
|
|