Sorting Product List pages by order popularity

[Cozmoz]

Btw, if I updated it, what will happen to modified files outside the template folder, is there any section I should refer to on this?

[Cozmoz]

has the "live" version been patched to work with/better with PHP 5.4 to remove the memory leak problem associated with the constant SID?

Hi, how would I go about checking this? Thanks!

[mc12345678]

Btw, if I updated it, what will happen to modified files outside the template folder, is there any section I should refer to on this?

Ot sure I follow this question. Updating the one file associated with the SID issue described is a core file issue, not a template driven issue.

To answer the other question posed above, the change is/would be made in the includes/functions/html_output.php file. If you search for defined('SID') the line returned includes a zen_not_null(SID) command and the next line has $sid = SID. In both cases replace SID with constant('SID') (don't modify the defined statement).

But this is something that has been identified as only necessary for PHP 5.4.x, so not sure that it will resolve your issue. :/

[mc12345678]

Looking into the specific erro esponse (should have done the first time around) the ero is related to a timeout of the mysql server (query taking too long) online suggestions indicate that indexing of some of the return results would help reduce the query time. Or increasing a timeout variable on the host may help. I haven't seen exactly which timeout variable/where it is in the setup in oder to help. :/

[Cozmoz]

Hi, McNumbers, I've had a chance to look again. The timeout was caused by me restarting mySQL, the server had a high level of traffic at the time and this problem has caused the server to crash in the past. I have tried running this script again, it never finished loading, the page just hangs. I'm at a loss at what might be causing this.

I've tried looking everywhere on the site where I can find $listing_sql but cannot find any conflicts and like I said previously, the code runs just fine on a fresh install. Short of moving modifications onto a fresh install I'm unsure as to how to go about further troubleshooting this.

[mc12345678]

When you say that. The page just hangs, is that to mean that basically get a white screen? A white. Screen generally will generate an error message in the logs folder (zc >= 1.5.1)

[Cozmoz]

When you say that. The page just hangs, is that to mean that basically get a white screen? A white. Screen generally will generate an error message in the logs folder (zc >= 1.5.1)

Yes, it's a white screen that doesn't seem to finish loading. It never generated an error but I'll try to give it a chance to time out. Thanks.

Will get back asap.