Loading...
 
Features / Usability

Features / Usability


TikiWiki bug crashed the server

posts: 60

Hi!

I am running tikiwiki 1.8.4 on server of hostrocket.com.
When I went to Admin->Modules and activated the module:
forums_last_post
(not forums_last_topic but forums_last_post)

TikiWiki started producing ultra-high server load and the server crashed. It took the admins of hostrocket almost 24 hours to see that this was the problem.

So, is there a way to modify something in the code to fix the bug so i can use this module?

Thanks!

posts: 2881 United Kingdom

Hi,

Also Image Galleries->Rebuild Thumbnails can spiral the server into a fatal crash.

Damian


posts: 60

Wonderful :-)

So, can the forums_last_posts thing be fixed, anyway?

posts: 2881 United Kingdom

Taken from the TikiFriendlyHosts page:

''Host Rocketexternal link is a US based web host that I've been very happy with pretty much across the board: price, available services, and very responsive tech support. I've setup several installs of TikiWiki without any troubles, all running swimmingly with moderate use.
PHP memory_limit here is set to 10Mb. It should be enough for some installations. Although you may experience problems with Image and File galleries, and Tikis with lots of content.''

10Mb is borderline. It could be memory_limit related especially as TW forums are just overgrown comments code and not the best in the world.

Looking at the code there is no strangeness happening in that module and it works fine on a duplicate of tw.o database on my workstation.

Damian


posts: 1092

The sql query is not the best
select * from `tiki_comments`,`tiki_forums` where `object`=`forumId` and `objectType` = 'forum' order by `commentDate` desc

Perhaps this needs to be replaced by a left join


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting