Can not update to 5.8

25.06.2025 14:21
#1
mhuber
User mhuber
Name: Manfred
21.05.2011
Сообщения: 125
Quote
Can not update to 5.8

Joomshopping was in my update list and I tried to update it. Unfortunately there was an error message coming up.
Now it disappeard from my extenions to be updated and I'm still runnung 5.6.1 and the frontend is showing following error:

1054 - Unknown column 'required' in 'SELECT'

Any suggestions how I can handke this issue?


Joomla: 4.4.13
JoomShopping: 5.6.1
Website Url: https://vet-tcm.de/shop

Последнее изменение: 25.06.2025 14:23
 
25.06.2025 14:33
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 28003
Quote
Aw: Can not update to 5.8

System Dashboard / Maintenance
Database
Update structure

 
25.06.2025 14:36
#3
mhuber
User mhuber
Name: Manfred
21.05.2011
Сообщения: 125
Quote
Aw: Can not update to 5.8

That's what I did. Still no change

 
25.06.2025 14:39
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 28003
Quote
Aw: Can not update to 5.8

update again

 
25.06.2025 14:40
#5
mhuber
User mhuber
Name: Manfred
21.05.2011
Сообщения: 125
Quote
Aw: Can not update to 5.8

debug-Modus

Unknown column 'required' in 'SELECT'
/www/htdocs/w019789e/vet-tcm.de/JOOMLA4/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:137

Call stack
# Function Location
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:137
2 mysqli->prepare() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:137
3 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089
4 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1912
5 Joomla\Database\DatabaseDriver->setQuery() JROOT/components/com_jshopping/Table/AttributTable.php:35
6 Joomla\Component\Jshopping\Site\Table\AttributTable->getAllAttributes() JROOT/components/com_jshopping/Lib/JSFactory.php:306
7 Joomla\Component\Jshopping\Site\Lib\JSFactory::getAllAttributes() JROOT/components/com_jshopping/Model/CartajaxattributesModel.php:333
8 Joomla\Component\Jshopping\Site\Model\CartAjaxAttributesModel->getProductRequiredAttributes() JROOT/components/com_jshopping/Model/CartajaxattributesModel.php:367
9 Joomla\Component\Jshopping\Site\Model\CartAjaxAttributesModel->getProductAttributesData() JROOT/components/com_jshopping/Model/CartajaxattributesModel.php:31
10 Joomla\Component\Jshopping\Site\Model\CartAjaxAttributesModel->getProductAttributesForm() JROOT/plugins/jshoppingproducts/cartajaxattributes/cartajaxattributes.php:30
11 plgJshoppingProductsCartAjaxAttributes->onBeforeDisplayProductList() JROOT/libraries/src/Plugin/CMSPlugin.php:289
12 Joomla\CMS\Plugin\CMSPlugin->Joomla\CMS\Plugin\{closure}() JROOT/libraries/vendor/joomla/event/src/Dispatcher.php:486
13 Joomla\Event\Dispatcher->dispatch() JROOT/libraries/src/Application/EventAware.php:111
14 Joomla\CMS\Application\WebApplication->triggerEvent() JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:51
15 include() JROOT/libraries/src/Dispatcher/ModuleDispatcher.php:52
16 Joomla\CMS\Dispatcher\ModuleDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/ModuleDispatcher.php:55
17 Joomla\CMS\Dispatcher\ModuleDispatcher->dispatch() JROOT/libraries/src/Helper/ModuleHelper.php:281
18 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/libraries/src/Helper/ModuleHelper.php:161
19 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:99
20 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:50
21 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:565
22 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:833
23 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:637
24 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1025
25 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:724
26 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:298
27 Joomla\CMS\Application\CMSApplication->execute() JROOT/includes/app.php:61
28 require_once() JROOT/index.php:32

 
25.06.2025 14:41
#6
mhuber
User mhuber
Name: Manfred
21.05.2011
Сообщения: 125
Quote
Aw: Can not update to 5.8

admin - 25.06.2025 14:39
update again

Still the same issue

 
25.06.2025 15:17
#7
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 28003
Quote
Aw: Can not update to 5.8

url?
admin login?
(privat msg.)

 
25.06.2025 15:44
#8
mhuber
User mhuber
Name: Manfred
21.05.2011
Сообщения: 125
Quote
Aw: Can not update to 5.8

I send you my credentials

 
25.06.2025 15:56
#9
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 28003
Quote
Aw: Can not update to 5.8

Fixed.
Added fields to DB manually.

 
25.06.2025 16:11
#10
mhuber
User mhuber
Name: Manfred
21.05.2011
Сообщения: 125
Quote
Aw: Can not update to 5.8

Perfect. Thank you so much :-)

 
01.07.2025 10:17
#11
ecoShopUser
Joomshopping forum user no avatar
Name: Andrea
13.08.2012
Сообщения: 299
Quote
Aw: Can not update to 5.8

We have also update problem:
JInstaller: :Install: SQL-Fehler Unknown column 'include_comment' in 'xn71i_jshopping_order_history'

DataBase repair: The same problem! Error in Database.

Updated again: No installation error, but the database error remains.

Update: 5.6.1 to 5.8.0
Joomla: 5.3.1


Последнее изменение: 01.07.2025 10:24
 
01.07.2025 16:06
#12
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 28003
Quote
Aw: Can not update to 5.8

Admin login
Url?
Forum privat msg.?

 
02.07.2025 08:47
#13
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 28003
Quote
Aw: Can not update to 5.8

bug in old update 5.1.3
ALTER TABLE `#__jshopping_order_history` ADD `include_comment` TINYINT NOT NULL AFTER `comments`;

--------------------
See all update
administrator\components\com_jshopping\sql\updates\mysql

--------------------
if the error is not fixed by updates or System Dashboard / Maintenance / Database / Update structure

update DB manual (use phpmyadmin)

 


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.