Vis problemdetaljer

IDProsjektKategoriVisningsstatusSiste oppdatering
0000054BAS21BAS21Offentlig2020-04-03 12:47
Rapportert avjarle-ba@online.no Delegert tilchreide  
PrioritetHasterAlvorlighetsgradAlvorligMulighet for å reprodusereKan ikke reprodusere
Status LøstLøsningsstatusFikset 
Oppsummering0000054: Får feilmelding når jeg skal fakturere.
Beskrivelsesqlite3.Operationalerror …. Får feilmelding posteringslinje har ikke periode_id. Har oppdatert til siste versjon. Har fakturert for januar og februar OK i 2020. Se vedlegg. Jarle Barnholdt 90124321
NøkkelordIngen nøkkelord tilknyttet

Activities

jarle-ba@online.no

2020-04-03 09:30

Rapportør  

feilmelding Bas21 mars 2020.JPG (37,335 bytes)   
feilmelding Bas21 mars 2020.JPG (37,335 bytes)   

chreide

2020-04-03 09:47

Administrator   ~0000119

Kan du lime inn de siste ca 50 linjene fra feilloggen her? Evt legge ved hele greia som fil? Du finner den i menyen "Hjelp -> feillogg"

jarle-ba@online.no

2020-04-03 10:36

Rapportør   ~0000120

2020-04-03 08:08:22,250 - ERROR - [0.9.9-20180131-1] Traceback (most recent call last):

2020-04-03 08:08:22,250 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:22,251 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\ui\innstillinger\selskap.py", line 199, in brreg_lookup_orgnr

2020-04-03 08:08:22,251 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:22,251 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\bascore\baslib\external\brreg.py", line 46, in hent_selskap_from_brreg

2020-04-03 08:08:22,252 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:22,254 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\__init__.py", line 354, in loads

2020-04-03 08:08:22,254 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:22,254 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 339, in decode

2020-04-03 08:08:22,254 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:22,255 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 357, in raw_decode

2020-04-03 08:08:22,255 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:22,255 - ERROR - [0.9.9-20180131-1] json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

2020-04-03 08:08:22,255 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:31,678 - ERROR - [0.9.9-20180131-1] Traceback (most recent call last):

2020-04-03 08:08:31,678 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:31,678 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\ui\innstillinger\selskap.py", line 199, in brreg_lookup_orgnr

2020-04-03 08:08:31,678 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:31,678 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\bascore\baslib\external\brreg.py", line 46, in hent_selskap_from_brreg

2020-04-03 08:08:31,678 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:31,678 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\__init__.py", line 354, in loads

2020-04-03 08:08:31,679 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:31,679 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 339, in decode

2020-04-03 08:08:31,679 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:31,679 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 357, in raw_decode

2020-04-03 08:08:31,679 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:31,679 - ERROR - [0.9.9-20180131-1] json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

2020-04-03 08:08:31,679 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:33,488 - ERROR - [0.9.9-20180131-1] Traceback (most recent call last):

2020-04-03 08:08:33,489 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:33,489 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\ui\innstillinger\selskap.py", line 199, in brreg_lookup_orgnr

2020-04-03 08:08:33,489 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:33,489 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\bascore\baslib\external\brreg.py", line 46, in hent_selskap_from_brreg

2020-04-03 08:08:33,490 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:33,490 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\__init__.py", line 354, in loads

2020-04-03 08:08:33,490 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:33,490 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 339, in decode

2020-04-03 08:08:33,490 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:33,491 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 357, in raw_decode

2020-04-03 08:08:33,491 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:33,491 - ERROR - [0.9.9-20180131-1] json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

2020-04-03 08:08:33,492 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:35,039 - ERROR - [0.9.9-20180131-1] Traceback (most recent call last):

2020-04-03 08:08:35,039 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:35,039 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\ui\innstillinger\selskap.py", line 199, in brreg_lookup_orgnr

2020-04-03 08:08:35,039 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:35,039 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\bascore\baslib\external\brreg.py", line 46, in hent_selskap_from_brreg

2020-04-03 08:08:35,039 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:35,039 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\__init__.py", line 354, in loads

2020-04-03 08:08:35,039 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:35,039 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 339, in decode

2020-04-03 08:08:35,039 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:35,040 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 357, in raw_decode

2020-04-03 08:08:35,040 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:35,040 - ERROR - [0.9.9-20180131-1] json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

2020-04-03 08:08:35,040 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:37,079 - ERROR - [0.9.9-20180131-1] Traceback (most recent call last):

2020-04-03 08:08:37,079 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:37,079 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\ui\innstillinger\selskap.py", line 199, in brreg_lookup_orgnr

2020-04-03 08:08:37,079 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:37,079 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\bascore\baslib\external\brreg.py", line 46, in hent_selskap_from_brreg

2020-04-03 08:08:37,079 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:37,079 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\__init__.py", line 354, in loads

2020-04-03 08:08:37,080 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:37,080 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 339, in decode

2020-04-03 08:08:37,080 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:37,080 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 357, in raw_decode

2020-04-03 08:08:37,080 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:37,080 - ERROR - [0.9.9-20180131-1] json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

2020-04-03 08:08:37,080 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,291 - ERROR - [0.9.9-20180131-1] Traceback (most recent call last):

2020-04-03 08:08:38,291 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,291 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\ui\innstillinger\selskap.py", line 199, in brreg_lookup_orgnr

2020-04-03 08:08:38,291 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,291 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\bascore\baslib\external\brreg.py", line 46, in hent_selskap_from_brreg

2020-04-03 08:08:38,291 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,291 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\__init__.py", line 354, in loads

2020-04-03 08:08:38,291 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,291 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 339, in decode

2020-04-03 08:08:38,291 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,292 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 357, in raw_decode

2020-04-03 08:08:38,292 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,292 - ERROR - [0.9.9-20180131-1] json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

2020-04-03 08:08:38,292 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,624 - ERROR - [0.9.9-20180131-1] Traceback (most recent call last):

2020-04-03 08:08:38,625 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,625 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\ui\innstillinger\selskap.py", line 199, in brreg_lookup_orgnr

2020-04-03 08:08:38,625 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,625 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\bascore\baslib\external\brreg.py", line 46, in hent_selskap_from_brreg

2020-04-03 08:08:38,625 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,625 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\__init__.py", line 354, in loads

2020-04-03 08:08:38,625 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,625 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 339, in decode

2020-04-03 08:08:38,625 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,625 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 357, in raw_decode

2020-04-03 08:08:38,626 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,626 - ERROR - [0.9.9-20180131-1] json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

2020-04-03 08:08:38,626 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,890 - ERROR - [0.9.9-20180131-1] Traceback (most recent call last):

2020-04-03 08:08:38,890 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,891 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\ui\innstillinger\selskap.py", line 199, in brreg_lookup_orgnr

2020-04-03 08:08:38,891 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,891 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\bascore\baslib\external\brreg.py", line 46, in hent_selskap_from_brreg

2020-04-03 08:08:38,891 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,891 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\__init__.py", line 354, in loads

2020-04-03 08:08:38,891 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,891 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 339, in decode

2020-04-03 08:08:38,891 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,891 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 357, in raw_decode

2020-04-03 08:08:38,891 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:08:38,891 - ERROR - [0.9.9-20180131-1] json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

2020-04-03 08:08:38,891 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:09:44,790 - ERROR - [0.9.9-20180131-1] Traceback (most recent call last):

2020-04-03 08:09:44,790 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:09:44,790 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\ui\innstillinger\selskap.py", line 199, in brreg_lookup_orgnr

2020-04-03 08:09:44,791 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:09:44,791 - ERROR - [0.9.9-20180131-1] File "C:\Users\chreide\Documents\bas21\src\bascore\baslib\external\brreg.py", line 46, in hent_selskap_from_brreg

2020-04-03 08:09:44,791 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:09:44,791 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\__init__.py", line 354, in loads

2020-04-03 08:09:44,792 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:09:44,792 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 339, in decode

2020-04-03 08:09:44,792 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:09:44,793 - ERROR - [0.9.9-20180131-1] File "c:\Python36\lib\json\decoder.py", line 357, in raw_decode

2020-04-03 08:09:44,793 - ERROR - [0.9.9-20180131-1]
2020-04-03 08:09:44,793 - ERROR - [0.9.9-20180131-1] json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

2020-04-03 08:09:44,793 - ERROR - [0.9.9-20180131-1]

jarle-ba@online.no

2020-04-03 10:39

Rapportør   ~0000121

Jeg ryddet litt på PC min i går, men trodde ikke jeg slettet noen Bas21-filer. Fant ikke mitt selskap når jeg logget inn for å fakturere i dag og la inn Barnholdt AS med alle opplysninger på nytt.

jarle-ba@online.no

2020-04-03 10:39

Rapportør   ~0000122

Takk for rask oppfølging

chreide

2020-04-03 10:54

Administrator   ~0000123

Loggen her gjelder versjon 0.9.9 av BAS21 (og den har du startet og kjørt i dag). Den kolonnen som mangler i den opprinnelige meldingen din ble fjernet for lenge siden. Så av en eller annen grunn kjører du en veldig gammel BAS21 mot en relativt ny database.

jarle-ba@online.no

2020-04-03 11:48

Rapportør   ~0000124

Men det er den loggen jeg har i Bas21 versjon 1,4,4? Hva kan jeg nå gjøre for å rydde bort alt og starte på nytt ?

jarle-ba@online.no

2020-04-03 11:49

Rapportør   ~0000125

Altså det skal ikke være ? Den logger jeg har tatt ut har jeg tatt ut av versjon 1.4.4 av Bas21!!

jarle-ba@online.no

2020-04-03 11:59

Rapportør   ~0000126

JEG KLARTE Å LØSE DETTE. KJØRTE INSTALLASJON PÅ NYTT. VALGTE "REPARER", DET FUNGERTE IKKE. VALGTE SÅ "SLETT" OG SÅ INSTALLERTE JEG PÅ NYTT PÅ EN ANNEN KATALOG PÅ MIN PC. AV ÅRSAKER JEG IKKE FORSTÅR FIKK JEG DA INSTALLERT NY VERSJON MED MITT AS ALLEREDE LIGGENDE INNE OG JEG FIKK FAKTURERT. TAKK FOR OPPFØLGING.

chreide

2020-04-03 12:07

Administrator   ~0000127

Oppdaterte du fra 0.9.9 til 1.4.4 nå i dag? Hvis du velger "Hjelp -> Om BAS21", står det virkelig versjon 1.4.4 der?

Hvis du ønsker å starte med "blanke ark" er det bare å slette databasen. Se https://hjelp.bas21.no/backup.html#backup-local for hvor du finner den.

Hvis du vil at jeg skal hjelpe deg å komme deg opp og stå uten å slette alt kan du sende meg filen bas21.db til epost support@bas21.no så skal jeg se om jeg greier å fikse databasen. Hvis det er en oppdatering fra 0.9.9 til 1.4.4 er det en veldig stor oppgradering (ca to år?) med masse databasejusteringer, men det skal la seg gjøre.

chreide

2020-04-03 12:09

Administrator   ~0000128

Ok, jeg så ikke den siste meldingen din før jeg sendte min. Da anser vi saken som løst.
Si fra om det kommer mer problemer.

chreide

2020-04-03 12:47

Administrator   ~0000129

En liten tilleggsopplysning. Etter en slik oppgradering (som spenner over mange versjoner) kan det lønne seg å kjøre vedlikeholdsrutinen "rekonstruer periodesummer". Du finner den i menyen "Verktøy -> Vedlikehold". Den "rydder opp" mye i databasen.

Sakshistorikk

Dato endret Brukernavn Felt Endring
2020-04-03 09:30 jarle-ba@online.no Ny sak
2020-04-03 09:30 jarle-ba@online.no Status Ny => Delegert
2020-04-03 09:30 jarle-ba@online.no Delegert til => chreide
2020-04-03 09:30 jarle-ba@online.no Fil lagt til:: feilmelding Bas21 mars 2020.JPG
2020-04-03 09:47 chreide Notat lagt til: 0000119
2020-04-03 10:36 jarle-ba@online.no Notat lagt til: 0000120
2020-04-03 10:39 jarle-ba@online.no Notat lagt til: 0000121
2020-04-03 10:39 jarle-ba@online.no Notat lagt til: 0000122
2020-04-03 10:54 chreide Notat lagt til: 0000123
2020-04-03 11:48 jarle-ba@online.no Notat lagt til: 0000124
2020-04-03 11:49 jarle-ba@online.no Notat lagt til: 0000125
2020-04-03 11:59 jarle-ba@online.no Notat lagt til: 0000126
2020-04-03 12:07 chreide Notat lagt til: 0000127
2020-04-03 12:09 chreide Status Delegert => Løst
2020-04-03 12:09 chreide Løsningsstatus Åpen => Fikset
2020-04-03 12:09 chreide Notat lagt til: 0000128
2020-04-03 12:47 chreide Notat lagt til: 0000129