| Author | Can you make this module running on PHPNUKE 7.5 ? |
|---|
Guest
Guest
|
|
Can you make this module running on PHPNUKE 7.5 ?
I did install to 7.5, and have problem.
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/sulamita.com/httpdocs/includes/sql_layer.php on line 288
Access Denied
Thanks |
|
 Posted:
Mon Nov 08, 2004 2:55 pm |
|
 |
planedoctor
Site Admin
Joined: Oct 08, 2002
Posts: 306
|
|
I won't be upgrading anytime soon.
I would be more then happy to assist you in fixing the error.
Please give me a little more info about the error!
Where is it showing up?
Top of the page, before the admin block, in the center area under the header?
I really havent looking into what changes were made from v7 to 7.5 I have the mod running on a v7 site with no prob.
Also make sure your using the V 1.5 of Audio!
_________________
|
|
Posted:
Mon Nov 08, 2004 10:02 pm |
|
|
Rama
Guest
|
|
2 Errors I found.
1) In the Admin Panel, inside Audio.
(/admin.php?op=Audio)
ERRO MSG: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/x1cabeza/public_html/includes/sql_layer.php on line 286
Access Denied
2) In /modules.php?name=Audio&l_op=viewaudio&cid=1
ERROR MSG: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/x1cabeza/public_html/includes/sql_layer.php on line 342
Please help! |
|
Posted:
Thu Feb 10, 2005 7:55 am |
|
|
planedoctor
Site Admin
Joined: Oct 08, 2002
Posts: 306
|
|
The first thing I noticed is where the error originated. The module doesnt have any files or changes to the sql_layer.php file
What you are getting is an error in the query. It's hidden now. You need to add some lines to this "sql_layer.php" file to show the true error.
I assume line 286 of this file looks something like this:
| Code: |
case "MySQL":
$rows=mysql_num_rows($res);
return $rows;
break;;
|
You need to change these lines to this:
| Code: |
case "MySQL":
if ($rows = mysql_num_rows($res)) {
return $rows;
} else {
print (mysql_error());
}
break;;
|
This will display the error and you can futther troubleshoot the problem.
Good luck 
_________________
|
|
Posted:
Thu Feb 10, 2005 10:04 am |
|
|
Guest
|
|
after adding the code i get this argument;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in *****\***\****\\includes\sql_layer.php on line 286
Unknown column 'radminlink' in 'field list'Access Denied |
|
Posted:
Thu Feb 10, 2005 2:32 pm |
|
|
planedoctor
Site Admin
Joined: Oct 08, 2002
Posts: 306
|
 |
|
Hi,
Take a look at the audio.php file located:
admin/modules/audio.php
A few lines into this file you will see:
| Code: |
if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); }
$result = sql_query("select radminlink, radminsuper from ".$prefix."_authors where aid='$aid'", $dbi);
list($radminlink, $radminsuper) = sql_fetch_row($result, $dbi);
if (($radminlink==1) OR ($radminsuper==1)) {
|
This is where I think your trouble is comming from.
I dont know what version Nuke your using, but I would guess it is above 6.8.
I believe I have installed it in a 7.0 version and it worked.
In Nuke 7.4 this is the way these lines are used:
| Code: |
if (!eregi("admin.php", $_SERVER['PHP_SELF'])) { die ("Access Denied"); }
global $prefix, $db;
$aid = substr("$aid", 0,25);
$row = $db->sql_fetchrow($db->sql_query("SELECT radminlink, radminsuper FROM " . $prefix . "_authors WHERE aid='$aid'"));
if (($row['radminlink'] == 1) OR ($row['radminsuper'] == 1)) {
|
The above lines were just copied from the links.php file
I cannot tell you if this will fix your problem.
I have not updated Audio to the current nuke version.
Hope this info helps.
_________________
|
|
Posted:
Thu Feb 10, 2005 11:29 pm |
|
|
Guest
|
|
| Now it just say "Access Denied" |
|
Posted:
Thu Feb 10, 2005 11:53 pm |
|
|
planedoctor
Site Admin
Joined: Oct 08, 2002
Posts: 306
|
|
What version nuke are you using?
Is it just the admin area of the module that isnt working?
Are you using version 1.5 of Audio?
_________________
|
|
Posted:
Sat Feb 12, 2005 12:27 am |
|
|
Guest
|
|
| I´m using php-nuke 7.5 and only the Admin of the Audio 1.5 is not working. |
|
Posted:
Tue Feb 15, 2005 2:25 am |
|
|
planedoctor
Site Admin
Joined: Oct 08, 2002
Posts: 306
|
|
I dont know what changes were made between version 7 and 7.5. I have the module running on a version 7 site.
I really dont have time to install a complete site and get this module running with 7.5 right now. You might post for some help on some of the nuke help forum sites. Maybe someone will assist you.
Sorry 
_________________
|
|
Posted:
Tue Feb 15, 2005 8:45 pm |
|
|
DJALPHA
Guest
|
|
|
hey guys please dont use patched (secure patch 7.5 or others) with this version audio. If you want use please tweak it Audio 1,5.
How?:
you ust compare with your other worked modules so easy example please look header of your /admin/modules/authors.php u can see bottom code in header and u must change your audio.php header in same directory.
| Code: |
global $prefix, $db, $admin_file;
if (!eregi("".$admin_file.".php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied"); }
$aid = substr("$aid", 0,25);
$row = $db->sql_fetchrow($db->sql_query("SELECT name, radminsuper FROM " . $prefix . "_authors WHERE aid='$aid'"));
if (($row['radminsuper'] == 1) && ($row['name'] == 'God')) { |
after go to modules/Audio/index.php
change
bottom codes
| Code: |
if (!eregi("modules.php", $PHP_SELF)) {
die ("You can't access this file directly...");
}
$index = 1; |
with this
| Code: |
if (!eregi("modules.php", $_SERVER['SCRIPT_NAME'])) {
die ("You can't access this file directly...");
}
$index = 1; |
if you whish u can make easy modifications and integrated to 7.6 Nuke with change name and move admin files to /modules/Audio/admin/
Dear admin I see some language files lost in your audio.1.5.zip please check it for exp: _PAGEURL
_IMAGE and too many ... thx for module. |
|
Posted:
Fri Feb 18, 2005 3:12 am |
|
|
DJALPHA
Guest
|
|
this is Audio 1.5 for phpnuke 7.6 wihout any script code changing.
This file same with last Audio 1.5 just I add Admin folder to /modules/Audio/Admin
u can manage module from 7.6 Admin panel and u can add administrator for just Audio module!!!
| Code: |
| http://s30.yousendit.com/d.aspx?id=36E4MLQS0GTF92W9BVD4N13O8R |
Admin lang files is incompilate becasue orginal admin lang files is missing!!! |
|
Posted:
Fri Feb 18, 2005 5:29 am |
|
|
besimtari
Newbie
Joined: Feb 15, 2005
Posts: 1
Location: Uk
|
|
First I woold like to thank you for this module!
When I submit a query for searching a word, I got this error:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/user/public_html/includes/sql_layer.php on line 286
This is the code on line 286 sql_layer.php:
| Code: |
case "MySQL":
$row = mysql_fetch_row($res);
return $row;
break;;
|
I changed this lines to this as you told us before:
| Code: |
case "MySQL":
if ($rows = mysql_num_rows($res)) {
return $rows;
} else {
print (mysql_error());
}
break;;
|
but the site is not loading.
For some more information I am using phpnuke 7.2. If this module works with phpnuke 7.5 I will Upgrade dhe phpnuke version
Thank you very much! |
|
Posted:
Thu Feb 24, 2005 8:52 pm |
|
|
Guest
|
|
|
| planedoctor wrote: |
Hi,
Take a look at the audio.php file located:
admin/modules/audio.php
A few lines into this file you will see:
| Code: |
if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); }
$result = sql_query("select radminlink, radminsuper from ".$prefix."_authors where aid='$aid'", $dbi);
list($radminlink, $radminsuper) = sql_fetch_row($result, $dbi);
if (($radminlink==1) OR ($radminsuper==1)) {
|
This is where I think your trouble is comming from.
I dont know what version Nuke your using, but I would guess it is above 6.8.
I believe I have installed it in a 7.0 version and it worked.
In Nuke 7.4 this is the way these lines are used:
| Code: |
if (!eregi("admin.php", $_SERVER['PHP_SELF'])) { die ("Access Denied"); }
global $prefix, $db;
$aid = substr("$aid", 0,25);
$row = $db->sql_fetchrow($db->sql_query("SELECT radminlink, radminsuper FROM " . $prefix . "_authors WHERE aid='$aid'"));
if (($row['radminlink'] == 1) OR ($row['radminsuper'] == 1)) {
|
The above lines were just copied from the links.php file
I cannot tell you if this will fix your problem.
I have not updated Audio to the current nuke version.
Hope this info helps. |
|
|
Posted:
Wed Jun 08, 2005 10:17 am |
|
|
gs
Intern
Joined: Jul 01, 2005
Posts: 8
Location: Ireland
|
|
Looks like you've fixed your audio.
I'll start a new topic, maybe you can help me fix this. |
|
Posted:
Fri Jul 01, 2005 9:26 pm |
|
|
|
Welcome, Guest
Membership:
Latest: 
Today: 0
Yesterday: 0
Overall: 497
Visitation: 
Guests: 7
Members: 0
Total: 7
