0001705: with more than 8 languages, the MySQL table size limit is reached

ID	Project	Category	View Status	Date Submitted	Last Update

0001705	OXID eShop (all versions)	4.06. Language and translations	public	2010-03-17 16:04	2010-09-07 10:52

Reporter	marco_steinhaeuser	Assigned To
Priority	high	Severity	block	Reproducibility	always
Status	closed	Resolution	suspended
Product Version	4.2.0 revision 23610
Fixed in Version	4.5.0_beta3

Summary	0001705: with more than 8 languages, the MySQL table size limit is reached
Description	Because all the language dependent text are kept in separate fields in the same table, and are varchar(255) with utf8 encoding, if you have more than 8 languages, the MySQL table size limit is reached thous adding new fields to the table it's impossible. So I had to add manually the new fields for languages from 8 to 15 and set them text (text fields are recorded in separate files).
Additional Information	Untested, found in this thread: http://www.oxid-esales.com/forum/showthread.php?t=4646 See the bug entry about the same issue 0001915. Issue is mentioned there as blocker for Updates to new eshop versions.
Tags	No tags attached.

Theme
Browser	All
PHP Version	any
Database Version	any

tomas_liubinas 2010-03-17 16:50 reporter ~0002416	We can not prevent users from reaching mysql row size limit eventually, but what we can do is at least informing shop administrator about the situation when this limit has been reached.

ralf_trapp 2010-09-07 10:50 reporter ~0003482 Last edited: 2010-09-09 10:47	As this is basically no bug in OXID eShop but a limit of MySQL, OXID eSales cannot really 'fix' it as it's a limit of another product which we neither support nor create. But anyway OXID will choose another way for representing multilanguagedata inside database. This will be build in into OXID eShop 4.5.0. As this issue here now is transferred into regular roadmap, this issue tracker entry will be closed. See also http://wiki.oxidforge.org/Roadmap/4.5.0#New_features