19.08.2014 21:29
|
|
Aleks_El_Dia
Name: Aleks
21.02.2014
Сообщения: 160
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25919
|
Aw: Error 1118 Row size too large.
Change varchar(100) to varchar(32)
|
|
21.08.2014 10:49
|
|
Aleks_El_Dia
Name: Aleks
21.02.2014
Сообщения: 160
|
Aw: Error 1118 Row size too large.
Also error
|
|
21.08.2014 11:19
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25919
|
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
|
|
Aleks_El_Dia
Name: Aleks
21.02.2014
Сообщения: 160
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25919
|
Aw: Error 1118 Row size too large.
220 - varchar(100)
440 - varchar(50)
|
|
27.03.2015 01:53
|
|
worldpeace
Name: Vladislav Dobrovolski
20.02.2013
Сообщения: 9
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25919
|
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
|
|
worldpeace
Name: Vladislav Dobrovolski
20.02.2013
Сообщения: 9
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25919
|
Aw: Error 1118 Row size too large.
Structure tjr4c_jshopping_products?
|
|
28.03.2015 02:37
|
|
worldpeace
Name: Vladislav Dobrovolski
20.02.2013
Сообщения: 9
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25919
|
Aw: Error 1118 Row size too large.
You use all languages?
ru, de, es, ....
|
|
28.03.2015 18:30
|
|
worldpeace
Name: Vladislav Dobrovolski
20.02.2013
Сообщения: 9
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25919
|
Aw: Error 1118 Row size too large.
change field type (example)
alias_... - varchar(50)
meta_title_... - varchar(50)
|
|
28.03.2015 22:24
|
|
worldpeace
Name: Vladislav Dobrovolski
20.02.2013
Сообщения: 9
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25919
|
Aw: Error 1118 Row size too large.
url?
admin login?
phpmyadmin access.
|
|
30.03.2015 04:59
|
|
worldpeace
Name: Vladislav Dobrovolski
20.02.2013
Сообщения: 9
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25919
|
Aw: Error 1118 Row size too large.
Table type InnoDB or MyISAM?
|
|
31.03.2015 13:32
|
|
worldpeace
Name: Vladislav Dobrovolski
20.02.2013
Сообщения: 9
|
Aw: Error 1118 Row size too large.
Table type InnoDB .
|
|
31.03.2015 21:17
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25919
|
Aw: Error 1118 Row size too large.
Try change to MyISAM
|
|