Error: Prepared statement needs to be re-prepared*

LaughingQuoll

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

peregrine

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

LaughingQuoll

@peregrine MySQL version: 5.1.73-cll where do I edit the MySQL config?

peregrine

LaughingQuoll said:
@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.