Package: phpmyadmin Version: 4:2.8.0.2-4 Severity: normal
I've dumped a table as UPDATE commands and got invalid result for the name column. Large hexadecimal numbers are dumped instead of strings. This cannot be executed on the same version of mysql. Dump is useless: -- phpMyAdmin SQL Dump -- version 2.8.0.2-Debian-4 -- http://www.phpmyadmin.net -- -- Hoszt: localhost -- Ltrehozs ideje: 2006. pr 25. 05:59 -- Szerver verzi: 4.1.15 -- PHP Verzi: 4.4.2-1+b1 -- -- Adatbzis: `cx_digit` -- -- -------------------------------------------------------- -- -- Tbla szerkezet: `parameters` -- CREATE TABLE `parameters` ( `rowid` int(11) NOT NULL auto_increment, `name` varchar(32) character set ascii collate ascii_bin NOT NULL default '', `label` varchar(100) NOT NULL default '', `language` char(2) character set ascii collate ascii_bin NOT NULL default '', `value` text NOT NULL, `description` text NOT NULL, `foreign` varchar(16) NOT NULL default '', `order` int(11) NOT NULL default '0', PRIMARY KEY (`rowid`), UNIQUE KEY `name_language` (`name`,`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; -- -- Tbla adatok: `parameters` -- UPDATE `parameters` SET `rowid` = 1, `name` = 0x737a616c6c69746173695f64696a5f474c53, `label` = 'GLS futrszolglat (kvetkez? munkanapra)', `language` = '', `value` = '2:1200, 3:1400, 5:1500, 10:1600, 15:1700, 20:1800, 25:2000, 30:2100, 50:5200', `description` = 'GLS szlltsi djai a sly fggvnyben. A lista vessz?vel elvlasztva slyhatr:dj rtkprokat tartalmaz. Az els? olyan dj lesz rvnyes, amelynl az sszsly a megadott hatrnl kisebb vagy egyenl?.', `foreign` = '', `order` = 1 WHERE `rowid` = 1, UPDATE `parameters` SET `rowid` = 2, `name` = 0x737a616c6c69746173695f64696a5f454d53, `label` = 'EMS gyorsposta (msnap de. 9-ig, 100% felrral)', `language` = '', `value` = '2:2400, 3:2800, 5:3000, 10:3200, 15:3400, 20:3600, 25:4000, 30:4200, 50:10400', `description` = 'EMS gyorsposta szlltsi djai a sly fggvnyben. A lista vessz?vel elvlasztva slyhatr:dj rtkprokat tartalmaz. Az els? olyan dj lesz rvnyes, amelynl az sszsly a megadott hatrnl kisebb vagy egyenl?.', `foreign` = '', `order` = 2 WHERE `rowid` = 2, UPDATE `parameters` SET `rowid` = 3, `name` = 0x737a616c6c69746173695f64696a5f737a656d656c796573656e, `label` = 'rte megynk', `language` = '', `value` = '0', `description` = 'A szemlyes tvtel ingyenes.', `foreign` = '', `order` = 3 WHERE `rowid` = 3, UPDATE `parameters` SET `rowid` = 4, `name` = 0x6b656476657a6d656e795f6b65737a70656e7a, `label` = 'Kszpnzes fizets kedvezmnye [%]', `language` = '', `value` = '3', `description` = 'Kszpnzes fizets esetn nyjtott rkedvezmny szzalkban. Tizedestrt rtk esetn tizedesvessz? helyett pontot kell hasznlni!', `foreign` = '0', `order` = 1 WHERE `rowid` = 4, UPDATE `parameters` SET `rowid` = 5, `name` = 0x6b656476657a6d656e795f706f737461695f7574616e766574, `label` = 'Postai utnvt kedvezmnye [%]', `language` = '', `value` = '1', `description` = 'Postai utnvt esetn nyjtott rkedvezmny szzalkban. Tizedestrt rtk esetn tizedesvessz? helyett pontot kell hasznlni!', `foreign` = '-3', `order` = 2 WHERE `rowid` = 5, UPDATE `parameters` SET `rowid` = 6, `name` = 0x6b656476657a6d656e795f7574616c61735f656c6f7265, `label` = 'El?reutals kedvezmnye [%]', `language` = '', `value` = '3', `description` = 'El?reutals esetn nyjtott rkedvezmny szzalkban. Tizedestrt rtk esetn tizedesvessz? helyett pontot kell hasznlni!', `foreign` = '1', `order` = 4 WHERE `rowid` = 6, UPDATE `parameters` SET `rowid` = 7, `name` = 0x6b656476657a6d656e795f7574616c61735f75746f6c6167, `label` = 'Utlagos tutals kedvezmnye [%]', `language` = '', `value` = '1', `description` = 'Utlagos tutals esetn nyjtott rkedvezmny szzalkban. Tizedestrt rtk esetn tizedesvessz? helyett pontot kell hasznlni!', `foreign` = '-1', `order` = 5 WHERE `rowid` = 7, UPDATE `parameters` SET `rowid` = 8, `name` = 0x6b656476657a6d656e795f62616e6b6b6172747961, `label` = 'Bankkrtys vsrls kedvezmnye', `language` = '', `value` = '0', `description` = 'Bankkrtys vsrls esetn nyjtott rkedvezmny szzalkban. Tizedestrt rtk esetn tizedesvessz? helyett pontot kell hasznlni!', `foreign` = '-2', `order` = 3 WHERE `rowid` = 8, UPDATE `parameters` SET `rowid` = 9, `name` = 0x616661, `label` = 'FA [%]', `language` = '', `value` = '20', `description` = 'ltalnos forgalmi ad mrtke szzalkban.', `foreign` = '', `order` = 0 WHERE `rowid` = 9; NOTE: Wrong accented characters in label fileds of the above example is not an issue, since my utf8 dump is correct. It appears incorrectly in this bug report only. My problem is the `name` column. -- System Information: Debian Release: testing/unstable APT prefers unstable APT policy: (990, 'unstable'), (500, 'stable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.14-sirius-20051219-0354 Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages phpmyadmin depends on: ii debconf [debconf-2.0] 1.4.72 Debian configuration management sy ii php4 4:4.4.2-1 server-side, HTML-embedded scripti ii php4-mysql 4:4.4.2-1+b1 MySQL module for php4 ii ucf 2.007 Update Configuration File: preserv Versions of packages phpmyadmin recommends: ii apache2 2.0.55-4 next generation, scalable, extenda ii apache2-mpm-prefork [httpd] 2.0.55-4 traditional model for Apache2 ii php4-gd 4:4.4.2-1+b1 GD module for php4 ii php4-mcrypt 3:4.3.10-2 MCrypt module for php4 -- debconf information: phpmyadmin/setup-username: admin * phpmyadmin/reconfigure-webserver: apache2 * phpmyadmin/restart-webserver: true -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
