Need help with some PHP coding please

Hello,

For my purpose of usage of Opencart 1.4.8b I need to modify it abit.
Basically I need to make 4 opencart systems within 1.
Each of the 4 system will have a link button in the header and each need to have their own modules (Ex. separate "Category" modules for all 4)

Seems I was ablue to get the Admin side of it done, but I'm kinda stuck on the User side.
I got as for as making sparate "home" modules and "category" modules for all 4.
Now I'm trying to make the product information to display when an item is selected from the category list.

Seems I have some problems with the "product_id" portion of the programming.
I'm getting the following error but can't figure out what needs to be done to correct it. All your help is greatly appriciated and thanks in advance.

Error: Unknown column 'r.productaboutus_id' in 'where clause'
Error No: 1054
SELECT *, pd.name AS name, p.image, m.name AS manufacturer, ss.name AS stock, (SELECT AVG(r.rating) FROM review r WHERE p.productaboutus_id = r.productaboutus_id GROUP BY r.productaboutus_id) AS rating FROM productaboutus p LEFT JOIN productaboutus_description pd ON (p.productaboutus_id = pd.productaboutus_id) LEFT JOIN productaboutus_to_store p2s ON (p.productaboutus_id = p2s.productaboutus_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN stock_status ss ON (p.stock_status_id = ss.stock_status_id) LEFT JOIN productaboutus_to_categoryaboutus p2c ON (p.productaboutus_id = p2c.productaboutus_id) WHERE p.status = '1' AND p.date_available <= NOW() AND pd.language_id = '1' AND p2s.store_id = '0' AND ss.language_id = '1' AND p2c.categoryaboutus_id = '35' ORDER BY p.sort_order ASC LIMIT 0,20

The error message kind of speaks for itself. You're trying to access which doesn't exist. Try

JAY6390 wrote:The error message kind of speaks for itself. You're trying to access

Code: Select all

r.productaboutus_id

which doesn't exist. Try

Code: Select all

r.product_id

JAY6390,
Thanks for your reply.

I know "r.product_id" is the original code for the product category list IDs and that part of my program is working fine.
"r.productaboutus_id" is one of the 4 new sets of products category listing I have duplicated, which doesn't seem to be linked properly and I need help with.

Okay...
Regarding above issue I've changed all the "productaboutus_id" to "product_id" in all the opencart and SQL files.

Now instaead of
Error: Unknown column 'r.productaboutus_id' in 'where clause'
Error No: 1054

I'm getting the following when clicking an item on the category list.
Fatal error: Call to undefined method ModelCatalogProductaboutus::getTotalProductaboutussByCategoryaboutusId() in /my URL/catalog/controller/productaboutus/categoryaboutus.php on line 93

At this location
.....categoryaboutus.php on line 93

This is what I have
$productaboutus_total = $this->model_catalog_productaboutus->getTotalProductaboutussByCategoryaboutusId($categoryaboutus_id);

Can any one make out what could be wrong with it?

I was able to resolve this issue.
Thank you for looking.