|
jmazziotta
|
September 4, 2015 at 1:09 pm
Hello,
I am creating events and when I view them on the front end, it has this giant list of start times for the event. Now, at the time of creation, I am “removing” start 2 through start 64 as to just have ONE start time but when I save it, thse times all come back, thus creating multiple start times for one event showing on the front end to the viewer. I DO NOT want this, I just want one start time.
Can you help me figure out why it is doing this?
thanks!
Jackie Ruiz
|
|
Lorenzo Orlando Caum
|
September 16, 2015 at 5:48 pm
Hi Jackie,
This could happen if you tried to use an old version of Event Espresso with the a current version of WordPress. We recommend staying up to date as we regularly release updates for Event Espresso to maintain compatibility with the latest version of WordPress.
We have a solution here which explains how to clear those out:
https://eventespresso.com/topic/add-event-displays-57-start-times-how-to-get-rid-of-them/#post-157228
—
Lorenzo
|
|
jmazziotta
|
September 21, 2015 at 9:10 pm
Thanks for the reply.
I upgraded and it works fine now, when I delete all the other times (in the initial setup of the event).
Now my question is, is there a way to not have so many “event date/times” and “event prices” shown when you initially setup an event? Why does it give you so many that you have to “remove” or “subtract”? It should be the option of adding start times and prices, not having to remove them. For instance, I am having to remove 128 “event date/times” and 275 “event prices” before i can save the event and have it displayed right.
Is there a fix for this? Maybe I am missing something in the setting area.
thanks in advance!
|
|
Tony
|
September 22, 2015 at 2:40 am
Hi there,
To explain a little where this has come from… in WordPress 4.2+ they introduced a new security feature in which fields that were to long for the database columns now return nothing (previously the data was truncated and added to the DB)
Without going into detail this causes EE 3.1.36.x and below to create a ‘blank’ row within the database (EE creates a time and price that applies to an event_id = 0) if you are using longer values that the DB expects.
We applied fixes to 3.1.37+ that prevents this, however if you used WP4.2 with 3.1.36 you will already have those additional rows saved in the db.
So when creating a new event, EE pulls the times and prices from the DB to be display, as those rows apply to no specific event_id it shows them too… all make sense?
So to fix this those fields need to be manually removed from the database which is the fix Lorenzo posted above, are you comfortable making changes to the database?
If not send login details using this form:
https://eventespresso.com/send-login-details/
I will remove those for you. However please make a database backup before doing so, just to be safe.
|
|
jmazziotta
|
September 22, 2015 at 9:58 am
Hello,
Thanks for the prompt response.
I went into the database and when I look at those tables suggested in that post (wp_events_start_end table, wp_events_prices table and wp_events_category_rel table), none of them have records that have a “0” in the “event_id” column. Maybe I am missing something, but I would like to see the problem before I would let someone else go in there to delete them.
I can send a screen shot if you allow this.
thanks in advance
|
|
Tony
|
September 22, 2015 at 10:01 am
For screenshots you’ll need to host them and post the link here.
We have some examples here:
https://eventespresso.com/wiki/troubleshooting-checklist/#screenshots
You can also add it to the media library within your dashboard and include the link from that if you prefer.
|
|
jmazziotta
|
September 22, 2015 at 10:16 am
See the links here
Prices Table;
http://www.sandiegoparent.com/wp-content/uploads/2015/09/prices.png
start and end times table:
http://www.sandiegoparent.com/wp-content/uploads/2015/09/star-end-table.png
Category Table:
http://www.sandiegoparent.com/wp-content/uploads/2015/09/category.png
I cannot find any “0” in the “event_ID” column in either of the tables. What am I missing?
thanks!
|
|
jmazziotta
|
September 22, 2015 at 10:17 am
I should add that I did search through all the records and even at the end of the table there are no “0” entries.
|
|
Tony
|
September 22, 2015 at 10:36 am
Looking within the event prices table, is you sort by event_id DESC, do you have many (in the example above is was 275) rows assigned to the same event_id?
|
|
jmazziotta
|
September 22, 2015 at 10:56 am
I don’t see a event_id DESC field…..
How do I find the rows assigned to the same event id? Do I have to expand the record or something? Sorry, I just want to be able to understand the issue before I make changes to anything. I do appreciate your time and patience.
|
|
Josh
|
September 22, 2015 at 1:25 pm
It’s still the event_id field, but you apply a sort by DESC (descending) instead of sort by ASC (ascending).
|
|
jmazziotta
|
September 22, 2015 at 1:30 pm
Yep, when I assort descending, it ends with 95, there are no “0” anywhere in that field. I looked through the entire table and all the records in each table and there apple to be no “0” in any of them in that column. So what might the issue be when I create an event that it would create so many start times and prices?
thanks!
|
|
Josh
|
September 22, 2015 at 1:41 pm
We’d need to be able to look at some copies of the database tables to be able to answer your question.
|
|
jmazziotta
|
September 22, 2015 at 1:49 pm
ok, I am sending login information shortly via the link you sent above.
thanks!
|
|
Tony
|
September 22, 2015 at 2:11 pm
I don’t see a event_id DESC field…..
Apologies, what I meant was if you sort the event_id column descending (largest number to lowest)
Usually you can do this by clicking on the column name to change between ascending order (ASC) or descending order (DESC) – http://take.ms/0RQp0
The only reason for those multiple times and prices would be those fields within the database, so it would be really strange if they aren’t there.
|
|
jmazziotta
|
September 22, 2015 at 2:17 pm
I will wait for Josh to respond,as I sent him login information for our wordpress website and database.
When I sort descending, the largest number is 95 and the smallest is 1…..there are no 0’s anywhere that I can see.
thanks!
|
|
Josh
|
September 22, 2015 at 4:00 pm
Hi Jackie,
I checked and we didn’t receive anything from that form yet. There’s a section that will not allow the form to submit if it’s not fully filled out. Can you try sending again via that form?
|
|
jmazziotta
|
September 23, 2015 at 4:54 pm
I sent the info again and this time got a confirmation email. Please advise what to do next.
thanks!
|
|
Tony
|
September 24, 2015 at 4:03 am
Hi Jackie,
I’ve been looking over your database and it appears the details sent are for an older or different database.
The events table only lists events from 2012 and checking your users table, I can’t see the user account that was created for us to log into the site with and again lists users from 2012 (the login does work on the site itself) so it appears that link is loading either a different database than your site is currently using or an older version of that database.
As no FTP details have been provided we won’t install any plugins (as renaming the plugin directory via FTP is needed if the plugin causes the site to go down) but I would recommend installing a plugin call Adminer which basically gives you the same view you have now only from within the dashboard.
That uses the details within your wp-config.php file to connect to the same database your site is. If you can let me know once that plugin has been installed I’ll take another look using that.
|
|
jmazziotta
|
September 24, 2015 at 8:45 am
I installed the Adminer plugin but when I try to open it in both the dashboard and a new tab, it is just blank. Maybe I am missing something on my end.
I do appreciate the help and think we are close to finding an answer! I will try and track down the database info to maybe login from outside the dashboard.
thanks again!
|
|
Tony
|
September 24, 2015 at 9:06 am
Hmm, that’s strange.
When you say blank do you mean just a whitescreen?
If so do you know how to enable WP_DEBUG within wp-config.php? (You’ll need to do so via FTP)
If you enable that and retry it should show and error message we can use to see what is happening.
|
|
jmazziotta
|
September 24, 2015 at 9:08 am
Yes just a white screen. I am running out the door in a few moments, so I will have to do this later today. What time are your forum hours? I am on the west coast (PST), it is 8:08am here now.
thanks!
|
|
Tony
|
September 24, 2015 at 9:15 am
No problem 🙂
The forum hours are:
Monday – Friday:
7AM – 7PM EST
12PM – 12AM UTC
|
|
jmazziotta
|
September 24, 2015 at 3:35 pm
Hello,
I got the login for the correct database, it was that I didn’t have the right privileges and I see what you are talking about now with the “0” in the “event_ID” column. So this solution post on that other thread is the answer, correct?
Thread:
You can remove those extra start times by going into phpmyadmin. They are in the wp_events_start_end table. All rows that have 0 for event_id should be removed. The same will also be true for any rows in wp_events_prices wp_events_category_rel too. Any rows that have 0 for event_id should be removed there too.
I found them and can do this myself. I just need a confirmation as to yes, thats all I have to do and all those multiple times and prices will go away.
thanks!
|
|
Lorenzo Orlando Caum
|
September 24, 2015 at 5:14 pm
Hi, those are the same steps that we would follow.
Please do backup your WordPress site including the database prior to making those changes.
https://eventespresso.com/wiki/how-to-back-up-your-site/
Thanks
—
Lorenzo
|
