Updated 2.02.02 to 2.10 - 3 errors

2Bob · Hangin' Around Joined: Jan 24, 2006 Posts: 25

Hi,

Firstly let me congratulate Raven and all involved for what must of been a monumental task in developing this distro.

To give a little history...
Some time ago i converted my nuke7.8 install to RN2.02, (and have never looked back) Tonight I decided to look at the upgrade to RN2.10. I firstly created a complete duplicate of my current site and DB to experiment with, did the conversion and was absolutely amazed at the ease so far. I intend test and go through this process once ot twice more before actually updating my "LIVE" site.

I have three errors in the first step of updating the tables:

1) ALTER TABLE nuke_banner ADD INDEX `bid` (bid); FAILED. MySQL reported: Duplicate key name 'bid'

2) CREATE TABLE nuke_cities (id mediumint(4) NOT NULL default '0', local_id mediumint(3) NOT NULL default '0', city varchar(65) NOT NULL default '', cc char(2) NOT NULL default '', country varchar(35) NOT NULL default '', PRIMARY KEY (id)); FAILED. MySQL reported: Table 'nuke_cities' already exists

3) city insert FAILED. MySQL reported: Duplicate entry '1' for key 1Can someone advise me what this would mean and if they are a problem ? Everything seems to work OK so far....

Also in updating the IP2country I received this error"

The exact error message that your MySQL server reported is:
MySQL Error # 4 = Duplicate entry '982745088-982753279' for key 1

One last question while I am here, I read somewhere about a "resend email" feature in this distro, although I cant see anything in admin etc.

Thanks in advance Smile

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

well what happens is ,or you are trying to create tables that already exist,and you try to insert info into the database thats already in there...

1) ALTER TABLE nuke_banner ADD INDEX `bid` (bid); FAILED. MySQL reported: Duplicate key name 'bid'
it seems that BID already exists

2) CREATE TABLE nuke_cities (id mediumint(4) NOT NULL default '0', local_id mediumint(3) NOT NULL default '0', city varchar(65) NOT NULL default '', cc char(2) NOT NULL default '', country varchar(35) NOT NULL default '', PRIMARY KEY (id)); FAILED. MySQL reported: Table 'nuke_cities' already exists

indeed...Table 'nuke_cities' already exists

3) city insert FAILED. MySQL reported: Duplicate entry '1' for key 1
city already excist...

personaly i would say.....
if you dont have that much banned friends in sentinel you can easely drop it and run a clean sentinel install.
that takes care of all the above errors as well..

fkelly · Posted: Sun Mar 25, 2007 3:08 pm

I believe that the genesis or cause of your errors may be because you are converting from a version of Nuke that had the advertising module and that had the index on bid in banners and the cities table already in it. So you should be okay as Hitwalker indicated.

And as for IPcountry, you don't need to drop all your sentinel tables. Just drop that table and run that step in the Installsql.php step of the installation. You should then be cooking with gas.

montego · Posted: Mon Mar 26, 2007 6:33 am

Do not "drop" that table. Instead, "truncate" it and then re-run the last step only in the installSQL.php.