New installation

grahamsmythe · October 7th, 2010, 04:49 PM

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
Database: photopost

Any ideas?

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.

Chuck S · October 7th, 2010, 05:01 PM

zipData is not used with photopost so you could have deleted that also.

grahamsmythe · October 7th, 2010, 05:32 PM

Yeah - deleted that and Review Post installed a treat.

Removed zipData again (as Review Post installed it again) and then went to try to install Classifieds...

Unfortunately, we get this error...

Quote:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

When we click on 'configure' in step 4.

Any ideas?

Chuck S · October 7th, 2010, 09:06 PM

have you entered the correct table prefixes etc? some more info like integration type etc would help.

grahamsmythe · October 8th, 2010, 02:15 AM

Yeah, apologies for that - I should have given you a bit more info...

vBulletin 4.0.7
Latest version of Classifieds.
It's going into our 'photopost' database, with the cp_ prefix.

Have double checked the variables in the editable files, and they seem fine.

But clearly I must have done something wrong, as it's not installing correctly - and it did before, so any help would be much appreciated.

Chuck S · October 8th, 2010, 07:51 AM

url?

Usually that error would suggest the table prefix for vb was not entered correctly on step 4.

grahamsmythe · October 8th, 2010, 11:48 PM

HI Chuck

Not sure what was wrong, but I started again and in both cases - reviews and classifieds installed them into a separate database to photopost, so we now have three separate databases for your products. All seems to be fine now.

Just the small job of configuring everything!

Chuck S · October 9th, 2010, 09:06 AM

well I just did a complete new install on a site last night so there is no issues with the code more than likely as noted you missed a prefix or something in your initial install.

grahamsmythe · October 9th, 2010, 12:24 PM

Yes - no doubt it was something I did, but as I say, all operating correctly now. Cheers for your input.

Chuck S · October 9th, 2010, 01:06 PM

Graham have a good weekend.