Update : please disregard the first paragraph of my reply above. Using http://www.bluesmaster.nl/hello.php *does* show the expected result. I now realise I forgot to include the .php extension and now the info.php works as expected : http://bluesmaster.nl/info.php
I deeply apologise for having made such a mess of my reporting this issue : it shows my stupidity to the fullest. Back to you, I hope ... On Oct 7, 1:49 pm, Scorpion <[email protected]> wrote: > I've uploaded your hello.php to my public_html folder : it will not > load, let alone show the expected result. Exactly the same as with me > trying to access bluesmaster.nl : the browser says it's busy > contacting the domain but nothing eventually happens. Updated my still > open support ticket with this result and asked for an explanation. > > Couldn't open my habari.db with terminal on the server (likely a > password should've been included somewhere ?) FYI : I'm not very > comfortable with terminal use (being a Mac OS X aficionado). So I've > downloaded habari.db via FTP and now accessed the file on my desktop > successfully: the answer was 'normal', but I'm afraid that doesn't say > much about the file on the remote server ? BTW, would deleting > habari.db on the server and replacing it with the copy on my desktop > be essentially the same as the result of the terminal session : > -quote- > $ sqlite3 /path/to/habari/user/habari.db > sqlite> .backup main habari.db.bak > sqlite> .exit > $ mv /path/to/habari/user/habari.db /path/to/habari/user/ > habari.db.old > $ mv /path/to/habari/user/habari.db.bak /path/to/habari/user/habari.db > -unquote- > > On Oct 7, 7:02 am, Colin <[email protected]> wrote: > > > > > > > > > The fact you can't even view a simple php file tells me there could be > > something wrong with your hosting configuration. > > > You could try make it even simpler and try creating a test file with the > > contents: > > > <?php echo "Hello"; ?> > > > If you don't see the word Hello when you view the page, it means your > > hosting is not configured correctly for PHP and your provider needs to look > > into it. Alternatively, you could have made a mistake and there was an > > error which should have been written to the error log. > > > As for the habari.db-journal file: this file is normal, however it should be > > deleted at the end of every transaction by default. If it isn't, it means > > some other application (not Habari) has probably enabled exclusive locking > > mode on this DB. > > > This could also explain the lock errors you get in the error log. > > > You can check if this is the case as follows: > > > $ sqlite3 /path/to/habari/user/habari.db > > sqlite> PRAGMA locking_mode; > > > If this returns "exclusive" then you can change this to normal using: > > > sqlite> PRAGMA locking_mode=NORMAL; > > > This should hopefully remove the exclusive locking on the DB file. > > > More details on the -journal file and exclusive locking can be found > > athttp://www.sqlite.org/tempfiles.html > > > HTH > > Colin > > > On Thu, Oct 6, 2011 at 7:29 PM, Scorpion <[email protected]> wrote: > > > Forgot to mention : in my public_html folder is an unknown file called > > > *habari.db-journal*, size 0 bytes, last modified sometime earlier > > > today ... I'm clueless. > > > > On Oct 6, 2:50 pm, Colin <[email protected]> wrote: > > > > It concerns me that you "can't view" a file because it has a .php > > > > extension. What exactly happens when you try to view the phpinfo.php I > > > > suggested? Do you just get a blank screen or are you prompted to > > > download > > > > the file? (It may download automatically in the background if your > > > browser > > > > is configured to do this). > > > > > If it does, then this would be a server config error. Of course your > > > > web > > > > server config could also be configured as such to not allow the use of > > > this > > > > extension whilst still allowing the use of PHP. > > > > > As for the... > > > > > [Thu Oct 06 10:19:26 2011] [error] [client 178.21.118.100] PHP Warning: > > > > PDOStatement::execute() [<a > > > > href='pdostatement.execute'>pdostatement.execute</a>]: SQLSTATE[HY000]: > > > > General error: 5 database is locked in /home/sites/ > > > > bluesmaster.nl/public_html/system/classes/databaseconnection.php on line > > > 271 > > > > > ... errors. I'm guessing you may be using Sqlite for the backend DB. > > > > If > > > > this is the case, your DB has a lock which needs removing. At a guess, > > > you > > > > may find you already have a process open locking the database in this > > > file, > > > > or the last process to access the DB failed to remove the lock when it > > > > exited. > > > > > You should be able to clear the lock by doing the following: > > > > > $ sqlite3 /path/to/habari/user/habari.db > > > > sqlite> .backup main habari.db.bak > > > > sqlite> .exit > > > > $ mv /path/to/habari/user/habari.db /path/to/habari/user/habari.db.old > > > > $ mv /path/to/habari/user/habari.db.bak /path/to/habari/user/habari.db > > > > > This should remove the lock on the DB and should resolve the above > > > errors. > > > > > HTH > > > > > On Thu, Oct 6, 2011 at 1:35 PM, Scorpion <[email protected]> wrote: > > > > > Update : I've just viewed my support ticket status and my hosting > > > > > provider states that no changes whatsoever to their server software > > > > > was made. > > > > > > On Oct 6, 2:23 pm, Scorpion <[email protected]> wrote: > > > > > > Forgot to mention in previous post : I've uploaded the <?php > > > > > > phpinfo(); ?> file via FTP : I can't access it, likely due to the > > > .php > > > > > > file extension, but I think the module list I've uploaded earlier > > > > > > ( see original post above) should provide all this info. > > > > > > > On Oct 6, 1:58 pm, Colin <[email protected]> wrote: > > > > > > > > Sounds like your hosting provider has changed something. I'd ask > > > them > > > > > for > > > > > > > details of any changes and maintenance made to your hosting env > > > > > recently. > > > > > > > They should know what they've changed. > > > > > > > > A simple test worth trying is to place the following in a file, eg > > > > > > > phpinfo.php... > > > > > > > > <?php phpinfo(); ?> > > > > > > > > ... and see if you can view the contents. > > > > > > > > If you can't, then something is seriously wrong with your hosting, > > > > > specific > > > > > > > to PHP, which you hosting provider will need to resolve. > > > > > > > > HTH > > > > > > > > On Thu, Oct 6, 2011 at 11:24 AM, Scorpion <[email protected]> > > > > > wrote: > > > > > > > > I've been using Habari forhttp://www.bluesmaster.nl/froalmost3 > > > > > > > > years now, but - suddenly & inexplicably - I can no longer > > > > > > > > access > > > my > > > > > > > > blog with a browser. For several months I've been running 0.7.1 > > > and > > > > > my > > > > > > > > most recent post was on September 24th ( > > > > > >http://webcache.googleusercontent.com/search?q=cache:dMGoKgAbdDcJ:www. > > > .. > > > > > > > > ) > > > > > > > > > Now all my browser(s) show is an attempt to 'contact > > > bluesmaster.nl > > > > > '. > > > > > > > > The domain is still alive & kicking, as a test page from my > > > hosting > > > > > > > > provider shows > > > > > > > > :http://www.bluesmaster.nl/test/(pleasenotethefile > > > > > > > > has the .html extension, changing this to .php fails to load it) > > > > > > > > > I've filed a support ticket with my hosting provider, but no > > > > > > > > explanation for this most annoying problem has been forthcoming > > > > > since. > > > > > > > > FYI, I've not touched any Habari files since the 0.7.1 upgrade > > > > > several > > > > > > > > months ago, only posted. All required files are still present (I > > > can > > > > > > > > still reach them via FTP, accessible for my IP address only) and > > > none > > > > > > > > show 'suspicious' dates. > > > > > > > > > AFAICS, all required PHP modules are still present, a text file > > > > > > > > listing all PHP 5 modules present on the server of my hosting > > > > > provider > > > > > > > > is available here :http://www.mediafire.com/?w3kbxupq364u43x > > > > > > > > > Any thoughts ? I'd hate to change hosting providers or to leave > > > > > > > > Habari. But since I just like to keep blogging I'm currently > > > > > > > > contemplating a static blog generator ( e.g. jekyll, > > > > > > > > blazeblogger > > > > > > > > etc. ) and have my hosting provider serve plain html files. > > > > > > > > > -- > > > > > > > > To post to this group, send email to > > > [email protected] > > > > > > > > To unsubscribe from this group, send email to > > > > > > > > [email protected] > > > > > > > > For more options, visit this group at > > > > > > > >http://groups.google.com/group/habari-users > > > > > > > > -- > > > > > > > Colin Seymour > > > > > > > Blog:http://colinseymour.co.uk > > > > > > > Tech Stuff:http://lildude.co.uk > > > > > > > Barefoot Running:http://barefootrunner.co.uk > > > > > > > IRC: lildude #habari > > > > > > -- > > > > > To post to this group, send email to [email protected] > > > > > To unsubscribe from this group, send email to > > > > > [email protected] > > > > > For more options, visit this group at > > > > >http://groups.google.com/group/habari-users > > > > > -- > > > > Colin Seymour > > > > Blog:http://colinseymour.co.uk > > > > Tech Stuff:http://lildude.co.uk > > > > Barefoot Running:http://barefootrunner.co.uk > > > > IRC: lildude #habari > > > > -- > > > To post to this group, send email to [email protected] > > > To unsubscribe from this group, send email to > > > [email protected] > > > For more options, visit this group at > > >http://groups.google.com/group/habari-users > > > -- > > Colin Seymour > > Blog:http://colinseymour.co.uk > > Tech Stuff:http://lildude.co.uk > > Barefoot Running:http://barefootrunner.co.uk > > IRC: lildude #habari -- To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/habari-users
