2.0.3 install and upgrade issue

[rhinoman]

I'm just looking to upgrade a site of mine running rc3 so I tried a dry run on a copy of my site setup at a subdomain, tested and working.

When running the upgrade.php i get these errors at the bottom of the sql output text although it does say successful upgrade.

Error: MySQL #1062: Duplicate entry '' for key 3

Error: MySQL #1054: Unknown column 'admin_username' in 'field list'

Error: MySQL #1062: Duplicate entry '100002-1' for key 1

Error: MySQL #1062: Duplicate entry '100002-2' for key 1

Error: MySQL #1062: Duplicate entry '100002-3' for key 1

Error: MySQL #1062: Duplicate entry '100003-1' for key 1

Error: MySQL #1062: Duplicate entry '100003-2' for key 1

Error: MySQL #1062: Duplicate entry '100003-3' for key 1

The site comes up ok but I cannot access the admin panel, I get this error using chrome as a browser

This web page has a redirect loop.

The web page at null has resulted in too many redirects. Clearing your cookies for this site may fix the problem. If not, it is possibly a server configuration issue and not a problem with your computer.

Here are some suggestions:
Reload this web page later.
Learn more about this problem.
More information on this error

I tried a clean install and still cannot get into the admin panel getting the exact same message, any clues to what I am missing?

Thanks

John

[ridexbuilder]

Try deleting files from the cache directory. Also, records in the cache table, using phpmyadmin.

[rhinoman]

Try deleting files from the cache directory. Also, records in the cache table, using phpmyadmin.

Tried that in the upgrade site and no change, no data in the cache of the new install.

[michael_s]

Error: MySQL #1062: Duplicate entry '' for key 3

Error: MySQL #1054: Unknown column 'admin_username' in 'field list'

This means you have more than one admin account. The admin username is a UNIQUE field, but because you have more than one admin account, you will have to first run this on your admin table:

ALTER TABLE admin
    ADD admin_username varchar(32) NOT NULL DEFAULT '' AFTER admin_groups_id;

Then, edit the records in the table, and you will need to manually enter a unique admin username in each admin record.

Once you have done that (via phpmyadmin is the easiest for most people), finish the admin table update by running this sql:

ALTER TABLE admin
ADD UNIQUE admin_username (admin_username);

That will get your access to the admin working.

Error: MySQL #1062: Duplicate entry '100002-1' for key 1

Error: MySQL #1062: Duplicate entry '100002-2' for key 1

Error: MySQL #1062: Duplicate entry '100002-3' for key 1

Error: MySQL #1062: Duplicate entry '100003-1' for key 1

Error: MySQL #1062: Duplicate entry '100003-2' for key 1

Error: MySQL #1062: Duplicate entry '100003-3' for key 1

This relates to this query in the upgrade script:

INSERT INTO orders_status (orders_status_id,language_id,orders_status_name,public_flag,downloads_flag) VALUES ('2','3','Proceso','1','1');
INSERT INTO orders_status (orders_status_id,language_id,orders_status_name,public_flag,downloads_flag) VALUES ('100000','3','Updated','1','0');
INSERT INTO orders_status (orders_status_id,language_id,orders_status_name,public_flag,downloads_flag) VALUES ('100002','1','Preparing [PayPal Standard]','0','0');
INSERT INTO orders_status (orders_status_id,language_id,orders_status_name,public_flag,downloads_flag) VALUES ('100002','2','Preparing [PayPal Standard]','0','0');
INSERT INTO orders_status (orders_status_id,language_id,orders_status_name,public_flag,downloads_flag) VALUES ('100002','3','Preparing [PayPal Standard]','0','0');
INSERT INTO orders_status (orders_status_id,language_id,orders_status_name,public_flag,downloads_flag) VALUES ('100003','1','Sofortüberweisung Vorbereitung','0','0');
INSERT INTO orders_status (orders_status_id,language_id,orders_status_name,public_flag,downloads_flag) VALUES ('100003','2','Sofortüberweisung Vorbereitung','0','0');
INSERT INTO orders_status (orders_status_id,language_id,orders_status_name,public_flag,downloads_flag) VALUES ('100003','3','Sofortüberweisung Vorbereitung','0','0');

They just add new order-status entries and should not cause any problems with the running of your site.

[mgrooten]

I ran into the same problem. Michael's solution was spot on. Thanks!!!!
Marinus

[rhinoman]

Michael,

Couldn't make that work for me

I also tried it another way which was to delete the other user/admin accounts to just leave one before backing up the database. That got rid of the associated admin error just leaving the sql error that you said wouldn't effect the site. I still cannot get in to the admin and still get the redirect loop error in my browser?

I've now resorted to a clean install here which comes up fine but cannot access the admin. I've also trioed accessing from another machine to make sure its not a machine/cookie issue.

Any ideas?

thanks

[rhinoman]

Now I'm really confuesd, my clean install site allowed me to log in to the admin today Strangely I changed nothing since the last post

[michael_s]

A clean install will not have this issue, as it doesn't have the upgrade to deal with.