[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]

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

[Rika]

I have daily backups so that is not a problem.

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

[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]

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.

[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

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.

Is there anything else I can try? I’ve downloaded the plugin so I can run basic queries – is there something there to check?

Is there any other way to check the databases?

[Rika]

I can’t access my server (on managed hosting package) so can’t run the SQL query.

The website is for a community center with a lot of classes – swim, ballet, art, sports etc so we do have a lot of events. I selected Events Calendar because I thought it could handle this number.

I have been going through the events – I have over 1000 pages so it is a huge task – and the calendar does not seem to delete events once completed. Is there a way in the plug in to speed this up?

[Rika]

Hi Geoff

Thank you for the email. I am getting back to this after my vacation as we are still getting the error message.

Re updating, we only use events calendar pro and that is up to date.

There are 23,455 items in the events calendar. Many of these are recurring. Is there an easy way to re-save every event?

[Rika]

This reply is private.

[Rika]

This reply is private.

[Rika]

My site is completely down – godaddy are supposedly restoring the databases
– so I can’t access the dashboard to export a copy. We are using the
Premium Virtue theme with minor modifications.

I got godaddy to increase the wp php memory to 1000mb.

I would have to ask them for the timeout settings as we are on managed
hosting.

[Rika]

This reply is private.

[Rika]

This reply is private.

[Rika]

Hi

I’d like an event to disappear once it has happened, not just update each day. When you looked at the link last night, the calendar was showing morning classes, even though there were afternoon events after the morning classes.

[Author]

Posts