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 » Wed Nov 28, 2012 9:10 pm

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 » Thu Nov 29, 2012 6:25 pm

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: 14718
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Ubuntu & sqlite3 installation error

Post by Thorsten » Fri Nov 30, 2012 9:07 am

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 » Mon Dec 03, 2012 9:44 pm

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: 14718
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Ubuntu & sqlite3 installation error

Post by Thorsten » Tue Dec 04, 2012 8:40 am

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 » Tue Dec 04, 2012 4:36 pm

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: 14718
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Ubuntu & sqlite3 installation error

Post by Thorsten » Tue Dec 04, 2012 7:47 pm

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 » Thu Dec 06, 2012 7:14 pm

Never mind, I have it work with mysql database.

Thanks!

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

Re: Ubuntu & sqlite3 installation error

Post by Thorsten » Thu Dec 06, 2012 8:22 pm

Hi,

okay, but I'll check it!

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Post Reply