getting fatal error message

[Rika]

I get a similar error message when I try to re-order the events using the re-order link on the Events dashboard:

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 192 bytes) in /home/content/p3pnexwpnas06_data02/26/3217726/html/wp-includes/cache.php on line 672

[Rika]

Hi Geoff

I have spoken to GoDaddy again and tried putting the php memory back up to 1024MB. No success. The site is now crashing when it tries to access the calendar and it then affects every site page in an open browser tab which then all freeze. This is getting ridiculous. There must be a way to find the problem which seems to be a database error somewhere.

Please go to the homepage at jccmw.org and click on calendar in the top righthand corner.

[Geoff B.]

Good evening Rika,

Thank you for writing back.

Running a sql query to find the recurring events doesn’t really help me as 99% of the events are in recurring series – over 1100 recurring events. It will take me days to resave all of them.

I believe I might have miscommunicated what the snippet does. My apologies.
This database query identifies only a handful of potentially problematic parent events. It is usually 2-3 events max.

This is by far the fastest approach to things, because if this is the cause of the issue, it can be fixed pretty quickly.

It really boils down to what that query returns. Please share the results you are getting from it with me.

The three other ways to run SQL queries are:

1. Via SSH (terminal)
2. Using a dedicated SQL local client on your computer (ex: SQL Pro for mac)
3. Having access to a phpMyAdmin type of interface

I get a similar error message when I try to re-order the events using the re-order link on the Events dashboard:

I am sorry to hear about that. There is something driving up the memory usage on your specific WordPress installation.
So far the most likely culprit is the presence of corrupted recurring events.

The site is now crashing when it tries to access the calendar and it then affects every site page in an open browser tab which then all freeze. This is getting ridiculous. There must be a way to find the problem which seems to be a database error somewhere.

We are in agreement, we have to get to the bottom of this ASAP.

With that in mind, could you please run that query and tell me what the results are ?

Additionally, since there is likely something off at the Database level, no amount of memory can compensate for the cause of the issue. Our best bet is to move fast with the suggestions.

As an alternative, there is something that you could try that could very well stabilize things.
But before trying that, I would highly recommend a complete database backup (and the ability to revert back to that backup if needed).

You mentioned that you don’t have access to a phpMyAdmin like interface. So you would have to see with GoDaddy how database backups work with your type of plan.

In any case, something that might work would be to temporarily deactivate the Pro plugin. If I am right about this, it will stop the “bleeding” (but also temporarily remove all the Pro features).

Best regards,

Geoff B.

[Rika]

This is what I get when I run the query

Fatal error: Uncaught exception ‘MDatabaseException’ with message ‘You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘0 AND post_type = \’tribe_events\’ GROUP BY post_parent ORDER BY ‘ at line 12 SQL=/* Shows how many recurrences each recurring event has. Includes events from all statuses including in the trash. */ SELECT post_parent as event_id, COUNT(*) As recurrences FROM wp_posts WHERE post_parent 0 AND post_type = \’tribe_events\’ GROUP BY post_parent ORDER BY recurrences DESC’ in /home/content/p3pnexwpnas06_data02/26/3217726/html/wp-content/miwi/framework/database/database/mysql.php:300 Stack trace: #0 /home/content/p3pnexwpnas06_data02/26/3217726/html/wp-content/miwi/framework/database/database.php(410): MDatabaseMySQL->execute() #1 /home/content/p3pnexwpnas06_data02/26/3217726/html/wp-content/plugins/miwosql/admin/models/miwosql.php(234): MDatabase->loadAssocList() #2 /ho in /home/content/p3pnexwpnas06_data02/26/3217726/html/wp-content/miwi/framework/database/database/mysql.php on line 300

[Rika]

I have daily backups so that is not a problem.

Please let me know if the query results show a way forward.

[Rika]

I have tried deactivating the Calendar PRO plug in but it doesn’t change anything – site is still freezing.

[Geoff B.]

Good evening Rika,

Thank you for trying the query out.
It looks like the plugin blocks the actual query from being run normally.

I just tested the query with the plugin (I get the same result as you) and with phpMyAdmin (it works great).
It is a shame that your plan will not let you use a DB management tool.

At this point, I would like to ask the specialist for this type of issue to chime in so that we can get to the bottom of this as fast as possible.

Hang in there!

Geoff B.

 

[Brook]

Howdy Rika,

Geoff asked me to take a look here. It’s nice to meet you, I’d love to assist with this.

What hosting plan are you on with GoDaddy? You probably still have access to PHPMyAdmin. Even their managed plans, such as the “Managed WordPress” one, still have access to PHP My Admin. Right now getting access to your SQL server would be incredibly helpful, and the typical way on almost every host out there is via PHPMyAdmin. Can you double check with GoDaddy that you do not have this access?

If you can get access, could you run through the steps Geoff outlined, In particular running that SQL query (https://gist.github.com/elimn/a998d7b67f6166dab5e17ec071eb35ee). Do note that sometimes your database has a different prefix than the default. The usual prefix is “wp_” and so that query attempts to select:

FROM 
 wp_posts

But if yous is a different prefix, like rika_ then you would want to change that query to:

FROM 
 rika_posts

Does that make sense? Are you able to get access and run the query?

Cheers!

– Brook

[Rika]

Hi Brook

I do have phpmyadmin access to the databases etc. I went into SQL and ran the query. Here’s what I got:

Error
SQL query: Documentation

SELECT post_parent AS event_id, COUNT( * ) AS recurrences
FROM wp_posts
WHERE post_parent <>0
AND post_type = ‘tribe_events’
GROUP BY post_parent
ORDER BY recurrences DESC
LIMIT 0 , 30

MySQL said: Documentation

#1146 – Table ‘a95d3217726726.wp_posts’ doesn’t exist

My databases do start with wp_

Please advise what I should do now. I have very little knowledge of servers/SQL.

THanks

Judy

[Rika]

Update –
I ran the query with the wp_xxxxxx_posts
using the same beginning for all the databases in my site.
It gave me this – see below. Looks like event id 3130 is the problem – is there a way to find it? From the dashboard or the server?

Show :
30
row(s) starting from record #
30

in mode and repeat headers after
100
cells > >> Page number:
Sort by key:
Full Texts
event_id recurrences Descending
3130 15877
2552 301
7498 64
5087 39
5244 38
4897 38
5205 37
5010 37
5128 37
4859 36
4972 36
5049 36
5167 36
4937 33
4825 32
4588 32
4653 32
4761 32
4556 30
4433 29
4121 29
4464 29
2434 29
4152 29
4495 29
4183 29
5284 29
4214 29
4279 29
4622 29

[Brook]

Excellent you got access!

That’s interesting. Would you mind taking a screenshot of your PHPMy Admin’s database? You might need to click on the database in the left hand column, it looks yours is called a95d3217726726. Then it will show you a list of all tables in that database. Could you capture those as a screenshot and share it here? For instance here is what mine looks like:

From there I can hopefully determine what your posts table is called.

Cheers!

– Brook

[Rika]

there’s 80 tables in the database – I’ve screenshot as many as I can. LMK if you need to see the rest.

[Brook]

Ooops we cross posted. I now see your update. There definitely is, if you go to: http://yoursite.org/wp-admin/post.php?post=3130&action=edit That should be the event. If you add a space to the description area, maybe after the rest of the content, then hit Update, it will regenerate that event.

Before clicking Update I would double check your recurrence settings. Are they setup to generate 15000 recurrences? Like is it set multiple times every day or anything? If they look good then just hit update, and any duplicate recurrences should get removed. You will see a progress bar at the top as it works to regenerate this sequences, it could take a good while to regenerate, but you can safely navigate away and it will continue working in the background, speeding up your site each hour that passes. Once the progress bar is complete you should be done! Does the progress bar appear as expected?

Cheers!

– Brook

[Rika]

There is a posts table – how do I access the contents?

[Rika]

The link isn’t bringingup the one event. It’s taking me to a list of posts (media clippings) followed by a page of events.

[Author]

Posts