search

jirismika / SFNC

Feeds input to your phpBB3 board - posts content into forums, shows news as ticking news block ...
http://phpbb3.smika.net/mod/sfnc
GNU General Public License v2.0
8 stars 3 forks source link

/contrib/install.php fails with sqlite as db #9

Open yaddapunk opened 11 years ago

yaddapunk commented 11 years ago

Unable to install when using sqlite as db with current ver of phpbb.

I'm unsure as to phpbbs handling of sql and weather or not it can adapt sql from one dbms to another.

General Error SQL ERROR [ sqlite ]

SQL logic error or missing database [1]

SQL

DROP TABLE IF EXISTS phpbb_smixmods_feed_news_center

BACKTRACE

FILE: (not given by php) LINE: (not given by php) CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php LINE: 757 CALL: trigger_error()

FILE: [ROOT]/includes/db/sqlite.php LINE: 128 CALL: dbal->sql_error()

FILE: [ROOT]/contrib/install.php LINE: 106 CALL: dbal_sqlite->sql_query()

jirismika commented 11 years ago

Hello, what's your version of SQLite? ... SQLite fully supports the IF EXISTS statement from version 3.3.0 http://www.sqlite.org/releaselog/3_3_0.html

yaddapunk commented 11 years ago

I was running version 2.8.17

however updating to version sqlite3-3.7.12.1-2.1.2.x86_64 has not fixed the issue.

I have tried with another clean phpbb3

the error is now: General Error SQL ERROR [ sqlite ]

SQL logic error or missing database [1]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.