Multisite install, "Error adding sheet."

I just tried the latest version of the plugin on the simple multi-site install on my development server and am not having any problems adding sheets/tasks to either of the two sites I set up on the multi-site install.

Are you able to disable other plugins and/or change themes to see if there is a conflict somewhere?

It will be hard for me to track down the problem if I can’t reproduce it here.

Maybe try uninstall/reinstall the plugin? Just guessing at this point.

Also, you will only see that error if an error was returned from WordPress when trying to insert the new sheet into the database tables. So, there is some kind of database write/insert error happening for your install.

Thanks so much for the quick reply, getting closer.

Disabled all plugins and themes did not change the results, but I found this in Apache Error logs:

Field ‘first_date’ doesn’t have a default value for query

INSERT INTO fr_pta_sus_sheets (title,details,type,chair_name,chair_email,reminder1_days,reminder2_days,visible) VALUES (‘Test ADD Sign-up Sheet on Multisite’,”,’Single’,’BG’,’[email protected]’,’0′,’0′,’1′)

made by do_action(‘sign-up-sheets_page_pta-sus-settings_modify_sheet’), call_user_func_array, PTA_SUS_Admin->admin_modify_sheet_page, PTA_SUS_Data->add_sheet, m_wpdb->query, referer: /admin.php?page=pta-sus-settings_modify_sheet

What version of MySQL is on your server? I would need to do some searches to see if there is anything different about different versions that requires a value for all fields when inserting into a table. The two values first_date and last_date can’t be figured out until you add tasks for the sheet, so they are not defined when you do the first step of adding a new sheet, even though the plugin creates the entry in the table. Possibly this is a strict/non-strict issue. Need to do some searching.

Perhaps I can set something up so when a new sheet is added, I set a default value for those first and last dates, which will later be updated when you actually enter some tasks (dates are now specified on the tasks page). Then, if this is an issue with some MySQL strict setting requiring each column to have a value, it would then work.

If you want to contact me privately so that I have your email address, I’ll try adding some code to do that and send the updated file to you to test out. Since it already works the way it is on my sites, I can’t really test the changes out myself.

You can use the contact form on my plugins site to send me your info:
https://stephensherrardplugins.com/contact/

Update…

Adding Allow NULL to the following fields fixed the issue:
– first_date
– last_date
– position

Yes, I was just working on making that change. Initially adding a new sheet was all done on one page (from the old plugin that I forked this one from), so all those values would be set, but I see that I didn’t change several fields from “NOT NULL” which, is some cases, can be null.

Weird that it never caused issues on other sites, and nobody else ever reported a problem… again, must be some kind of strict/non-strict settings.

I’ll make some changes and do some testing to make sure I don’t break anything new, and release this as an update soon.

Removed several “Not Null” statements in fields of the database tables for both sheets and tasks, and that should hopefully fix these issues.

Those changes were made in version 1.5.6. Let me know if you still have troubles after updating.

Marking resolved as this was determined to be an issue with another plugin that altered the WordPress database structure for multi-sites.