Knowledgebase: Errors & Common Problems
Error in SQL query definition for table XXXX. The version reported is YY instead of the version ZZ.
Posted by Mark [Elevated X Support] on 04 January 2019 09:16 PM

Error:

Error in SQL query definition for table XXXX. The version reported is YY instead of the version ZZ.

What is this:

Your CMS is connecting to a version of the database that is newer than the CMS files support.

How this happens:

Often, if a host is moving files or databases back and forth between servers, they may restore a prior copy of the /cms_admin/ folder in place.
This prior copy is expecting a different version of the database files than what the CMS is expecting.

How to correct this:

Any one of these options should correct the issue at hand.
  • Have your host copy over the CMS files from /cms_admin/ the other machine over the machine where these error messages are happening.
  • Install a new copy of the CMS in place that is newer than the current version you have. The newest copy of the CMS files are available here.
  • If none of these are viable options, please have your host restore the database to an older state.






(0 vote(s))
Helpful
Not helpful

Comments (0)