Help with PHP, MySQL and Apache in Ubuntu 10.04

[Paul King]

Done. Thanks. I would suppose that means I'm getting warm, but I am
still being served a blank page, and the error in the log is the same as
already mentioned below.

But I guess sqlite still needed to be installed, so thanks for asking
about the obvious.

On Sun, 2010-09-12 at 19:54 -0400, Tyler Aviss wrote:
> Maybe you need the php SQLite packages?
> 
> apt-get install php-mdb2-driver-sqlite php5-sqlite
> 
> On Sun, Sep 12, 2010 at 6:12 PM, Paul King <sciguy-Ja3L+HSX0kI at public.gmane.org> wrote:
> > Hello
> >
> > I recently purchased (donationware) a web app (ThemeFrame) written in
> > PHP that makes use of MySQL. It is supposed to run locally, on a local
> > web server (localhost is OK, apparently).
> >
> > To make this work, it appeared that I needed to install PHP, mySQL, and
> > Apache to some degree beyond their default packages.
> >
> > I wrote a little script that gave me phpinfo() and it tells me what I've
> > installed, from PHP's point of view:
> >
> > I am running Debian on a 64-bit processor (SMP) with 2GB RAM
> > Apache 2.2.14
> > PHP 5.3.2
> > I am viewing this on Firefox 3.6.9
> >
> > The problem is that, in the ThemeFrame installation instead of a kickass
> > AJAX app, I get a blank screen. The online help at the BytesForAll
> > website is a tad slow (it appears developers double as the tech
> > support). I don't think it's the source code. I think the problem is in
> > my configuration of apache/php/mysql, which was pretty much done "out of
> > the box".
> >
> > Here is the only error reported by the apache error log:
> >        [Sun Sep 12 17:40:43 2010] [error] [client ::1] PHP Fatal error:
> >        Class 'SQLiteDatabase' not found
> >        in /var/www/themeframe/functions.php on line 20
> >
> > By the code, it seems like it is attempting to make a database, then
> > creating a table for data. If it fails, it dies. By my reckoning, it
> > failed and it died, but not on that line. Here is the source code around
> > that area:
> >
> >
> >        // Check if DB "thfrdb" exists, else create it or display error
> >        if ($db = new SQLiteDatabase(dirname(__FILE__) .
> >        '/sqlite/thfrdb')) {
> >                // if table "default" does not exist, create it
> >                if (sqlite_table_exists($db, 'newdefault') === FALSE) {
> >                        // Create table
> >                        $db->queryExec('CREATE TABLE newdefault (id int,
> >        option_name TEXT, option_value TEXT, PRIMARY KEY (id))');
> >                }
> >        } else {
> >                die($err);
> >        }
> >
> > It fails on the first line, just after the comment. Commenting out the
> > "die" statement still results in the same error. So, it fails on object
> > creation, as the error suggests. Also, the sqlite directory is
> > world-writeable.
> >
> > Any suggestions?
> >
> > Paul King
> >
> > --
> > The Toronto Linux Users Group.      Meetings: http://gtalug.org/
> > TLUG requests: Linux topics, No HTML, wrap text below 80 columns
> > How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists
> >
> 
> 
> 


--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists