Form Tools
Can't complete installation step 3 - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: Installation (https://forums.formtools.org/forumdisplay.php?fid=4)
+--- Thread: Can't complete installation step 3 (/showthread.php?tid=1426)

Pages: 1 2


Can't complete installation step 3 - pepperbeast - Jun 28th, 2011

When I try to set up, I can't complete step 3.

The error displayed is • INSERT INTO ft_accounts (account_id, account_type, account_status, timezone_offset, login_page, menu_id) VALUES (1, 'admin', 'active', '0', 'admin_forms', 1) - Field 'username' doesn't have a default value.


RE: Can't complete installation step 3 - Ben - Jul 1st, 2011

Interesting! Is this with the 2.1.0 beta or the current release?

It looks like maybe you have strict mode - or something else of that nature running on your database.

- Ben


RE: Can't complete installation step 3 - pepperbeast - Jul 1st, 2011

It's the current release.


RE: Can't complete installation step 3 - pepperbeast - Jul 3rd, 2011

MySQL mode information
'STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER'



RE: Can't complete installation step 3 - pepperbeast - Jul 4th, 2011

Turned out it was indeed a mode problem.

http://thilinaonline.wordpress.com/2010/06/20/how-to-disable-strict-mode-in-mysql-5-windows-xp/


RE: Can't complete installation step 3 - victorycck - Jul 4th, 2011

what do you mean by 'mode problem'? I actually got the same poblem an d don't know how to solve it. it reads:

The following error occurred:

• INSERT INTO ft_accounts (account_id, account_type, account_status, timezone_offset, login_page, menu_id) VALUES (1, 'admin', 'active', '0', 'admin_forms', 1) - Field 'username' doesn't have a default value

Please double-check your database settings and click the Continue button again.


RE: Can't complete installation step 3 - Ben - Jul 4th, 2011

Hey guys,

I'm going to fix this with 2.1.0, but probably not 2.0.6. Strict mode isn't that common, and I think it's fair to require it to be off.

- Ben


RE: Can't complete installation step 3 - Ben - Jul 4th, 2011

Hey victory,

Sorry, that last remark of mine wasn't terribly helpful! To fix it, you should be able to just add this line to your /global/code/general.php file at line 45:

Code:
@mysql_query("SET SQL_MODE = ''", $link);

It should appear right after these two lines:

Code:
if ($g_unicode)
    @mysql_query("SET NAMES 'utf8'", $link);

Let me know if that fixes it for you.

All the best -

- Ben



RE: Can't complete installation step 3 - victorycck - Jul 5th, 2011

Thanks for your response but it still did not work. I got this error:

The following error occurred:

• INSERT INTO ft_accounts (account_id, account_type, account_status, timezone_offset, login_page, menu_id) VALUES (1, 'admin', 'active', '0', 'admin_forms', 1) - Field 'username' doesn't have a default value

Please double-check your database settings and click the Continue button again.


RE: Can't complete installation step 3 - Ben - Jul 6th, 2011

Hi Victory,

Weird... that worked for me! And change I get could get temporary access to your installation (FTP + Form Tools access) so I could log on and debug the problem directly? If so, send me an email at ben.keen@gmail.com containing your FTP information and Form Tools login information.

- Ben