MySQL error when update joom shopping and when check tables

12.01.2020 19:00
#1
imanagerseo0
Joomshopping forum user no avatar
Name: imanagerseo0
23.12.2019
Posts: 11
Quote
MySQL error when update joom shopping and when check tables

MySQL error when update and check tables

1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs

i have ~ 3000 products with totally 220 attributes

i cant update Joom Shopping 4.16.0 because was error , i think files updated, database no, because error 1060 i think

send me patch for update Joom Shopping 4.16.0 please, 5.5.41-MariaDB

i see editor on this forum not work ))


Joomla: 3.9.14
JoomShopping: 4.16.0 - 4.18.4
PHP: 5.6
MySQL: 5.5.41-MariaDB
Website Url: joomshopping.com
 
12.01.2020 21:54
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
Quote
Aw: MySQL error when update joom shopping and when check tables

Number of languages?
Number of characteristic?

 
14.01.2020 17:25
#3
imanagerseo0
Joomshopping forum user no avatar
Name: imanagerseo0
23.12.2019
Posts: 11
Quote
Aw: MySQL error when update joom shopping and when check tables

220 characteristics, one language for products

whats solutions ?? i want update BD to latest version because will crashed when updates mistmatch,,

 
15.01.2020 08:01
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
Quote
Aw: MySQL error when update joom shopping and when check tables

Delete 1-2 characteristics.

 
15.01.2020 20:27
#5
imanagerseo0
Joomshopping forum user no avatar
Name: imanagerseo0
23.12.2019
Posts: 11
Quote
Aw: MySQL error when update joom shopping and when check tables

why i must delete it ???

how to update database now from 4.16 to 4.18 ??

 
15.01.2020 21:41
#6
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
Quote
Aw: MySQL error when update joom shopping and when check tables

Joomshopping save characteristics in table product.
update add new field in table product.
Need change type field characteristics or delete characteristics.
Product table is already completely filled with fields.


Last change: 15.01.2020 21:46
 


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.