Project

General

Profile

upgrade error

Added by skorc99 almost 3 years ago

ERROR 1062 (23000) at line 4 in file: '/home/pi/domotiga/upgrade/10021to10022.sql': Duplicate entry '671' for key 'PRIMARY'

what is wrong ?


Replies (6)

RE: upgrade error - Added by wwolkers almost 3 years ago

Looks like you already have a devicetype with id 671.
Did you add any devicetypes yourself? Or did you try the upgrade before?

try a 'select * from devicetypes where id=671' on your sql server

RE: upgrade error - Added by skorc99 almost 3 years ago

i didnt add a device.

Before it was no problem upgrading.

How to do this ?

try a 'select * from devicetypes where id=671' on your sql server

RE: upgrade error - Added by skorc99 almost 3 years ago

i also get this msg when running JSONRPC...

FSettingsJSONRPC.LoadSettings.166: Unknown field: sslcertificate_id
FMain.MenuSettingsJSONRPC_Click.2160

Is this because database is not upgraded..

Can you help me with SQL ?

RE: upgrade error - Added by skorc99 almost 3 years ago

hello,

i am stuck on 21 now..

error:
ERROR 1050 (42S01) at line 41 in file: '/home/pi/domotiga/upgrade/10021to10022.sql': Table 'sslcertificate' already exists

how to fix this ?

RE: upgrade error - Added by Alexie almost 3 years ago

If the DB isn't top secret, can you email it to me at ualex73 [at] gmail [dot] com, then i will sent you a fixed DB back.

RE: upgrade error - Added by skorc99 almost 3 years ago

i have send it...

    (1-6/6)