OS info
- Operating System : Windows 10.0.19041
- Wappler Version : 3.5.1
Problem description
overwriting every line in database with the same data
Steps to reproduce
- change data in one colomn could only get the first line
- click save
- all posts will change to the same data as the first one. Just for that coloumn.
Debuging of sql call will be added soon.
the database viewer is not using primary key. So if the primary key has several columns thte database viewer isnot using them
Her is the SQL that ruined my database
update timeliste
set tid_inn
= ‘2020-11-10 22:03:43’,
km_inn
= 99999
where brsted
= 1
it should have been
update timeliste
set tid_inn
= ‘2020-11-10 22:03:43’,
km_inn
= 99999
where brsted
= 1
and kunde = 45
and id = 123
Community Page
Last updated:
Last updated: