Title: Multisite install, "Error adding sheet."
Last modified: August 21, 2016

---

# Multisite install, "Error adding sheet."

 *  Resolved [bgetkin](https://wordpress.org/support/users/bgetkin/)
 * (@bgetkin)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/multisite-install-error-adding-sheet/)
 * Hello,
 * Great plugin, exactly what I need but can’t seem to add sheet to sub-site of 
   multisite install, returns “Error adding sheet.” in all cases.
 * [https://wordpress.org/plugins/pta-volunteer-sign-up-sheets/](https://wordpress.org/plugins/pta-volunteer-sign-up-sheets/)

Viewing 8 replies - 1 through 8 (of 8 total)

 *  Plugin Author [DBAR Productions](https://wordpress.org/support/users/dbar-productions/)
 * (@dbar-productions)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/multisite-install-error-adding-sheet/#post-5043102)
 * 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.
 *  Plugin Author [DBAR Productions](https://wordpress.org/support/users/dbar-productions/)
 * (@dbar-productions)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/multisite-install-error-adding-sheet/#post-5043103)
 * 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.
 *  Thread Starter [bgetkin](https://wordpress.org/support/users/bgetkin/)
 * (@bgetkin)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/multisite-install-error-adding-sheet/#post-5043118)
 * 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’,’brian.getkin@gmail.com’,’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
 *  Plugin Author [DBAR Productions](https://wordpress.org/support/users/dbar-productions/)
 * (@dbar-productions)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/multisite-install-error-adding-sheet/#post-5043144)
 * 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/](https://stephensherrardplugins.com/contact/)
 *  Thread Starter [bgetkin](https://wordpress.org/support/users/bgetkin/)
 * (@bgetkin)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/multisite-install-error-adding-sheet/#post-5043148)
 * Update…
 * Adding Allow NULL to the following fields fixed the issue:
    – first_date – last_date–
   position
 *  Plugin Author [DBAR Productions](https://wordpress.org/support/users/dbar-productions/)
 * (@dbar-productions)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/multisite-install-error-adding-sheet/#post-5043154)
 * 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.
 *  Plugin Author [DBAR Productions](https://wordpress.org/support/users/dbar-productions/)
 * (@dbar-productions)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/multisite-install-error-adding-sheet/#post-5043193)
 * 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.
 *  Plugin Author [DBAR Productions](https://wordpress.org/support/users/dbar-productions/)
 * (@dbar-productions)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/multisite-install-error-adding-sheet/#post-5043441)
 * Marking resolved as this was determined to be an issue with another plugin that
   altered the WordPress database structure for multi-sites.

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Multisite install, "Error adding sheet."’ is closed to new replies.

 * ![](https://ps.w.org/pta-volunteer-sign-up-sheets/assets/icon-128x128.jpg?rev
   =980645)
 * [Volunteer Sign Up Sheets](https://wordpress.org/plugins/pta-volunteer-sign-up-sheets/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/pta-volunteer-sign-up-sheets/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/pta-volunteer-sign-up-sheets/)
 * [Active Topics](https://wordpress.org/support/plugin/pta-volunteer-sign-up-sheets/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/pta-volunteer-sign-up-sheets/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/pta-volunteer-sign-up-sheets/reviews/)

 * 8 replies
 * 2 participants
 * Last reply from: [DBAR Productions](https://wordpress.org/support/users/dbar-productions/)
 * Last activity: [11 years, 10 months ago](https://wordpress.org/support/topic/multisite-install-error-adding-sheet/#post-5043441)
 * Status: resolved