MyBB Community Forums

Full Version: Unable to edit theme stylesheet.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
MyBB: 1.4.9
PHP: 5.2.6-1+lenny3
SQL Engine: SQLite 4 (Using PDO driver for SQLite 3.5.9)
File permissions: 644
Directory permissions: 755

I have tested this with SQLite 2 and SQLite 3. When using SQLite2 for the database, making a theme and editing a style sheet works fine. When using SQLite3, editing the style sheet and choosing to save changes and close loads an empty page. I get this in the PHP error log:

[26-Oct-2009 07:30:08] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 near "0": syntax error' in /var/www/default/forums/inc/db_pdo.php:67
Stack trace:
#0 /var/www/default/forums/inc/db_pdo.php(67): PDO->query('????INSERT ????...', 4)
#1 /var/www/default/forums/inc/db_sqlite3.php(189): dbpdoEngine->query('????INSERT ????...')
#2 /var/www/default/forums/inc/db_sqlite3.php(261): DB_SQLite3->query('????INSERT ????...', 0)
#3 /var/www/default/forums/inc/db_sqlite3.php(617): DB_SQLite3->write_query('????INSERT ????...')
#4 /var/www/default/forums/admin/inc/functions_themes.php(720): DB_SQLite3->insert_query('themestylesheet...', Array)
#5 /var/www/default/forums/admin/modules/style/themes.php(1409): copy_stylesheet_to_theme(Array, '3')
#6 /var/www/default/forums/admin/index.php(380): require('/var/www/defaul...')
#7 {main}
thrown in /var/www/default/forums/inc/db_pdo.php on line 67