Help make Auto Category Image work for 1.5.6

[dtblingerie]

I have found two excellent extensions; however, neither of them work for 1.5.6. I keep getting the same error whenever I try to run them:

Notice: Error: Table 'removed_removed.category' doesn't exist
Error No: 1146
SELECT category_id FROM `category` WHERE parent_id > 0 Order By category_id ASC in /removed/removed/mysql.php on line 50

Can someone please tell me what to do in order to make these work for 1.5.6.

Here is the first file: autocategoryimage.php

<?php
require_once('config.php');
require_once(DIR_SYSTEM . 'startup.php');

// Registry
$registry = new Registry();

// Loader
$loader = new Loader($registry);
$registry->set('load', $loader);

// Config
$config = new Config();
$registry->set('config', $config);

// Database 
$db = new DB(DB_DRIVER, DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
$registry->set('db', $db);


$query = $db->query("SELECT category_id FROM `category` WHERE parent_id > 0 Order By category_id ASC");

foreach ($query->rows as $category){
    $query2 = $db->query("SELECT * FROM `" . DB_PREFIX . "product_to_category` WHERE category_id = '" . $category['category_id'] . "' ORDER BY RAND() LIMIT 1");
    foreach($query2->rows as $product){
        $query3 = $db->query("SELECT * FROM `" . DB_PREFIX . "product` WHERE product_id = '" . $product['product_id'] . "'");
        foreach($query3->rows as $image){
            $query4 = $db->query("UPDATE `" . DB_PREFIX . "category` SET image = '" . $image['image'] . "' WHERE category_id = '" . $category['category_id'] . "'");
            //echo ("UPDATE `" . DB_PREFIX . "category` SET image = '" . $image['image'] . "' WHERE category_id = '" . $category['category_id'] . "' <hr>");
        }
    }
}
   

$query = $db->query("SELECT category_id,parent_id FROM `category` WHERE parent_id > 0 and image='' Order By category_id ASC");

 foreach ($query->rows as $category){
    $query2x = $db->query("SELECT * FROM `" . DB_PREFIX . "category` WHERE parent_id = '" . $category['category_id'] . "' LIMIT 0, 1");
    foreach($query2x->rows as $realcat){
    //echo "{$realcat['category_id']}-{$realcat['parent_id']} <hr>";
        $query2 = $db->query("SELECT * FROM `" . DB_PREFIX . "product_to_category` WHERE category_id = '" . $realcat['category_id'] . "' ORDER BY RAND() LIMIT 1");
        foreach($query2->rows as $product){
            $query3 = $db->query("SELECT * FROM `" . DB_PREFIX . "product` WHERE product_id = '" . $product['product_id'] . "'");
            foreach($query3->rows as $image){
                $query4 = $db->query("UPDATE `" . DB_PREFIX . "category` SET image = '" . $image['image'] . "' WHERE category_id = '" . $realcat['parent_id'] . "'");
                //echo ("UPDATE `" . DB_PREFIX . "category` SET image = '" . $image['image'] . "' WHERE category_id = '" . $realcat['parent_id'] . "' <hr>");
            }
        }
    }
   
}

echo 'All category images are set.';

?>

and here is the second: runonce.php

<?php
require_once('config.php');
require_once(DIR_SYSTEM . 'startup.php');

// Registry
$registry = new Registry();

// Loader
$loader = new Loader($registry);
$registry->set('load', $loader);

// Config
$config = new Config();
$registry->set('config', $config);

// Database 
$db = new DB(DB_DRIVER, DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
$registry->set('db', $db);



$query = $db->query("SELECT category_id FROM `category` WHERE parent_id > 0 Order By category_id ASC");

foreach ($query->rows as $category){
    $query2 = $db->query("SELECT * FROM `" . DB_PREFIX . "product_to_category` WHERE category_id = '" . $category['category_id'] . "' LIMIT 0, 1");
    foreach($query2->rows as $product){
        $query3 = $db->query("SELECT * FROM `" . DB_PREFIX . "product` WHERE product_id = '" . $product['product_id'] . "'");
        foreach($query3->rows as $image){
            $query4 = $db->query("UPDATE `" . DB_PREFIX . "category` SET image = '" . $image['image'] . "' WHERE category_id = '" . $category['category_id'] . "'");
        }
    }
}
   
echo 'done';
@unlink('runonce.php');

I have also included the extension urls:
opencart(dot)com/index.php?route=extension/extension/info&extension_id=5781[/url]
forum.opencart(dot)com/viewtopic.php?t=48045[/url]


Any help would truly be appreciated.

 

[sb65]

I get a similar error trying this on a test installation, which is caused by the absence of the DB_PREFIX constant in part of the sql.

In AutoCategoryImage.php replace this:

$query = $db->query("SELECT category_id FROM `category` WHERE parent_id > 0 Order By category_id ASC");

with this

$query = $db->query("SELECT category_id FROM `" . DB_PREFIX . "category` WHERE parent_id > 0 Order By category_id ASC");

and this

$query = $db->query("SELECT category_id,parent_id FROM `category` WHERE parent_id > 0 and image='' Order By category_id ASC");

with this

$query = $db->query("SELECT category_id,parent_id FROM `" . DB_PREFIX . "category` WHERE parent_id > 0 and image='' Order By category_id ASC");

If I make these subsututions I get a success message running the file.

 

[dtblingerie]

It works! You are amazing! Thank you so much!