Error when update 1.6.4 to 1.7.0

An error occurred running the upgrade. Please take a screen shot of this page and seek help. Statement number: 80. Error Message = [SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1’ for key ‘PRIMARY’]

Is there a reason why did you try to upgrade it to 1.7.0 and not to 1.7.7?
Just so you know you can do it straight to 1.7.7.

Did you follow upgrading instructions? http://xibo.org.uk/manual/en/release_notes_1.7.7.html

The reason I do this is so I can update the client, and then upgrade to the latest, and so not stop the monitors at once

when i try 1.7.7 this error hapen´s

An error occurred running the upgrade. Please take a screen shot of this page and seek help. Statement number: 80. Error Message = [SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1’ for key ‘PRIMARY’]. File = [Array]. SQL = [INSERT INTO bandwidthtype (bandwidthtypeid, name) VALUES (1, ‘Register’), (2, ‘Required Files’), (3, ‘Schedule’), (4, ‘Get File’), (5, ‘Get Resource’), (6, ‘Media Inventory’), (7, ‘Notify Status’), (8, ‘Submit Stats’), (9, ‘Submit Log’), (10, ‘Blacklist’), (11, ‘Screen Shot’)].

can i truncate this tables??

Have you seen the below topic yet? Not sure if it’s helpful in your situation, but it’s worth a read.

Apos limpar a tabela de banda consumida funcionou bem

Obrigado a todos