Ver 2.0.4 Hospital and Jail Always Display 0

[Dodger]

I'm looking for someone to help me fix an issue with my hospital and jail both always showing 0 players whether empty or not. Paying by paypal. Thanks

[Uridium]

I'll have a quick look at my copy and make a fix...

[Mystical]

I'm looking for someone to help me fix an issue with my hospital and jail both always showing 0 players whether empty or not. Paying by paypal. Thanks

I had the same problem. I finally figured out that the crons needed to be running to show the people in the jail or hospital. Are your crons running?

[rulerofzu]

Yeah the cron needs to be running. IDK what made them think that was a good idea but my suggestion would be to remove it

[Dabomstew]

Every v2 release has had the crons update hospital/jail count since otherwise it wasted 2 queries every page. Making sure they're on will solve any such problem

[Dodger]

Thanks for the info all, the minute cron isnt running properly. I'm on a paid host that allows 1 minute crons

[rulerofzu]

Every v2 release has had the crons update hospital/jail count since otherwise it wasted 2 queries every page. Making sure they're on will solve any such problem

No it wouldnt if you did it correctly.

[Dabomstew]

No it wouldnt if you did it correctly.

Do elaborate if you wish here or in a PM; i see a way to make it 1 query per pageload for the both but no more efficient than that without *some* form of cache, or updating a count every time someone enters/leaves one of the two.

[HauntedDawg]

Use, query caching.

http://devzone.zend.com/171/sql-query-caching/

[Dabomstew]

That has the same shortfalls as caching it any other way in V2 since we load settings either way. But it is interesting for other purposes.

[HauntedDawg]

I don't think you understand the concept of "Caching".

Also, if your game has 1000 active user's, theres no need for a number to be displayed in any case. As you'll always know there WILL be some one in the hospital or jail. To me, having a counter next to the jail or hospital is for small games.

[Dodger]

My 1 minute cron isn't running, when I manually run it I get this error message on the page

Critical Error

A critical error has occurred, and this page cannot be displayed. Please try again later.

Query failed.

Any help would be much appreciated

[Dabomstew]

The v2.0.4 cron_minute file has a small bug in it causing this issue.

It will be fixed in a future patch but here's the immediate fix:

Open the file, and replace every time it has GREATER (there should be 2) with GREATEST.

Save and it should work.

[Dodger]

Thanks that did the trick