Ubuntu & sqlite3 installation error

All about webserver configurations, PHP and databases.

Moderator: Thorsten

Post Reply
tqlam
Posts: 5
Joined: Wed Nov 28, 2012 8:48 pm

Ubuntu & sqlite3 installation error

Post by tqlam »

Hello,

I am trying install phpMyFAQ onto the ubuntu webserver with sqlite3 database, and got the "error: invalid server error" no matter what I change in the setup form.
My other php web applications are working fine with sqlite3 database on the same server. Please let me know what are fixes to get phpMyFAQ install and run.

Thank you!


Below is my system information.

root@srcweb:/src/www/faq# sqlite3 -version
3.7.3
root@srcweb:/src/www/faq# php -version
PHP 5.3.3-7+squeeze14 with Suhosin-Patch (cli) (built: Aug 6 2012 14:18:06)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
with Suhosin v0.9.32.1, Copyright (c) 2007-2010, by SektionEins GmbH
root@srcweb:/src/www/faq#
tqlam
Posts: 5
Joined: Wed Nov 28, 2012 8:48 pm

Re: installation error on linux & winxp

Post by tqlam »

Hello,

I tried to install on Windows xp with apache2 server, and got the same error "invalid server type". Can someone here please help?


Thank you!
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Ubuntu & sqlite3 installation error

Post by Thorsten »

Hi,

which database server type did you choose?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
tqlam
Posts: 5
Joined: Wed Nov 28, 2012 8:48 pm

Re: Ubuntu & sqlite3 installation error

Post by tqlam »

Hello,

I choose "SQLite 3 (only PHP5.3+).

my PHP version 5.3.5 and sqlite version is 3.7.3 on both windows XP and Ubuntu machines.


Thanks,
Thanh
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Ubuntu & sqlite3 installation error

Post by Thorsten »

Hi,

do you use the latest phpMyFAQ 2.7.9 version?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
tqlam
Posts: 5
Joined: Wed Nov 28, 2012 8:48 pm

Re: Ubuntu & sqlite3 installation error

Post by tqlam »

Yes.

The cause is from the following codes in setup.php file, but I don't know how to fix it.

// check database entries
$sql_type = PMF_Filter::filterInput(INPUT_POST, 'sql_type', FILTER_SANITIZE_STRING);
if (!is_null($sql_type)) {
$sql_type = trim($sql_type);
if (file_exists(PMF_ROOT_DIR . '/install/' . $sql_type . '.sql.php')) {
require PMF_ROOT_DIR . '/install/' . $sql_type . '.sql.php';
} else {
print '<p class="error"><strong>Error:</strong> Invalid server type.</p>';
HTMLFooter();
die();
}

Thanks,
Thanh
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Ubuntu & sqlite3 installation error

Post by Thorsten »

Hi,

I'll check it.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
tqlam
Posts: 5
Joined: Wed Nov 28, 2012 8:48 pm

Re: Ubuntu & sqlite3 installation error

Post by tqlam »

Never mind, I have it work with mysql database.

Thanks!
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Ubuntu & sqlite3 installation error

Post by Thorsten »

Hi,

okay, but I'll check it!

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply