TEMA:

Hi,

I'm updating a site from Joomla! 1.0.x to 1.5.4 and have installed BreezingForms as part of that process - and I have donated a small amount today I hope the good work on this extension continues!!

I am trying to create a package from the Facile Forms on the old site, so that I can try to import it into the new site (I'm hoping BreezingForms will accept an old FacileForms package import!)

However, I am having a problem, when I set up the package to be created, I get this error:

DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=select name from jos_facileforms_pieces where id=

I know it's not technically a problem with BreezingForms, but I thought since you're more expert with FacileForms than I am, perhaps you could give me some guidance on how to fix this?

Thanks,
Scott

hey, first of all thanks for the donation! do you mind if I will put you on the donators list?

your problem: looks like the pieces id is empty. did you accidentally delete a piece and you form is still referencing it? if yes, try to restore the piece(s).

this would be the first thing I would check.

Thanks TheMuffinMan!

Yes, feel free to add me to your list of donators.

Through some trial and error I found that the problem is with one particular form. I haven't checked yet to see if there are pieces being referenced in that form that no longer exist, but I'll do that next.

For now, I have all the rest of the forms imported into BreezingForms and I am a very happy guy that I don't have to recreate some of the longer, more complicated forms we have!!!

Thanks,
Scott

You were right!

The one form that was causing the problem had some pieces set that were blank. Changing those to "none" made it possible to export it successfully.

Thanks for your help!

Scott