search

Shadez / wowarmory

The World of Warcraft Armory is a vast searchable database of information for World of Warcraft - taken straight from the real servers and presented in a user-friendly interface. Since the Armory pulls its data from the actual game servers, it is the most comprehensive and up-to-date database on the characters, arena teams, guilds, and items of World of Warcraft in existence.
http://getmangos.com/community/showthread.php?t=12096
GNU General Public License v3.0
193 stars 183 forks source link

New problem database #148

Closed C0urage closed 13 years ago

C0urage commented 13 years ago

Fatal error: wrong Armory DB name DB_VERSION error: Current version is not defined but expected 'armory_r471'. Apply all neccessary updates from 'sql/updates' folder and refresh this page.

this is the error:

DEBUG [09-03-2011 15:23:55]: ArmoryDatabaseHandler::_query : unable to execute SQL query (SELECT version FROM armory_db_version). MySQL error: none

I applied all the patches to the core and all updates to the database. Armory in the database version is: 'armory_r471'.

any solution?

Jildor commented 13 years ago

Are you configured configuration.php ?

C0urage commented 13 years ago

yes. Initially I had another problem: will not connect to the database. now I have solved by creating a new database with the db characters and db auth. appears to connect, but does not run the query.

The installation requirements are all ok.

NeTw0rK commented 13 years ago

Ingles: I have the same problem, but it is curious that the system If it detects that there are 5 characters in that account.

Español: Tengo el mismo problema, pero es curioso que el sistema Sí detecte que existen 5 personajes en esa cuenta.

DEBUG [13-03-2011 23:16:22]: Utils::GetBookmarks : bookmarks for account 5 not found
DEBUG [13-03-2011 23:30:39]: ArmoryDatabaseHandler::_query : unable to execute SQL query (SELECT SUM(points) FROM armory_achievement WHERE id IN ()). MySQL error: "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 ')' at line 1" (Error #1064)

C0urage commented 13 years ago

Your should be a syntax error. my no. can someone help me? Shadez?

Shadez commented 13 years ago

Please, re-check your Armory MySQL DB connection info. Wrong connection info causes this error. Closed.

Mrbytes commented 13 years ago

(SELECT SUM(points) FROM armory_achievement WHERE id IN ()). MySQL error: "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 ')' at line 1" (Error #1064)

This is my error, it´s the same of NeTw0rk say before, any solutions, please.

Best regards