[Plugin: GigPress] Unable to edit anything.

  • allshookup

    (@allshookup)


    14 years, 6 months 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

Viewing 7 replies - 1 through 7 (of 7 total)
  • mrherbivore

    (@mrherbivore)

    14 years, 6 months ago

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

    Thread Starter allshookup

    (@allshookup)

    14 years, 6 months 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

    mrherbivore

    (@mrherbivore)

    14 years, 6 months 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?

    Thread Starter allshookup

    (@allshookup)

    14 years, 6 months 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

    Thread Starter allshookup

    (@allshookup)

    14 years, 6 months ago

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

    mrherbivore

    (@mrherbivore)

    14 years, 6 months ago

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

    Thread Starter allshookup

    (@allshookup)

    14 years, 6 months ago

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘[Plugin: GigPress] Unable to edit anything.’ is closed to new replies.