Hallo zusammen. Ich probiere nun schon seit geraumer Zeit, die weewx.sdb der Version 3.9.0 mit der neuen weewx.sdb der aktuellen Version 4.7.0 zusammen zu legen. Dies klappte bis anhin leider nicht. Nun vermute ich aber, das dies daran liegt, das ab der Version 4.7 ein anderes Shema benutzt wird? Interessanterweise konnte ich die alte weewx.sdb mit wee_database weewx.conf --reconfigure in das richtige format bringen. Nun aber fehlen mit die "sunshine_hours". Die neuste Version von weewx hat ja ebenfalls ein neues "sunshine_time" format. Nun wollte die mittels "rename" einfach die Tabllenespalte anpassen. Dies blieb aber erfolglos. Kann ich die "sunshine_hours" über einen anderen weg ind die neue weewx.sdb in dessen "sunshine_time" spalte kopieren? Ich weiss wirklich nicht mehr weiter und würde mich über Hilfen freuen. Vielen Dank
Der Fehler bei der Datenbank zusammenführung: Error: near line 333827: table archive has 114 columns but 53 values were supplied Error: near line 333828: table archive has 114 columns but 53 values were supplied Error: near line 333829: table archive has 114 columns but 53 values were supplied Error: near line 333830: table archive has 114 columns but 53 values were supplied Error: near line 333831: table archive has 114 columns but 53 values were supplied Error: near line 333832: table archive has 114 columns but 53 values were supplied Error: near line 333833: table archive has 114 columns but 53 values were supplied Error: near line 333834: table archive has 114 columns but 53 values were supplied Error: near line 333835: table archive has 114 columns but 53 values were supplied Error: near line 333836: table archive has 114 columns but 53 values were supplied Error: near line 333837: table archive has 114 columns but 53 values were supplied Error: near line 333838: table archive has 114 columns but 53 values were supplied Error: near line 333839: table archive has 114 columns but 53 values were supplied Error: near line 333840: table archive has 114 columns but 53 values were supplied Error: near line 333841: table archive has 114 columns but 53 values were supplied Error: near line 333842: table archive has 114 columns but 53 values were supplied Error: near line 333843: table archive has 114 columns but 53 values were supplied Error: near line 333844: table archive has 114 columns but 53 values were supplied Error: near line 333845: table archive has 114 columns but 53 values were supplied Error: near line 333846: table archive has 114 columns but 53 values were supplied Error: near line 333847: table archive has 114 columns but 53 values were supplied Error: near line 333848: table archive has 114 columns but 53 values were supplied Error: near line 333849: table archive has 114 columns but 53 values were supplied Error: near line 333850: table archive has 114 columns but 53 values were supplied Error: near line 333851: table archive has 114 columns but 53 values were supplied Error: near line 333852: table archive has 114 columns but 53 values were supplied Hello, everyone. For some time now I've been trying to merge the weewx.sdb of version 3.9.0 with the new weewx.sdb of the current version 4.7.0. Unfortunately, this has not worked so far. But now I assume that this is due to the fact that a different shema is used from version 4.7 onwards? Interestingly, I was able to get the old weewx.sdb into the right format with wee_database weewx.conf --reconfigure. But now I'm missing the "sunshine_hours". The latest version of weewx also has a new "sunshine_time" format. Now she just wanted to adjust the table column using "rename". But this was unsuccessful. Can I use another way to copy the "sunshine_hours" into the new weewx.sdb in its "sunshine_time" column? I really don't know what to do and would appreciate any help. Thanks very much Meteo Oberwallis schrieb am Donnerstag, 31. März 2022 um 11:35:55 UTC+2: > Hello, everyone. > > The error really seems to be with the database, i.e. SQLite, since the > "user.sunduration.schema_with_sunshine_time" will have a different > structure. But what can I do now so that I can use my old database from the > previous weewx version again with the latest version and thus overwrite the > sunshine hours (old name in the old weewx.sdb) in the new one? > > Many thanks for your help > > Meteo Oberwallis schrieb am Montag, 28. März 2022 um 19:39:22 UTC+2: > >> Hey Tom. >> >> >> >> Thx for your Help. >> >> In the new weewx version, "schema = schemas.wview_extended.schema" is >> used with the table. In the previous version of weewx, however, this was >> "schema = user.radiationhours.schema_with_sunshine_hours". What exactly do >> I have to do if I transfer my old weewx.sdb to the program? Do I then have >> to adapt these with sudo wee_database weewx.conf --reconfigure to the >> ""schema = schemas.wview_extended.schema"? I think that's where my problem >> lies. >> >> >> >> Currently I did the following: Old weewx.sdb in the /var/lib/weewx/ >> folder. Then adjust the column names with "wee_database >> --rename-column=sunshine_hours --to-name=sunshine_time" and finally adjust >> the new Shmea from weewx with sudo wee_database weewx.conf --reconfigure. >> After I did that, the "sunshine_time" column was gone. Only after "sudo >> wee_database --add-column=sunshine_time" is it back, but unfortunately >> without all the data from the last few years. >> >> >> >> Where is my mistake? >> >> >> >> *Von:* [email protected] <[email protected]> *Im Auftrag >> von *Tom Keffer >> *Gesendet:* Montag, 28. März 2022 13:51 >> *An:* weewx-user <[email protected]> >> *Betreff:* Re: [weewx-user] Re: Datenbank zusammen legen. >> >> >> >> If I understand correctly, you're trying to rename a database type from >> sunshine_hours to sunshine_time. >> >> >> >> If so, use the utility wee_database with the --rename-column >> <http://www.weewx.com/docs/utilities.htm#Action_--rename-column> option: >> >> >> >> *wee_database --rename-column=sunshine_hours --to-name=sunshine_time* >> >> >> >> Make a backup first. >> >> >> >> On Mon, Mar 28, 2022 at 12:14 AM Meteo Oberwallis <[email protected]> >> wrote: >> >> Good Morning >> >> >> >> I have a question regarding the SQLite database. I updated weewx and now >> use sunshine_time instead of sunshine_hours. Now of course the problem is >> that the old sunshine times are in the sunshine_hours column and not in the >> sunshine_time. How can I fix the fact that the old sunshine_hours data is >> now being sent to the sunshine_time splate? >> >> Thanks and Greetings >> >> [email protected] schrieb am Sonntag, 19. April 2020 um 19:30:30 UTC+2: >> >> Hallo >> >> >> >> wenn du die Standard Installation hast ist das >> /home/weewx/public_html/NOAA oder /var/www/html/weewx/NOAA so wie es >> Gary geschrieben hat. >> >> >> >> Grüße >> >> >> >> >> >> Hello >> >> >> >> if you have the standard installation this is >> /home/weewx/public_html/NOAA or /var/www/html/weewx/NOAA as Gary wrote it. >> >> >> >> greetings >> >> >> >> >> >> >> >> >> Am Sonntag, 19. April 2020 13:58:05 UTC+2 schrieb Meteo Oberwallis: >> >> Hallo Günther >> >> >> >> Nun. Das finde ich so nirgends in meinem weewx Ordner. Ist das der >> Ordner, bevor es via FTP hochgeladen wird? >> >> >> >> Gruss >> >> >> >> *Von:* [email protected] <[email protected]> *Im Auftrag >> von *Günther Wrana >> *Gesendet:* Sonntag, 19. April 2020 08:32 >> *An:* weewx-user <[email protected]> >> *Betreff:* Re: [weewx-user] Re: Datenbank zusammen legen. >> >> >> >> Hallo >> >> >> >> Ich habe die Dateien im /var/weewx/reports/NOAA gelöscht aber ich habe >> diesen Pfad bei mir vorher so geändert damit diese Dateien nicht auf die >> SD-Karte sondern in den RAM Speicher geschrieben werden. >> >> >> >> Grüße Günther >> >> Hello >> >> >> >> I deleted the files in /var/weewx/reports/NOAA but I changed this path >> for me beforehand so that these files are not written to the SD card but to >> the RAM memory. >> >> >> >> Regards Günther >> >> >> >> >> >> Am Samstag, 18. April 2020 17:45:24 UTC+2 schrieb Meteo Oberwallis: >> >> Hallo Günther >> >> >> >> In welchem Ordner hast du das gelöscht? >> >> >> >> >> >> On Sat, Apr 18, 2020 at 5:34 PM +0200, "Günther Wrana" <[email protected]> >> wrote: >> >> Hello >> >> I deleted the file NOAA-2019-05.txt, NOAA-2019.txt and it worked >> perfectly. For me is now the 01.05.2015 that I imported. The fact that >> there is nothing inside has happened to me even though I have only deleted >> the NOAA.txt. Maybe you have to restart or reload weewx. >> >> >> >> Günther >> >> >> Am Samstag, 18. April 2020 14:56:21 UTC+2 schrieb Meteo Oberwallis: >> >> Hello. >> >> I have now deleted the data in the folder "/var/www/html/weewx/NOAA/". These >> came again after the next interval. Unfortunately without data. Do I have to >> delete it anywhere else? >> >> Thank you for your top help >> >> >> >> Am Freitag, 17. April 2020 23:42:39 UTC+2 schrieb gjr80: >> >> Hallo Günther, >> >> Good to hear you have imported your data and WeeWX is running without >> error. You need WeeWX to recreate all of your NOAA format reports, to do >> this just delete the reports on your WeeWX machine and they will be >> recreated (including your earlier ones) on the next report cycle. >> >> Gary >> >> -- >> You received this message because you are subscribed to the Google Groups >> "weewx-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/8fc609f0-224a-4205-98d4-410a7acc759f%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/8fc609f0-224a-4205-98d4-410a7acc759f%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> -- >> You received this message because you are subscribed to the Google Groups >> "weewx-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/f02b56bc-8550-45f7-95ae-3e58054284d5%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/f02b56bc-8550-45f7-95ae-3e58054284d5%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> -- >> You received this message because you are subscribed to the Google Groups >> "weewx-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/f7df793b-6e6b-43f8-95e8-799af2218b3en%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/f7df793b-6e6b-43f8-95e8-799af2218b3en%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "weewx-user" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/weewx-user/86KPd-dyvD4/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/CAPq0zEBx1WzUgoiV%2Bj07vMVqW7seYe6jM-3WCmks2ZmREeVmCQ%40mail.gmail.com >> >> <https://groups.google.com/d/msgid/weewx-user/CAPq0zEBx1WzUgoiV%2Bj07vMVqW7seYe6jM-3WCmks2ZmREeVmCQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/6b0185a5-4700-430f-aba3-435a332ba2c2n%40googlegroups.com.
