View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002901 | OXID eShop (all versions) | 1. ----- eShop frontend ----- | public | 2011-05-19 11:18 | 2012-12-10 14:16 |
| Reporter | Helmut L. | Assigned To | |||
| Priority | urgent | Severity | block | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.5.0 revision 34568 | ||||
| Fixed in Version | 4.5.1 revision 38045 | ||||
| Summary | 0002901: insert into oxfield2shop fails | ||||
| Description | The 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 Information | The 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 | ||||
| Tags | Subshops | ||||
| Theme | Both | ||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
| related to | 0002758 | resolved | arvydas_vapsva | oxfield2shop does not work with multilingual fields |
