Hardkap » Topic: Sqlite help

Hardkap » Topic: Sqlite help http://hardkap.net/forums/topic/sqlite-help Macpup, Pritlog, Pritdeals discussion forums en-US Thu, 09 Feb 2012 08:23:18 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://hardkap.net/forums/search.php Prit on "Sqlite help" http://hardkap.net/forums/topic/sqlite-help#post-1006 Sun, 07 Jun 2009 10:11:40 +0000 Prit 1006@http://hardkap.net/forums/ 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. chill on "Sqlite help" http://hardkap.net/forums/topic/sqlite-help#post-1004 Sun, 07 Jun 2009 02:05:34 +0000 chill 1004@http://hardkap.net/forums/ 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 Prit on "Sqlite help" http://hardkap.net/forums/topic/sqlite-help#post-922 Fri, 17 Apr 2009 09:31:32 +0000 Prit 922@http://hardkap.net/forums/ Sorry Tommy. Currently Pritlog only works on Sqlite 2. The commands for these two versions are different. Hopefully, your host activates Sqlite 2. Tommy on "Sqlite help" http://hardkap.net/forums/topic/sqlite-help#post-920 Fri, 17 Apr 2009 07:15:22 +0000 Tommy 920@http://hardkap.net/forums/ 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 Prit on "Sqlite help" http://hardkap.net/forums/topic/sqlite-help#post-895 Mon, 13 Apr 2009 10:41:14 +0000 Prit 895@http://hardkap.net/forums/ 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. john on "Sqlite help" http://hardkap.net/forums/topic/sqlite-help#post-894 Mon, 13 Apr 2009 10:40:14 +0000 john 894@http://hardkap.net/forums/ 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. john on "Sqlite help" http://hardkap.net/forums/topic/sqlite-help#post-893 Mon, 13 Apr 2009 10:40:13 +0000 john 893@http://hardkap.net/forums/ 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. Tommy on "Sqlite help" http://hardkap.net/forums/topic/sqlite-help#post-892 Mon, 13 Apr 2009 09:48:55 +0000 Tommy 892@http://hardkap.net/forums/ Here you can see the phpinfo <a href="http://www.tukkies.nl/phptest.php" rel="nofollow">http://www.tukkies.nl/phptest.php</a> Tomorrow i contact the webhosting company Much thanks, Tommy Prit on "Sqlite help" http://hardkap.net/forums/topic/sqlite-help#post-890 Mon, 13 Apr 2009 09:19:03 +0000 Prit 890@http://hardkap.net/forums/ 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? Tommy on "Sqlite help" http://hardkap.net/forums/topic/sqlite-help#post-889 Mon, 13 Apr 2009 09:13:40 +0000 Tommy 889@http://hardkap.net/forums/ 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() ?> <a href="http://php.about.com/od/troubleshooting/qt/php_version.htm" rel="nofollow">http://php.about.com/od/troubleshooting/qt/php_version.htm</a> Can I give you that file, so you can see more? Much thanks, Tommy Prit on "Sqlite help" http://hardkap.net/forums/topic/sqlite-help#post-869 Fri, 10 Apr 2009 12:34:22 +0000 Prit 869@http://hardkap.net/forums/ 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. Tommy on "Sqlite help" http://hardkap.net/forums/topic/sqlite-help#post-867 Fri, 10 Apr 2009 12:25:29 +0000 Tommy 867@http://hardkap.net/forums/ 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