This topic is locked
[SOLVED]

 Simple MySQL query giving me headaches

4/6/2020 12:34:31 PM
PHPRunner General questions
K
keithh0427 author

I have a Custom View with the following query:
SELECT experienceID AS experienceID, count( sacramentsID )

FROM sacraments

WHERE sacramentStatus IN ( 'A', 'AR' , 'C')

GROUP BY experienceID
If I look at the "Results" tab after a create the query, I get the results that I am looking for.
But, if I go back a page to the "Tables" page, I get the following error messages in a popup window. PHPRunner then gets extremely slow when I attempt to move from page to page.
TypeError: Unable to get property 'cells' of undefined or null reference
stack:

TypeError: Unable to get property 'cells' of undefined or null reference

at HorizontalGridForm.prototype.createCell (http://localhost:8085/main.bundle.js:30826:9)

at Form.prototype.addItem (http://localhost:8085/main.bundle.js:28190:13)

at Form.prototype.addItem (http://localhost:8085/main.bundle.js:28175:17)

at Page.prototype.addItem (http://localhost:8085/main.bundle.js:50066:17)

at Page.prototype.addItemIfAbsent (http://localhost:8085/main.bundle.js:50026:9)

at FieldsOption.prototype.toggleGridField (http://localhost:8085/main.bundle.js:45676:13)

at WipService.prototype.setFieldProp (http://localhost:8085/main.bundle.js:19388:13)

at Anonymous function (http://localhost:8085/main.bundle.js:19418:13)

at WipService.prototype.setFieldPropsBulk (http://localhost:8085/main.bundle.js:19416:9)

at Anonymous function (http://localhost:8085/main.bundle.js:19343:17)

at WipService.prototype.setManyFieldsPropsBulk (http://localhost:8085/main.bundle.js:19341:9)

at Anonymous function (http://localhost:8085/main.bundle.js:18765:67)

at ZoneDelegate.prototype.invoke (http://localhost:8085/polyfills.bundle.js:6856:13'>http://localhost:8085/polyfills.bundle.js:6856:13)

at onInvoke (http://localhost:8085/vendor.bundle.js:49946:17)

at ZoneDelegate.prototype.invoke (http://localhost:8085/polyfills.bundle.js:6856:13'>http://localhost:8085/polyfills.bundle.js:6856:13)

at Zone.prototype.run (http://localhost:8085/polyfills.bundle.js:6616:17)

at Anonymous function (http://localhost:8085/polyfills.bundle.js:7355:17)

at ZoneDelegate.prototype.invokeTask (http://localhost:8085/polyfills.bundle.js:6888:13'>http://localhost:8085/polyfills.bundle.js:6888:13)

at onInvokeTask (http://localhost:8085/vendor.bundle.js:49937:17)

at ZoneDelegate.prototype.invokeTask (http://localhost:8085/polyfills.bundle.js:6888:13'>http://localhost:8085/polyfills.bundle.js:6888:13)

at Zone.prototype.runTask (http://localhost:8085/polyfills.bundle.js:6661:21)

at drainMicroTaskQueue (http://localhost:8085/polyfills.bundle.js:7067:25)

K
keithh0427 author 4/6/2020

It seems that this problem and the associated error messages occur whenever I use the "sacraments" table in a query.
It I edit the query for the sacraments table or use the sacraments table in a query, I get the error messages.
I tried deleting the table, re-sync the database, save the project, load the project, copy the table from another database and re-sync the table once again.
Edit the queries and the same problem occurs.
This is the only table that I hvae found with this issue.

need2sleepDevClub member 4/6/2020

Have you tried the latest v10.4 34767?
I was having some issues as well with a simple left join.
I was also jumping between versions and I think the background process "node.js" might be conflicting but not 100% sure. I suggest restarting your computer after upgrading phprunner and see if you still have the same problem.

K
keithh0427 author 4/7/2020

I'm surrently using the just released Build 34792 and still having this issue.