Results 1 to 10 of 13

Hybrid View

  1. #1
    Join Date
    Oct 2010
    Posts
    7
    Plugin Contributions
    0

    Default Re: cannot create session when trying to update database

    Yes this outsmarting me is quite humbling.

    I think I fixed it before coming back here tho. I took the upgrade script from zc_install and altered it with my table prefixes and took it in to phpmyadmin and it ran successfully... the store no longer shows the warning to update so does that mean Im good to start reconfiguring and making a new template and such? or would you still recommend I try to move the old store then upgrade it for other reasons?

    I'm reluctant to move and upgrade because there was a lot of customizations in the old store that i want to sluff off. I really want to start with a fresh install but still require all my old products and customers etc.

    sorry for trying to break the rules; thanks for your help despite that.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: cannot create session when trying to update database

    zc_install relies on the /cache/ folder being writable and browser cookies being enabled in order to do its session handling.
    .

    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. #3
    Join Date
    Oct 2010
    Posts
    7
    Plugin Contributions
    0

    Default Re: cannot create session when trying to update database

    Quote Originally Posted by DrByte View Post
    zc_install relies on the /cache/ folder being writable and browser cookies being enabled in order to do its session handling.
    The installer gave me a green check next to the cache folder being writable and permission on that folder is currently 777. cookies are most definitely enabled and accepted as i can look at my browser cookies and I have a zenInstallid cookie set. My php.ini only allows session cookies and not the query string method.

    Right now everything is working fine, including loging into the admin section, but I failed to sluff off all the additional crap i was trying to leave behind since, apparently, much of that stuff was stored in the DB.

    With that said I think I'll attempt a fresh install on this server then import only the customers/products/orders over. is this a bad idea? I havent yet searched for a guide on this, but it seems like i ought to be able to pull it off ok.

    My only concern is the installer not letting me install for the same reason it wont let me upgrade the db. I am hopeful that removing my config files and emptying the database will solve that issue. I will now search for a way to import the customers/products/orders from a 1.3.8 db to a 1.3.9 db. Unless somebody wants to help out and post a link.

  4. #4
    Join Date
    Oct 2010
    Posts
    7
    Plugin Contributions
    0

    Default Re: cannot create session when trying to update database

    deleting the configure files and running the installer again worked. I was able to install a clean install without all the crap from the old store. Now I just need to find out what data I need to import to the new store and from where.

    I have this new database and all I want to import is customers/products/coupons/orders and related data. would it be best to insert into the appropriate tables all the data from my old 1.3.8 database or insert the data from the 1.3.9 database that I upgraded from the 1.3.8 database from my previous attempt?

  5. #5
    Join Date
    Jul 2005
    Location
    Upstate NY
    Posts
    22,010
    Plugin Contributions
    25

    Default Re: cannot create session when trying to update database

    I have seen people recommend using easy populate to export the info from the old store, massage as desired, and import into the new one.

  6. #6
    Join Date
    Oct 2010
    Posts
    7
    Plugin Contributions
    0

    Default Re: cannot create session when trying to update database

    Quote Originally Posted by gjh42 View Post
    I have seen people recommend using easy populate to export the info from the old store, massage as desired, and import into the new one.
    excellent info, thanks. Do you know if that can import from an older version to a newer one? I will look into this.

    Edit: looked into EP and it lists 1.3.8 for compatibility...
    Last edited by brad_at_foreverybody; 21 Oct 2010 at 07:32 PM.

  7. #7
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: cannot create session when trying to update database

    As for EP, it only handles products and categories. Not attributes or customers/orders.
    .

    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.

  8. #8
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: cannot create session when trying to update database

    Quote Originally Posted by brad_at_foreverybody View Post
    With that said I think I'll attempt a fresh install on this server then import only the customers/products/orders over. is this a bad idea?
    Every time I see someone try to do that they bork it up.

    Well, actually, some don't: the ones who don't have any problem with it are the ones who don't have to ask "how" because they already understand databases and relational integrity since they do it every day.

    If that's not you, then it's advisable that you wipe your new database, import the old one, run zc_install to do the database-upgrade, and then carry on.


    You could remove old database components added by addons by running any provided uninstall scripts that might have been published by the addons' authors. Since you haven't elaborated on anything about the kinds of things you think you need to remove, it's hard to guide you about that.
    .

    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.

 

 

Similar Threads

  1. trying to create new database
    By jenbullfrog in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 24 May 2010, 05:38 PM
  2. cannot update database
    By inkuyo in forum Upgrading from 1.3.x to 1.3.9
    Replies: 7
    Last Post: 8 Jan 2008, 12:40 AM
  3. Cannot Update Database
    By f_raze1 in forum Installing on a Linux/Unix Server
    Replies: 3
    Last Post: 22 Mar 2007, 02:59 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