[Plugin: GigPress] Unable to edit anything.

Can you tell me what the error message is when you try to edit a venue or an artist?

Well I guess I assumed that I would get the same error with editing venues & artist but, I don’t. To be clear I can edited venues & artist.
What I can’t do is edit a show at all. Once I enter a show that’s it nothing else can be done. I can’t go back and add details or change the time, nothing.
I get the edit screen, I fill out the changes I would like to make then I hit save and I get the following error.

WordPress database error Out of range value adjusted for column ‘show_related’ at row 1 for query UPDATEwp_gigpress_showsSETshow_date= ‘2009-11-08′,show_time= ’00:00:01’,show_expire= ‘2009-11-08’,show_multi= ‘0’,show_price= ”,show_tix_url= ”,show_tix_phone= ”,show_ages= ‘Not sure’,show_notes= ‘Two Services 9:00am & 10:45‘,show_status= ‘active’,show_artist_id= ‘1’,show_venue_id= ’22’,show_tour_id= ‘0’,show_related= ” WHEREshow_id= 3 made by do_action, call_user_func_array, gigpress_add, gigpress_update_show

OK, that’s good. Do you have access to your database via phpMyAdmin? If so, try changing the show_related column of the wp_gigpress_shows table to have a default value of 0. My intuition is that you’re running MySQL in STRICT mode, and this is the problem.

Let me know?

hmmm…
I sent the default valve to 0 but, I still get the following error…

WordPress database error Out of range value adjusted for column ‘show_related’ at row 1 for query UPDATE wp_gigpress_shows SET show_date = ‘2009-11-08’, show_time = ’00:00:01′, show_expire = ‘2009-11-08’, show_multi = ‘0’, show_price = ”, show_tix_url = ”, show_tix_phone = ”, show_ages = ‘Not sure’, show_notes = ‘
Two Services 9:00am & 10:45‘, show_status = ‘active’, show_artist_id = ‘1’, show_venue_id = ’22’, show_tour_id = ‘0’, show_related = ” WHERE show_id = 3 made by do_action, call_user_func_array, gigpress_add, gigpress_update_show

Just in case it helps this is what it is currently set at:
show_related int(4) default ‘0’,

Hmm …. can you email me at [email protected]? I’ll send you an updated file to see about solving this.

That fixed it! Thanks for your help!
Great plugin!