View Single Post
Old November 20th, 2005, 10:54 PM   #5 (permalink)
Jeremy
Member
Verified Customer
 
Join Date: Nov 2005
Posts: 142
Quote:
Originally Posted by Chuck S
Well there would be no way to fix that as its not really an issue.

It is just one of those things that like you noticed it since the table exists and came here to post. If someone posts about it we can answer.

You would get similiar issues if you run install twice or an upgrade twice just a mysql warning saying it exists
Of course it can be fixed.

It's a seperate sql file that you import right?

Why not import all the RP sql, then before attempting to import the zip.sql file you would just check to see if it exists & if it does, confirm that the a couple or all of the fields within it are what you expect - then don't attempt to import it & you wont get the error.


BETTER YET, if it was doing what it was _supposed_ to be doing, then it wouldn't have gotten the error in the first place.

It should have created the database as rp_zipData since ALL tables created/imported by RP should use the rp_ table prefix that I was prompted for and specified.

The reason for using those table prefixes is to keep things oragnized and also to keep things like this from happening.

In this case it happened to be OK because the existing table was another of your own and interchangeable - but if I had another mod to my VB3.5.1 with a table named zipData this would not have been the case.

Last edited by Jeremy; November 20th, 2005 at 11:00 PM.
Jeremy is offline   Reply With Quote