TypeError: row[meta.col] is undefined when running a query without * in SELECT

[lorenzos]

A JavaScript error is thrown when running a query with a custom field list in the SELECT clause, for example:

SELECT * FROM mytable; -- Success
SELECT field1, field2 FROM mytable; -- Error

The error, as displayed in Firefox, is:

TypeError: row[meta.col] is undefined[Ulteriori informazioni]  app.js:136:17
	inflateData/columnHeader[i].data http://localhost:8080/app.js:136:17
	Q/< http://localhost:8080/jquery.dataTables.min.js:18:355
	ja/b.fnGetData http://localhost:8080/jquery.dataTables.min.js:12:86
	B http://localhost:8080/jquery.dataTables.min.js:17:61
	Ha http://localhost:8080/jquery.dataTables.min.js:24:390
	N http://localhost:8080/jquery.dataTables.min.js:16:337
	m/< http://localhost:8080/jquery.dataTables.min.js:92:408
	each http://localhost:8080/jquery.min.js:2:2813
	each http://localhost:8080/jquery.min.js:2:1001
	m http://localhost:8080/jquery.dataTables.min.js:82:383
	inflateData http://localhost:8080/app.js:174:8
	success http://localhost:8080/app.js:47:12
	i http://localhost:8080/jquery.min.js:2:27978
	fireWith http://localhost:8080/jquery.min.js:2:28749
	A http://localhost:8080/jquery.min.js:4:14201
	c/< http://localhost:8080/jquery.min.js:4:16491

After the error, the data table disappear (only a 1px dark line is shown instead), and nothing works after. A reload of the page become needed.

[lorenzos]

I noticed this is a duplicate of #66. I didn't find it before posting since that issue does not specify any error message: I leave my issue here since I reported more info.

[amitshekhariitbhu]

@lorenzos Thanks, I will consider it.