TypeError: Cannot read property 'length' of null

[Robin Samways]

Hello there,

I am seeing this error when attempting to run a select statement on a table in Google Chrome Developer Tools under the Application tab on WebSql database:

TypeError: Cannot read property 'length' of null

The table in question has many columns. Running a select with some columns works, but not others. Also, a simple "select * from <table_name>" is returning this error.

What is going on? How can a "select *" possibly return such an error?

Thanks..

Robin

[Pete Robie]

Good morning Robin,

Can you give more detail and possibly the code that you're using that's giving this error? Typically if you're getting the error "can not read property *** of null" then there is something that's typically not defined properly. Without seeing the code it will be incredibly difficult to deduce what the exact problem is.

Additionally 'select * ' is a very bad idea and in general bad practice in an application.

[PhistucK]

Robin is using the Developer Tools to inspect web databases, so trying there a select * from query while debugging is perfectly fine.

I can reproduce it as well (see the screenshot below) using the latest canary build on Windows, using the following statements -

CREATE TABLE topic (topic_id TEXT PRIMARY KEY NOT NULL, topic_name TEXT UNIQUE NOT NULL, 'topic description' TEXT)

insert into topic (topic_id, topic_name) values ('1', '1')

select * from topic

However, it does not reproduce if I create the table without the topic description field definition.

You can search crbug.com for an existing issue and star it. If you cannot find one, file a new issue using the "New issue" link on the same page.

Please, do not add a "+1" or "Me too" or "Confirmed" (or similar) comment. It just wastes the time of Chrome engineers and sends unnecessary e-mails to all of the people who starred the issue.

You can reply with a link to the found or created issue and might get triaged (and fixed) faster.

Thank you.

☆PhistucK

--
You received this message because you are subscribed to the Google Groups "Chrome DevTools" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-chrome-develo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-chrome-developer-tools/e6a9158d-92c7-4ee2-ac29-1ac32eb3ca69%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Robin Samways]

Correct, Phistuck. Any clue why they've built their product this way? Very frustrating.

[PhistucK]

Well, do you ever have a bug in your code? So do they... It was not intended.

☆PhistucK

On Wed, Aug 15, 2018 at 3:57 PM Robin Samways <rgsa...@gmail.com> wrote:

Correct, Phistuck. Any clue why they've built their product this way? Very frustrating.

--
You received this message because you are subscribed to the Google Groups "Chrome DevTools" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-chrome-develo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-chrome-developer-tools/26c57de8-c577-4203-baef-e049c21b170a%40googlegroups.com.

[Robin Samways]

Hey guys,

Any word on a fix for this? I really need to be able to debug my queries in the dev tools console.

Do I need to define my tables differently to handle this? I build my tables on the fly using javascript. Perhaps I need to define the columns better?

Thanks..

Robin

To view this discussion on the web visit https://groups.google.com/d/msgid/google-chrome-developer-tools/CABc02_K1OThDOyt-zGA_s0x0xaK%3D8dcAk2f9jB2xDmGcqvubBA%40mail.gmail.com.

[PhistucK]

Did you search and found or filed an issue at crbug.com like I suggested? Just posting about bugs in the group usually does not get them fixed (unless they are major). Having them filed at crbug.com adds them to the backlog and gets them prioritized.

☆PhistucK

To view this discussion on the web visit https://groups.google.com/d/msgid/google-chrome-developer-tools/CAKKfmw0jwGDJ9wTacLjEd5%3DZ%2BG6%3Dy2bSHPf0hisGAGHqsOLP8g%40mail.gmail.com.

[Robin Samways]

Bug entered. Hopefully someone can reproduce it as you did.

https://bugs.chromium.org/p/chromium/issues/detail?id=890580

To view this discussion on the web visit https://groups.google.com/d/msgid/google-chrome-developer-tools/CABc02_LXoAaHOv8PE5Zn1A2E3UxiM4QSafx2DAVQ9D3uOGRV1A%40mail.gmail.com.