Hardkap » Pritlog - Blogging made simple

Sqlite help

(12 posts)

Tags:

  1. Tommy
    Member

    Hi, i use Pritlog for my website.
    With the last update, there are no flat files more but you use Sqlite.
    I have uploaded all the files, but when i go to index.php i see nothing.
    When i got to update.php, i see this:

    'Your server does not seem to have Sqlite enabled. This version of Pritlog will not work without Sqlite.'

    I don't have Sqlite. How must I get Sqlite? Must i contact with my server, or can I install it?? Please, help...

    I really need Pritlog for my website, and I need really the last update...
    Much thanks!

    Tommy

    Posted 11 months ago #
  2. Prit
    Pritlogger

    Hi Tommy,

    Welcome to the forum. Can you please post the version of PHP your server is using? Usually, with PHP5, most installation will have Sqlite enabled by default.

    If your server is using PHP4 and you have an option to move to PHP5, then that would be the way to go.

    Posted 11 months ago #
  3. Tommy
    Member

    Hi Prit,

    I have checked it and I have PHP Version 5.2.9
    Strange...

    I also checked the website where my website is hosted.
    I found that register_globals and allow url fopen were Off.

    register_globals = Off
    allow_url_fopen = Off

    Is that the problem?

    I have checked the Php version with <?php phpinfo() ?>
    http://php.about.com/od/troubleshooting/qt/php_version.htm
    Can I give you that file, so you can see more?

    Much thanks,
    Tommy

    Posted 11 months ago #
  4. Prit
    Pritlogger

    Hi Tommy,

    I think it might be just the matter of talking to the webhosting company and ask them to enable Sqlite. They might have turned it off.

    It might help to see your phpinfo. Can you post it somewhere?

    Posted 11 months ago #
  5. Tommy
    Member

    Here you can see the phpinfo

    http://www.tukkies.nl/phptest.php

    Tomorrow i contact the webhosting company
    Much thanks,
    Tommy

    Posted 11 months ago #
  6. john
    Member

    Hi Prit and Tommy,

    Sorry for posting into your exchange, I just saw your php_info and it seems to me that your provided disabled sqlite 2 (which is normally part of PHP5) and enabled sqlite 3 (which uses an external driver)

    Configure Command shows: without-sqlite and with-pdo-sqlite=shared
    also PDO Driver for SQLite 3.x

    Pritlog uses sqlite 2 and doesn't work with sqlite 3
    I hope this helps.

    Posted 11 months ago #
  7. john
    Member

    Hi Prit and Tommy,

    Sorry for posting into your exchange, I just saw your php_info and it seems to me that your provided disabled sqlite 2 (which is normally part of PHP5) and enabled sqlite 3 (which uses an external driver)

    Configure Command shows: without-sqlite and with-pdo-sqlite=shared
    also PDO Driver for SQLite 3.x

    Pritlog uses sqlite 2 and doesn't work with sqlite 3
    I hope this helps.

    Posted 11 months ago #
  8. Prit
    Pritlogger

    Your webhost is using PDO_Sqlite and version 3 of Sqlite. I believe that, if it was the default Sqlite that goes along with PHP, there should be a separate section called Sqlite in your phpinfo. But there is no such section, instead there is a section for PDO_Sqlite.

    Let us know what your host says.

    Posted 11 months ago #
  9. Tommy
    Member

    Got a message back from my host.

    They say that sqlite version 3.3.13 is installed on the server.
    BUT they say that in PHP, sqlite is not activated.
    If more people ask for sqlite, then they want to activate it... :(

    Thanks for your help
    Tommy

    Posted 10 months ago #
  10. Prit
    Pritlogger

    Sorry Tommy. Currently Pritlog only works on Sqlite 2. The commands for these two versions are different. Hopefully, your host activates Sqlite 2.

    Posted 10 months ago #
  11. chill
    Member

    Tommy,

    I had the same problem too. I'm using Plesk Control Panel 8.6 (Parallels). I sent in a request to have Sqlite 2 activated and it was done in a short period of time and I now have Pritlog working. One of the problems I did initially have was that any changes in the admin I made, adding users or adding a post entry did not initially work. And, for the life of me, I couldn't understand why. Well, after looking through things, I found the file postdb.sqlite in the data subdirectory. This file is not in the zip file. I guess it is automatically created when you begin using Pritlog. Well, on my server its owner is Apache. So, I downloaded it to my computer, deleted the one on my server and then uploaded the postdb.sqlite on my computer (ascii) to the data subdirectory and now I can make changes in the admin, add users and post. Its owner is still apache, so I don't know what is happening here, but maybe Prit has an answer. By the way, I uploaded postdb.sqlite using Gossamer Threads File Manager.

    Chill

    Posted 9 months ago #
  12. Prit
    Pritlogger

    The only reason I can think of is the owner of the file. But since you verified that in both cases it was apache, I dont have a clue. If this happens on my servers, maybe I could do more analysis.

    Posted 9 months ago #

Important: If you want to be notified for any new post on this thread/topic, please go to your profile, activate favorite notification and then subscribe to this topic.


RSS feed for this topic

Reply

You must log in to post.