classified ads

[TechnoBum]

Does anyone know of a good classified ads script "out there" ?

I use nuke6, and I tried a whole slew of 'em, some nuke specific some not, none of which will work.
I get tons of MySQL errors.
The latest one, NukeC-1.0, seems to work in some sites, but no joy for me. :cry:

[WiZARD]

Give just one error......

[TechnoBum]

Hi,
here's a couple:

Fatal error: Call to undefined function: error() in /var/www/html/my-site-name/modules/NukeC/functions.php on line 605
(and this is line 605:

# mysql_query( "select imageads FROM ".$prefix."_ads_ads WHERE validuntil < '$nowdate'" ) or error( mysql_error() );

without the #)

Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/my-site-name/includes/sql_layer.php on line 241

240 ) case "MySQL":
241 ) $rows=mysql_num_rows($res);
242 ) return $rows;
243 ) break;;

and

Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/my-site-name/includes/sql_layer.php on line 289

288 ) case "MySQL":
289 ) $row = mysql_fetch_row($res);
290 ) return $row;
291 ) break;;

Although I know squat about php or MySQL scripting, I don't think there are any errors with the sql_layer file.

I see no entries whatsoever in MySQL's tables about NukeC.
Shouldn't there be some?

I use phpnuke6 which I run off my own Apache 1.3.26 with MySQL 3.23.52
All my other mods are doing fine. I tried a few other classified ads mods, all of which give me MySQL errors.

Thanks for your reply.

[WiZARD]

Hi TechnoBum!
I'm try to explaine some youre problem.....
I.

Code: Select all

Fatal error: Call to undefined function: error() in /var/www/html/my-site-name/modules/NukeC/functions.php on line 605

mysql_query( "select imageads FROM ".$prefix."_ads_ads WHERE validuntil < '$nowdate'" ) or error( mysql_error() );


Try to find this function in functions.php, or some included file if you cannot find try to change to

Code: Select all

mysql_query( "select imageads FROM ".$prefix."_ads_ads WHERE validuntil < '$nowdate'" ) or die(mysql_error(),"sorry...");


II.

Code: Select all

Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/my-site-name/includes/sql_layer.php on line 241

240 ) case "MySQL":
241 ) $rows=mysql_num_rows($res);
242 ) return $rows;
243 ) break;;

and

Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/my-site-name/includes/sql_layer.php on line 289

288 ) case "MySQL":
289 ) $row = mysql_fetch_row($res);
290 ) return $row;
291 ) break;;


some bug in youre NukeC or type of DataBase is indefinably.

P.S. Some addon you may find in http://www.hotscripts.com/PHP/Scripts_a ... ke_Addons/

[TechnoBum]

Hi Wiz,
Thanks for your suggestion. I'll look into that.

I really think the problem is with the NukeC module. There have been a lot of complaints about it in a few forums, but it seems that no "perfect" fix has been found yet.
Also, all my other modules are working just fine.

NukeC seems to be working ok in a couple of sites I've seen (sorry, I don't remember which ones), so I assume the site owners must be php programmers and found a way to fix the bugs themselves.

I may have to use a different classified ads module.