Install issue No record created in DB

You must have the [pdb_signup_thanks] shortcode on your thanks page in order to complete the submission.

Hi, I checked and double checked. It doesn’t add record with it on the correct page, or same page, and I am not able to add a record from the admin panel.

In between the time I posted this I download MySQL database workbench and looked at the database, all the table and columns seem to be there, including the groups and the group data, but I don’t see any data for the client records I am trying to add…

Wonder If this helps:

Feb 28, 05:54:12 WordPress database error Field ‘last_accessed’ doesn’t have a default value for query INSERT INTO tst_participants_database SET date_recorded = NOW(), date_updated = NOW(), first_name = ‘Henry’, email = ‘henry.vanderleest@gmail.com’, date_begin_cdf = ‘1969’, private_id = ‘ICTX2’ made by require(‘E:\web\empirexd\tst\wp-blog-header.php’), require_once(‘E:\web\empirexd\tst\wp-load.php’), require_once(‘E:\web\empirexd\tst\wp-config.php’), require_once(‘E:\web\empirexd\tst\wp-settings.php’), do_action(‘init’), call_user_func_array, Participants_Db::init, Participants_Db::process_page_request, Participants_Db::process_form

Thanks for that…that gave me the piece I was missing. I now understand the problem, and I’m going to have to release a fix for it.

What happened is the MySQL server is running in a strict mode that doesn’t allow the form of statement I was using. You can probably fix this right away by switching your MySQL server out of strict mode. This is probably something your web host will have to help you with unless you’re familiar with changing the settings on a MySQL server.

Ok, I have requested a ticket with my host concerning the “strict mode” , as I don’t know how to make the change.
I wonder if my database login would allow me to make this change if I could figure out how to do it…
This script is running on a test site, my intention is to use it on another after doing testing, so my other site will need the change also.
How long till you issue the “fix” ?

Thanks

Henry

Ok, my hosting company replied, they can’t/won’t change the strict mode, but said I could change it on a call by call basis, so, I guess the ball is in your court.
Henry

Hi Henry,

OK, the bad news: WordPress does not support MySQL strict mode. (here is the reference to that) There are different kinds of strict mode, some of them won’t even allow WordPress to install.

I can fix my plugin to avoid this particular error, but you may find you’re running into other problems with WordPress.

Well, I appreciate your effort. It looks to me like it has strict rules for date time like fields. Other than images, my use is primarily text…
Having said that, what would be your time frame for the fix. I am going to pursue a custom template to display the data, and I wont be able to do that until I have some data.
My good friend Murphy is always looking over our shoulders.
Henry

Hi Henry,

still trying to get more detail on this, can you help me out a little? Do you know how to look at the database using PHPMyAdmin? If so, what I need you to do is grab a screenshot of the “structure” screen for the participants_database table.

email it to me at support AT xnau.com

thanks very much

I am using MySQL workbench, can I get what you want in that?

As long as I can see the structure (not the data) of the table, that will help.

Issue resolved. Thanks for the great support and your fast responses.

The plug in is great, I see many good possibilities with it..

Henry