ID: 19404 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Closed Bug Type: mbstring related Operating System: SuSE Linux 8.0 PHP Version: 4.2.3 New Comment:
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 Previous Comments: ------------------------------------------------------------------------ [2002-10-16 06:05:26] [EMAIL PROTECTED] i want to make a good forum for my homepage ------------------------------------------------------------------------ [2002-10-12 10:51:56] [EMAIL PROTECTED] This is the same issue which was reported here http://bugs.php.net/bug.php?id=19460 I was advised to take latest PHP from CVS. I did and the problem was solved. ------------------------------------------------------------------------ [2002-09-14 11:33:54] [EMAIL PROTECTED] Reclassify ------------------------------------------------------------------------ [2002-09-14 11:32:01] [EMAIL PROTECTED] This was a problem with mbstring that has been fixed in CVS. The workaround is not to use --enable-mbstr-enc-trans when configuring PHP. (You won't miss it, because the chances are that you don't even know what it does :-) ------------------------------------------------------------------------ [2002-09-14 11:19:10] [EMAIL PROTECTED] Hm, but its a strange behaviour of PHP if the same script worked from Version 4.0.0 up to 4.2.2 and just stopped with 4.2.3. I don't believe this is because of the script :) Even the configuration file has been adapeted (MagicQuoting, SafeMode, RegisterGlobals etc) ------------------------------------------------------------------------ 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
