No topic images after upgrading 7.7 to 7.9

Nuke Cadet Joined: Feb 19, 2004 Posts: 3

I just upgraded PHPNuke from 7.7 to 7.9 Patched version.
Now my Topic images are shown as red crosses in the main (news) page. When I right click on it, it only shows a filepath (the right one) but no image name.
When I want to edit a topic and choose an image, I can't choose one from the drop-down list, because it is empty. In the edit-screen of the topic the right image is shown.
I edited the path in config.php, but it was the right path. When I browse to the full path of the image (inclusive an imagename.gif) an image is shown..
I also added the IMG-tag to the config.php but that doesn't seem to happen..

Anyone else ideas?

Site Admin Joined: Aug 17, 2003 Posts: 12397

I cannot seem to duplicate this problem. Is the topic image path in your config.php correct?

Nuke Cadet Joined: Feb 19, 2004 Posts: 3

Yes it is. It's the standard path to images/topics where the topic images are.
When opening the properties of the "red crosses" in the main-page, it show the path to images/topics , but no filename in it. I don't know if this can help you determine the problem...
I couldn't also choose a new topic image from the dropdown list.

Nuke Cadet Joined: Feb 19, 2004 Posts: 3

Found the answer on nukeresources.com:

In the mainfile.php replace the GetTopics function:

Code:

function getTopics($s_sid) {
global $topicname, $topicimage, $topictext, $prefix, $db;
$sid = intval($s_sid);
$query = $db->sql_query("SELECT topic FROM ".$prefix."_stories WHERE sid='$sid'");
list($rtopic) = $db->sql_fetchrow($query);
$result2 = $db->sql_query("SELECT topicid, topicname, topicimage, topictext FROM ".$prefix."_topics WHERE topicid='$rtopic'");
list($topicid, $topicname, $topicimage, $topictext) = $db->sql_fetchrow($result2);
$topicid = intval($topicid);
$topicname = filter($topicname, "nohtml");
$topicimage = filter($topicimage, "nohtml");
$topictext = filter($topictext, "nohtml");

Nuke Cadet Joined: May 10, 2005 Posts: 6

thx for the reply, great fix.

Nuke Cadet Joined: Nov 04, 2003 Posts: 3

I had the exact same problem, $topicimage didn't get set, that's the reason the "image" source would show only a path and not the filename Embarassed

Anyways, this fixed the problem for me too, thanks for the reply jeesee Smile