Ahh, I'm not very familiar with php, should have looked into the
effects of the '@' symbol. Once removing the symbols, running via CLI,
it fails with;
'Call to undefined function: sqlite_open()'
whereas, running via apache, it fails with;
'Call to undefined function: sqlite_query()'
I have sqlite and sqlite_php installed and enabled in php.ini (there's
an entry under phpinfo()).
Any ideas why it may be failing? Thanks again.
On 10/30/05, JeRRy <jusa_98@xxxxxxxxx> wrote:
>
> Hi,
>
>
>
> Errors are more than likely not being produced because of the '@' symbol. Try removing this and see how you go. Also check your code for syntax errors. These will be produced within the errors.
>
>
>
> J
>
>
>
> ---------------------------------------------start of message-------------------------------------------
>
>
> Hello, I have the following very basic sqlite test harness:<?php $dbconn = @sqlite_open('testdb'); if ($dbconn) { @sqlite_query($dbconn, "CREATE TABLE test_table (test_id INT);"); @sqlite_query($dbconn, "INSERT INTO test_table VALUES (100)"); $result = @sqlite_query($dbconn, "SELECT test_id FROM test_table"); var_dump(@sqlite_fetch_array($result, SQLITE_ASSOC)); } else { print "Connection to database failed!\n"; }?>When running via CLI the script goes into 'sqlite_open', but nevercomes out, i.e. none of the rest of the code is hit. When running viaapache and mod_php, it gets out of 'sqlite_open' with a validconnection but never comes out of the first 'sqlite_query' call.It does this without any errors or warnings. The database file ispresent with correct permissions. I'm running a standard php install.I am using: php 4.4.0 sqlite 3.2.7 sqlite-php 0.0.5Any ideas where things are going wrong? Or perhaps tips on improvingdebug output. Any help would be
> appreciated,Eoin.
>
> ------------------------end of message-------------------
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Find a local business fast with Yahoo! Local Search
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
