MyBB Community Forums

Hey,

I just installed a MyBB 1.4 Beta board on a site which is actually on 110mb.com

and as you know they don't allow free MySQL. So I used their SQLite and everything went and going smooth,

I just find one problem. When I try to browse :

online.php

I get this error ;

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1 - near "DISTINCT": syntax error
Query:
SELECT COUNT(DISTINCT sid) as online FROM mybb_sessions WHERE time > 1217280270

But When I visit : online.php?action=today

It works perfectly, As It is suppose to work

I don't think if it's the problem of Host, because everything works smoother other then this..

And I don't think if it's a Bug because this thing works on my Localhost!

So Please help me

Thanks alot

Badly waiting for answer

FAISAL~

confirmed

Which version SQLite are you running?

Thank you for your bug report.

This bug has been fixed in our internal code repository. Please note that the problem will not be fixed here until these forums are updated.

Well, I do use ; SQLite 2.8.17

And is this bug is fixed? I mean you have fixed this bug in your COPY that would be Beta 5? in future?

Thanks a lot
FAISAL~

---

And sorry TIKITIKI, I wrote that this works on on localhost, actually on Localhost I have installed MyBB 1.4(Beta 1) but using a MySQL not SQLite Sorry for that stupid mistake

FAISAL~

SQLite 2.8.17 <-- same for me