LO 7.3 base file in 25.2 difference

[Robgh]

I have an odb file which was created in LO 7.3 and has nearly 9000 records. When I open the same odb file in LO 25.2, almost the last 200 records are missing! How can that happen when it is the same odb file, and is there an easy way to fix it.

Thanks

[Wanderer]

@Robgh

When I open the same odb file in LO 25.2,

Is it an embedded database?
Any filters set? (Had once a problem with one table until I realized a filter I set was saved and still active.)
If you open the file again with 7.x , can you see the missing data?
.
Type of your database? Firebrid/hsqldb/dbase … ?
.
PS: check for backups and copy old versions to a safe place, before poking around…

[Robgh]

No, it is just a fairly simple database and does have 1 filter table. When I open the file in LO 7.3 yes the missing data i there. That is how I know about it missing in LO25.1

It is an embedded HSQLB database when open inLO25.1

[RobertG]

Tested with LO 25.2.0.3 and also 24.8.4.2: Same database file, both will show all 8187 rows of the table of HSQLDB example database here.

Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

[Robgh]

I don’t doubt what you say, but with LO7.3 I have 8910 records and with LO25.1 it only shows 8725 records. I cannot understand why the difference when it is the same file.
One other difference I have found is that in the table of LO25.1, record number 8724 is for 15/09/2024, then record 8725 jumps to 21/12/2024

[Robgh]

As requested.

LeedsWXData.odb (963.3 KB)

[RobertG]

You haven’t written which table should be opened. There is only table tblWXdataLeeds which many rows. It will show 8706 rows here on LO 25.2.0.3, LO 24.8.4.2 and LO 7.4.7.2. No difference. Don’t know how you get 8725 records or 8910 records instead.

[Robgh]

Ok, for got to say that.
It is tblWXdataLeeds, and I opened it in both LO7.3 and LO 25 to check the number of records.
In LO7.3 there ore 8912 records to date, and in LO 25.1, there are 8755. The drop down box which has the years and month in does not show this year and month.

[RobertG]

@Robgh

The drop down box

There is no drop down box in a table. Seems you open a form. Might be this form depends on a query, which duplicates some entries of tblWXdataLeeds. But I couldn’t find this form. The table only contains 8706 rows - in all versions here.
Add a screenshot here with the different results.

[Robgh]

I meant the drop down box in the form, sorry for the confusion.The form depends on tbl_filter, and this is the filter: ( “tbl_Filter”.“ID” = TRUE ) when I view form properites / data.

[Robgh]

As requested , 2 different results. The top or 1st picture is with or using LO 7.3, and the 2nd or bottom picture is with using LO25.1.

[mikekaganski]

@RobertG

Seems you open a form. … But I couldn’t find this form.

@Robgh

I meant the drop down box in the form

It would be great to also mention the name of the form Leeds Weather?

Are you sure, that you use the same database in both versions, and not different copies in different places, possibly registered in the two LO versions?

[RobertG]

The ID in your form shows 8912. This isn’t total number of rows. There will be deleted some rows so the total number is about 8706 rows (2 rows more in your database, because the uploaded database doesn’t contain ID 8912 - maximum is 8910).

I will get the data for 09/02/2025 in LO 25.2.0.3 without any problem here. I could also choose other month’s - also totally wrong years like 2202-20; 21-10 and 2108-12

[Robgh]

The name of the form is called LeedsWeather

Yes I am using the same database in both versions.

The ID in the top form is 8912, as I have just checked the table, and it says so in the top picture of the form.

I am not sure what you mean here:
‘also totally wrong years like 2202-20; 21-10 and 2108-12’

Thanks.

[RobertG]

@Robgh

‘also totally wrong years like 2202-20; 21-10 and 2108-12’

See screenshot form LO 25.2.0.3 here

Listbox shows three entries, which will appear, because there are wrong values in your table.

Have a look at table LeedsWXData. Order by “ReadDate”. The first 2 entries are wrong (Years is in the future). And about 14 entries at the bottom of the table are wrong (no year or year is like 0202…)

[Robgh]

Thanks for pointing out the typos. It doesn’t hep when your finger ends are numb.
I have removed the errors because they would have been double entries.

Here are 2 screenshots of the tblLeedsWXData.

The 1st one is from LO7.3

And the 2nd on is from LO25.1

I still don’t see this years data either in the table nor the form.

One other annoying thing when I use LO25.1 , when I click on the drop down box on the form, the data , ie years and months listing goes off the form to the far right of my monitor screen. I wish I knew why this was.

Thanks

[RobertG]

and

Table is ordered by “ReadDate”
… and it has nothing to do with the version. That are data you have saved in the table.

[Robgh]

Please find file from LO7.3 with corrected or deleted typos in the ReadDate.
I hope I have done them all, but you may find more.

LeedsWXData.odb (963.1 KB)

[RobertG]

Have a look at this rows - created a query to find the wrong entries:

[Robgh]

I have corrected or deleted the entries with typos, so hopefully there won’t be any more.
Oh, please use the last uploaded odb file which has been, mostly, corrected.
What is the bottom picture of, ie which querry file is, or have you created it
Thanks