#1 2017-01-04 20:40:02

FabricioAraujo
Member
Registered: 2015-01-05
Posts: 8

Forums are semi-"empty"

I'm reading the forums and can access the first page of results normally, but when I go to the second,
third, fourth, etc pages it come empty. The page itself says "Forum is empty" under the "Topic" title of the title.

I made some tests:
* Work computer (Windows; Firefox 34.0)

  • Anonymous access: problem

  • Logged on: problem


* Smartphone (Android; through 3G/4G connection, Opera Browser 41.2.2246.111806)

  • Anonymous access: problem

  • Logged on: problem

Offline

#2 2017-01-04 20:54:42

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 13,490
Website

Re: Forums are semi-"empty"

We changed the server, updated the forum engine, and changed also the storage engine...
This is a bug...
I will investigate further...

Offline

#3 2017-01-04 20:58:59

FabricioAraujo
Member
Registered: 2015-01-05
Posts: 8

Re: Forums are semi-"empty"

We changed the server, updated the forum engine, and changed also the storage engine...
This is a bug...
I will investigate further...


Test with biggest sub-forums like "mORMot Framework", "PDF Engine", etc.

Thank you.

Last edited by FabricioAraujo (2017-01-04 21:02:13)

Offline

#4 2017-01-04 22:36:50

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 13,490
Website

Re: Forums are semi-"empty"

Should be OK now.

But the fix is not a perfect fix...

I will need to fork and send fixes to https://github.com/adaur/fluxbb-sqlite3

Offline

#5 2017-01-04 22:40:12

FabricioAraujo
Member
Registered: 2015-01-05
Posts: 8

Re: Forums are semi-"empty"

ab wrote:

Should be OK now.

But the fix is not a perfect fix...

I will need to fork and send fixes to https://github.com/adaur/fluxbb-sqlite3

It's ok now.

Offline

#6 2017-01-04 23:18:40

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 13,490
Website

Re: Forums are semi-"empty"

I've fixed the following function as such:

	function num_rows($query_id = 0)
	{
		if ($query_id && preg_match ('/\bSELECT\b/i', $this->last_query))
		{
			$res = 0;
			while ($query_id->fetchArray(SQLITE3_NUM))
				++$res;

			$query_id->reset();
			
			return $res;
			
		}
		else
			return false;
	}

Even if it may be sub-optimal, it is working as expected.
It should have fixed other issues in the forum.

Don't hesitate to report back here any problem you encounter...
Thanks for your feedback!

Offline

Board footer

Powered by FluxBB