开云体育

confirmed.

UNIQUE constraint failed:

You already have the 8m band in the band table. I don't want to speculate on how it was done, but it's not an installation.

You have two options how to fix it:

1) You will remove the 8m band record from the band table via an external application.

2) If you don't know how to do it, send me your database to my email (zip it before sending if it is a large database). I'll edit it and send it back. Where you can find the database is on the Wiki

.

so 30. 11. 2024 v?20:18 odesílatel Bent Andersen via <eskolin=[email protected]> napsal:

here you have it:

20:16:50.101 [DEBUG ? ] [0x4150] ? ? ? ? ? ? [qlog.core.migration.function.entered] => *** [bool __cdecl Migration::backupDatabase(bool):..\QLog\core\Migration.cpp:85]
20:16:50.101 [DEBUG ? ] [0x4150] ? ? ? ? ? ? ? ? ? ? ?[qlog.core.migration.runtime] => The last backup date QDate("2024-11-30") Force false [bool __cdecl Migration::backupDatabase(bool):..\QLog\core\Migration.cpp:94]
20:16:50.101 [DEBUG ? ] [0x4150] ? ? ? ? ? ? ? ? ? ? ?[qlog.core.migration.runtime] => Backup skipped [bool __cdecl Migration::backupDatabase(bool):..\QLog\core\Migration.cpp:101]
20:16:50.102 [DEBUG ? ] [0x4150] ? ? ? ? ? ? [qlog.core.migration.function.entered] => *** [bool __cdecl Migration::run(void):..\QLog\core\Migration.cpp:21]
20:16:50.103 [DEBUG ? ] [0x4150] ? ? ? ? ? ? [qlog.core.migration.function.entered] => *** [int __cdecl Migration::getVersion(void):..\QLog\core\Migration.cpp:188]
20:16:50.103 [DEBUG ? ] [0x4150] ? ? ? ? ? ? ? ? ? ? ?[qlog.core.migration.runtime] => 30 [int __cdecl Migration::getVersion(void):..\QLog\core\Migration.cpp:194]
20:16:50.103 [DEBUG ? ] [0x4150] ? ? ? ? ? ? ? ? ? ? ?[qlog.core.migration.runtime] => Backup before migration [bool __cdecl Migration::run(void):..\QLog\core\Migration.cpp:38]
20:16:50.103 [DEBUG ? ] [0x4150] ? ? ? ? ? ? [qlog.core.migration.function.entered] => *** [bool __cdecl Migration::backupDatabase(bool):..\QLog\core\Migration.cpp:85]
20:16:50.103 [DEBUG ? ] [0x4150] ? ? ? ? ? ? ? ? ? ? ?[qlog.core.migration.runtime] => The last backup date QDate("2024-11-30") Force true [bool __cdecl Migration::backupDatabase(bool):..\QLog\core\Migration.cpp:94]
20:16:50.103 [DEBUG ? ] [0x4150] ? ? ? ? ? ? ? ? ? ? ?[qlog.core.migration.runtime] => QList(QFileInfo(C:\Users\Bent\AppData\Local\hamradio\QLog\qlog_backup_20240919153734.adx), QFileInfo(C:\Users\Bent\AppData\Local\hamradio\QLog\qlog_backup_20240930181517.adx), QFileInfo(C:\Users\Bent\AppData\Local\hamradio\QLog\qlog_backup_20241007.adx), QFileInfo(C:\Users\Bent\AppData\Local\hamradio\QLog\qlog_backup_20241007145137.adx), QFileInfo(C:\Users\Bent\AppData\Local\hamradio\QLog\qlog_backup_20241018.adx), QFileInfo(C:\Users\Bent\AppData\Local\hamradio\QLog\qlog_backup_20241102.adx), QFileInfo(C:\Users\Bent\AppData\Local\hamradio\QLog\qlog_backup_20241112.adx), QFileInfo(C:\Users\Bent\AppData\Local\hamradio\QLog\qlog_backup_20241119.adx), QFileInfo(C:\Users\Bent\AppData\Local\hamradio\QLog\qlog_backup_20241124.adx), QFileInfo(C:\Users\Bent\AppData\Local\hamradio\QLog\qlog_backup_20241130.adx)) [bool __cdecl Migration::backupDatabase(bool):..\QLog\core\Migration.cpp:125]
20:16:50.103 [DEBUG ? ] [0x4150] ? ? ? ? ? ? ? ? ? ? ?[qlog.core.migration.runtime] => Exporting a Database backup to ?"C:/Users/Bent/AppData/Local/hamradio/QLog/qlog_backup_20241130.adx" [bool __cdecl Migration::backupDatabase(bool):..\QLog\core\Migration.cpp:169]
20:16:50.988 [DEBUG ? ] [0x4150] ? ? ? ? ? ? ? ? ? ? ?[qlog.core.migration.runtime] => Database backup finished [bool __cdecl Migration::backupDatabase(bool):..\QLog\core\Migration.cpp:180]
20:16:50.988 [DEBUG ? ] [0x4150] ? ? ? ? ? ? ? ? ? ? ?[qlog.core.migration.runtime] => Starting database migration [bool __cdecl Migration::run(void):..\QLog\core\Migration.cpp:41]
20:16:51.000 [DEBUG ? ] [0x4150] ? ? ? ? ? ? [qlog.core.migration.function.entered] => *** [int __cdecl Migration::getVersion(void):..\QLog\core\Migration.cpp:188]
20:16:51.000 [DEBUG ? ] [0x4150] ? ? ? ? ? ? ? ? ? ? ?[qlog.core.migration.runtime] => 30 [int __cdecl Migration::getVersion(void):..\QLog\core\Migration.cpp:194]
20:16:51.000 [DEBUG ? ] [0x4150] ? ? ? ? ? ? [qlog.core.migration.function.entered] => *** [bool __cdecl Migration::migrate(int):..\QLog\core\Migration.cpp:230]
20:16:51.000 [DEBUG ? ] [0x4150] ? ? ? ? ? ? ? ? ? ? ?[qlog.core.migration.runtime] => migrate to 31 [bool __cdecl Migration::migrate(int):..\QLog\core\Migration.cpp:232]
20:16:51.000 [DEBUG ? ] [0x4150] ? ? ? ? ? ? [qlog.core.migration.function.entered] => *** [bool __cdecl Migration::runSqlFile(class QString):..\QLog\core\Migration.cpp:257]
20:16:51.000 [DEBUG ? ] [0x4150] ? ? ? ? ?[qlog.core.migration.function.parameters] => ":/res/sql/migration_031.sql" [bool __cdecl Migration::runSqlFile(class QString):..\QLog\core\Migration.cpp:259]
20:16:51.000 [DEBUG ? ] [0x4150] ? ? ? ? ? ? ? ? ? ? ?[qlog.core.migration.runtime] => QList("INSERT INTO bands (name, start_freq, end_freq, enabled) VALUES ('8m',40.0, 45.0, 0)", " ") [bool __cdecl Migration::runSqlFile(class QString):..\QLog\core\Migration.cpp:265]
20:16:51.000 [DEBUG ? ] [0x4150] ? ? ? ? ? ? ? ? ? ? ?[qlog.core.migration.runtime] => "INSERT INTO bands (name, start_freq, end_freq, enabled) VALUES ('8m',40.0, 45.0, 0)" [bool __cdecl Migration::runSqlFile(class QString):..\QLog\core\Migration.cpp:272]
20:16:51.000 [DEBUG ? ] [0x4150] ? ? ? ? ? ? ? ? ? ? ?[qlog.core.migration.runtime] => QSqlError("2067", "Kunne ikke hente r?kke", "UNIQUE constraint failed: ") [bool __cdecl Migration::runSqlFile(class QString):..\QLog\core\Migration.cpp:277]?

Den l?r. 30. nov. 2024 kl. 20.10 skrev ok1mlg via <ok1mlg=[email protected]>:

OK...windows...

1) start command line

cmd

2) jump to QLog system dir

cd c:\Program Files\QLog

3) type follow command

set QT_LOGGING_RULES=qlog.core.migration.*=true

4) start qlog with following parameters

qlog.exe > c:\Users\<YOUR_HOME>\debug.txt 2>&1

Please, replace <YOUR_HOME> the folder, where you have your Home dir.

It will generate a debug.txt file in your home directory. Please, send me the file.

Unfortunately, I did not find any issue when I tested this version under Linux and Windows and again I retested this version under Windows from QLog v0.36. So it seems that your database is "unexpectedly" different.

so 30. 11. 2024 v?19:21 odesílatel Bent Andersen via <eskolin=[email protected]> napsal:

I use this one for windows:

and install?it as standard !

Ben?

Den l?r. 30. nov. 2024 kl. 19.17 skrev ok1mlg via <ok1mlg=[email protected]>:

you have to specify the path to the qlog. Which package system do you use? Deb, Flatpak, RPM?

so 30. 11. 2024 v?18:58 odesílatel Bent Andersen via <eskolin=[email protected]> napsal:

I cannot?start Qlog.... and I did not add the 8m Band to the?database

if I try to run this cmd: QT_LOGGING_RULES=qlog.core.migration.*=true qlog from a cmd-line I get the error that the file is not found !

Ben

Den l?r. 30. nov. 2024 kl. 18.07 skrev ok1mlg via <ok1mlg=[email protected]>:

Did you manually add the 8m band to the database? If not, please, send me the debug output for Migration - execute QLog manually from a command line :? QT_LOGGING_RULES=qlog.core.migration.*=true qlog

so 30. 11. 2024 v?17:46 odesílatel Bent Andersen via <eskolin=[email protected]> napsal:

sorry but last working ver is for me 0.40 and there is no 8m band in it....

how to fix this problem ??? and I havent got a copy of 0.40 :-(

Ben

Den l?r. 30. nov. 2024 kl. 17.37 skrev ok1mlg via <ok1mlg=[email protected]>:

If you already have an 8m band in the databa, then remove it. The release adds the record for it.

so 30. 11. 2024 v?17:31 odesílatel Bent Andersen via <eskolin=[email protected]> napsal:

just updated to v0.40.1 and get this screen:

?