I have installed and used this mod on 6.5 with no problems but it appears to have a prob with 6.8 for some reason. The Author says he has no idea or maybe he just isnt interested I dont know but I really would like to use this, CAN SOMEONE HELP PLEASE ???
Once installed it will not allow you to see the currently installed modules from admin so you can add them to the categorys you set. I also get this error message.
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /www/www.mysite.com/htdocs/includes/sql_layer.php on line 286 .
99% of the time when you get a argument isn't valid the problem is the query that is being plugged into the argument. Around nuke 6.5 a new sql abstraction layer was implemented with the prior version (that your mod uses) being deprecated (ending support).
I don't have nuke 6.8 installed, but most likely your problem is:
A.) The sql_query("SELECT..."); line is referring to bad sql tables or field names
B.) You don't have the "old" sql_layer in your 6.8 install.
--Hadron
Stevek Nuke Soldier
Joined: Jul 04, 2003
Posts: 12
Posted:
Mon Aug 25, 2003 4:15 am
The Author has it running on 6.8 but he reckons he has made no changes. I have a fresh install of 6.8 and i cant get it to work. Stuffs me how it works on my 6.5 and not 6.8 but does on his, I reckon he is pullin my chain.
Hadron Corporal
Joined: Aug 20, 2003
Posts: 61
Posted:
Mon Aug 25, 2003 8:18 am
Tou could always turn on debugging in the sql abstraction layer, but it could make your page pretty ugly for other users if they hit errors while you are doing the debugging. Just make $sql_debug = 1; in the sql_query function in sql_layer.php, which is in your includes folder.
For a less annoying method for your users, my suggestion would be to insert an echo statement just above any '$result = sql_query("SELECT...' type statements (preferably one at a time so you can find the offender easily). For example:
Code:
echo "select mid from ".$prefix."_modules where title='$modlist[$i]'<br>";
$result = sql_query("select mid from ".$prefix."_modules where title='$modlist[$i]'", $dbi);
Then try and load the page. Youll see the echo statement and then you can copy/paste it into an SQL query box in phpMyAdmin and see what error results. Sometimes you don't even need to do that as you can see the error from the echo.
--Hadron
Stevek Nuke Soldier
Joined: Jul 04, 2003
Posts: 12
Posted:
Mon Aug 25, 2003 8:50 pm
Mmmm Since I am No Whiz at this stuff I wont play with that last suggestion but thanks for your reply.
If the Author would only assist it would probably be fixed in a few secs, he would be the only one that I have found not willing to assist someone who doesnt know alot about php programming. The rest of you guys ROCK !!
Stevek Nuke Soldier
Joined: Jul 04, 2003
Posts: 12
Posted:
Thu Aug 28, 2003 4:20 pm
Ok guys here is the solutiuon to our problems.
This little suqer will do what we want and you can order the options as you wish, also you can throw offsite entries into the menu. This one rocks !!!!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Just make $sql_debug = 1; in the sql_query function in sql_layer.php, which is in your includes folder.