mysql snippet for set to weekly

[Ronald]

Ran the code snippet. I did a search and replace to fix table names from wp_ to match my database structure and got this error

Error

SQL query:

DELIMITER;

CALL tribe_update_ea_schedule(

);

MySQL said: Documentation
#1312 – PROCEDURE broa3249864771.tribe_update_ea_schedule can’t return a result set in the given context

MYSQL version 5.5

[Cliff]

Hi Ronald. I see this question is a continuation of your previous thread at https://theeventscalendar.com/support/forums/topic/question-on-100-a-day-limit/

I suggested in that thread that if you have any issues with this SQL script, you should ask your host.

However, I did find http://stackoverflow.com/questions/2360371/mysql-stored-procedures-not-working-with-select-basic-question, which may indicate an error with older versions of PHPMyAdmin (since you’re not on that old of a version of MySQL, as described in this link).

If your server/host gives you access to the command line, you could run that query directly or ask them to run it for you.

Again, I’m going to need to refer you back to your web host to dig deeper into this, but I hope this additional research helps.

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts