• Страница 1 из 1
  • 1
Архив - только для чтения
Модератор форума: andycrowz  
Как исправить помогите.
Ro3m2
Сержант
START TIME: Sat Aug 1 08:32:10 MSK 2015
In mysql_stmt_prepare() id: 57, sql: "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, durability, playedTime, text, bag, slot, item, itemEntry, transmogItemEntry FROM character_inventory ci JOIN item_instance ii ON ci.item = ii.guid WHERE ci.guid = ? ORDER BY bag, slot"
Unknown column 'transmogItemEntry' in 'field list'
In mysql_stmt_prepare() id: 104, sql: "REPLACE INTO item_instance (itemEntry, owner_guid, creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, durability, playedTime, text, transmogItemEntry, guid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Unknown column 'transmogItemEntry' in 'field list'
In mysql_stmt_prepare() id: 105, sql: "UPDATE item_instance SET itemEntry = ?, owner_guid = ?, creatorGuid = ?, giftCreatorGuid = ?, count = ?, duration = ?, charges = ?, flags = ?, enchantments = ?, randomPropertyId = ?, durability = ?, playedTime = ?, text = ?, transmogItemEntry = ? WHERE guid = ?"
Unknown column 'transmogItemEntry' in 'field list'
In mysql_stmt_prepare() id: 186, sql: "INSERT INTO instance (id, map, resettime, droptime, difficulty, completedEncounters, data) VALUES (?, ?, ?, ?, ?, ?, ?)"
Unknown column 'droptime' in 'field list'
In mysql_stmt_prepare() id: 81, sql: "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, durability, playedTime, text, item_guid, itemEntry, owner_guid, itemEntry, transmogItemEntry FROM mail_items mi JOIN item_instance ii ON mi.item_guid = ii.guid WHERE mail_id = ?"
Unknown column 'transmogItemEntry' in 'field list'
In mysql_stmt_prepare() id: 81, sql: "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, durability, playedTime, text, item_guid, itemEntry, owner_guid, itemEntry, transmogItemEntry FROM mail_items mi JOIN item_instance ii ON mi.item_guid = ii.guid WHERE mail_id = ?"
Unknown column 'transmogItemEntry' in 'field list'
DatabasePool characters NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://collab.kpsn.org/display/tc/TrinityCore+Home
Cannot connect to Character database 127.0.0.1;3306;root;fggwerffssed65;characters
Using configuration file /home/gameserver/server/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.1f 6 Jan 2014 (library: OpenSSL 1.0.1f 6 Jan 2014)
Using ACE version: 6.0.3
Core:BTCore
Based on: TDB
rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Unix, Release) (worldserver-daemon)
<Ctrl-C> to stop.

######## ## ## ##
## ## ## ## ##
## ## ###### ###### ###### ## ######
######## ## ## ## ## ## ## ##
## ## ######## ## ## ## ##########
## ## ## ## ## ## ## ##
## ## ## ##### ## ## ## ## ##
######## ##### ## ### ### ### ######

C O R E
Основано на TrinityCore(master branch)
Приватная версия The Battle Core!
https://bitbucket.org/Vitup/battlecore
○RO3M2○ Programming IT
Сообщение # 1 написано 01.08.2015 в 08:34
Devalyne
Скаут
Цитата
Unknown column 'transmogItemEntry' in 'field list'

Как я понял стоит патч на трансмогрификатора, sql залили ?
Пишет что нет такой колоны 'transmogItemEntry'

А так же:
Цитата
Unknown column 'transmogItemEntry' in 'field list'
Unknown column 'droptime' in 'field list'
Enshine <Developer team>
Сообщение # 2 отредактировано Devalyne - Суббота, 01.08.2015, 09:33
Ro3m2
Сержант
START TIME: Sat Aug 1 10:06:43 MSK 2015
In mysql_stmt_prepare() id: 57, sql: "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, durability, playedTime, text, bag, slot, item, itemEntry, transmogItemEntry FROM character_inventory ci JOIN item_instance ii ON ci.item = ii.guid WHERE ci.guid = ? ORDER BY bag, slot"
Column 'transmogItemEntry' in field list is ambiguous
DatabasePool characters NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://collab.kpsn.org/display/tc/TrinityCore+Home
Cannot connect to Character database 127.0.0.1;3306;root;EWze8c6yANE8jxdN;characters
Using configuration file /home/gameserver/server/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.1f 6 Jan 2014 (library: OpenSSL 1.0.1f 6 Jan 2014)
Using ACE version: 6.0.3
Core:BTCore
Based on: TDB
rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Unix, Release) (worldserver-daemon)
<Ctrl-C> to stop.

######## ## ## ##
## ## ## ## ##
## ## ###### ###### ###### ## ######
######## ## ## ## ## ## ## ##
## ## ######## ## ## ## ##########
## ## ## ## ## ## ## ##
## ## ## ##### ## ## ## ## ##
######## ##### ## ### ### ### ######

C O R E
Основано на TrinityCore(master branch)
Приватная версия The Battle Core!
https://bitbucket.org/Vitup/battlecore

Часть ошибок поправил
где можно sql взять трансмогрификатора?
○RO3M2○ Programming IT
Сообщение # 3 написано 01.08.2015 в 10:07
Devalyne
Скаут
Там же где брал трансмогрификатора ?

Добавлено (01.08.2015, 10:53)
---------------------------------------------
Так же и поправь и эту ошибку как поправил предыдущие.

Добавлено (01.08.2015, 10:54)
---------------------------------------------
Они аналогичные.

Enshine <Developer team>
Сообщение # 4 написано 01.08.2015 в 10:54
  • Страница 1 из 1
  • 1
Поиск: