Search options

I use Gvim for most things and nano for small textfiles.

I like it simple.

It's a great forum. I love it.

The error is the lack of prefix in col-names.

Ok, I'll try to explain this...

Example SQL: SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name FROM  '.$db->prefix.'categories AS c LEFT JOIN '.$db->prefix.'forums AS f ON c..id=f.cat_id ORDER BY c.disp_position, c.id, f.disp_position'

This will load for example cat_name from the table category into c.cat_name. In the code the prefix 'c.' is missing. This doesn't work in SQLite! Atleast not in the new version.

You can either add 'AS cat_name' to the SQL or replace 'cat_name' with c.cat_name' in the code.

It's not my server. It's not my forum actually. I'm just admin there.

Anyway, someone I know managed to find the PunBB++ code somewhere. It supports SQLite.

Ok, I'll continue to work on the mod. If you release it then I would probably only use it to get some hints on how to use SQLite anyway.

I wish there was a SQLite mod available..

Hmm..

I don't have a reason other than that the forum I'm replacing have been down too long already.

Oh well, I can try to mod the durrent release to SQLite..

The only way is to hide the post count. That's what I did on the forum I'm running. A lot of the spammers just left the forum then.

Why can't you just release the old version of PunBB++? There are a lot of forums that is running it currently and I can't see why it shouldn't be able for download.

I just need the SQLite support..  -_-