Page 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 of 32
  1. #11
    Join Date
    Sep 2005
    Posts
    52
    Plugin Contributions
    0

    Default Re: "table doesn't exist" errors after 1.3.7 install

    Okay - I've changed the prefix in my config from nothing to "zen" which is what the prefix is in the restored database. I've followed your instructions to delete the tables, restore teh database & re-run zcinstall choosing the "Upgrade Cfg Files" option, rather than "Install".

    When I get to the "Database Setup" page, I kept everything the same:
    Host = mysql.butternugsquash.com
    Username: maggiesmom1
    Password: XXXXXXX
    DB Name: bsdzencart
    DB Sessions: Yes
    Sql Cache: None
    Session/SQL Cache directory: /home/maggiesmom1/butternugsquash.com/store/cache

    When I click on "Save DB Settings", I get this error:
    1146 Table 'bsdzencart.zenconfiguration' doesn't exist
    in:
    [update zenconfiguration set configuration_value='/home/maggiesmom1/butternugsquash.com/store/cache' where configuration_key='SESSION_WRITE_DIRECTORY']

  2. #12
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: "table doesn't exist" errors after 1.3.7 install

    was the old prefix "zen" or "zen_" ?
    .

    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.

  3. #13
    Join Date
    Sep 2005
    Posts
    52
    Plugin Contributions
    0

    Default Re: "table doesn't exist" errors after 1.3.7 install

    It was "zen_"

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

    Default Re: "table doesn't exist" errors after 1.3.7 install

    Quote Originally Posted by maggiesmom1 View Post
    I've changed the prefix in my config from nothing to "zen" which is what the prefix is in the restored database.

    1146 Table 'bsdzencart.zenconfiguration' doesn't exist
    in:
    [update zenconfiguration set ....
    vs
    It was "zen_"
    ... note the underscore.
    Quote Originally Posted by DrByte
    1. In your "old" configure.php files, what was the setting for DB_PREFIX ?
    2. In your "new" configure.php files, what is the setting for DB_PREFIX ?

    They need to match.
    .

    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
    Sep 2005
    Posts
    52
    Plugin Contributions
    0

    Default Re: "table doesn't exist" errors after 1.3.7 install

    Do you mean I need to change the "zen" in the config to "zen_", or is there something else I need to do?

  6. #16
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: "table doesn't exist" errors after 1.3.7 install

    Quote Originally Posted by maggiesmom1 View Post
    Do you mean I need to change the "zen" in the config to "zen_"
    Yes .
    .

    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.

  7. #17
    Join Date
    Sep 2005
    Posts
    52
    Plugin Contributions
    0

    Default Re: "table doesn't exist" errors after 1.3.7 install

    Okay - did that. It's still giving me this:
    1146 Table 'bsdzencart.zenconfiguration' doesn't exist
    in:
    [update zenconfiguration set configuration_value='/home/maggiesmom1/butternugsquash.com/store/cache' where configuration_key='SESSION_WRITE_DIRECTORY']

  8. #18
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: "table doesn't exist" errors after 1.3.7 install

    You must have changed "zen" to "zen_" in the wrong file, or the uploaded change didn't get saved/uploaded properly.
    .

    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.

  9. #19
    Join Date
    Sep 2005
    Posts
    52
    Plugin Contributions
    0

    Default Re: "table doesn't exist" errors after 1.3.7 install

    I changed it in includes/configure.php
    I then saved it to my HD, doublechecked it to be sure the change had been made, deleted the original configure.php that's in includes/ and uploaded the one saved to my hard drive.
    I then viewed includes/configure.php & it's correct.

  10. #20
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: "table doesn't exist" errors after 1.3.7 install

    What's the setting for HTTP_SERVER and DIR_WS_CATALOG and DIR_FS_CATALOG in that configure.php file ?
    .

    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.

 

 
Page 2 of 4 FirstFirst 1234 LastLast

Similar Threads

  1. EZ Pages disappeared and get "Table 'ezpages_content' doesn't exist" error
    By ilmarchez in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 19 Nov 2011, 05:34 AM
  2. "1146 Table 'beeworks_zc1.configuration' doesn't exist" when moving my site
    By newbeeman in forum Installing on a Windows Server
    Replies: 11
    Last Post: 14 Jul 2009, 02:17 AM
  3. Replies: 6
    Last Post: 7 Apr 2009, 12:30 AM
  4. table error please help: "table 'sessions' doesn't exist"
    By ebydrc in forum General Questions
    Replies: 3
    Last Post: 6 Apr 2008, 06:13 AM

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