View Issue Details

IDProjectCategoryView StatusLast Update
0002901OXID eShop (all versions)1. ----- eShop frontend -----public2012-12-10 14:16
ReporterHelmut L. 
PriorityurgentSeverityblockReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.5.0 revision 34568 
Target VersionFixed in Version4.5.1 revision 38045 
Summary0002901: insert into oxfield2shop fails
DescriptionThe insert string for oxfield2shop is always a select from the oxarticles view for all languages and the oxartextends view for all languages. This is also the case when all values are directly provided and the select is not needed.
If you have many language tables, the MySQL limit of 61 tables per join is reached and the query fails.
Additional InformationThe generated insert string:
insert into oxfield2shop ( oxid, oxshopid, oxartid , oxprice , oxpricea , oxpriceb , oxpricec ) select 'lmae8b4f3f79dd1ff39266079d54f25c', '2', '7aq325e707f625d6182685b72c8cf51c' , '7.04' , '5.22' , '9' , '12.05' from oxv_oxarticles as oxarticles left join oxv_oxartextends as oxartextends on oxarticles.oxid=oxartextends.oxid where oxarticles.oxid="7aq325e707f625d6182685b72c8cf51c";

The MySQL error:
1116: Too many tables; MySQL can only use 61 tables in a join
TagsSubshops
ThemeBoth
BrowserAll
PHP Versionany
Database Versionany

Relationships

related to 0002758 resolvedarvydas_vapsva oxfield2shop does not work with multilingual fields 

Activities

birute_meilutyte

2011-05-19 12:10

reporter   ~0004616

@developers: check from source code side if such issue still exist

arvydas_vapsva

2011-07-13 10:25

reporter   ~0004855

fixed together with 0002758