[Solved] SQL error when Record in database is set to No

[NickC4555]

Joomla 3.2.1
Fabrik 3.1rc2 + latest Github update

I have 2 forms both of which go to the error page and show SQL=" on submission when Record in database is set to No. They work without error when it is set to Yes.

I'd be grateful for any suggestions, please.

 

[Sophist]

Just out of interest, what purpose is a form which doesn't save to the database?

 

[NickC4555]

To send an email, just like the Joomla contact form does but with additional fields.

 

[Sophist]

Ok - so can you please post the entire SQL error including references to any PHP file.

 

[rob]

I'm not seeing an SQL error - but i did get an error thrown, if no redirect plugin was set. That is because the default option is to return to the list view after (which if you aren't recording to the db doesn't exist)

 

[NickC4555]

Thanks for your replies.

Rob: It's got a redirect plugin set, which does work when record in database is set to yes.
Sophist: The entire error is "SQL="

 

[rob]

got a url we can look at? Fill in your sites info here http://fabrikar.com/you/my-sites/ with an admin account and ftp account and I'll take a look.

 

[NickC4555]

I'm glad you reply more quickly than I do! I've put a couple of sites in the list, the one with the problem is http://dev.pangeasystems.co.uk/.

 

[Sophist]

Tried the two contact us forms and they both worked.

 

[NickC4555]

Sorry, try this one.

http://dev.pangeasystems.co.uk/contact

 

[Sophist]

Well - I do get the SQL error, but I cannot be certain whether the error message is really SQL= or whether your special template error page is truncating it to that.

Can you turn off the special error handling and allow the default error page to show?

Otherwise I will need to leave this to Rob who has access to the site details (which I don't because I am not a Fabrikar staff member).

 

[NickC4555]

With another template, the standard Joomla error page has "Error: 0" in the title bar and the same "SQL=" in the detail box at the bottom.

 

[troester]

Is this a form which has been recording to the database originally?
Can you enable fabrik debug (in Fabrik "Options")?

 

[Sophist]

Thanks. That eliminates a potential source.

 

[NickC4555]

I have had it set to record in database - the error doesn't happen in that mode. I have enabled fabrik debug.

 

[troester]

I have had it set to record in database

This may be an issues.
If you want to use a form not recording to DB it's best to create the form directly.

But if the form is not recording to DB I assume you have a redirect/email/php plugin.
Which one(s), which settings?
Is this form inserted via content plugin?

 

[NickC4555]

Now you're onto something. The form is inserted using the content plugin. I tried it displaying directly from a menu item and the error doesn't occur. Unfortunately for this application it has to be displayed using the plugin.

 

[troester]

Did you try to create a new form (not list), directly set to not recording to DB and use this form in the article?
After creating the new form you can move your elements to this form (edit element, select new group, save), so you don't need to create new elements.

 

[NickC4555]

New form, same problem. It does seem to point to the plugin, because it doesn't happen when the same form is used from a menu item. The new form is http://dev.pangeasystems.co.uk/contact-2

 

[rob]

should be fixed now on your site and with this commit :
https://github.com/Fabrik/fabrik/commit/95e07138daee238203a6ca37d26256b260cf665a