View Issue Details

Jump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0001003OXID eShop (all versions)1.04. Content, static (register, contact etc.) pagespublic2009-06-10 14:252009-06-16 16:24
Reportermichael_keiluweit Assigned To 
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.1.2 revision 18998 
Fixed in Version4.1.3 revision 19918 
Summary0001003: Problems with MySQL version 5.0.37
DescriptionHi,

using MySQL Version 5.0.37, the long description will not be saved
trying to change the long desc of an article. Only this database field
seems to be affected. After updating the database to version 5.0.67,
everything went fine again.
Additional Informationreported by a customer: http://www.oxid-esales.com/forum/showthread.php?t=1371 (german board)
TagsNo tags attached.
Attached Files
mysql-5.0.32.txt (4,482 bytes)    
mysql> delete from oxartextends where OXID in ("test0","test1","test2","test3");
Query OK, 1 row affected (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test0','inserted 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'updated 0';
Query OK, 1 row affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test0','inserted 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'updated 1';
Query OK, 2 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test0','inserted 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'updated 2';
Query OK, 2 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test0','inserted 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'updated 3';
Query OK, 2 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test1','inserted 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'updated 1';
Query OK, 1 row affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test1','inserted 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'updated 2';
Query OK, 2 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test1','inserted 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'updated 3';
Query OK, 2 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test1','inserted 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'updated 0';
Query OK, 2 rows affected, 7 warnings (0.01 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test2','inserted 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'updated 2';
Query OK, 1 row affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test2','inserted 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'updated 3';
Query OK, 2 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test2','inserted 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'updated 0';
Query OK, 2 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test2','inserted 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'updated 1';
Query OK, 2 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test3','inserted 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'updated 3';
Query OK, 1 row affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test3','inserted 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'updated 0';
Query OK, 2 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test3','inserted 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'updated 1';
Query OK, 2 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test3','inserted 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'updated 2';
Query OK, 2 rows affected, 7 warnings (0.00 sec)

mysql>
mysql> select OXID,OXLONGDESC,OXLONGDESC_1,OXLONGDESC_2,OXLONGDESC_3 from oxartextends where OXID in ("test0","test1","test2","test3");
+-------+------------+--------------+--------------+--------------+
| OXID  | OXLONGDESC | OXLONGDESC_1 | OXLONGDESC_2 | OXLONGDESC_3 |
+-------+------------+--------------+--------------+--------------+
| test0 | inserted 0 | updated 1    | updated 2    | updated 3    |
| test1 | updated 0  | inserted 1   | updated 2    | updated 3    |
| test2 | updated 0  | updated 1    | inserted 2   | updated 3    |
| test3 | updated 0  | updated 1    | updated 2    | inserted 3   |
+-------+------------+--------------+--------------+--------------+
4 rows in set (0.00 sec)

mysql>
mysql-5.0.32.txt (4,482 bytes)   
mysql-5.0.37.txt (4,476 bytes)    
mysql> delete from oxartextends where OXID in ("test0","test1","test2","test3");
Query OK, 1 row affected (0.09 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test0','inserted 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'updated 0';
Query OK, 1 row affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test0','inserted 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'updated 1';
Query OK, 0 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test0','inserted 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'updated 2';
Query OK, 0 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test0','inserted 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'updated 3';
Query OK, 0 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) V
ALUES ('test1','inserted 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'updated 1';
Query OK, 1 row affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test1','inserted 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'updated 2';
Query OK, 0 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test1','inserted 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'updated 3';
Query OK, 0 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test1','inserted 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'updated 0';
Query OK, 0 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test2','inserted 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'updated 2';
Query OK, 1 row affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test2','inserted 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'updated 3';
Query OK, 0 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test2','inserted 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'updated 0';
Query OK, 0 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test2','inserted 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'updated 1';
Query OK, 0 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test3','inserted 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'updated 3';
Query OK, 1 row affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test3','inserted 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'updated 0';
Query OK, 0 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test3','inserted 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'updated 1';
Query OK, 0 rows affected, 7 warnings (0.00 sec)

mysql> insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test3','inserted 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'updated 2';
Query OK, 0 rows affected, 7 warnings (0.00 sec)


mysql> select OXID,OXLONGDESC,OXLONGDESC_1,OXLONGDESC_2,OXLONGDESC_3 from oxartextends where OXID in ("test0","test1","test2","test3");
+-------+------------+--------------+--------------+--------------+
| OXID  | OXLONGDESC | OXLONGDESC_1 | OXLONGDESC_2 | OXLONGDESC_3 |
+-------+------------+--------------+--------------+--------------+
| test0 | inserted 0 | updated 1    | updated 2    | updated 3    |
| test1 | updated 0  | inserted 1   | updated 2    | updated 3    |
| test2 | updated 0  | updated 1    | inserted 2   | updated 3    |
| test3 | updated 0  | updated 1    | updated 2    | inserted 3   |
+-------+------------+--------------+--------------+--------------+
4 rows in set (0.00 sec)

mysql>
mysql-5.0.37.txt (4,476 bytes)   
test.txt (2,865 bytes)    
delete from oxartextends where OXID in ("test0","test1","test2","test3");

insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test0','insert 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'update 0';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test0','insert 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'update 1';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test0','insert 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'update 2';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test0','insert 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'update 3';

insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test1','insert 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'update 1';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test1','insert 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'update 2';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test1','insert 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'update 3';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test1','insert 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'update 0';

insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test2','insert 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'update 2';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test2','insert 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'update 3';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test2','insert 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'update 0';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test2','insert 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'update 1';

insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test3','insert 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'update 3';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test3','insert 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'update 0';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test3','insert 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'update 1';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test3','insert 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'update 2';

select OXID,OXLONGDESC,OXLONGDESC_1,OXLONGDESC_2,OXLONGDESC_3 from oxartextends where OXID in ("test0","test1","test2","test3");
test.txt (2,865 bytes)   
Theme
BrowserAll
PHP Version5.2.6
Database Version5.0.37

Activities

alfonsas_cirtautas

2009-06-10 14:47

reporter   ~0001040

Article long descriptions are in separate table "oxartextends". It
is saved using mysql syntax INSERT ... ON DUPLICATE KEY UPDATE ... .

After investigating mysql 5.0.37 on windows results of these queries i
noticed that mysql affected rows are reported badly (must be 1 on insert, 2
on update, and i got 1 on insert, 0 on update ) but data was still inserted
correctly (on mysql version 5.0.32 everything worked fine)

Test sql and results on different mysql versions are attached.

After such results i found that there are few similar mysql bugs (
http://bugs.mysql.com/bug.php?id=27744 and
http://bugs.mysql.com/bug.php?id=27210 ) affecting MySQL 5.0.36-5.0.37 and
has fixed in MySQL 5.0.38. In my case i was lucky and got only bad affected
rows report, but as described in bug reports, it is possible to end up with
not updated records too.

dainius.bigelis

2009-06-15 09:59

reporter   ~0001061

Please update the System requirement check with additional exception, that MySQL versions 5.0.36-5.0.37 are not supported.
Also - need to update the System Requirement documentation online.

sarunas_valaskevicius

2009-06-16 16:24

reporter   ~0001081

added requirements check for NOT 5.0.36 and 5.0.37 mysql versions