• Registered: 2008-05-03
  • Posts: 6

Topic: Seemingly random "Unable to create..." errors

Hi all,

I've been getting rather strange errors. I kinda fooled around with the punBB login in order to integrate it into our website, and I've been getting these seemingly random "Unable to create post" or "Unable to create topic" errors.

When creating posts I get it really randomly, but as for topics I couldn't create one yet...

When I used a different approach to the login system, it didn't come up this often...

Right now I modded it that it doesn't use cookies for authentication, it stores stuff in $_SESSION. Anyway, if I dump $pun_user right before the query would be executed, it seems it's all there...

The server runs IIS and MySQL.

Any thoughts on what the problem could be?

  • Registered: 2008-05-03
  • Posts: 6

Re: Seemingly random "Unable to create..." errors

oh, sorry, I just realised it should go under "Integration"...

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Seemingly random "Unable to create..." errors

Enable debug mode, paste the full errro

  • Registered: 2008-05-03
  • Posts: 6

Re: Seemingly random "Unable to create..." errors

An error was encountered
File: C:\...\post.php
Line: 181

PunBB reported: Unable to create post

Database reported: Incorrect string value: '\xE1rv\xEDzt...' for column 'message' at row 1 (Errno: 1366)

apparently the problem is with characters like éá??úöüóí - so non-latin1 characters...

i'm gonna look into that. no idea why this is happening, tho.

  • Registered: 2008-05-03
  • Posts: 6

Re: Seemingly random "Unable to create..." errors

ok, so after a little searching here I found out I should change the default encoding to UTF-8 in  lang\common.php  - now it posts everything like a charm, except that it dies halfway, saying "Error: Unable to insert search index words." .

At least it seems like we know what the problem is, question would be, how do i resolve this?

thanks

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Seemingly random "Unable to create..." errors

The problem is that PunBB 1.2 doesn't have full UTF-8 support. If you can, you should avoid using any UTF-8 related stuff at all.

  • Registered: 2008-05-03
  • Posts: 6

Re: Seemingly random "Unable to create..." errors

well, for now i have to stick with using UTF8, as the rest of the database is in UTF8, plus the site is as international as possible. i'll dig myself into proper UTF8 conversion, they say there's loads of info about it up here.

thanks anyway for the hints.