hi Sir/Madam,
We are trying to update the expiration date of many event listings. Initially, my approach is to export the listing via csv. We then modify the date and re-import the modified csv. However, we encounter some errors in the import process. As such, we think it is much easier to make a change directly to the MySQL table. Since we are making changes to listing owned by one author, we would think that should be pretty straightforward to do.
All the listing is non-recurring all-day event with one start date and one end date. The only thing we are trying to do is to change the end date. We try to modify “event_enddate” field of the “WPHQ_GEODIR_EVENT_SCHEDULE” table. However, it does not seem to work as we expect. We probably do not understand the table structure correctly. Can someone please point us in the right direction?
thanks for your help.
Peter