FUDforum: Bug Reports » sqlite support not working at all.

Home » FUDforum Development » Bug Reports » sqlite support not working at all.

Show: Today's Messages :: Polls :: Message Navigator

sqlite support not working at all. [message #33165]

Tue, 15 August 2006 02:24

judas_iscariote

Messages: 17
Registered: March 2006

Karma: 0

Junior Member

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: Tue, 15 August 2006 02: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 13:45

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

Report message to a moderator

Re: sqlite support not working at all. [message #33176 is a reply to message #33165]

Tue, 15 August 2006 21:11

judas_iscariote

Messages: 17
Registered: March 2006

Karma: 0

Junior Member

Hi Ilia

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

Attachment: fud.png
(Size: 66.72KB, Downloaded 912 times)
Attachment: trace.2043925204.txt
(Size: 34.68KB, Downloaded 946 times)

Report message to a moderator

Re: sqlite support not working at all. [message #33183 is a reply to message #33176]

Wed, 16 August 2006 13:35

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

Report message to a moderator

Re: sqlite support not working at all. [message #33189 is a reply to message #33183]

Wed, 16 August 2006 17:52

judas_iscariote

Messages: 17
Registered: March 2006

Karma: 0

Junior Member

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

Report message to a moderator

Re: sqlite support not working at all. [message #33208 is a reply to message #33189]

Thu, 17 August 2006 13:36

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

Report message to a moderator