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 at http://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
