News:

Join the Facebook Fan Page.

Main Menu

Subs-Post.php error

Started by Epsynus, April 11, 2011, 01:54:58 PM

Previous topic - Next topic

Epsynus

Hello i got a fresh windows server 2008 server today, so i fired up a install of PHP, MYSQL & Apache
everything configures and runs just great, untill i edit a post on the forums.

i get this error each time i try to save the post after editing it

Incorrect string value: '\xE4lkomm...' for column 'subject' at row 1
File: C:\sidan\forum\Sources\Subs-Post.php
Line: 1896

and if i go into Subs-Post.php to line 1896 this exists

// Change the post.
   db_query("
       UPDATE {$db_prefix}messages
      SET " . implode(', ', $messages_columns) . "
      WHERE ID_MSG = $msgOptions[id]
      LIMIT 1", __FILE__, __LINE__);

but i can not for my life figure out what is wrong.

here is our
phpinfo
apparantly i am not allowed to post external links.
so here is the details

PHP Version 5.3.6
SMF Version 1.1.13
MYSQL Version 5.5


All help is appriciated

Arantor

Using UTF-8?

You might try not using MySQL 5.5, since when SMF 1.1.x was mostly written, even MySQL 5.0 was new-fangled...

Epsynus

Quote from: Arantor on April 11, 2011, 02:16:25 PM
Using UTF-8?

You might try not using MySQL 5.5, since when SMF 1.1.x was mostly written, even MySQL 5.0 was new-fangled...
nope not using UTF-8.

Ok if no one got any other help i will resolve into doing that. but before i want to see if there is something else that might work

Adish - (F.L.A.M.E.R)

All I can think about is try using an older version of MySQL as Arantor suggested. The file doesn't seem to have any issues IMO. :o

Epsynus

Allright it seems like that is the only way. Thanks for the help :)

and i just noticed a thing. i asked this question in the wrong forum :P
Anywho Thanks again :)

Advertisement: