MyBB Community Forums

Full Version: help? mybb 1.6 problem of sqlite
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
i have't used english for a long time,maybe i can't express my real problem. i have installed mybb 1.6 using sqlite3.
over installing ,when "new thread",an error come. the error is down
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 19 column title is not unique' in /data/multiserv/users/447308/projects/1117633/www/english/inc/db_pdo.php:67 Stack trace: #0 /data/multiserv/users/447308/projects/1117633/www/english/inc/db_pdo.php(67): PDO->query('UPDATE mybb_dat...', 4) #1 /data/multiserv/users/447308/projects/1117633/www/english/inc/db_sqlite.php(189): dbpdoEngine->query('UPDATE mybb_dat...') #2 /data/multiserv/users/447308/projects/1117633/www/english/inc/db_sqlite.php(683): DB_SQLite->query('UPDATE mybb_dat...') #3 /data/multiserv/users/447308/projects/1117633/www/english/inc/db_sqlite.php(982): DB_SQLite->update_query('datacache', Array, NULL) #4 /data/multiserv/users/447308/projects/1117633/www/english/inc/class_datacache.php(173): DB_SQLite->replace_query('datacache', Array, 'title', false) #5 /data/multiserv/users/447308/projects/1117633/www/english/inc/functions.php(1808): datacache->update('stats', Array, 'dateline') #6 /data/multiserv in /data/multiserv/users/447308/projects/1117633/www/english/inc/db_pdo.php on line 67

but the new thread is succesed.i can see it in thread list.
when “quick reply” or Register,the same error come。
over it,quick reply can be succesed .i also can see it.
"new reply" is ok,have't any problem.
anybody can help me?see http://mybb.a.gp/english
user is tom,password is 123456
There has been numerous bugs reported when running MyBB on a SQLite database.
can you solve this problem?ple help me!
nobody here?
help?
can? help me ?
i need answer
Switch to a hosting that offers a MySQL database, and use MySQL.
Same problem here, if SQlite is not supported then why there is an option for it.
If someone reports a bug with SQLite, it will be fixed.
http://dev.mybb.com/issues/1613

This was posted year ago, same error while posting and deleting new posts. Nothing happened since then.

SQLSTATE[23000]: Integrity constraint violation: 19 column dateline is not unique