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


1748 posts in this topic

Posted

I shoved all the updates, but otherwise does not carry any ItemEntry

Sorry my bad English

What is your core version?

0

Share this post


Link to post
Share on other sites

Posted

What is your core version?

11623 and DB : TDB 2011_39 last

0

Share this post


Link to post
Share on other sites

Posted

Does your table item_instance looks like this:


CREATE TABLE `item_instance` (

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

  `itemEntry` mediumint(8) unsigned NOT NULL DEFAULT '0', // <-- It seems this column is missing on your DB.

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

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

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

  `count` int(10) unsigned NOT NULL DEFAULT '1',

  `duration` int(10) NOT NULL DEFAULT '0',

  `charges` tinytext,

  `flags` mediumint(8) unsigned NOT NULL DEFAULT '0',

  `enchantments` text NOT NULL,

  `randomPropertyId` smallint(5) NOT NULL DEFAULT '0',

  `durability` smallint(5) unsigned NOT NULL DEFAULT '0',

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

  `text` text,

  PRIMARY KEY (`guid`),

  KEY `idx_owner_guid` (`owner_guid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item System';

0

Share this post


Link to post
Share on other sites

Posted

it looks to me like your auth login is messed up in the worldserver.conf...

DatabaseWorkerPool for ''

0

Share this post


Link to post
Share on other sites

Posted

it looks to me like your auth login is messed up in the worldserver.conf...

DatabaseWorkerPool for ''

How i missed that?!

Paradox you're the best! ;)

When will you come again to the team?

0

Share this post


Link to post
Share on other sites

Posted (edited)

it looks to me like your auth login is messed up in the worldserver.conf...

DatabaseWorkerPool for ''

The config in worlserver.conf and authserver.conf is perfectly.

Thanks

Athenea, I have no such table in my database EntryItem not is

Sorry for my bad English

Edited by hedes
0

Share this post


Link to post
Share on other sites

Posted

The config in worlserver.conf and authserver.conf is perfectly.

Thanks

Athenea, I have no such table in my database EntryItem not is

Sorry for my bad English

With what program did you loaded it?

I just checked and that column is present on it... soo... if you don't see it, it's because something was not loaded very well.

0

Share this post


Link to post
Share on other sites

Posted

With what program did you loaded it?

I just checked and that column is present on it... soo... if you don't see it, it's because something was not loaded very well.

Server: worlserver.exe authserver.exe

DB: SQLyog

0

Share this post


Link to post
Share on other sites

Posted (edited)

Hello, I am new to this and i just got all the steps done and i can run authserver.exe fine and it stays open but worldserver dies on me i opened in cmd and tried and i got an error:

[ERROR]: In mysql_stmt_prepare() id: 8, sql: "SELECT entry, groupid, id, text, t

ype, language, probability, emote, duration, sound FROM creature_text"

[ERROR]: Unknown column 'groupid' in 'field list'

so if anyone knows what that means or how to fix it pls tell me.

OS: Win7 x64

and I am using SkyfireEMU not sure where to find the build so if someone tells me how I do that too that would be great

thanks

Edited by Solidus
0

Share this post


Link to post
Share on other sites

Posted

You are on the wrong forum, we do not support someone else's fork of TC, and, especially not repacks... Either build the core from the official repo and use TDB, or find your support elsewhere.

0

Share this post


Link to post
Share on other sites

Posted

oh my bad i thought the name of this was interchangeable sorry. will go to skyfire forum then. Thx anyways

0

Share this post


Link to post
Share on other sites

Posted

Operating Environment: Linux Fedora 14 (latest kernel update)

Last pulled/compiled database source: TDB_335.11.39_2011_04_02.rar

Last update/pull/compile of core: 13 Apr 2011 10:30AM (GMT)

Error when importing: /TrinityCore/sql/updates/auth_char/2011_04_05_00_characters_arena_team_misc.sql

ERROR 1060 (42S21) at line 2: Duplicate column name 'rating'

Error when importing: .../updates/auth_char/2011_04_08_00_characters_battleground_data.sql

ERROR 1054 (42S22) at line 1: Unknown column 'instance_id' in 'character_battleground_data'

Error when importing: .../updates/auth_char/2011_04_08_01_characters_homebind.sql

ERROR 1054 (42S22) at line 1: Unknown column 'map' in 'character_homebind'

Error when importing: .../updates/auth_char/2011_04_08_03_characters_arena_team_member.sql

ERROR 1054 (42S22) at line 4: Unknown column 'character_arena_stats.personalRating' in 'field list'

Error when importing: .../updates/auth_char/2011_04_11_00_characters_corpse.sql

ERROR 1054 (42S22) at line 1: Unknown column 'player' in 'corpse'

Any ideas or fixes?

This is as far as I have gotten, so far, since I am trying to do this stuff remotely from my workplace.

I will be sure to repost in here if I get any more errors when importing the world directory updates.

Thanks in advance.

0

Share this post


Link to post
Share on other sites

Posted

If you are getting errors, then 99% of the time, it is because you are doing something wrong, such as trying to apply updates to a freshly created char DB...

0

Share this post


Link to post
Share on other sites

Posted

-Core Commit: c9fb6011743fe2cf95c9

-DB Commit(Attempted): 3993b73925c8ef344100

-OS: Windows Web Server 2008 R2

-SQL GUI: SQLyog Community v9.0

-SQL GUI2: Navicat Lite v9.1.9

-MySQL: MySQL Workbench 5.2.31


Query:

ALTER TABLE `channels` CHANGE COLUMN `m_name` `name` varchar(128) NOT NULL,

  CHANGE COLUMN `m_team` `team` int(10) unsigned NOT NULL,

  CHANGE COLUMN `m_announce` `announce` tinyint(3) unsigned NOT NULL DEFAULT '1',

  CHANGE COLUMN `m_ownership` `ownership` tinyint(3) unsigned NOT NULL DEFAULT '1',

  CHANGE COLUMN `m_password` `password` varchar(32) DEFAULT NULL,

  CHANGE COLUMN `BannedList` `bannedList` text,

  CHANGE COLUMN `last_used` `lastUsed` int(10) unsigned NOT NULL


Error occured at:2011-04-14 03:23:24

Line no.:8

Error Code: 1146 - Table 'aero_characters.channels' doesn't exist


Query:

CREATE TABLE `corpse` (

  `corpseGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',

  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',

  `posX` float NOT NULL DEFAULT '0',

  `posY` float NOT NULL DEFAULT '0',

  `posZ` float NOT NULL DEFAULT '0',

  `orientation` float NOT NULL DEFAULT '0',

  `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',

  `phaseMask` smallint(5) unsigned NOT NULL DEFAULT '1',

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

  `itemCache` text NOT NULL,

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

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

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

  `flags` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `dynFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',

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

  `corpseType` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',

  PRIMARY KEY (`guid`),

  KEY `idx_type` (`corpseType`),

  KEY `instance` (`instanceId`),

  KEY `Idx_player` (`player`),

  KEY `Idx_time` (`time`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Death System'


Error occured at:2011-04-14 03:24:03

Line no.:1220

Error Code: 1072 - Key column 'player' doesn't exist in table


Query:

INSERT INTO character_queststatus_rewarded SELECT guid, quest FROM character_queststatus WHERE rewarded = 1


Error occured at:2011-04-14 03:27:30

Line no.:9

Error Code: 1054 - Unknown column 'rewarded' in 'where clause'


Query:

CREATE TABLE `corpse` (

  `corpseGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',

  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',

  `posX` float NOT NULL DEFAULT '0',

  `posY` float NOT NULL DEFAULT '0',

  `posZ` float NOT NULL DEFAULT '0',

  `orientation` float NOT NULL DEFAULT '0',

  `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',

  `phaseMask` smallint(5) unsigned NOT NULL DEFAULT '1',

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

  `itemCache` text NOT NULL,

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

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

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

  `flags` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `dynFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',

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

  `corpseType` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',

  PRIMARY KEY (`guid`),

  KEY `idx_type` (`corpseType`),

  KEY `instance` (`instanceId`),

  KEY `Idx_player` (`player`),

  KEY `Idx_time` (`time`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Death System'


Error occured at:2011-04-14 04:39:13

Line no.:1220

Error Code: 1072 - Key column 'player' doesn't exist in tabl

0

Share this post


Link to post
Share on other sites

Posted (edited)

Tried Runner85sx's fix here. Tried starting worldserver.exe, throws failed to connect to character db error. Auth and world connects fine.

Update:

Fixed.

Changed:


 KEY `Idx_player` (`player`),

To:
KEY `Idx_player` (`guid`),

Thanks pek2011.

Edited by kaotik0fx
0

Share this post


Link to post
Share on other sites

Posted

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

Posted

Excuse me,But what should I do if I want to apply updates to a freshly created char DB?

0

Share this post


Link to post
Share on other sites

Posted

They aren't intended to be applied over a freshly characters db.

0

Share this post


Link to post
Share on other sites

Posted (edited)

Oh,I see

Thank you very much! :)

But I'm not sure about one thing.

Whether the fresh character db needn't any updates from the folder"sql/updates/auth_char" at all?

or they need a few?like what?Exectuable ones?

Edited by jzy
0

Share this post


Link to post
Share on other sites

Posted

a fresh char (and auth also) DB needs NO UPDATES AT ALL. Updates are only meant for those who have already setup and used their char and auth db, and have now pulled a newer revision. This is different for the world DB because the full one is not updated with every change, (at least, not yet... this may change in the future.) but, the char and auth fulls are.

0

Share this post


Link to post
Share on other sites

Posted (edited)

Today I grabbed the new sql updates from the git data base and ran them. On the character updates I was getting a lot of errors such as cannot drop column and unknown column. I ran all of the updates in the SQL.

I am now presented with this


login as: wutai

wutai@192.168.2.251's password:

Linux ubuntu 2.6.35-22-generic #33-Ubuntu SMP Sun Sep 19 20:32:27 UTC 2010 x86_64 GNU/Linux

Ubuntu 10.10


Welcome to Ubuntu!

 * Documentation:  https://help.ubuntu.com/

Last login: Sun Apr 17 18:04:07 2011 from 192.168.2.143

wutai@ubuntu:~$ cd server/bin/

wutai@ubuntu:~/server/bin$ screen

[detached from 1115.pts-0.ubuntu]

wutai@ubuntu:~/server/bin$ screen

MySQL server ver: 5.1.49-1ubuntu8.1

MySQL client library: 5.1.49

MySQL server ver: 5.1.49-1ubuntu8.1

Databasepool opened succesfuly. 2 total connections running.

Opening databasepool 'characters'. Async threads: 1, synch threads: 2

MySQL client library: 5.1.49

MySQL server ver: 5.1.49-1ubuntu8.1

[ERROR]: In mysql_stmt_prepare() id: 32, sql: "SELECT arenaTeamId, weekGames, seasonGames, seasonWins, personalRating FROM arena_team_member WHERE guid = ?"

[ERROR]: Unknown column 'personalRating' in 'field list'

[ERROR]: In mysql_stmt_prepare() id: 185, sql: "UPDATE arena_team_member SET personalRating = ?, weekGames = ?, weekWins = ?, seasonGames = ?, seasonWins = ? WHERE arenaTeamId = ? AND guid = ?"

[ERROR]: Unknown column 'personalRating' in 'field list'

MySQL client library: 5.1.49

MySQL server ver: 5.1.49-1ubuntu8.1

MySQL client library: 5.1.49

MySQL server ver: 5.1.49-1ubuntu8.1

Databasepool opened succesfuly. 3 total connections running.

Cannot connect to Character database 192.168.2.252;3306;(HIDDEN);(HIDDEN);characters

~DatabaseWorkerPool for ''.

~DatabaseWorkerPool for 'characters'.

~DatabaseWorkerPool for 'world'.

These updates were ran from build TDB_335.11.39_2011_04_02. Any suggestions and thank you for your help in advance.

Edited by robby0328
0

Share this post


Link to post
Share on other sites

Posted

Is this an existing characters DB? if it is, you need the character DB updates, if it is a new character DB (You just created it) it needs NO UPDATES.

0

Share this post


Link to post
Share on other sites

Posted (edited)

*smacks self in head* Thank you that makes sense now. I'll edit this post to let you know if it works.

EDIT: it was a new char database

EDIT: Replaced with original char database and worked great. Thank you this is now solved ^_^

Edited by robby0328
0

Share this post


Link to post
Share on other sites

Posted

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

Posted

I am using a unstucker script that has always done the trick for me, but now for some reason after clicking the unstuck button i get brough to a blank page with this error "Unknown column 'username' in 'where clause'"

I was hoping someone could help me out.

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.