Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17
  1. #11
    Join Date
    Mar 2009
    Posts
    15
    Plugin Contributions
    0

    Default Re: Fatal error: 1146:Table plugin_control' doesn't exist

    I figured out my issue. In turned out when I uploaded(sftp) the zc_install folder it set the permission wrong on the files/folders. Therefore I got the 500 Internal error do to file permissions being wrong.

    Issue resolved now.

    thanks, Mark.

  2. #12
    Join Date
    Oct 2006
    Location
    Worcester, MA
    Posts
    422
    Plugin Contributions
    0

    Default Re: Fatal error: 1146:Table plugin_control' doesn't exist

    I'm having a very similar issue to that described in the original post of this thread. I am upgrading a shop from 1.5.6c to 1.5.7b

    I did a clean install with test data and that was fine. Then I proceeded on the step of making a copy of the live store data and changing the config files to that DB. I expected to be prompted to upgrade the database by running zc_install. But instead I'm getting the same error about missing plug_in table in the log files.

    I'm assuming some folks have solved this. Is the solution to first upgrade to an earlier version? If so, which version? Would it be possible to just add the missing plug_in tables? I have quite a few mods to make and I'd hate to have to re-do the hours of work I already did on 1.5.7b and do it all again on an earlier version.

    Any advice? I read through this thread a couple of times I couldn't quite pick out what solved the issue the original poster reported.

  3. #13
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,083
    Plugin Contributions
    7

    Default Re: Fatal error: 1146:Table plugin_control' doesn't exist

    Quote Originally Posted by earmsby View Post
    I'm having a very similar issue to that described in the original post of this thread. I am upgrading a shop from 1.5.6c to 1.5.7b

    I did a clean install with test data and that was fine. Then I proceeded on the step of making a copy of the live store data and changing the config files to that DB. I expected to be prompted to upgrade the database by running zc_install. But instead I'm getting the same error about missing plug_in table in the log files.

    I'm assuming some folks have solved this. Is the solution to first upgrade to an earlier version? If so, which version? Would it be possible to just add the missing plug_in tables? I have quite a few mods to make and I'd hate to have to re-do the hours of work I already did on 1.5.7b and do it all again on an earlier version.

    Any advice? I read through this thread a couple of times I couldn't quite pick out what solved the issue the original poster reported.
    i see no need to re-do all of your hours of work.

    using your favorite db admin tool, i would look over and execute the SQL statements in the following section of code:

    https://github.com/zencart/zencart/b....sql#L261-L356

    best.
    help with WCAG is now here! PM if you want some help with this. (or any ZC issue).
    if you feel so inclined, feel free to send some cake....

  4. #14
    Join Date
    Jan 2004
    Posts
    66,350
    Blog Entries
    7
    Plugin Contributions
    271

    Default Re: Fatal error: 1146:Table plugin_control' doesn't exist

    and maybe inspect your /logs directory for errors logged by zcInstall during the upgrade
    and check your database's upgrade_exceptions table to find out what statements failed
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #15
    Join Date
    Oct 2006
    Location
    Worcester, MA
    Posts
    422
    Plugin Contributions
    0

    Default Re: Fatal error: 1146:Table plugin_control' doesn't exist

    thanks Dr. Byte. Once I replace the database in the config file, I never get to the install/upgrade. I just get an error on the screen which is why I checked into the log files. I will try running the SQL statements mentioned by carlwhat.

  6. #16
    Join Date
    Oct 2006
    Location
    Worcester, MA
    Posts
    422
    Plugin Contributions
    0

    Default Re: Fatal error: 1146:Table plugin_control' doesn't exist

    Thank you very much for pointing me to this. I ran those SQL statements (adding my table prefix) and then tried the install again and now I was able to successfully update the database.

  7. #17
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,083
    Plugin Contributions
    7

    Default Re: Fatal error: 1146:Table plugin_control' doesn't exist

    Quote Originally Posted by earmsby View Post
    Thank you very much for pointing me to this. I ran those SQL statements (adding my table prefix) and then tried the install again and now I was able to successfully update the database.
    help with WCAG is now here! PM if you want some help with this. (or any ZC issue).
    if you feel so inclined, feel free to send some cake....

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. v155 PHP Fatal error: 1146:, table doesn't exist
    By cubmanky in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 4 Nov 2018, 02:10 PM
  2. v150 PHP Fatal error: 1146:Table 'products_attrib_cross_validation' doesn't exist
    By diamondminer in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 24 Feb 2013, 03:42 PM
  3. v151 upgrading error 1146 table doesn't exist
    By scottrdj in forum Upgrading to 1.5.x
    Replies: 4
    Last Post: 31 Dec 2012, 03:05 PM
  4. Replies: 3
    Last Post: 27 Jul 2011, 08:32 PM
  5. 1146 Table error zenconfiguration doesn't exist
    By gayelston in forum Installing on a Linux/Unix Server
    Replies: 6
    Last Post: 1 Dec 2007, 10:26 PM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR