Records presented double and quadruple.

[Martin Pfeifer]

Hi,

Since yesterday a strange fenomena occurs in my DaDaBik applikctaion.

The last record entry is shown 4 times in the result sreen, the record before thar 2 times.
In my database tables they are both presented as unique record (one time).
Any Ideas?


Current PHP version: 5.6.40-15+ubuntu18.04.1+deb.sury.org+1 OK

mbsgtring extension: Installed

ioncube extension: Installed

ioncube extension version: 10.3 OK

Check DB connection: OK

postgres version: 11.6 (Ubuntu 11.6-1.pgdg18.04+1) NO (min postgres version is: 7.4)

 

[larryk]

is this on a view?

I had saw this one time in my app... but I forget this issue. It was a user error

I'm pretty sure you are over-looking a "logic" issue.

 

[Martin Pfeifer]

Yes it is on a view.

We have entered 21335 records with no problem; then it suddenly appeared. The operator stopped entering data immediately.

 

[eugenio]

Hello,
typically this happens if you have a lookup field and you set, as "Lookup table primary key field " something that is not a primary key: DaDaBIK joins the two tables and the same record in the table A is showed two times because there are two matches in the table B.

Best,

 

[Martin Pfeifer]

Thanks for the tip. Found it.
Someone had messed with a primary key value.