CPG Random Thumber gives error for guests

EliteRides · 15.09.2005, 20:27

If I am logged in and viewing my site the thumber module works fine. However, if I log out and vew the site as a guest that module then displays:

Code:

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /var/www/html/modules/mod_copprand.php on line 120

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/modules/mod_copprand.php on line 123

How can I fix this?

fattykid17 · 21.10.2005, 21:10

You probable didn't use the standard table when you installed coppermine. The standard table prefix is cpg. Which is what is used in the random image mod. Just go through and replace the cpg_ prefix with your own. Like
$queryaid = mysql_query("SELECT * FROM `cpg_albums` where visibility ='0'");
Change to :

$queryaid = mysql_query("SELECT * FROM `NAMEOFYOURTABLE_albums` where visibility ='0'");
DON'T LEAVE "NAMEOFYOURTABLE" THERE CHANE IT TO THE NAME OF YOUR TABLE
Should be around lines 119 and 140 for the users not loged in function.
There are a few more in there you should probable hunt down too before they give you problems

UPDATE :

Added ability to change the table prefix through Admin
Fixed Error caused by having coppermine in a different database from Thumb Rotater module (was causing all modules placed after it to have SQL errors)
You can download the new file from HERE

fattykid17 · 27.11.2005, 03:54

I fixed the module and forgot to ever post a link to it here. Sorry about that but here it is late is better than never

http://www.greedygamer.com/index.php...nc=select&id=3
Any questions / comments please direct to me not chris fuller since I hacked up his module. Don't blame him for my coding errors

You can contact me aaron (the symbol) greedygamer (the dot) com