Ubuntu 16.04 + sqlite3 not work for F3

[Stone Wu]

I had tried php7.0 +php7.0-sqlite or php5.6+php5.6-sqlite bind to F3

 when startup : got error : 

Fatal error: PHP Startup: Unable to load dynamic library '/usr/lib/php/20131226/pdo_sqlite.so' - /usr/lib/php/20131226/pdo_sqlite.so: undefined symbol: sqlite3_column_table_name

ask for help

[Stone Wu]

 under Ubuntu 16.04

Stone Wu於 2017年9月25日星期一 UTC+8下午3時31分55秒寫道：

[ved]

This issue is not in any way related with F3 and it's most likely a configuration issue with your server and php setup.

How exactly are you installing that? Are you using ubuntu's own packages? Or are you compiling it yourself?

These issues seem to be related:

https://stackoverflow.com/questions/10565521/error-in-php5-unable-to-load-dynamic-library

https://bugs.php.net/bug.php?id=48614

I would suggest an "apt-get --purge remove php5-* php7.0-*" and just reinstall everything from scratch. Please backup your existing configuration first if you follow my suggestion.

[Stone Wu]

dear ved,

    I do purge all and install again, but still got this message at startup

Internal Server Error

Fatal error: PHP Startup: Unable to load dynamic library '/usr/lib/php/20131226/pdo_sqlite.so' - /usr/lib/php/20131226/pdo_sqlite.so: undefined symbol: sqlite3_column_table_name

what i missing?

ved於 2017年9月25日星期一 UTC+8下午6時23分25秒寫道：

[ikkez]

It's obviously the sqlite module that is trying to be loaded but it is not installed.

[ved]

@ikkez: maybe, but he did state on his first post that he tried: "php7.0 +php7.0-sqlite or php5.6+php5.6-sqlite" so I assume the sqlite module is installed.

@Stone Wu:

Can you confirm that the file "/usr/lib/php/20131226/pdo_sqlite.so" exists in the affected system?

Are the php packages from Ubuntu's repository or are you using a 3rd party repo?

What webserver are you using?

[Stone Wu]

yes I sure it is there, "/usr/lib/php/20131226/pdo_sqlite.so" 

and using apt-get install php5.6  

using apache 2.4 

ubuntu 16.04 

 

ved於 2017年9月26日星期二 UTC+8下午5時03分55秒寫道：

[Stone Wu]

may be cause by  /usr/lib/php/20131226/pdo_sqlite.so: undefined symbol: sqlite3_column_table_name 

what do you think

Stone Wu於 2017年9月27日星期三 UTC+8上午10時51分08秒寫道：

[ved]

Yes, it's definitely because of that error. The thing is that should not happen if you're using ubuntu's own packages since they're usually pretty well tested.

The problem seems to be related with some bad upgrade or something like that. Have you upgraded anything recently? Apache or php? Can you purge and reinstall apache?

Anyway, the issue is with your server configuration and not related with F3 so there's really not much else I can do besides what was already suggested.

[ikkez]

sudo apt-get install php5.6-sqlite3

[ved]

sudo apt-get install php5.6-sqlite3

Yep, that's probably it.

Just searched for that package name and apparently more people are having issues with the regular *-sqlite and have to install that one. 

[Stone Wu]

thanks anyway

ved於 2017年9月27日星期三 UTC+8下午6時49分24秒寫道：