Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Error: Prepared statement needs to be re-prepared*
LaughingQuoll
New
Can someone please tell me what this error means and how to fix it: PDO Statement failed to execute|Gdn_Database|Query|[HY000] (1615) Prepared statement needs to be re-prepared|select count(u.UserID) as UserCount
from GDN_User u join GDN_UserRole ur on u.UserID = ur.UserID where ur.RoleID = :urRoleID and u.Deleted = :uDeleted
0
Comments
what mysql version are you using? or possibly upgrade your sql to more recent version.
try increasing table_definition_cache to 16384 in your sql configuration.
http://dev.mysql.com/doc/refman/5.1/en/statement-repreparation.html
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
@peregrine MySQL version: 5.1.73-cll where do I edit the MySQL config?
that would be done by googling and asking your host to do it, if you don't know how. or asking them to upgrade your sql to to see if that improves it.
this really a non-vanilla forum question. it is a hosting provider question.
Thank you for asking your host.
excellent descriptive title btw, almost as good as "Help!".
take some time from your busy day and read these as well
when-asking-a-question
http://vanillaforums.org/discussion/26710/why-adding-your-version-is-more-important-than-ever
http://vanillaforums.org/discussion/25115/how-to-how-can-a-new-user-better-help-the-community-
and a few other helpful links:
http://vanillaforums.org/discussion/23130/forum-post-ettikett-etiquette
http://vanillaforums.org/discussion/17954/food-for-thought-forum-etiquette
http://vanillaforums.org/discussion/23483/advice-for-all-those-just-starting-out-with-vanilla
http://vanillaforums.org/discussion/18015/how-to-ask-questions-on-the-internet
and use vanilla version 2.1 - http://vanillaforums.org/addon/vanilla-core
since 2.2.x is NOT SUGGESTED for open-source forums.
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.