magicbug
commented
6 years ago Another thing I have seen is that I can't actually import my logbook
I suspect its probably me, its late :p
I get the following error
`A Database Error Occurred Error Number: 1406
Data too long for column 'COL_DXCC' at row 1
INSERT INTO TABLE_HRD_CONTACTS_V01 (COL_TIME_ON, COL_TIME_OFF, COL_CALL, COL_BAND, COL_FREQ, COL_MODE, COL_RST_RCVD, COL_RST_SENT, COL_NAME, COL_COMMENT, COL_SAT_NAME, COL_SAT_MODE, COL_GRIDSQUARE, COL_COUNTRY, COL_QTH, COL_PROP_MODE, COL_DISTANCE, COL_FREQ_RX, COL_BAND_RX, COL_ANT_AZ, COL_ANT_EL, COL_STX_STRING, COL_SRX_STRING, COL_IOTA, COL_QSLRDATE, COL_QSL_RCVD, COL_QSLSDATE, COL_QSL_SENT, COL_LOTW_QSL_SENT, COL_LOTW_QSL_RCVD, COL_DXCC, COL_CQZ, COL_MY_RIG, COL_TX_PWR, COL_MY_GRIDSQUARE) VALUES ('2012-04-30 09:41', '2012-04-30 09:41', 'GS6PYE/P', '20m', '142000', 'SSB', '59', '59', '', '', '', '', '', 'Scotland', '', '', 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 'N', NULL, 'N', NULL, NULL, 'Not Found', NULL, NULL, 0, NULL)
Filename: models/Logbook_model.php
Line Number: 172`
@teabreakninja @Manawyrm this is the first time I've done a clean install in ages so thought I'd go through it a bit and point out issues I've noticed
First thing I noticed is that "updates" folder needs to be added to the default install.
Second when I try and populate the prefix dates using the update script I get quite a few errors
`A PHP Error was encountered Severity: Notice
Message: Undefined variable: record
Filename: controllers/Update.php
Line Number: 34`
`A Database Error Occurred Error Number: 1364
Field 'ituz' doesn't have a default value
INSERT INTO
dxcc_entities(adif,name,prefix,cqz,cont,long,lat,start,end) VALUES (1, 'CANADA', 'VE', 5, 'NA', -80, 45, '', '')Filename: controllers/Update.php
Line Number: 59`
Followed by quite errors relating to start and end, this is using PHP Version 7.2.6-1 wondered if you guys had seen this?