| Author |
Message |
SmackDaddy
Involved
Joined: Jun 02, 2004
Posts: 268
Location: Englewood, OH
|
 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
Hangin' Around
Joined: Jan 26, 2004
Posts: 46
Location: 127.0.0.1
|
| 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. |
_________________
Independent Network Solutions
www.insglobal.net
www.indnet.ca
www.joombug.net |
|
|
|
|
JRSweets
Worker
Joined: Aug 06, 2004
Posts: 192
|
| Posted:
Fri Sep 03, 2004 4:11 pm |
|
|
|
|
|
Doodle
|
| Posted:
Fri Sep 03, 2004 4:17 pm |
|
|
|
|
|
builtforspeed
New Member
Joined: Mar 22, 2004
Posts: 2
|
| Posted:
Sat Sep 11, 2004 7:27 pm |
|
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
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 17088
|
| 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
|
| Posted:
Sun Sep 12, 2004 1:45 am |
|
Thank you raven for that,
is there a way to fix it? |
| |
|
|
|
|
MrFluffy
Hangin' Around
Joined: Jun 24, 2004
Posts: 28
Location: Berlin
|
| 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:
http://www.ayhsel.de/ftopict-134.html
| 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:
http://www.ayhsel.de/ftopict-137.html |
_________________
cu,
MrFluffy
Only registered users can see links on this board! Get registered or login! |
|
 
  |
|
jbsarma
New Member
Joined: Jan 23, 2004
Posts: 24
|
| Posted:
Sun Sep 12, 2004 9:32 am |
|
| 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 |
|
|
|
|
|
jbsarma
|
| Posted:
Sun Sep 12, 2004 9:46 am |
|
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![/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
Client
Joined: Jun 03, 2004
Posts: 302
Location: Huber Heights Ohio
|
| 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. |
_________________
"The Daytona 500 is ours! We won it, we won it, we won it!", Dale Earnhardt, February 15th, 1998, Daytona 500
Last edited by GeekyGuy on Sun Sep 12, 2004 4:33 pm; edited 1 time in total |
|
|
|
|
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
|
| Posted:
Sun Sep 12, 2004 4:18 pm |
|
| 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
|
| Posted:
Sun Sep 12, 2004 9:41 pm |
|
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. 
Any assistance would be greatly appreciated. Thanks for assisting me along this far! 
- Cory |
| |
|
|
|
|
coyoweb
New Member
Joined: Oct 06, 2004
Posts: 1
|
| Posted:
Wed Oct 06, 2004 1:26 pm |
|
|
|
|
|
|
|
![[Valid RSS]](https://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
