FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » sqlite support not working at all.
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
sqlite support not working at all. [message #33165] Mon, 14 August 2006 22:24 Go to next message
judas_iscariote is currently offline  judas_iscariote   Chile
Messages: 17
Registered: March 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hi:

If you do a clean install of current CVS or stable release, using the pdo_sqlite driver install goes fine but after install it doesn't seem to work at all.

categories are not displayed in the main page, nor the testing forums, nor forums you added manually.

No errors, no warnings. nothing Crying or Very Sad

I should have reported this issues before http://fudforum.org/forum/index.php?t=msg&th=6786&start=0& but havent' found time until now to play with FUD Razz


Im using current PHP 5_2 CVS but i tested it with previuos versions too...

[Updated on: Mon, 14 August 2006 22:26]

Report message to a moderator

Re: sqlite support not working at all. [message #33171 is a reply to message #33165] Tue, 15 August 2006 09:45 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
I've just installed FUDforum 2.7.6RC1 against PHP 5.2.0 cvs with pdo_sqlite and it works fine for me. Check your apache and php error logs, perhaps PHP is crashing?

FUDforum Core Developer
Re: sqlite support not working at all. [message #33176 is a reply to message #33165] Tue, 15 August 2006 17:11 Go to previous messageGo to next message
judas_iscariote is currently offline  judas_iscariote   Chile
Messages: 17
Registered: March 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hi Ilia Wink

1.No, PHP is not crashing.
2. it works just fine with mysql

attached screenshot and xdebug trace file.

it is just a default,clean installation

system info :

OS: linux , 64 bit
apache 2.2
PHP 5.2.0RC2-dev (built: Aug 14 2006 01:21:49) ( I got the same results with 5.1.4)

is there any kind of FUDdebug mode ? Rolling Eyes

Re: sqlite support not working at all. [message #33183 is a reply to message #33176] Wed, 16 August 2006 09:35 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
hrm... don't know what to tell you aside from the fact my sample SQLite install works just fine on PHP 5.2.0-cvs. Xdebug backtrace seems to indicate that all the queries are running without fail.

Are there any entries inside the fud26_forum table? Have you tried running the consistency checker?


FUDforum Core Developer
Re: sqlite support not working at all. [message #33189 is a reply to message #33183] Wed, 16 August 2006 13:52 Go to previous messageGo to next message
judas_iscariote is currently offline  judas_iscariote   Chile
Messages: 17
Registered: March 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Ilia wrote on Wed, 16 August 2006 09:35


Are there any entries inside the fud26_forum table?


sqlite> select * from fud26_forum;
1|1|TestForum||||1155607245|0|0|0|1|1024|1||0|16
2|2|foobar 2|cdcd|||1155607529|0|0|0|1|4096|1||0|16

Shocked
Quote:


Have you tried running the consistency checker?



Yes, no luck Sad

Im not familiar with the FUD source, can you give me some pointer abaout where I start looking ? Confused
Re: sqlite support not working at all. [message #33208 is a reply to message #33189] Thu, 17 August 2006 09:36 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
You may want to check that the cat_cache.inc and idx.inc files are present inside the cache directory and are not empty. Also make sure you have at least one entry inside the category table.

FUDforum Core Developer
Re: sqlite support not working at all. [message #33213 is a reply to message #33165] Thu, 17 August 2006 20:44 Go to previous messageGo to next message
judas_iscariote is currently offline  judas_iscariote   Chile
Messages: 17
Registered: March 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Ilia :

Geez, I updated to php 5.2.0RC2 and all is working fine. Shocked Rolling Eyes
Re: sqlite support not working at all. [message #33214 is a reply to message #33213] Fri, 18 August 2006 09:37 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
That's good to hear Wink I guess the new sqlite version helps

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Subject only search doesn't find after split
Next Topic: Enable PATH_INFO, some links not worked
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 29 14:48:55 EDT 2014

Total time taken to generate the page: 0.00700 seconds