Error 1118 Row size too large.

ПерваяПредыдущая 1 2 СледующаяПоследняя
19.08.2014 21:29
#1
Aleks_El_Dia
User Aleks_El_Dia
Name: Aleks
21.02.2014
Сообщения: 160
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25919
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
Сообщения: 160
Quote
Aw: Error 1118 Row size too large.

Also error
Aw: Error 1118 Row size too large.

 
21.08.2014 11:19
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25919
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
Сообщения: 160
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25919
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
Сообщения: 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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25919
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


Последнее изменение: 27.03.2015 08:05
 
27.03.2015 10:14
#9
worldpeace
Joomshopping forum user no avatar
Name: Vladislav Dobrovolski
20.02.2013
Сообщения: 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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25919
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
Сообщения: 9
Quote
Aw: Error 1118 Row size too large.

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


Последнее изменение: 28.03.2015 02:38
 
28.03.2015 08:46
#12
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25919
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
Сообщения: 9
Quote
Aw: Error 1118 Row size too large.

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


Последнее изменение: 28.03.2015 18:30
 
28.03.2015 19:58
#14
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25919
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
Сообщения: 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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25919
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
Сообщения: 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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25919
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
Сообщения: 9
Quote
Aw: Error 1118 Row size too large.

Table type InnoDB .

 
31.03.2015 21:17
#20
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25919
Quote
Aw: Error 1118 Row size too large.

Try change to MyISAM

 
ПерваяПредыдущая 1 2 СледующаяПоследняя


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.