Jump to content
TrinityCore
Apple

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

Recommended Posts

-- 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) start core

4) leave core to update databases.

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

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.

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

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 ---

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?

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!

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

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'"

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!

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.

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

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

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.

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 ^^

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 Ramboknife
      So I'm trying to set up a debugging process where I can see what functions are being called when I do certain things in game, that way I can hopefully locate exactly which functions in which cpp files might possibly be involved with the bug I'm trying to fix.  Is something like this possible?  I can get VS Code to launch my worldserver or attach to the worldserver process but beyond that I'm not getting any other information out of the Call Stack or anything when I make certain actions in-game.
      Thanks
    • By cloudfox
      hi there
      i've met a strange problem on linux running TC worldserver.
      everything is ok when i direct type ./worldserver and don't close ssh window. the worldserver session only take 1% less cpu use.
      but when i try to use nohup or setsid to put worldserver backgroud.
      this world server instantly taking 100% cpu percent .no matter how long i wait,%cpu will not come down.
      i even try to use systemctl's service to made server run background,and i found server and systemctl still got 100% cpu use.
      i'm asking for help about how to run server background on ubuntu16.04,and not with 100%cpu use.
       
      thanks!!
    • By Lenny4
      Hi, I notice that the wordl server display a message when he think that a player is cheating.
      I would like to know if there a way to get the all the server log messages using php (or another way).
      I notice that the file Server.log contain some logs but not all of them for me the log stop at :
      "TrinityCore rev. e86a2c439aa2 2017-12-17 16:45:50 +0100 (master branch) (Win64, RelWithDebInfo, Static) (worldserver-daemon) ready..."
      And even if there other logs after it doesn't record.
      So my questions are:
      - is there a way to get the log of the worldserver using a coding language or command ?
      - is there a way to update the Server.log file with the current log message of the server using a coding language or command ?
    • By labaouici
      Hello!
      I was checking my DB but I didn't find any table that could tell "this is when it will happen"
      I wonder how it work, I activated it but is there a table to put the unix time? (like to do : every wednesday, at 15:25:30 there will be the distribution)
      Thanks!
    • By Szone
      Hello,
       
      I have a TrinityCore 3.3.5 realm and i want to make a second realm (4.3.4), but the question is : can I run/install on the same server (Ubuntu 16.04 server) ACE and BOOST ?    
       
      Thank you!
       
       
×