Form Wizard Generates an Error

[nevadatex]

I attempted to run Form Wizard on one table that I had created in the Sample database. The error returned was "a4df5bc". No form was created.

[admin]

nevadatex,

It does work, doing things in a certain order might break it though.

I'll need to know this if I am to fix it.

Steven

[nevadatex]

I created a table in the Sample Database using PHPMyAdmin inside EasyPHP loaded on a USB drive. I also entered one record in the table so there would be some data sitting there when I ran the wizard. I logged into the database and selected the Form Wizard button. On the Form Wizard screen, I selected the table name, then selected the fields to add to form objects. I then selected the fields to add to browse column. I clicked the Run button and got the following error:

Error
An error has occurred while running this query. Please contact technical support and quote error reference: 5d5b1b6.
The following information is only provided for users logged on as globeadmin.

SQL

INSERT INTO zzsys_form (zzsys_form_id, sfo_name, sfo_title, sfo_access_without_login, sfo_close_after_save, sfo_refresh_after_save, sfo_sql, sfo_table, sfo_primary_key, sfo_add_button, sfo_save_button, sfo_delete_button, sfo_clone_button, sfo_close_button) VALUES ('15037985d58ec3', '(Wizard) projects', 'projects', '0', '0', '1', 'SELECT * FROM projects', 'projects', 'proj_id', '1', '1', '1', '1', '0');

[admin]

nevadatex,

I'm not sure what is wrong.

Paste the sql into phpmyadmin and see if it gives an error.

Code: Select all

INSERT INTO zzsys_form (zzsys_form_id, sfo_name, sfo_title, sfo_access_without_login, sfo_close_after_save, sfo_refresh_after_save, sfo_sql, sfo_table, sfo_primary_key, sfo_add_button, sfo_save_button, sfo_delete_button, sfo_clone_button, sfo_close_button) VALUES ('15037985d58ec3', '(Wizard) projects', 'projects', '0', '0', '1', 'SELECT * FROM projects', 'projects', 'proj_id', '1', '1', '1', '1', '0');

Steven

[nevadatex]

I ran the SQL in PHPMyAdmin and got the following error.

Field 'sfo_row_height' doesn't have a default value

[admin]

nevadatex,

I don't know why that is but you could run this..

Code: Select all

ALTER TABLE  `zzsys_form` CHANGE  `sfo_row_height`  `sfo_row_height` INT( 11 ) NOT NULL

for sfo_row_height and do the samething for any other fields that give the same error..

Steven

[nevadatex]

I think I found the problem. Did some research on the Web about "mysql insert error no default value" and discovered that the my.ini file had a sql mode setting of "strict" and needed to be set to NULL. I tried to set that to " " and it inadvertantly crashed the MySql server. Couldn't get it to recover, so I went back to the EasyPHP site to reinstall the webserver, I decided to upgrade to the newest version (which wasn't much later than the one I had). I went into the my.ini file to set the sql mode again and found that the sql mode setting had been eliminated. That got me thinking that my problem may be solved. I proceeded to load up the Sample database and copy it to my specific database job which is called "Projects". I added my first table. After solving some problems with the login setup in PhpMyAdmin, I was able to login and went to the Form Wizard. I ran thru the Form Wizard and to my pleasant surprise, it finally WORKED!!!!

[admin]

nevadatex,

Well done!

That's good to know.

Steven