error on form submit

Hi,
Wondering if you have ever see the below error. All was working fine on my own hosting setup but site was transferred to another hosting setup. I suspect something may not be right with the new hosting setup but I have limited access to check. Any thoughts?

Thanks....Vince

Error:
Form submit failed
Problem saving data. Table 'guildline.f' doesn't exist SQL=INSERT INTO `#__visforms_4` (`created`,`ipaddress`,`published`,`created_by`,`F65`,`F66`,`F67`,`F68`,`F69`,`F70`,`F71`,`F72`,`F74`,`F75`,`F76`,`F77`,`F78`,`F79`,`F80`,`F100`,`F82`,`F83`,`F84`,`F85`,`F86`,`F87`,`F88`,`F89`,`F90`,`F91`,`F92`,`F93`,`F94`,`F101`,`F96`,`F99`,`F104`,`F105`) VALUES ('2017-02-14 21:19:58','172.68.65.10','0','0','Probata Corporation\r\n14600 Metro Plaza Blvd.\r\nEdmond, OK 73012','Yes','','Javier Easton','Supplier Services/Shipping Receiving Supervisor','javier.easton@probatacorp.com','4056074813','4056074832','Courier','UPS-3 Day - Insurance $ 700.00','A557W1','PO','21704501','','','73-1295634','Standard Resitor - Model: 9336-1G','','','68377','','','1 year','','','Accredited Calibration','','','Calibration','Canada','Javier Easton','207','W-','-USA')

Hi Vince,

I'm absolutely not sure about this but to me it looks as if the actual error is "Table 'guildline.f' doesn't exist ".
This error does not come form Visforms in the first place and I do not know where it comes from, although the rest of the error message clearly comes from Visforms, including the "Problem saving data." The SQL statement that comes from Visforms and which should be performed is the part that starts with "SQL=..." and there is actually no error about this.

It looks, as if the "Table 'guildline.f' doesn't exist " is an error from some other component which tries to do something with the database, and that this error is still somewhere on the stack and causes Visforms to fail to store the data. But somehow this feels just wrong.

Regards,
Aicha

Thanks for the quick response. I agree with your thoughts. I did add a trigger to deal with some auto id creation need. I'm suspecting the folks who installed the database did not install the trigger correctly which might be related to this issue. But not having access to the database makes it difficult to correctly diagnose. I'm trying to gain access now, then I should be able to dig further. Thanks for the response.

Looks like my suspicions are correct. I found a local copy of the database and can see the trigger. The trigger is where the f. is coming from. The folks who installed the database on new hosting platform changed the database name but the trigger is still referencing the old name. I just need to gain access and should be able to correct. Thanks again for the speedy response. Much appreciated.

You're welcome.
I hope you can fix it soon.
Maybe you should remove the error message here in the forum at least the part with the user data.
Regards,
Aicha