Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    41
    Plugin Contributions
    0

    database error 1050 Table 'upgrade_exceptions' already exists

    Hi all,

    I am installing a Zen Cart, and encounter the following installation problem:

    1050 Table 'upgrade_exceptions' already exists
    in:
    [CREATE TABLE `upgrade_exceptions` ( `upgrade_exception_id` smallint(5) NOT NULL auto_increment, `sql_file` varchar(50) default NULL, `reason` varchar(200) default NULL, `errordate` datetime default '0001-01-01 00:00:00', `sqlstatement` text, PRIMARY KEY (`upgrade_exception_id`) ) TYPE=MyISAM AUTO_INCREMENT=5 ;]

    I have searched the SQL file, there is only one place to create table `upgrade_exceptions`.

    Please kindly advise how to resolve this problem, thank you!

    Best regards,
    lioncity

  2. #2

    Default Re: 1050 Table 'upgrade_exceptions' already exists

    Is this your first attempt at installing, or did you start the process and then exit somewhere in the middle before completion?

    If you have access to phpMyAdmin try dumping the entire database, or try adding a table prefix when you attempt to install, as that will compensate if the standard table names are already created.
    Last edited by Neon Phoenix; 18 Aug 2008 at 04:58 AM. Reason: table prefix not database prefix
    Karl

 

 

Similar Threads

  1. Website exists already. Interested in integrating with ZC
    By Bob4786 in forum General Questions
    Replies: 3
    Last Post: 20 Oct 2011, 03:38 PM
  2. Skipped:cannot .... because it already exists
    By Wilfred in forum Installing on a Linux/Unix Server
    Replies: 26
    Last Post: 22 Nov 2010, 08:48 PM
  3. 1064 Error in SQL Syntax - upgrade_exceptions table
    By trave40 in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 26 Feb 2008, 10:20 PM
  4. Error: [DROP TABLE IF EXISTS upgrade_exceptions;]
    By trcc14 in forum Installing on a Linux/Unix Server
    Replies: 6
    Last Post: 17 Feb 2008, 08:46 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