#19404 [Csd]: phpMyAdmin does not work properly anymore

ID: 19404 Updated by: sniper@php.net Reported By: mv02@gmx.de Status: Closed Bug Type: mbstring related Operating System: SuSE Linux 8.0 PHP Version: 4.2.3 New Comment: This bug was fixed long time ago in CVS. Stop posting any more comments here. Thank you. Previous Comments: ------------------------------------------------------------------------ [2002-10-31 10:10:37] tlush@comresults.com Got the same error (first four characters left off strings) using another (not phpMyAdmin) script on: FreeBSD with PHP (4.2.3) and MySQL (3.23.52) Looks like a PHP/MySQL bug, not phpMyAdmin. ------------------------------------------------------------------------ [2002-10-27 23:32:45] silence@sdf.lonestar.org Hi Fernando.. do you have the problem yet? if you like, write me to my email and i can help you... (i´m in Colombia too, i´m writing in english for the forum) :) Byron H. silence@sdf.lonestar.org ------------------------------------------------------------------------ [2002-10-22 09:27:00] uniqueidlondon@yahoo.com I couldn't recreate the bug with your examples. It worked for me. I am using Apache 2.x php 4.23 and mysql 3.23.53 Did you scroll across to make make a primary key. The last option is not visible unless you scroll horizontally. But it is probably something else on your system. ANDY ------------------------------------------------------------------------ [2002-10-21 05:15:19] papelnet@yahoo.com Hello, Please i had created site on PHP 4.0.5 on my windows 98 I send FTP and PHPMYADMIN the DB and files to server with PHP 4.2.2 The site dont execute, http://www.fonaviemcali.com.co How can i find a solution ? Thanks. Fernando A.- ------------------------------------------------------------------------ [2002-10-20 09:19:04] ck.No.Spam@phptalk.No-SPAM.com Hello!! I have the same problem for phpmyadmin and php 4.2.3 such that: There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem ERROR: Unclosed quote @ 58 STR: ' SQL: UPDATE log_activity SET hits = '765' WHERE month = \'10\' AND day = \'5\' AND year = \'2002\' AND hits = \'764\' AND topics = \'2\' AND posts = \'6\' AND registers = \'2\' AND mostOn = \'9\' LIMIT 1; Hata SQL-sorgusu : UPDATE log_activity SET hits = '765' WHERE month = \'10\' AND day = \'5\' AND year = \'2002\' AND hits = \'764\' AND topics = \'2\' AND posts = \'6\' AND registers = \'2\' AND mostOn = \'9\' LIMIT 1; MySQL çýktýsý: You have an error in your SQL syntax near '\'10\' AND day = \'5\' AND year = \'2002\' AND hits = \'764\' AND topics' at line 1 ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/19404 -- Edit this bug report at http://bugs.php.net/?id=19404&edit=1