Search found 17 matches

Page 1 of 1

Search found 17 matches

OKI

Re: The Missing Table - formerly - Instructions for DOWNGRAD

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 descripti...

Jump to post
  • Mon Sep 30, 2013 7:08 pm
  • Replies 28
  • Views 5213

OKI

Re: The Missing Table - formerly - Instructions for DOWNGRAD

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

Jump to post
  • Mon Sep 30, 2013 2:09 am
  • Replies 28
  • Views 5213

OKI

Re: The Missing Table - formerly - Instructions for DOWNGRAD

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. Any...

Jump to post
  • Sun Sep 29, 2013 4:58 pm
  • Replies 28
  • Views 5213

OKI

Re: The Missing Table - formerly - Instructions for DOWNGRAD

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...

Jump to post
  • Sun Sep 29, 2013 2:41 am
  • Replies 28
  • Views 5213

OKI

Re: upgrade to 1.5.6 open cart

Qphoria wrote: Part of me wants to just write a script to remove all the openbay stuff and apply the handful of fixes and require that anyone using mods or requesting support from me run that first. But I'm sure as soon as I finish the script, 1.5.6.1 will be released rendering it mostly useless. [...

Jump to post
  • Tue Sep 24, 2013 9:22 pm
  • Replies 45
  • Views 19313

OKI

Re: The Missing Table - formerly - Instructions for DOWNGRAD

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 mes...

Jump to post
  • Tue Sep 24, 2013 2:42 pm
  • Replies 28
  • Views 5213

OKI

Re: The Missing Table - formerly - Instructions for DOWNGRAD

Ok.... If you are in Singapore, then you are six hours ahead of me. I am still having my first cup of coffee, so I will research the details on setting up a server on my home system,, after my caffeine reservoir is sufficiently charged. I have been thinking about doing this for some time now. I just...

Jump to post
  • Mon Sep 23, 2013 2:22 pm
  • Replies 28
  • Views 5213

OKI

Re: The Missing Table - formerly - Instructions for DOWNGRAD

Ok profile table dropped... query ran... columns added as previewed. I am still having errors on both front and admin sides. FRONT END No Change Notice: Error: Unknown column 'pp.product_id' in 'where clause' Error No: 1054 SELECT `pd`.* FROM `product_profile` `pp` JOIN `profile_description` `pd` ON...

Jump to post
  • Sun Sep 22, 2013 10:56 pm
  • Replies 28
  • Views 5213

OKI

Re: The Missing Table - formerly - Instructions for DOWNGRAD

Inside my profile table are these columns : But like before, it is without the oc prefix product_id profile_id customer_group_id Should I run a query with the code above? I found an ocart.sql backup from 22 june. I had the host upload it with the hope that it would fix the problem. No change in resu...

Jump to post
  • Sat Sep 21, 2013 10:08 pm
  • Replies 28
  • Views 5213

OKI

Re: The Missing Table - formerly - Instructions for DOWNGRAD

I changed the product.php file as suggested. Below is a before and after shot of the generated error messages. I have also since found another error when accessing products from the "ADMIN" for editing. I thought the two issues could be related and possibly provide a clue for finding a solution. Err...

Jump to post
  • Sat Sep 21, 2013 7:19 pm
  • Replies 28
  • Views 5213

OKI

Re: The Missing Table - formerly - Instructions for DOWNGRAD

ok I understand. Unfortunately 131 is a specific product. Each product has a unique number, and they all have the same error. ie, another product shows this; Notice: Error: Column 'product_id' in where clause is ambiguous Error No: 1052 SELECT `pd`.* FROM `product_profile` `pp` JOIN `profile_descrip...

Jump to post
  • Fri Sep 20, 2013 10:27 pm
  • Replies 28
  • Views 5213

OKI

Re: The Missing Table - formerly - Instructions for DOWNGRAD

I don't know. That is why I was asking if a query existed to identify the duplicate column names within the entire database. From what I was reading, it seems that the computer can't tell one from the other if they have the same name. I am in way over my head here. Sorry if I am not clear. The above...

Jump to post
  • Fri Sep 20, 2013 8:29 pm
  • Replies 28
  • Views 5213

OKI

Re: The Missing Table - formerly - Instructions for DOWNGRAD

DONE ! The original 1146 error has now been replaced by a 1052 error. Guess that is a step in the right direction. At least the tables exist now. Notice: Error: Column 'product_id' in where clause is ambiguous Error No: 1052 SELECT `pd`.* FROM `product_profile` `pp` JOIN `profile_description` `pd` O...

Jump to post
  • Fri Sep 20, 2013 7:53 pm
  • Replies 28
  • Views 5213

OKI

Re: The Missing Table - formerly - Instructions for DOWNGRAD

Thank you so much for taking the time to assist. I was a little lost at first because I had never run a query before. I searched google and found a video example with step by step instructions. After the query I had two new tables in my database. oc_product_profile and oc_product_recurring. Unfortun...

Jump to post
  • Fri Sep 20, 2013 3:37 pm
  • Replies 28
  • Views 5213

OKI

Re: The Missing Table

Thanks for responding MarketInSG I agree 100% ! For a real opencart geek fixing the error would be a piece of cake. The trouble is I am just a geek apprentice with a lack of knowledge in this area. Three years ago I didn't even know what CSS was. I have come a long way, however I have absolutely no ...

Jump to post
  • Thu Sep 19, 2013 6:08 pm
  • Replies 28
  • Views 5213

OKI

The Missing Table - formerly - Instructions for DOWNGRADING

Hello..... After upgrading to 1.5.6 My site is having serious problems. I am getting the dreaded 1146 error * Table 'XXXX_ocart.product_profile' doesn't exist * Everything works fine until selecting any product, either in ADMIN or the Front end. I have searched the forums and discovered a few issues...

Jump to post
  • Thu Sep 19, 2013 3:05 pm
  • Replies 28
  • Views 5213

OKI

Re: Web hosts. Who's good and who to avoid

I use Inmotion Hosting in USA. They have pretty good reviews and their customer service has been paramount.

Jump to post
  • Sun Apr 29, 2012 1:06 am
  • Replies 143
  • Views 28837

Page 1 of 1

Search found 17 matches