Page 1 of 1

[ERROR] ManiaLive1 r267 and SQlite

Posted: 30 Jul 2012, 22:26
by Cayseth
Hi,

im getting the following error with ManiaLive1 r267:

Code: Select all

ManiaLive
PHP Environment Compatibility Test
-----------------------------------------------------
PHP 5.3.1 or newer    -> required  -> [ Yes ] 5.3.10-1ubuntu3.2
Standard PHP Library  -> required  -> [ Yes ]
JSON                  -> required  -> [ Yes ]
OpenSSL               -> required  -> [ Yes ]
cURL with SSL         -> required  -> [ Yes ] 7.22.0 (OpenSSL/1.0.1) (with OpenSSL/1.0.1)
SQLite                -> optional  -> [ Yes ]
-----------------------------------------------------
[01:24:23] XML-RPC connection established
[01:24:23] Successfully authentified with XML-RPC server
PHP Fatal error:  Call to undefined function ManiaLive\Database\SQLite\sqlite_open() in /home/tmf/ManiaLive/libraries/ManiaLive/Database/SQLite/Connection.php on line 41

Fatal error: Call to undefined function ManiaLive\Database\SQLite\sqlite_open() in /home/tmf/ManiaLive/libraries/ManiaLive/Database/SQLite/Connection.php on line 41
Everything is running fine on my old server with the same ManiaLive settings.

I have pdo_sqlite (SQLite Library 3.7.9) and sqlite3 (module version 0.7-dev) installed.
I'm using CGI/FastCGI as server API.

The funny thing is, even when I manually set $sqlite_ok = false in bootstrapper.php, I get the same error again (?).

Would be grateful if someone could help me, it's the one thing keeping me away from changing the server machines.

Greetings,
Cay

Re: [ERROR] ManiaLive1 r267 and SQlite

Posted: 31 Jul 2012, 08:02
by farfa
You have to setup sqlite, it's not sqlite3 neither pdo_sqlite.

Re: [ERROR] ManiaLive1 r267 and SQlite

Posted: 31 Jul 2012, 16:46
by Cayseth
How can I get the old sqlite installed?

apt-get/yum install sqlite doesn't work, it says sqlite is already the latest version.

When I install the 2.8.17 (http://sqlite.org/sqlite-2.8.17.tar.gz) version from source, I only get the libsqlite.so?
And with the pecl version (1.0.3) there is an error with byref_none undeclared (seems like it was a bug back then in 2004).

I also wonder why it says SQLite is enabled in the ManiaLive log.
And it seems to check for either sqlite2 or sqlite3, but sqlite3 doesn't work with sqlite_open()?

Re: [ERROR] ManiaLive1 r267 and SQlite

Posted: 31 Jul 2012, 17:45
by Cayseth
Okay, I worked around it.
I copied a working sqlite.so into the lib and loaded that. Im not getting any php error now, ManiaLive is starting perfectly with FreeZone and MLIntegration plugins.

But I don't see the server in the public lists (like via choosing Country->State) on a TMN account (I do see it with TMF account).
Joining via tmtp://#join=superloltm doesn't work on a TMN account as well (it does on TMF account).

I know that ManiaLive sometimes needs a few hours to start up? Hopefully that will fix it, otherwise I'll be coming back :D

Greetings

Re: [ERROR] ManiaLive1 r267 and SQlite

Posted: 01 Aug 2012, 22:32
by Cayseth
Well, it still doesn't work.

As there is not a single error, this is very hard for me to judge.
Everything seems to be running perfect, everything in the logs is ok.
The settings are the same as on the old working machine.

But it just doesn't show up in the server lists on a TMN account, even not in favorites??
Joining via tmtp://# link just returns "Server connection failed".

For TMF accounts nothing has changed. Seeing it in the public server lists works, favorite works, tmtp-join works.
Restarting the server doesn't help either.

Someone got an idea?

Re: [ERROR] ManiaLive1 r267 and SQlite

Posted: 04 Aug 2012, 19:44
by Cayseth
Anyone? I'm happy about every input.

EDIT: It's working now with an old version of ManiaLive.

Re: [ERROR] ManiaLive1 r267 and SQlite

Posted: 04 Sep 2012, 23:45
by TheBigG.
i have the same problem which version did you choose?

Re: [ERROR] ManiaLive1 r267 and SQlite

Posted: 06 Sep 2012, 13:31
by TheBigG.
ok so i have to remove manialive from every server