0006641: UTF-8 update script runs into an endless loop

ID	Project	Category	View Status	Date Submitted	Last Update

0006641	OXID eShop (all versions)	5. ------ UpdateApp / Update ------	public	2017-05-16 13:32	2024-05-16 10:07

Reporter	michael_keiluweit	Assigned To
Priority	normal	Severity	minor	Reproducibility	always
Status	closed	Resolution	no change required
Product Version	4.7.0 / 5.0.0 revision 51243

Summary	0006641: UTF-8 update script runs into an endless loop
Description	While executing the update script to change the charset from ISO to UTF-8 it runs into an endless loop.
Steps To Reproduce	1. Install the shop 5.0.0 (and do not check the checkbox to install with the charset UTF-8) 2. Get the fitting update package from this page: https://www.oxid-esales.com/de/support-services/dokumentation-und-hilfe/oxid-eshop/installation/oxid-eshop-aktualisieren/auf-utf-8-umstellen.html 3. Follow the instructions and begin the update. 4. At the step "done convertConfigData," it will loop.
Additional Information	Also experienced with the script for the shop version 5.1.0. MySQL Server version: 5.5.55-0ubuntu0.14.04.1-log (Ubuntu) Suggested fix: update.php \update_utf8::convertConfigData Search for $iUpdateCnt = 0; $oRs = oxDb::getDb(true)->Execute( $sQ ); Replace with $iUpdateCnt = 0; $oRs = oxDb::getDb(oxDb::FETCH_MODE_ASSOC)->Execute( $sQ );
Tags	Solution Provided, UTF-8

Theme	Not defined
Browser	Not defined
PHP Version	Not defined
Database Version	Not defined