search

FreederTeam / Freeder

An easy-to-use free feed reader
Other
5 stars 1 forks source link

Uncaught exception 'PDOException' #34

Closed marienfressinaud closed 10 years ago

marienfressinaud commented 10 years ago

I'm running PHP 5.3.3 and SQLite 3.6.20 (CentOS 6). Problem comes from query in install.php:

INSERT OR IGNORE INTO views(name, rule) VALUES
    ("_home", "+$all -_read -_no_home BY -$pubDate"),
    ("_public", "+$all -_private BY -$pubDate")

Indeed, multiple insertions don't work.

Here is the full stack trace:

Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 near ",": syntax error' in /var/www/html/inc/install.php:164
Stack trace:
#0 /var/www/html/inc/install.php(164): PDO->query('INSERT OR IGNOR...')
#1 /var/www/html/inc/install.php(206): install_db()
#2 /var/www/html/inc/init.php(33): install()
#3 /var/www/html/index.php(9): require_once('/var/www/html/i...')
#4 {main}
  thrown in /var/www/html/inc/install.php on line 164, referer: http://localhost/
marienfressinaud commented 10 years ago

It works by running two INSERT instructions ;)

Phyks commented 10 years ago

Should be fixed in the todo branch which is the updated branch with latest backend features, see https://github.com/FreederTeam/Freeder/issues/25#issuecomment-53045688.