We haven't used Review Post or Classifieds for a while now, and have decided to completely re-install them and start again. We have been into www.ourdomain.com/pma
and in our PhotoPost database, we have removed all the tables with rp_ and cp_ and just left all the photopost ones.
We've re-installed all the files, filled out the variables in config-inc.php and config-intr.php
Unfortunately when we run the install file, we get the following error:
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', lat varchar(8) NOT NULL default '', lon varchar(8) NOT NULL default '') TYPE=MyISAM]
Result: Table 'zipData' already exists
Interestingly, on the PhotoPost database, zipData was already there. Should I have deleted this along with all the cp_ and rp_ files, or would I also need that file for our PhotoPost installation (which is currently working brilliantly!).
Look forward to hearing from anyone.