The Missing Table - formerly - Instructions for DOWNGRADING

I have downloaded the program EasyPHP and MySQL. Then using a fresh copy of OpenCart 1.5.6, I was able to import the 'structure only' TO the table 'profile_description'. The table columns match now, and when clicking on edit for a product from Admin, I am not getting a white screen with an error message, but I still don't have my product information. What I am seeing is the same page that I have been getting when selecting CATALOG / PROFILES in ADMIN, with a second Admin header too which is a bit strange. There is a Red 'PERMISSION DENIED' message and a white bar saying; "You do not have permission to access this page, please refer to your system administrator." The new Profiles feature in 1.5.6 is mixing into my Product information. I will continue verifying the database structure.

I also need to read about this new Profiles feature, and how it integrates OC.

I will keep you informed to the status. It's slowly progressing. Because of you, I am learning a lot as I try fix this mess. Thanks a lot for helping me.

go over to user groups and edit your permission. Give permission for all the new features

MarketInSG wrote:go over to user groups and edit your permission. Give permission for all the new features

Thanks, Your advice about permissions worked great. So.... Now the ADMIN side seems to be functioning. I haven't tried modifying anything, but I can see the products like before.

I have been trying to decipher the cryptic error message that remains on the front end. I still don't understand what it is saying. From what I have been reading in stack overflow, it may have something to do with the alias given to the columns. (pp for product_profile, pd for product_description, etc). I just can't seem to wrap my brain around this one.

Notice: Error: Unknown column 'pp.product_id' in 'where clause'
Error No: 1054
SELECT `pd`.* FROM `product_profile` `pp` JOIN `profile_description` `pd` ON `pd`.`language_id` = 1 AND `pd`.`profile_id` = `pp`.`profile_id` JOIN `profile` `p` ON `p`.`profile_id` = `pd`.`profile_id` WHERE `pp.product_id` = 100 AND `status` = 1 AND `customer_group_id` = 8 ORDER BY `sort_order` ASC in /home/produi5/public_html/system/database/mysql.php on line 50

This a seriously complex error message. I am sure there is a logic to this but I just haven't been able to see it.

look into your product_profile table, I believe a column is missing

Columns in product_profile;
1. product_id
2. profile_id
3. customer_group_id

I noticed at the top of the page there is a tab called browse.
The hover text says;
Table seems to be empty!
Don't know if that is a valid reason for the problem or not. Just trying to give you as much info as possible. Anything else I can check?

compare the database structure of your profile_description table

There is no difference between the structure of the hosted, and local profile_description tables

Columns in profile_description;
1. profile_id
2. language_id
3. name

the error shouldn't exist because all the columns are there as it should be. You might want to hire someone to look into it, which would make this work much quicker

Ok thanks for all you did. I really appreciate all your efforts. If I can't figure it out on my own, I will dump opencart and start fresh with another platform. I am not going to invest another penny in this mess. Thanks to you, I am at least to the point now that I can retrieve my product descriptions from the admin side. It took months to translate. Good luck in all your endeavors. You are good people. OpenCart WAS great! I really am sorry to see the direction it is headed. There are some really helpful people here.