Thread: Database Prefix

Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2006
    Location
    Rotherham, UK
    Posts
    143
    Plugin Contributions
    0

    Default Database Prefix

    hiya
    I had zencart installed and working on one domain name.
    I have now decided to change hosts and to put the install on a different domain.
    Before I cancelled my hosting on domain 1, I backed up all the files and also backed up the database.
    I have installed zencart on domain 2 and am in the process of transferring the old files to the new domain.
    I deleted all the database entries on the new install and imported the old database sql file from domain 1.
    the problem i am having is this:
    when I installed zencart on domain 2 it asked for domain prefix and i put esparkle_
    when i import the previous database, the tables (or whatever they are called) have no prefix on them. I cant see a way to rename them and add esparkles_ to them, so is there a way i can go back and delete the esparkle_ prefix from the installation of zencart or do i have to delete and start over ?

    does all that make sense?

    Many thanks for any help you can give
    Erica xx
    Last edited by Erica; 21 Jul 2007 at 05:24 PM. Reason: spelling

  2. #2
    Join Date
    Jul 2006
    Location
    Rotherham, UK
    Posts
    143
    Plugin Contributions
    0

    Default Re: Database Prefix

    well i figured out that bit - i needed to change the configure files in admin/includes and includes .. but now i have hit another snag.
    you load up the site: www.esparkles.co.uk and at the top i get this error:

    Warning: session_save_path() [function.session-save-path]: open_basedir restriction in effect. File(/home/costumej/public_html/cache) is not within the allowed path(s): (/home/esparkle:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/esparkle/public_html/includes/functions/sessions.php on line 145

    Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/esparkle/public_html/includes/functions/sessions.php:145) in /home/esparkle/public_html/includes/functions/sessions.php on line 102

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/esparkle/public_html/includes/functions/sessions.php:145) in /home/esparkle/public_html/includes/functions/sessions.php on line 102

    Warning: Cannot modify header information - headers already sent by (output started at /home/esparkle/public_html/includes/functions/sessions.php:145) in /home/esparkle/public_html/includes/init_includes/init_templates.php on line 78

    does anyone know what all that means in none coder terms ?
    Thanks loads
    Erica xx

  3. #3
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Database Prefix

    Some related FAQs
    https://www.zen-cart.com/tutorials/index.php?article=54
    https://www.zen-cart.com/tutorials/index.php?article=99
    https://www.zen-cart.com/tutorials/i...hp?article=101
    https://www.zen-cart.com/tutorials/i...hp?article=122

    Your session-directory in your Admin->Configuration->Sessions is still pointing to the old server setup.
    These FAQs talk about ways of fixing 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.

  4. #4
    Join Date
    Jul 2006
    Location
    Rotherham, UK
    Posts
    143
    Plugin Contributions
    0

    Default Re: Database Prefix

    Quote Originally Posted by DrByte View Post
    Your session-directory in your Admin->Configuration->Sessions is still pointing to the old server setup.
    These FAQs talk about ways of fixing that.
    Nice one, thank you Dr Byte.
    It wouldnt allow me to change the sessions bit in admin, so I downloaded that fix cache file and ran it. I then deleted the log files or something because they were older than 2 months old and everything is running great (as far as my untrained eye can see anyway lol)
    Theres no errors showing now, and all my customers and their previous orders are showing, as is my catalogue

    Thanks again for your help
    Erica xx

 

 

Similar Threads

  1. add prefix to database
    By balihr in forum General Questions
    Replies: 8
    Last Post: 10 Nov 2009, 12:37 AM
  2. Add database prefix...
    By Alex Clarke in forum General Questions
    Replies: 5
    Last Post: 9 Aug 2006, 09:49 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