Re: PHP questions

From: Date: Wed, 06 Mar 2019 17:58:27 +0000
Subject: Re: PHP questions
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-326736@lists.php.net to get a copy of this message
On Wed, Mar 6, 2019 at 4:13 PM Tim Streater <tim@clothears.org.uk> wrote: > Hi, > > > I've got a couple of web sites with a hosting provider. One of them uses a > small amount of PHP to log those who choose to download an app from the > site (which I'm advertising on the site). That has all worked fine for some > years up until recently. But I have some code that started failing: > > > $dbh = new SQLite3 ('dlglobals'); > > $reg = $dbh->querySingle ('select dlversion1, dlversion2 from globals', > true); > > if ($reg!==false) > > { > > $vsn1 = $reg['dlversion1']; // Should execute this > > $vsn2 = $reg['dlversion2']; > > } > > else { > > $savc = $dbh->lastErrorCode (); // but comes here instead > > $savm = $dbh->lastErrorMsg (); > > $reg = $dbh->querySingle ('select sqlite_version() as vers', true); > > $vers = $reg['vers']; > > $str = ' (' . $vers . ' ' . phpversion() . ') ' . $savm . > ' (' . > $savc . ')' . "\n"; > > echo 'Downloading unavailable: ' . $str; > > } > > > Pretty innocuous, I'd have thought, but what I'm getting is: "Downloading > unavailable: (3.6.20 7.2.14) disk I/O error (10)" > > > I can SSH to the site and use the sqlite3 shell program to issue the same > SQL select as above and that works with no issues. So I don't think the > database is faulty, and I don't believe there are any real I/O errors. But > before I start hassling the hosting provider I have a couple of PHP related > questions. > > > This is a Linux hosting, which I assume is done using VMs somehow. In such > cases do I get my own entire private copy of the Linux install, or is > everything that would be common somehow mirrored with one copy therefore > shared between all hosted clients? > > > More particularly, would they be likely to be generating their own build > of PHP, i.e. compiling from sources? I ask this because although I'm > getting PHP 7.2.14, released in January 2019, the sqlite3 module is version > 3.6.20, released in November 2009. Current sqlite3 is 3.27.x or so. I've > confirmed this via phpinfo(). Is there any good reason for them to be using > such an old module? The sqlite3 shell I mention above is also 3.6.20. > > > Finally, you'll see above that I use $dbh->querySingle (...) which I > assume is still valid under PHP7. As fas as I can see it should be, since > the doc for SQLite3::querySingle mentions PHP7. > > > Comments and suggestions welcome. > > > > > -- > Cheers -- Tim > Disk Space is common issue for 'disk I/O error'. So check once if there is enough space on the disk. In linux, 'df -h' should help. Or check with hosting provider if there is enough disk space. -- <https://about.me/jigar?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=edit_panel&utm_content=thumb> Jigar Dhulla about.me/jigar <https://about.me/jigar?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=edit_panel&utm_content=thumb>

« previous php.general (#326736) next »