Results 1 to 8 of 8

Hybrid View

  1. #1

    Default SQL DB error message 1146 after installing group_pricing_per_item

    I'm setting up a new install on zc 1.3.8 and just installed group_pricing_per_item_1.2.1a. When I click on a category to view my products, I get the following error: (I edited out my db name)


    1146 Table '******_**********.yourprefix_customers' doesn't exist
    in:
    [select gp.group_name from yourprefix_customers cu left join yourprefix_group_pricing gp on cu.customers_group_pricing=gp.group_id where cu.customers_id = 540]

    I thought I delt with this error in the past, but it looks like it's different, because the old fix that worked for me, isn't working anymore.

    If you want to see the problem, visit:
    http://www.canemasters.net/premium-c...-c-1_3_12.html


    Thank you zc community! You guys are great!

  2. #2

    Default Re: SQL DB error message 1146

    LOL, I just realized it's useless to hide the db name if it shows up for you on the page I showed you to visit to see the error message.

  3. #3

    Default Re: SQL DB error message 1146

    Thats strange... I just got home, and all of a sudden it's working properly....

    Maybe the sql db was slacking?? I know I deleted my web browsers cache when I made changes.

    Anyways, case closed.

  4. #4

    Default Re: SQL DB error message 1146

    Okay, nevermind, it's back, only this time, it's happening when I check out using the COWOA mod. I'm not sure if it's that mod that's actually causing the problem though. Please help if you can. I'm going to continue to investigate.

    Thank you.

  5. #5
    Join Date
    Oct 2006
    Location
    Alberta, Canada
    Posts
    4,571
    Plugin Contributions
    1

    Default Re: SQL DB error message 1146

    Were you first going to fix the problem as described by the big red error msg. at the top of your pages?

  6. #6

    Default Re: SQL DB error message 1146 after installing group_pricing_per_item and COWOA

    Yeah, I wasn't worried too much about that. I was modifying the config.php files.

    I fixed this. I went thru all of the php files included in the group_pricing_per_item_1.2.1a mod, and took out the code that was causing the problem. All is well and my new ZC 1.3.8 site is up and running.

 

 

Similar Threads

  1. 1146 Tables error after installing ultimate SEO URLs.
    By mohinder in forum All Other Contributions/Addons
    Replies: 22
    Last Post: 28 Oct 2013, 09:30 AM
  2. error message when installing SQL
    By gerand in forum Bug Reports
    Replies: 0
    Last Post: 6 Oct 2008, 09:10 AM
  3. Replies: 3
    Last Post: 21 Sep 2008, 12:45 AM
  4. Error message while installing (1064 - SQL syntax)
    By DataJack in forum Installing on a Windows Server
    Replies: 7
    Last Post: 29 Oct 2007, 11:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg