Hello,
First of all I want to apologize for my English, because I'm French.
This morning I had a problem with the chat, which had never happened to me!
Here are the logs :
ZitatAlles anzeigenSat, 31 Jan 2015 05:14:47 +0000
Message: Could not execute prepared statement: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'chatLastSeen' cannot be null
File: /public_html/forum/lib/system/database/statement/PreparedStatement.class.php (100)
PHP version: 5.4.36
WCF version: 2.0.10 pl 1 (Maelstrom)
Request URI: /fo/chat/index.php/NewMessages/
Referrer: http://paytoclickfr.org/fo/cha…toclickfr-T%E2%80%99Chat/
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/38.0.2125.122 Safari/537.36
Information: "<b>sql type:<\/b> wcf\\system\\database\\MySQLDatabase<br \/><b>sql error:<\/b> Column 'chatLastSeen' cannot be null<br \/><b>sql error number:<\/b> 23000<br \/><b>sql version:<\/b> 5.5.41-0+wheezy1-log<br \/><b>sql query:<\/b> UPDATE\twcf1_user\n\t\t\tSET\tchatLastSeen = ?, chatLastActivity = ?\n\t\t\tWHERE\tuserID = ?<br \/><b>sql query parameter 0:<\/b><br \/><b>sql query parameter 1:<\/b>1422681287<br \/><b>sql query parameter 2:<\/b>1<br \/>"
Stacktrace:
#0 /public_html/forum/lib/data/DatabaseObjectEditor.class.php(69): wcf\system\database\statement\PreparedStatement->execute(Array)
#1 /public_html/forum/lib/data/user/UserEditor.class.php(84): wcf\data\DatabaseObjectEditor->update(Array)
#2 /public_html/fo/chat/lib/page/NewMessagesPage.class.php(90): wcf\data\user\UserEditor->update(Array)
#3 /public_html/fo/chat/lib/page/NewMessagesPage.class.php(65): chat\page\NewMessagesPage->readMessages()
#4 /public_html/forum/lib/page/AbstractPage.class.php(179): chat\page\NewMessagesPage->readData()
#5 /public_html/fo/chat/lib/page/NewMessagesPage.class.php(106): wcf\page\AbstractPage->show()
#6 /public_html/forum/lib/page/AbstractPage.class.php(86): chat\page\NewMessagesPage->show()
#7 /public_html/forum/lib/system/request/Request.class.php(58): wcf\page\AbstractPage->__run()
#8 /public_html/forum/lib/system/request/RequestHandler.class.php(108): wcf\system\request\Request->execute()
#9 /public_html/fo/chat/index.php(10): wcf\system\request\RequestHandler->handle('chat')
#10 {main}
Can you help me? please