Keep getting this error when submitting form to MySql DB:

Fatal error: Uncaught exception 'Exception' with message 'DateTime::__construct() [<a href='datetime.--construct'>datetime.--construct</a>]: Failed to parse time string (Fred Lueck) at position 0 (F): The timezone could not be found in the database' in C:\inetpub\wwwroot\ibrbsantas\forms\Contact_Form\fbapp\php\config.cls.php:179 Stack trace: #0 C:\inetpub\wwwroot\ibrbsantas\forms\Contact_Form\fbapp\php\config.cls.php(179): DateTime->__construct('Fred Lueck') #1 C:\inetpub\wwwroot\ibrbsantas\forms\Contact_Form\fbapp\php\datasavemysql.cls.php(399): Config->ApplyUserTimezone('Fred Lueck') #2 C:\inetpub\wwwroot\ibrbsantas\forms\Contact_Form\fbapp\php\datasave.cls.php(343): DataSaveMySQL->_applyTimeZone('Fred Lueck') #3 C:\inetpub\wwwroot\ibrbsantas\forms\Contact_Form\fbapp\php\datasave.cls.php(77): DataSave->_InsertRow() #4 C:\inetpub\wwwroot\ibrbsantas\forms\Contact_Form\fbapp\php\formpage.cls.php(475): DataSave->Save() #5 C:\inetpub\wwwroot\ibrbsantas\forms\Contact_Form\fbapp\php\formpage.cls.php(318): FormPage->_ProcessPos in C:\inetpub\wwwroot\ibrbsantas\forms\Contact_Form\fbapp\php\config.cls.php on line 179

Form keeps trying to parse first field as time. Happens to be my name. Have been fighting this for 3 days. Even reinstalled WFB. Built form with just 3 fields. It does post to csv file. Have set the MySql setup fields correctly including time to "America/Los_Angeles". Any help would be appreciated.

Fred the Elder

I see you are on a Windows server. Make sure you server is first meets the server requirements. From what you have pasted, I don't think it does.

http://www.coffeecup.com/help/articles/ … m-builder/

You can always publish to S-Drive.

Dbl check that you entered the proper name for the data base and that it's actually on the server.

Thanks for input. However: Win7 fully patched, 16gig mem, IIS 7.5, php 5.3.8, cUrl 7.21.7, sessions support enabled. I run Ecommerce Templates PHP shopping cart with no problem. Had small sign up form to do and thought CC WFB would be simple way to go. Not so.

Something in form not working with time stamp. WFB automatically adds time stamp field. We seem to have no control over it being part of the form.

The timezone could not be found in the database' in C:\inetpub\wwwroot\ibrbsantas\forms\Contact_Form\fbapp\php\config.cls.php:179

Line 179 = $recorded_time = new DateTime( $value );

In checking time in csv file, it seems to be set at UTC 0, not +8 which is west coast (I live in Washington state). I have set time in WFB settings to: America/Los_Angeles.

I also have correct MySql information: localhost, 3306, root, XXXXX (password), test (name of db), contacts (name of table).

Am I only one who has had this anomoly? Fred

If you go into the Settings > General Tab, are the TimZone drop down lists empty? If they are, then go to these locations and make sure they are populated with files. If one is empty, just copy the contents from one to the other. Once you do that, re-export and upload your form.

C:\Users\[account-name]\Documents\CoffeeCup Software\Web Form Builder\timezones

C:\Program Files\CoffeeCup Software\Web Form Builder\library\timezones

I had the exact same issue running on a Linux server. (Lunarpages). I reverted to the previous version of web form builder (2.1 build 4652) and my form worked just fine.

~Darrel

Thank you Darrel,

I reverted to my version 2.1.4504 and it worked like a champ.

For CC info: update 4504 uploaded 68 files verses 4866's 75 files to my server test folder.

Also Scott, I did check the time listing as you suggested and both folders were correct and the same.

Would seem to be a CC bug only on some development servers. The only additional piece of info is I do run the 64-bit version of Win7.

Again Darrel, many thanks for the info.

Fred the Elder