Problem with Links, No File Exists

[BugOnAWall]

Hi, I have just installed this news system on a sample page on my site to get it working. Well everything seems to be fine except the links.

For Example, when it shows, Read Full Story, and click on it, it shows No File Exists. Same on the comments. It shows the right amount of comments posted but when you click on it, takes you to Sorry, such file doesn't exist...

And the author names are not showing up.

The link to the sample news page is http://www.animegeek.net/testforumnews.php

If someone could show me what I am doing wrong I would highly appreciate it. Thanks so much.

[Patrick]

What version of the script are you using?

The links in your read more, comments, etc are all EP-Dev Forum News version 1.x link styles, but the current release is version 2.1.

Since version 2.0, the links go directly to the forum posts, author profiles, etc instead of the forum news script.

You should be using version 2.1. You can find it at http://www.ep-dev.com . Version 2.1 is far superior to previous versions. I suggest you upgrade immediately.

There is no upgrade available from version 1.x, you will simply have to copy over your settings.


You can find the new version at http://www.ep-dev.com/scripts-5.php

[BugOnAWall]

okay Ill try it thanks

[BugOnAWall]

Hmmmm okay now I have a new problem...

MYSQL ERROR: 1146 : Table 'animegeek.nuke_bbusers' doesn't exist QUERY: SELECT username FROM nuke_bbusers WHERE user_id='67'

My site is phpnuke and users in the database are under nuke_users not nuke_bbusers, is there a way I can fix this?

[Patrick]

What forum does PHP-Nuke use?

The script currently supports:
vBulletin
Invision Power Board
Web Burning Board
YaBB SE
Simple Machines Forum
phpBB


If you can tell me which forum PHP-Nuke uses I could tell you how to modify it.

[BugOnAWall]

phpbb, everything is prefixed for the forums with nuke_bb except users which is just nuke_

[Patrick]

Simple enough then.

Open classes/forums/phpBB_2.php

Find:

$this->DB->prefix . "users

Replace:

"nuke_users


You will of course have to change nuke_users in that file if you ever change the prefix for PHP-Nuke in the future.


Here is something unrelated, but rather some code that I used with PHP-Nuke 7.3 for a news module (not sure if it will work with your version). I put this code into a file named index.php in a folder called Forum_News that I placed in the modules folder in PHP-Nuke:

<?php


if (!eregi("modules.php", $_SERVER['PHP_SELF'])) {
die ("You can't access this file directly...");
}

require_once("mainfile.php");
$module_name = basename(dirname(__FILE__));

global $index;
$index = 1;

include("header.php");

// generated EP-Dev Forum News code
require_once("forum-news/news.php");
$forum_obj = new EP_Dev_Forum_News();
$forum_obj->display_News();

include("footer.php");

The above assumes the script is installed to /forum-news/ on your website.

You can load that module without any modification right into PHP-Nuke and it should pick it right up without any problems with the default forum news settings.

[BugOnAWall]

I replaced


$this->DB->prefix . "users

with


"nuke_users

but its still showing

MYSQL ERROR: 1146 : Table 'animegeek.nuke_bbusers' doesn't exist QUERY: SELECT user_avatar, user_avatar_type FROM nuke_bbusers WHERE user_id='67'



:unsure:

I have php nuke 6.5. If we can get this to work, I will try it to see if it works with the version of phpnuke I am using.

Oh and I want to thank you for all your help incase I forget to say thanks later!

[Patrick]

Nothing else calls the users. Everything that is related to the forum database is within that file.

There should have been three replacements made. On line 120, line 130, and line 214.

Can you confirm that all of these have been modified?

Also, don't for get to reupload the file ;)

[BugOnAWall]

Okay I only did it twice. Hehehe fixed the third one and uploaded. Everything is showing up but the links are still doing the same thing. Showing Sorry, such file doesn't exist...

for example the link will show up as

http://www.animegeek.net/modules.php?name=...opic.php?t=1167 (http://www.animegeek.net/forum-news/news.php?page=comments&nid=1167)

http://www.animegeek.net/modules.php?name=...opic.php?t=1167 (http://www.animegeek.net/modules.php?name=Forums/viewtopic.php?t=1167)

when the file should be reading the link as

http://www.animegeek.net/modules.php?name=...iewtopic&t=1167 (http://www.animegeek.net/modules.php?name=Forums&file=viewtopic&t=1167)

any clues on how to fix this problem? the link to the sample news page is

http://www.animegeek.net/testingforumnews.php

[Patrick]

It appears that PHP-Nuke has heavily modified phpBB.

You can correct the links by opening up the same file I told you to earlier (phpBB_2.php) and modifying the $this->LINKS['author'] and $this->LINKS['thread'] that appear near the top of the file in the manner of:


$this->LINKS['author'] = $this->CONF['url'] . "profile.php?mode=viewprofile&u=";
$this->LINKS['thread'] = $this->CONF['url'] . "viewtopic.php?t=";

If you modify those to reflect the format of PHP-Nuke's config, you should be good to go. For example:


$this->LINKS['author'] = $this->CONF['url'] . "modules.php?name=Forums&file=profile&mode=viewprofile&u=";
$this->LINKS['thread'] = $this->CONF['url'] . "modules.php?name=Forums&file=viewtopic&t=";


And your forum URL setting (within the EP-Dev Forum News admin panel) is: http://www.animegeek.net/

[BugOnAWall]

LMFAO it went back showing

MYSQL ERROR: 1146 : Table 'animegeek.nuke_bbusers' doesn't exist QUERY: SELECT username FROM nuke_bbusers WHERE user_id='67'

This is getting hopeless. I fixed the things you showed me and I didn't mess with the users thing, so I don't know why it went back showing this again. :unsure:

[BugOnAWall]

OKayOKay OKay I GOT IT WORKING THANKS SO MUCH!! I LOVE YOU FOREVER AND EVER AND EVER!!

Thanks again for all your help hun! ^_^

Oh Yeah your code for the News Module works perfectly!! OMG Thank You SO MUCH!!!