Comments (4)
Actually, the problem is wider than that: any update where any field is set to NULL field will silently fail. So it's not only that you can't change foreign keys back to NULL, you also can't change any other field of a record where there is a key already pointing to NULL.
from tabulate.
Hm, yes, this is a tricky thing. Your PR fixes for updates, but inserts still are buggy.
Do you think it's a terrible idea to eschew the use of wpdb->insert and ->update entirely, and build the SQL directly? I might have a look at doing that....
from tabulate.
Nulls are now working correctly. Do you think this is an okay fix?
Thanks for taking the time to report problems! I really appreciate it. :)
from tabulate.
This looks like a proper decent fix. Thanks for fully taking care of this issue!
from tabulate.
Related Issues (20)
- Cross Referencing converts to integer after saving HOT 3
- Can't add data to tables. HOT 11
- Drop requirement of rest-api plugin for WP >= 4.7 HOT 1
- I want to connect to a different DB other than WP HOT 1
- Temp directory HOT 6
- User with editor role got Tabulate shortcode error HOT 2
- Reports cannot be enabled HOT 15
- Add 'report' format to shortcode
- Logo proposal HOT 6
- Maximum length when importing CSV HOT 2
- Tables without PKs HOT 3
- Edit window not populating HOT 1
- Sorting by columns on the main site
- Lists as headers
- pip install fails HOT 1
- Table Pagination
- Option for minimum width of table
- Latest version support issue
- HTML link in db view is not shown as link in report on wordpress page
- Code error - prevented login
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tabulate.