Page 1 of 1

Ubuntu & sqlite3 installation error

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

Re: installation error on linux & winxp

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

Re: Ubuntu & sqlite3 installation error

Posted: Fri Nov 30, 2012 9:07 am
by Thorsten
Hi,

which database server type did you choose?

bye
Thorsten

Re: Ubuntu & sqlite3 installation error

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

Re: Ubuntu & sqlite3 installation error

Posted: Tue Dec 04, 2012 8:40 am
by Thorsten
Hi,

do you use the latest phpMyFAQ 2.7.9 version?

bye
Thorsten

Re: Ubuntu & sqlite3 installation error

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

Re: Ubuntu & sqlite3 installation error

Posted: Tue Dec 04, 2012 7:47 pm
by Thorsten
Hi,

I'll check it.

bye
Thorsten

Re: Ubuntu & sqlite3 installation error

Posted: Thu Dec 06, 2012 7:14 pm
by tqlam
Never mind, I have it work with mysql database.

Thanks!

Re: Ubuntu & sqlite3 installation error

Posted: Thu Dec 06, 2012 8:22 pm
by Thorsten
Hi,

okay, but I'll check it!

bye
Thorsten