Broken Modules due to 7.5

SmackDaddy · Posted: Fri Sep 03, 2004 3:34 pm

Well, I am intending this post to be a "what's what" of modules that people find are broken as a result of the recent modularization of PHPNuke 7.5.

As Raven as pointed out in another thread, the following code:

Code:

// Administrators Table modification
$db->sql_query("ALTER TABLE nuke_authors DROP radminarticle, DROP radmintopic, DROP radminuser, DROP radminsurvey, DROP radminlink , DROP radminfaq, DROP radmindownload, DROP radminreviews, DROP radminnewsletter, DROP radminforum, DROP radmincontent, DROP radminency");

...has the possibility to break modules that rely on those variables. If you find a module has been "broken" as a result, please first double-check the issue for yourself (before posting), and then list the module and if possible anything that can be done as a temporary work-around/fix until a solution is achieved...

I'll try and keep this list as update to date as possible.

(updated: 3 Sep 04)
MODULES AFFECTED BY 7.5:
(none reported as of yet)

Raven, if possible, could you place this as a sticky? I am unable....thank you.

Doodle · Posted: Fri Sep 03, 2004 3:56 pm

I got a reply from Warrick regarding AutoTheme functioning with 7.5:

Quote:

I'm not aware of any problems at the moment, but then I'm not the developer of the module. One thing I can say is that the developer works pretty quickly to fix compatibility issues when they occasionally arise.

I'm going to fire up a test site and see what happens over the weekend.

JRSweets · Worker Joined: Aug 06, 2004 Posts: 192

CZM Modules - from

Only registered users can see links on this board!
Get registered or login to the forums!

I was able to fix it and posted the fix here...

Only registered users can see links on this board!
Get registered or login to the forums!

Doodle · Posted: Fri Sep 03, 2004 4:17 pm

Woohoo! Thanks!

builtforspeed · New Member Joined: Mar 22, 2004 Posts: 2

I am running Nuke 7.5 and I am experiencing the following problems with Admin modules:

Archives
Edit Users
NSN Edit News Ads
Ephemerids
MS Analysis
NukeWin V1.4

The error I am receiving is:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in sql_layer.php on line 286
Unknown column 'radminuser' in 'field list'Access Denied

Some modules only error with "Access Denied" and not the full error code. Several other modules work, but they still strangly enough display the "Access Denied" in the theme at the top left of the screen?

Any assistance would be very much appreciated.

Thanks,

Cory

Raven · Posted: Sun Sep 12, 2004 1:36 am

I have responded to Cory via email and explained that it's due to the table alteration of the authors table in most cases.

tag · Regular Joined: Dec 18, 2003 Posts: 53 Location: Worldwide

Thank you raven for that,

is there a way to fix it?

MrFluffy · Posted: Sun Sep 12, 2004 3:14 am

builtforspeed wrote:

I am running Nuke 7.5 and I am experiencing the following problems with Admin modules:

...
MS Analysis
...

Find a fix here:

Only registered users can see links on this board!
Get registered or login to the forums!

Quote:

Several other modules work, but they still strangly enough display the "Access Denied" in the theme at the top left of the screen?

List of files to delete to avoid the access denied on top of your admin section:

Only registered users can see links on this board!
Get registered or login to the forums!

jbsarma · New Member Joined: Jan 23, 2004 Posts: 24

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/assamch/public_html/travel/includes/sql_layer.php on line 286
Access Denied

I too get this error when I click certain module in the admin panel e.g., content. The error appears at the top of the header but otherwise everything seems OK. I just upgraded from Nuke7.8 to 7.5.

Is there a fix available? Please enlighten.[/quote]

MrFluffy · Posted: Sun Sep 12, 2004 9:40 am

Where can one download the Certain module? LOL

You can find some general directions in english here:

Only registered users can see links on this board!
Get registered or login to the forums!

jbsarma · New Member Joined: Jan 23, 2004 Posts: 24

The problem is fixed by deleting the redundant files in the admin module as listed

Only registered users can see links on this board!
Get registered or login to the forums!

[/code]

Raven · Posted: Sun Sep 12, 2004 9:49 am

That error is a result of not being able to connect to a table. This can be because

A) MySQL is unreachable
B) The table does not exist or is corrupted
C) The table structure has changed and the sql that accesses it is not in sync

C is the most likely since the nuke_authors table no longer contains most of the columns, Turn $sql_debug on and find out which table is being called and what column is missing. Then correct the sql call accordingly.

Doodle · Posted: Sun Sep 12, 2004 10:58 am

By the way I tested 7.5 with Autotheme Lite 0.8 and it seems to work. I haven't fully tested the blocks admin functions but so far so good.

GeekyGuy · Posted: Sun Sep 12, 2004 1:19 pm

I think I have a fix for the Ephimerids block.
Add this to your /language/lang-XXXX.php (if it is not already there)

Code:

define("_EPHEMERIDS","Ephemerids");
define("_ONEDAY","One Day like Today...");

Add this to your /admin/language/lang-XXXX.php (if it is not already there)

Code:

define("_EPHEMADMIN","Ephemerids Administration");
define("_ADDEPHEM","Add a New Ephemerid");
define("_EPHEMDESC","Ephemerid Description");
define("_EPHEMMAINT","Ephemerid Maintenance (Edit/Delete):");
define("_EPHEMEDIT","Edit Ephemerids");

Open /admin/modules/ephemerids.php and find this code:

Code:

$row = $db->sql_fetchrow($db->sql_query("SELECT radminephem, radminsuper FROM " . $prefix . "_authors WHERE aid='$aid'"));
if (($row['radminephem'] == 1) OR ($row['radminsuper'] == 1)) {

And change it to:

Code:

$row = $db->sql_fetchrow($db->sql_query("SELECT name, radminsuper FROM ".$prefix."_authors WHERE aid='$aid'"));
$admins = explode(",", $row['admins']);
$auth_user = 0;
for ($i=0; $i < sizeof($admins); $i++) {
if ($row['name'] == "$admins[$i]") {
$auth_user = 1;
}
}
if ($row['radminsuper'] == 1 || $auth_user == 1) {

Since I am not a programmer, I just took a fix for another module and hacked on it until it worked for the Ephemerids.

GeekyGuy · Posted: Sun Sep 12, 2004 1:46 pm

I think I have also fixed the JAG Virus block.
In /admins/module/JAG_Virus_Alerts.php, find all this code:

Code:

$Q01 = "SELECT radminency, radminsuper
FROM ".$prefix."_authors
WHERE aid = '$aid'";
$R01 = $db -> sql_query($Q01) or die("Bad Q01:".mysql_error());
list($radminency, $radminsuper) = sql_fetch_row($R01);

if (($radminency==1) OR ($radminsuper==1))
{

And change it to:

Code:

$result = sql_query("select radminsuper from ".$prefix."_authors where aid='$aid'", $dbi);
list($radminsuper) = sql_fetch_row($result, $dbi);
if ($radminsuper==1) {

tag · Regular Joined: Dec 18, 2003 Posts: 53 Location: Worldwide

Quote:

$row = $db->sql_fetchrow($db->sql_query("SELECT name, radminsuper FROM ".$prefix."_authors WHERE aid='$aname'"));
$admins = explode(",", $row['admins']);
$auth_user = 0;
for ($i=0; $i < sizeof($admins); $i++) {
if ($row['name'] == "$admins[$i]") {
$auth_user = 1;
}
}
if ($row['radminsuper'] == 1 || $auth_user == 1) {

This works for most fo the admin blocks, some will need you to define the stuff in them in admin/language

Thanks for your help

Still cant get Submit news to show up anywhere tho. "submit.php

MrFluffy · Posted: Sun Sep 12, 2004 4:27 pm

@ GeekGuy and tag

You're making a fault there, you adapted my MS_Analysis fix, which is generally quite right. The problem is that the $aname variable is something special to this module.

Please use $aid for 'normal' modules instead.

GeekyGuy · Posted: Sun Sep 12, 2004 4:32 pm

MrFluffy,
Thanks for the info, I've edited my previous post.

builtforspeed · New Member Joined: Mar 22, 2004 Posts: 2

This code above worked for all of the modules access through admin that were previously broken.
All I seem to have to do, is the language part now. I also used it with a new version of "User Administration" that we upgraded too. Users can edit there account information fine from the My Account options of the site. But, now I am receiving the following error when attempting to use any of the administrative options except for config users in the user edit module of admin (i.e. add new users, create field, active users, regular users, etc.)

Warning: Division by zero in functions.php on line 261

This user administration was designed by Bob Marion nukescripts.net, and the current owner as indicated in the credits is André V Escudero of phpnuke.org.br which is in brazilian language so I can't understand anything. Question

Any assistance would be greatly appreciated. Thanks for assisting me along this far! Very Happy

- Cory

coyoweb · New Member Joined: Oct 06, 2004 Posts: 1

Hello here the are a tutorial its has accepted on phpnuke.org Very Happy

Only registered users can see links on this board!
Get registered or login to the forums!

Y tambien esta disponible en español Very Happy

Only registered users can see links on this board!
Get registered or login to the forums!