Quote:
Originally Posted by Bill from Cleve
I'm getting the same error. My guest views are turned on and a reinstall / fresh upload didn't help. Any Ideas what we are doing wrong? I'm using Mysql 5.1.30
|
Change networkforum.php:
from:
Code:
$forumsnodes = $db->query("
SELECT * FROM " . TABLE_PREFIX . "network_sub
LEFT JOIN network_node
ON (network_sub.node_code = network_node.node_code)
AND (network_sub.networkid = network_node.networkid)
WHERE (network_sub.networkid = ".$network['networkid'].") AND (subid = ".$forum['subid'].")
ORDER BY network_sub.node_code
");
change to:
Code:
$forumsnodes = $db->query("
SELECT * FROM " . TABLE_PREFIX . "network_sub
LEFT JOIN " . TABLE_PREFIX . "network_node
ON (" . TABLE_PREFIX . "network_sub.node_code = " . TABLE_PREFIX . "network_node.node_code)
AND (" . TABLE_PREFIX . "network_sub.networkid = " . TABLE_PREFIX . "network_node.networkid)
WHERE (" . TABLE_PREFIX . "network_sub.networkid = ".$network['networkid'].") AND (subid = ".$forum['subid'].")
ORDER BY " . TABLE_PREFIX . "network_sub.node_code
");