Topics Module Not Working After Server Change.

Theme Guru Joined: Nov 01, 2003 Posts: 1006

Hello,

Today I relocated a client's website from one server to another. She currently has a nuke 7.0 website. I will be upgrading her to RN in a few days however, I need this issue sorted sooner.

The topics module does not work after the move. It did prior to the change.

The module only shows this text, currently.

Code:

...There aren't any news yet for this topic...

It does not work at all.

Any suggestions would be much appreciated.

Error reporting is on and no errors are revealed.

Thank you in advance. Razz

registered · Posted: Wed Jan 28, 2009 10:32 pm

Pretty sure its the issue with MySQL and usage of "reads" in the SQL statement.
If you quote it in single quotes, so MySQL uses it as a string, (or just change the name) it should be fine.

Posted: Wed Jan 28, 2009 11:00 pm

Not to sound dense, but where exactly would I make this change? Which table in the database? I do not see "reads" anywhere offhand. Thank you again.

I noticed in the index.php for this there are references to "read" such as

Code:

$sql = "SELECT t.topicid, t.topicimage, t.topictext, count(s.sid) AS stories, SUM(s.counter) AS reads FROM ".$prefix."_topics t LEFT JOIN ".$prefix."_stories s ON (s.topic = t.topicid) GROUP BY t.topicid, t.topicimage, t.topictext ORDER BY t.topictext";


$result = $db->sql_query($sql);

Do you know why it would have worked on the old server and not the new one? What could have changed in the module in that short time?

registered · Posted: Fri Jan 30, 2009 6:41 am

Try this:

Code:




$sql = "SELECT t.topicid, t.topicimage, t.topictext, count(s.sid) AS stories, SUM(s.counter) AS 'reads' FROM ".$prefix."_topics t LEFT JOIN ".$prefix."_stories s ON (s.topic = t.topicid) GROUP BY t.topicid, t.topicimage, t.topictext ORDER BY t.topictext";


$result = $db->sql_query($sql);

"reads" is right before the FROM...

Posted: Fri Jan 30, 2009 6:43 am

Oh, and the issue is most likely just a different MySQL version and/or configuration. (Sorry, didn't have time to look it up, but certain it is related just to that.)

Posted: Fri Jan 30, 2009 6:48 am

Thank you, Montego. That fixed it.