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
Code: Select all
r.productaboutus_id
Code: Select all
r.product_id
JAY6390,JAY6390 wrote:The error message kind of speaks for itself. You're trying to accesswhich doesn't exist. TryCode: Select all
r.productaboutus_id
Code: Select all
r.product_id
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?
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?
Who is online
Users browsing this forum: No registered users and 4 guests