Error on grid Load – pop up with json and no error message – PostgreSQL

QuestionsError on grid Load – pop up with json and no error message – PostgreSQL
James Davis asked 2 weeks ago

Just downloaded the free version to test. Using PostgreSQL and I’ve been debugging for hours and still no luck. I have the grid constructed and pulling data back from the database just fine. Unfortunately no matter what table I connect to I get the same pop up error with json and I can see the values from my table in the error but the grid will not load. I really want to buy this and need it ASAP. Please help as I cannot figure out why this is happening.

I’ve read several help articles on the forum about get the render() line above any HTML tags and I’ve verified that. I have SSL servers and even setup a non SSL server and same issue.

Error screenshot

https://imgur.com/a/smgz6Ok

 

Code sample

https://goonlinetools.com/snapshot/code/#z0qu5xejsv9hup515cedmk

 

 

2 Answers
James Davis answered 2 weeks ago

I Wanted to add in the example above the first column in my database table is a integer primary key field in PostgreSQL.  I’m guessing there might be a bug in the grid code that is not identifying this field as a primary key or something?

I’ve tested tables in public schema and in my custom schema, I’ve made sure all table names and columns are lower case letters only and still this pop-up error with no data loading in Grid.  I’ve also tried Chrome and FF and Safari with same issue.

James Davis answered 2 weeks ago

I solved the issue. If you look at the example code again included above I had a HTML comment line at the very top of the file even before the PHP open tag. Ughh hours of debugging to find this. So anyone else having this issue you definitely need to make sure you have no HTML or comments even before the render() PHP code.

<!– Dynamically load in header for session start and login check –>

That was the comment line that got me at top of my page. Once removed everything works as expected!

Your Answer

8 + 4 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?