View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002996 | OXID eShop (all versions) | 5. ------ UpdateApp / Update ------ | public | 2011-06-20 17:54 | 2015-08-06 13:08 |
| Reporter | leofonic | Assigned To | |||
| Priority | high | Severity | crash | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.5.0 revision 34568 | ||||
| Target Version | 4.6.7 | Fixed in Version | 4.6.1 revision 45706 | ||
| Summary | 0002996: UpdateApp fails on MySQL 5.5 | ||||
| Description | UpdateApp and also some update Packages use "TYPE=MyISAM", which does not work anymore on MySQL 5.5 The issue was not fully fixed in 0002470. The TYPE changed to ENGINE only in the eShop SQLs, but not in the Update SQL to version 4.5.0. As update.sql to 4.5.0 is included also in all further updates (i.e. updating to 4.5.1 at first it uses the update sql to version 4.5.0) - then need to fix this issue in all the update.sql for previous versions. | ||||
| Additional Information | See bug 0002470 | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Theme | Both | ||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
| related to | 0002470 | resolved | arvydas_vapsva | Setup fails on MySQL 5.5 |
|
|
Still present in 450 to 451 |
|
|
@developers: please investigate it |
|
|
type changed to engine in all update scripts since 4.0.0 version |
|
|
update engine script has the same problem |
|
|
changed in update script app |
|
|
There is still TYPE=MyISAM in udpateTracker.php of some of the Update packages, e.g. 4.4.6 to 4.4.8. |
|
|
in 1.sql update script changed TYPE = to ENGINE |
|
|
also happens with efire modules for example efiHeidelpay |
|
|
Still found TYPE=MyISAM in the creditpass files "oxid2creditPass.sql", also moduleInfo.php (testdata). Please entire repository for files, containing this text. |
|
|
fixed in creditpass |
|
|
There is still TYPE=MyISAM in many of the update packages in update engines and also in update files. |
|
|
Reminder sent to: leofonic Hi, Could you please tell exact package name, where you found TYPE=MyISAM in any place? Best regards, |
|
|
there was a problem with update: http://forum.oxid-esales.com/showthread.php?t=15553 so i looked into some packages: PATCH_OXID_ESHOP_CE_V.4.4.6_32697_TO_V.4.4.8_34028: updateTracker.php UPDATE_OXID_ESHOP_CE_V.4.0.1.0_15990_TO_V.4.4.8_34028: updateTracker.php, 15990.sql, 27884.sql UPDATE_OXID_ESHOP_CE_V.4.3.2_27884_TO_V.4.4.8_34028: updateTracker.php, 27884.sql The other packages i didn't look into. |
|
|
bug is still present and prevents updating with cumulative packs |
|
|
Why is this marked "resolved"? |
|
|
All old CuPs for updating to eShop 4.4.8 was regenerated. Files are available upon request from support. |
|
|
Sorry for reopening, but Priority:high, Severity:critical, and then only "available upon request from support"? Why no fix in the downloadable update packages? |
|
|
The bug is still present in all updates to 4.4.8. If you won't fix this please leave a note. |
|
|
For CE cumulative update packages to 4.4.8 the problem present in these three files, which I atached to this bug. updateApp/core/updateTracker.php 15990.sql 27884.sql Please change them manually before updating to 4.8.8 |
