Apple

"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page

1,833 posts in this topic

-- EDIT BY Aokromes --

If you get "unknown column" "missing table" "Duplicate column" errors:

use mysql --default-character-set=utf8 to avoid import failures because timeout/mysql gone away/etc

1) Clone desired branch.

2) Import sql/create/create_mysql.sql

3) Import sql/base/auth_database.sql

4) Import sql/base/character_database.sql

5) DON'T Import sql/base/*_database.sql, THIS TABLES ARE ONLY TO ALLOW OUR BOT TEST SQL FILES

6) Download the last released TDB from http://www.trinitycore.org/f/files/category/1-database/

7) Apply TDB

8) check TrinityCore/sql/old/ directory, if you see TDBxx_to_TDByy_updates where xx is the number of the TDB release you have download, you have downloaded one outdated database return to forum and download the last avariable database.

9) Apply updates from sql/updates/world

10) 6.x only: Apply updates from sql/updates/hotfixes into hotfixes database.

11) NOTICE WE NEVER IMPORT sql/updates/auth or sql/updates/character files on fresh installation, also DON'T IMPORT sql/base/dev/*_database.sql.

Our Wiki: http://collab.kpsn.org/display/tc/TrinityCore+Home

0

Share this post


Link to post
Share on other sites

It is disabled.

Edited by Apple
0

Share this post


Link to post
Share on other sites

Check if you have accurate data in the quest_poi and quest_poi_points table. (TDB data is the only accurate data).

If that doesn't cut it, attach a debugger to it and post a dump in the tracker.

0

Share this post


Link to post
Share on other sites

Okay I ''designed'' my quest_poi_points table to same which it is in the TrinityCore wiki.

Now I get error:

Loading Quest POI

SQL: SELECT questId, id, x, y FROM quest_poi_points ORDER BY questId DESC, idx

ERROR: [1054] Unknown column 'idx' in 'order clause'

Unhandled MySQL errno 1054. Unexpected behaviour possible

and then comes classic ''Worldserver has stopped to respond''.

Edited by Apple
0

Share this post


Link to post
Share on other sites

That error is pretty self-explanatory, don't you think?

You're missing an essential column. You should use TDB.

0

Share this post


Link to post
Share on other sites

Yeah, this one is easy to fix, but shall I post the dump to tracker or what?

0

Share this post


Link to post
Share on other sites

No need to post crash dumps to fix undefined behaviour caused by wrong database structure ;).

0

Share this post


Link to post
Share on other sites

--- Canned message start

It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread.

--- Canned message end ---

0

Share this post


Link to post
Share on other sites

run "tc/sql/update/10828_characters_character_queststatus.sql "

tips "[Err] 1054 - Unknown column 'rewarded' in 'where clause'

[Err] INSERT INTO character_queststatus_rewarded SELECT guid, quest FROM character_queststatus WHERE rewarded = 1;

[Err] 1054 - Unknown column 'rewarded' in 'where clause'

[Err] DELETE FROM character_queststatus WHERE rewarded = 1;

[Err] 1091 - Can't DROP 'rewarded'; check that column/key exists

[Err] ALTER TABLE character_queststatus DROP COLUMN rewarded;

[Msg] Finished - Unsuccessfully"

Impact on the entire database it?

0

Share this post


Link to post
Share on other sites

i see data in tc/sql/characters_database.sql, no data in tc/ sql/characters_database.sql

0

Share this post


Link to post
Share on other sites

I've encountered the same issue, I skipped it and it seemed to have no impact on my server.

0

Share this post


Link to post
Share on other sites

I finally got a recent version of the core to compile and install on a mac, but now I need to apply SQL updates to my databases. Can someone remind me how to tell which sql updates I need to apply from the git source?

Thanks for the help!

0

Share this post


Link to post
Share on other sites

If you bothered looking you would have found this on the wiki.

http://www.trinitycore.org/w/How-to:Mac#Installing_The_Trinity_Databases

0

Share this post


Link to post
Share on other sites

How do I tell what version of the "characters" database I am on? My world database updated fine from 10818 to 10925, but when I run the script "10828_characters_character_queststatus.sql", I get the following error: "ERROR 1054 (42S22) at line 8: Unknown column 'rewarded' in 'where clause'"

0

Share this post


Link to post
Share on other sites

If you created a new character and auth DB, you need NO UPDATES at all.

0

Share this post


Link to post
Share on other sites

If you created a new character and auth DB, you need NO UPDATES at all.

gotcha, that makes sense. When I wipe everything and install fresh, everything starts up great and I can create a new account and login.

The problem however, is that I still have my old character and auth DB, which I would like to preserve. Unfortunately, I wasn't very diligent about keeping track of my versions, and now TC does not start.

Is there an easy way to figure out which version my characters and auth DB are on, so I can apply the necessary patches to get things working again?

Thanks!

0

Share this post


Link to post
Share on other sites

check your old server.log files to see what the last revision you ran was?, or, look in auth DB for the uptime table, it should have the last revision you ran in it.

0

Share this post


Link to post
Share on other sites

nevermind, I've figured it out. Thanks for the tip Paradox!

I was able to figure out my versions and apply the correct updates to the characters datababase.

Edited by ipreferpapaya
0

Share this post


Link to post
Share on other sites

Hey anyone know how I can get this thing up and running? heh, I keep getting this error:

[ERROR]: In mysql_stmt_prepare() id: 0, sql: "DELETE FROM pool_quest_save WHERE pool_id = ?"

[ERROR]: Table 'characters.pool_quest_save' doesn't exist

~DatabaseWorkerPool for ''.

~DatabaseWorkerPool for 'characters'.

~DatabaseWorkerPool for 'world'.

When launching the ./worldserver

using the most up-to-date version of TDB. Does anyone have an idea what's going on?

Trying on a x64 bit install of Ubuntu 10.10.

Edited by Noaru
0

Share this post


Link to post
Share on other sites

You sure you applied all the updates from the trinitycore

Well I used the most current fresh install. I had looked everywhere in the error logs, inc the DB Errors, and nothing. That error shows up in the server.

0

Share this post


Link to post
Share on other sites

"[ERROR]: Table 'characters.pool_quest_save' doesn't exist"

Looks like you missed that table.

0

Share this post


Link to post
Share on other sites

Simply run this query in the characters database:

DROP TABLE IF EXISTS `pool_quest_save`;

CREATE TABLE `pool_quest_save` (

  `pool_id` int(10) unsigned NOT NULL DEFAULT '0',

  `quest_id` int(10) unsigned NOT NULL DEFAULT '0',

  PRIMARY KEY (`pool_id`,`quest_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Which we can find in the 3.3.5 sql updates folder; found it in 10 seconds ^^

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By HolyNitzan
      Hey Guys,
      I want to explore the 6.x server.
      As for now according to the wiki I understand that 6.x follows the latest patch available
      I wonder how can I open a WoD server using the 6.x?
      Should I use an earlier branch?
      I tried to compile 363731a but I kept gettings errors
      What is the right way to get a working WoD server for linux?
       
      Thanks, Nitzan
    • By Ewe Loon
      I followed the instructions  ( i think )
      compile went OK (i think, didn't see any errors)
      downloaded the database and copied the file as required
      got to the point where the instructions say to run worldserver
      I cd'd to the folder /server/bin and typed "worldserver" and got the message 
      worldserver: command not found
      so i typed dir and it appears to be there
      here is a copy of the terminal showing commands and results
       
      [email protected]:~/server/bin$ worldserver
      worldserver: command not found
      [email protected]:~/server/bin$ dir
      authserver    mmaps_generator                vmap4assembler  worldserver
      mapextractor  TDB_full_world_335.61_2016_04_11.sql  vmap4extractor
       
      anyone have any idea why it wont run
       
    • By Nether
      I followed the guide on how to install the core on Linux, but while configuring CMake I got this error: 
      [email protected]:~/absolutely-hopeless-server/build$ cmake ../ -DCMAKE_INSTALL_PREFIX=/home/netherblood/server -DCONF_DIR=/home/netherblood/server/etc -DTOOLS=1 -DWITH_WARNINGS=1 -- Detected 64-bit platform -- UNIX: Using default library directory CMake Error at cmake/platform/unix/settings.cmake:14 (configure_file):   configure_file attempted to configure a file:   /home/netherblood/absolutely-hopeless-server/cmake_uninstall.cmake into a   source directory. Call Stack (most recent call first):   cmake/macros/CheckPlatform.cmake:13 (include)   CMakeLists.txt:58 (include)     -- Configuring incomplete, errors occurred! See also "/home/netherblood/absolutely-hopeless-server/CMakeFiles/CMakeOutput.log". [email protected]:~/absolutely-hopeless-server/build$ Attached is the log.   CMakeOutput (1).log
    • By jaydee2k
      Hello,
      I compiled the latest source of the 3.3.5 core on Windows 10 - 64bit. On my desktop machine everything is running fine, but
      when i copy my server folder to my laptop both server exes are not even opening. When i double click on em the blue circle rotates next to my mouse and 
      thats it. The mysql server is running fine on my laptop too. The laptop has Windows 10 - 64bit, the needed vcredist installed and the processor has SSE2.
      I'm not even getting an error log because of this which makes it really hard to figure out what the problem is....
      Thanks for your help and patience! 
       
      EDIT: I need Boost, git, openssl, cmake and so on only to compile right? Not to run the compiled exe files or am I wrong?
      I don't want to install all these things on my laptop, he is slow enough. ^^
    • By Billy
      Seeing how as TrinityCore is not developing 4.3.4., who's repack would TrinityCore (as a collective), recommend? I've tried a few of them but they all seem to fall short in one way or another.