Jump to content
Why are these forums read only? ×
TrinityCore
Why are these forums read only?

Thomson

Members
 View Profile  See their activity

  • Posts

    20

  • Joined

  • Last visited

 Content Type 

Posts posted by Thomson

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

    in Help and Support

    Posted

    Thx for reply also to you..

     

    Well I did not mention those dates..

     

     

    Nice, but sql updates from CORE/sql/updates/world

    is unexecutable because of an error:

    ERROR 1146 (42S02) at line 271: Table 'cata_world.creature_ai_scripts' doesn't exist..

     

    I've tried to find some conversion to SAI but I've found only https://github.com/TrinityCore/EventAI-to-SmartAI/ so I've tried to execute those files but the error is the same... I have no idea and please you help like "use brain" or "use google" is non-sense :)

     

    Thx, T.

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

    in Help and Support

    Posted · Edited by Thomson

    Hello all,

     

    I have a problem with running server.

     

    The problem is that core want atribute "permission" in world.command table:

    



Using configuration file /home/tccata/server/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.0 29 Mar 2010 (library: OpenSSL 1.0.0 29 Mar 2010)
Using ACE version: 6.0.3
TrinityCore rev. 912808887749+ 2013-10-15 23:35:40 +0200 (4.3.4 branch) (Unix, Release) (worldserver-daemon)
<Ctrl-C> to stop.

 ______                       __
/__  _       __          __/ __
/_/ / _ __ /_    ___ /_ , _  __  __
     /`'__/  /' _ `/   / / / 
        /   / /     _  _ 
      _ _   _ _ _ _ __/`____ 
      /_//_/   /_//_//_//_//__/ `/___/> 
                                 C O R E  /___/
http://TrinityCore.org                    /__/

In mysql_stmt_prepare() id: 53, sql: "SELECT name, permission, help FROM command"
Unknown column 'permission' in 'field list'
DatabasePool cata_world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;MySecretUsername;MySecretPassword;cata_world

    I have read a lot on forum and I did those steps:

     

    1. - Downloaded TrinityCore via git clone https://github.com/TrinityCore/TrinityCore.git

    2. - Then I used command git checkout 4.3.4 ( for switching to 4.3.4 branche )

    3. - After this I used git reset HEAD~10 - some files were downloaded...

    4. - I checked if there is a BuradinHold folder in src/scripts/EasternKingdoms - it was, so I thought that 4.3.4 files were downloaded

    5. - config, make, install - succesfully

    6. - Google, found this - http://collab.kpsn.org/pages/viewpage.action?pageId=1704351

    7. - I used command ( in my home directory ) - git clone https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha.git

    8. - Then I've downloaded TDB_full_434.05_2013_07_17.7z, which should be the newest one.

    9. - Extracted TDB_full_434.05_2013_07_17.7z, executed to worldDB file from it.

    10. - Then I've opened TrinityCore_4.3.4_DB_Alpha and used commands:

     

    cd updates

    cat *.sql > updtm.sql

    11. - Tried to execute on world DB - allright.

    12. I've re-written the config files to MySQL connection

    13. - The lucky number - I've got the error :)

     

    So, I've read DatabasePool cata_world NOT opened. There were errors opening the MySQL connections. -First think - there's wrong connection string in my config, but it is not..

     

    I want to ask you for check my procedure for some wrong steps or errors and what to insted. 

     

    Thx so much, Thomson :)

×
×
  • Create New...