PhotoPost Community - View Single Post - RP Installation MySQL error on existing zipData Table

Jeremy · November 20th, 2005, 06:08 PM

Step 3: MySQL error reported: [CREATE TABLE zipData (zipcode varchar(5) NOT NULL default '', ZipCodeType char(3) NOT NULL default '', City varchar(128) NOT NULL default '', CityType char(3) NOT NULL default '', State varchar(64) NOT NULL default '', StateCode varchar(5) NOT NULL default '', AreaCode int(5) NOT NULL default '0', lon varchar(8) NOT NULL default '', lat varchar(8) NOT NULL default '') TYPE=MyISAM]
Result: Table 'zipData' already exists

Hmm... I thought it was supposed to use rp_ (as I specified) for any tables it creates anyway?

What if a user already had a (non-PhotoPost/Classifieds/RP) zipData table here? I guess zipData for PP products wouldn't get installed in that case.

November 20th, 2005, 06:08 PM	#1 (permalink)
Jeremy Member Verified Customer Join Date: Nov 2005 Posts: 142	RP Installation MySQL error on existing zipData Table Step 3: MySQL error reported: [CREATE TABLE zipData (zipcode varchar(5) NOT NULL default '', ZipCodeType char(3) NOT NULL default '', City varchar(128) NOT NULL default '', CityType char(3) NOT NULL default '', State varchar(64) NOT NULL default '', StateCode varchar(5) NOT NULL default '', AreaCode int(5) NOT NULL default '0', lon varchar(8) NOT NULL default '', lat varchar(8) NOT NULL default '') TYPE=MyISAM] Result: Table 'zipData' already exists Hmm... I thought it was supposed to use rp_ (as I specified) for any tables it creates anyway? What if a user already had a (non-PhotoPost/Classifieds/RP) zipData table here? I guess zipData for PP products wouldn't get installed in that case.