CRON - Update_Tag_Cloud.php problem

[FSGDAG]

I'm having a hard time getting the CRON for update_tag_cloud.php to run each night. I decided tonight to try running it from within my browser.

Calling : http://www.<mydomain>.com/cronjobs/update_tag_cloud.php and I got the following message :

Fatal error: Call to a member function Execute() on a non-object in /home/XXXX/public_html/cronjobs/update_tag_cloud.php on line 17

Here is line 1 through 41 in update_tag_cloud.php with line 17 being in a bigger font size

<?
/*
cronjobs name: Update_tag_cloud
cronjobs URI: Quality Web Based Software for Your Business - IndexU Link Directory - iDesk Help Desk - NiceTalk LiveHelp script - NiceMember membership script - NiceBackup cPanel™ backup utility - DMOZ Extractor
Description: update tag could be ran by cronjobs.
Version: 1.0
Author: indexu
Author URI: -
*/
global $site_url;
// get new/updated links
$query = "select keywords, category_id, cat1, cat2 from idx_link
where suspended = 0
and (new = 1 or updated = 1)
and keywords != ''";

$result = $dbConn->Execute($query);
$tag_values = array();
$i = 0;
$total_record = $result->RecordCount();
while ($row = $result->FetchRow()) {
$i++;
$keywords = $row["keywords"];
$words = explode(",", $keywords);
while (list($k, $v) = @each($words)) {
$v = trim($v);
if ($v) {
if (strlen($v) > 2) {
$v = addslashes($v);
$tag_values[] = "('$v', 0, -1)";
if ($row["category_id"]) {
$tag_values[] = "('$v', $row[category_id], -1)";
}
if ($row["cat1"]) {
$tag_values[] = "('$v', $row[cat1], -1)";
}
if ($row["cat2"]) {
$tag_values[] = "('$v', $row[cat2], -1)";
}
}
}

Any thoughts?

[mpdaddy]

Change

global $site_url;

To

global $dbConn, $site_url;

Regards
mp

[FSGDAG]

I'm still getting the same thing

[mpdaddy]

I'm checking the file now. I had to download it using the file manager in my cpanel. I am at work.

[mpdaddy]

Without being at home and being able to see the big picture, I am not sure if this file is meant to be called from a plugin or directly.

If it is to be called form a plugin, the following code will probably throw an error.

If it is to be called directly, then this code will work. Also, when it's used, it simply displays a blank screen.

I can look into it further tomorrow, but for now add this code to the top just above the globals.

include "../application.php";

Regards
Wayne

[Bruceper]

As mpdaddy stated, it doesn't appear to be including application.php which is required to connect to the database.

[mpdaddy]

Looking into it further I see that it is meant to be called by the admin/cronjobs.php file. Therefore it does not need to include the application.php file since the cronjobs.php already includes it. The update_tag_clouds.php file is not meant to be accessed directly.

When I have better script access and more time, I will look into why the script does not seem to be working properly. When I know more, I will report back with my findings.

Regards
Wayne

[FSGDAG]

You guys are the best!!! Thank you for looking into it further

[mpdaddy]

Frank

My apologies. I have not been able to solve the problem you are having. I know that the only cronjob that updates the time is the clear_templates_c.php. The update_tag_cloud.php seems to function correctly, but does not update the time.

I have limited internet access until at least Friday. I also have my 3 days off starting Friday. I will have more time to go through all the files and check it out more.

On another note, I am almost finished with the last conversion projects you requested. I will keep you posted.

Regard
mp

[FSGDAG]

Hey Wayne...

No need for apologies All is good and well When you have some free time, we can talk more then