500 Error with a list

[sjmatheson]

Hello,

I have been working on some groups and elements within a form/list and now seem to be getting a 500 error, both on the client side of things and also when clicking on 'view details' from the admin site of things, within the list.

The error I get is...

An error has occurred.
500 Fabrik has generated an incorrect query for the list Testing Demo: <br />

Any ideas?

 

[troester]

enable Fabrik debug in Fabrik Options
then call your list or details view again and append &fabrikdebug=1 to the URL
this should display the complete error message

Gesendet von meinem GT-I9300 mit Tapatalk

 

[cheesegrits]

Also, you might want to fill out http://fabrikar.com/you/my-sites with a backend login, and any details we need about which list, elements, etc. Make sure you give us a super-admin account (so we can do things like turning debugging on and off). And make it a dedicated account for us, which you can disable when we aren't actively working on issues for you.

-- hugh

 

[sjmatheson]

Great, thanks Hugh, i'll sort that out today.

 

[sjmatheson]

Hey Hugh, I've added the details into the my-sites area.

The same issue still exists.

Did you want me to pm you with anything specific?

 

[cheesegrits]

Try it now.

The error was "unknown field hydraulic_description in field list", which means that the actual field in the table for that element didn't exist. I hit the "Update database" button for that form (on the main Forms admin page), which does some basic sanity checking and repairs, including adding any fields to the table which are missing.

I don't know how the field got removed from the table, not something that happens very often. It's usually pilot error - for example, if you delete a copy of the element, empty the trash, and tell Fabrik to delete the database field.

-- hugh

 

[sjmatheson]

Ah thank you Hugh. Appreciate your help.

Works fine now. Thanks


Sent from my iPhone using Tapatalk