Javascript error on opening query builder
tr-j opened this issue · 0 comments
tr-j commented
What happened?
A javascript error, followed by a SQL error when trying to create a new query builder report.
/admin/thoughtco/reports/builder/create
The Rules Orders and Customers are listed, but with no columns and they can't be properly selected.
Submitting the page results in a SQL error:
| 2022-04-20 21:02:42 | PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'builderjson' cannot be null in ~/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 |
|---|
What did you expect to happen?
I believe rules and columns should be able to be selected and added.
Version
Newest versions of everything installed April 20, 2022
What browser are you seeing the problem on?
Firefox
Relevant log output
Console:
Uncaught TypeError: this.$builderElement.queryBuilder is not a function
Both this file:
https://cdn.jsdelivr.net/npm/jQuery-QueryBuilder@2.6.0/dist/js/query-builder.standalone.js
And an assets file loaded.
A SQL error (above) is reported in the TastyIgniter logs.
And this: ErrorException: Trying to access array offset on value of type null
in ~/public_html/extensions/thoughtco/reports/controllers/Builder.php:228