help to solve the error: You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `yn5lm_jshopping_products`

22.11.2015 18:10
#1
vmmix
Joomshopping forum user no avatar
Name: valery
13.09.2015
Posts: 5
Quote
help to solve the error: You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `yn5lm_jshopping_products`

help to solve the error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `yn5lm_jshopping_products` ADD COLUMN `extra_field_597` varchar(100)

 
23.11.2015 08:00
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: help to solve the error: You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `yn5lm_jshopping_products`

Change field extra_field_xxx to varchar 32


List characteristics not unlimited!

 
23.11.2015 10:26
#3
vmmix
Joomshopping forum user no avatar
Name: valery
13.09.2015
Posts: 5
Quote
Aw: help to solve the error: You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `yn5lm_jshopping_products`

Thank you. How to do it?

 
24.11.2015 07:50
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: help to solve the error: You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `yn5lm_jshopping_products`

Use phpmyadmin.

 
26.11.2015 21:57
#5
vmmix
Joomshopping forum user no avatar
Name: valery
13.09.2015
Posts: 5
Quote
Aw: help to solve the error: You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `yn5lm_jshopping_products`

I did what you said, but an error:

1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `yn5lm_jshopping_products` ADD `extra_field_600` varchar(100) NOT NULL
Aw: help to solve the error: You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `yn5lm_jshopping_products`

 
26.11.2015 22:07
#6
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: help to solve the error: You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `yn5lm_jshopping_products`

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

 
23.03.2016 01:05
#7
vmmix
Joomshopping forum user no avatar
Name: valery
13.09.2015
Posts: 5
Quote
Aw: help to solve the error: You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `yn5lm_jshopping_products`

How to change this automatically? When I did, I was able to upload a maximum of 40 more characteristics. and again I had to change.

 
Copyrights MAXXmarketing GmbH. All Rights Reserved