Error 1118 Row size too large.

«StartZurück12WeiterEnde»
19.08.2014 21:29
#1
Aleks_El_Dia
User Aleks_El_Dia
Name: Aleks
21.02.2014
Posts: 120
Quote
Error 1118 Row size too large.

При создании новой характеристики появляется ошибка:
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 SQL=ALTER TABLE `l3kop_jshopping_products` ADD `extra_field_220` text NOT NULL

http://prntscr.com/4efgsg
Изменение типа строки с varchar(100) на TEXT ничего не дает. Да и строка то не появляется.
При правке файла administrator\components\com_jshopping\controllers\productfields.php, строка 177 - вместо varchar(100) - text ситуация не изменилась - http://prntscr.com/4dzqdk


Joomla: 3.2.3
JoomShopping: 4.4.1
PHP: 5.3.28
MySQL: 5.1.72-cll-lve
Website Url: http://mortorg.com/
 
20.08.2014 07:44
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: Error 1118 Row size too large.

Change varchar(100) to varchar(32)

 
21.08.2014 10:49
#3
Aleks_El_Dia
User Aleks_El_Dia
Name: Aleks
21.02.2014
Posts: 120
Quote
Aw: Error 1118 Row size too large.

Also error
Aw: Error 1118 Row size too large.

 
21.08.2014 11:19
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: Error 1118 Row size too large.

All (old) extra_field_* change to varchar 32

extra_field_1, extra_field_2, ..... change to varchar 32

 
22.08.2014 14:29
#5
Aleks_El_Dia
User Aleks_El_Dia
Name: Aleks
21.02.2014
Posts: 120
Quote
Aw: Error 1118 Row size too large.

Thank you, it works.
How many product charactecteristic can be added to joomshopping?

 
22.08.2014 14:35
#6
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: Error 1118 Row size too large.

220 - varchar(100)
440 - varchar(50)

 
27.03.2015 01:53
#7
worldpeace
Joomshopping forum user no avatar
Name: Vladislav Dobrovolski
20.02.2013
Posts: 9
Quote
Aw: Error 1118 Row size too large.

I have such problem:

1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. You have to change some columns to TEXT or BLOBs SQL=UPDATE `tjr4c_jshopping_products` SET `parent_id`='0',`product_ean`='',`product_quantity`='0',`unlimited`='0',`date_modify`='2015-03-27

How to resolve?

 
27.03.2015 08:04
#8
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: Error 1118 Row size too large.

Need optimize field
extra_field_1
extra_field_2
....

Varchar (32)
or
Varchar (8)

depending on your data


Letzte Änderung: 27.03.2015 08:05
 
27.03.2015 10:14
#9
worldpeace
Joomshopping forum user no avatar
Name: Vladislav Dobrovolski
20.02.2013
Posts: 9
Quote
Aw: Error 1118 Row size too large.

And where are these files? These files are not present in the table "tjr4c_jshopping_products".
And what should I optimize, what change?

 
27.03.2015 20:50
#10
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: Error 1118 Row size too large.

Structure tjr4c_jshopping_products?

 
28.03.2015 02:37
#11
worldpeace
Joomshopping forum user no avatar
Name: Vladislav Dobrovolski
20.02.2013
Posts: 9
Quote
Aw: Error 1118 Row size too large.

In the attached file, see the structure of the "tjr4c_jshopping_products"
strcture.jpg


Letzte Änderung: 28.03.2015 02:38
 
28.03.2015 08:46
#12
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: Error 1118 Row size too large.

You use all languages?
ru, de, es, ....

 
28.03.2015 18:30
#13
worldpeace
Joomshopping forum user no avatar
Name: Vladislav Dobrovolski
20.02.2013
Posts: 9
Quote
Aw: Error 1118 Row size too large.

Yes, I use all languages.
7 languages:
en, ru, de, es, fr, pl, ro


Letzte Änderung: 28.03.2015 18:30
 
28.03.2015 19:58
#14
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: Error 1118 Row size too large.

change field type (example)
alias_... - varchar(50)
meta_title_... - varchar(50)

 
28.03.2015 22:24
#15
worldpeace
Joomshopping forum user no avatar
Name: Vladislav Dobrovolski
20.02.2013
Posts: 9
Quote
Aw: Error 1118 Row size too large.

I did as you said, but the problem still remains. I changed in the fields "alias_" and "meta_title_" to "varchar(50)",but no result, and also, in all fields where it was "varchar (255)" I changed to "varchar (50"), but remains the same error.

 
29.03.2015 21:36
#16
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: Error 1118 Row size too large.

url?
admin login?
phpmyadmin access.

 
30.03.2015 04:59
#17
worldpeace
Joomshopping forum user no avatar
Name: Vladislav Dobrovolski
20.02.2013
Posts: 9
Quote
Aw: Error 1118 Row size too large.

My website is currently not on the Internet, and on the local server - Denwer
How can you help me in this case?

 
31.03.2015 07:54
#18
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: Error 1118 Row size too large.

Table type InnoDB or MyISAM?

 
31.03.2015 13:32
#19
worldpeace
Joomshopping forum user no avatar
Name: Vladislav Dobrovolski
20.02.2013
Posts: 9
Quote
Aw: Error 1118 Row size too large.

Table type InnoDB .

 
31.03.2015 21:17
#20
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: Error 1118 Row size too large.

Try change to MyISAM

 
«StartZurück12WeiterEnde»
Copyrights MAXXmarketing GmbH. All Rights Reserved