WordPress.org

1. allshookup
   Member
   Posted 3 weeks ago #

   First off I have the latest version installed 2.0.2
   I am unable to edit a date, venue or whatever...
   I can add new venues, dates, etc... I just can go back and edit them.
   When I try to I get the following blank page with the error massage:

   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= '<strong>Two Services 9:00am & 10:45</strong>',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

2. mrherbivore
   Member
   Posted 3 weeks ago #

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

3. allshookup
   Member
   Posted 3 weeks ago #

   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

4. mrherbivore
   Member
   Posted 3 weeks ago #

   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?

5. allshookup
   Member
   Posted 3 weeks ago #

   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

6. allshookup
   Member
   Posted 3 weeks ago #

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

7. mrherbivore
   Member
   Posted 3 weeks ago #

   Hmm .... can you email me at derek@gigpress.com? I'll send you an updated file to see about solving this.

8. allshookup
   Member
   Posted 3 weeks ago #

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

Reply

You must log in to post.