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

[wolfz]

I have just compiled a fresh trinitycore. Everything is working, expect the worldserver. When I load it up, I get this error:

 

[1054] Unknown column 'attackpower' in 'field list'

 

 

I would like to get some support! Thank you all. I've been trying all day to get this server to working!

 

- Wolfz

 

 

(Here is the Server logs if needed)

 

http://pastebin.com/qihUXXvF


 

Edited March 8, 2014 by wolfz

[CDawg]

You say fresh trinitycore?

TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Release) (worldserver-daemon)

Does that mean a brand new TDB as well?

[wolfz]

You say fresh trinitycore?

TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Release) (worldserver-daemon)

Does that mean a brand new TDB as well?

Uhm. I did execute the TDB.sql in my world database, and I keep getting Unknown Columns errors. I manage to fix some of them.

[CDawg]

@Wolfz,

It's hard to judge because you lack the revision, so if you installed git properly or downloaded from TC's official repo, and installed the latest TDB (remember the updates) look at the date... Then you wouldn't have this problem.

I think you jacked up your DB and need to start over.

[wolfz]

@Wolfz,

It's hard to judge because you lack the revision, so if you installed git properly or downloaded from TC's official repo, and installed the latest TDB (remember the updates) look at the date... Then you wouldn't have this problem.

I think you jacked up your DB and need to start over.

I installed the right TDB, I installed : TDB_full_335.52_2013_07_17.7z and It still give me errors. Also I got something like 'Mixed linebreaks' when uploading the updates .sql files. I did install Git properly, I check the box as 'Command Prompt' and compile did go through sucessfully. Also, When I typed in like "account set gmlevel 'username' 'level' -1 It said like Unknown Commands and such as that. Idk what it's going on right now.

 

I can't use .gm commands (When I am GM) .lua scripts won't work.

Edited March 10, 2014 by wolfz

[MrSmite]

I can't use .gm commands (When I am GM) .lua scripts won't work.

 

lua scripts aren't part of the standard core and this section is for help with unmodified cores. You should post in the custom code section instead.

[Selo]

Hi all. 

 

At the beginning of the speech that I am not an experienced programmer and server doing just to play along with a small group of friends. 

 

I have a problem with Mysql namely Mysql is enabled but like for instance, use HeidiSQL I can not connect. Authserver August starts without problems. But when you want to run worldserer pops a mistake:

 

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

I carried all instructions of http://collab.kpsn.org/display/tc/How-to_Linux .

i working on Debian 7 64bit.

 

Maybe someone knows what to do?

thank you in advance for your help.

 

 

 

 

[Clonix]

So I'm setting up my own localhost server to practise SQL on. I've follow this guide " http://collab.kpsn.org/display/tc/How-to_Win " but I'm getting a very odd error that I can't seem to fix when I run the worldserver.exe:

 

 

I've filled the following in in my worldserver.conf file:

 

LoginDatabaseInfo     = "127.0.0.1;3306;root;password;auth"

WorldDatabaseInfo     = "127.0.0.1;3306;root;password;world"

CharacterDatabaseInfo = "127.0.0.1;3306;root;password;characters"

 

 

And the following in my authserver.conf file:

 

LogindDatabaseInfo = "127.0.0.1;3306;root;password;auth"

 

 

I can't seem to find the issue, is there anything I'm missing? Any help is appreciated, I'll of course provide any information to you need regarding the tables and columns in my db.

 

Oh and by the way this is my first time ever setting up a trinitycore server and my first time with SQL in general (almost). Thank you! 

Edited March 27, 2014 by Clonix

[CDawg]

There was a problem connecting, because..

1. MySQL is not setup according to the wiki, or

2. You didn't run the updates.

unknown column 'permission' in field list.

I'm leaning toward number 2.

MySQL will try to read a DB/Table, when it's presented with too many errors than MySQL will dump the connection.

thus the...

Cannot connect to ...

It's not always a permission or "access" issue.

[Clonix]

There was a problem connecting, because..

1. MySQL is not setup according to the wiki, or

2. You didn't run the updates.

unknown column 'permission' in field list.

I'm leaning toward number 2.

MySQL will try to read a DB/Table, when it's presented with too many errors than MySQL will dump the connection.

thus the...

Cannot connect to ...

It's not always a permission or "access" issue.

Alright when you say "run the updates" how exactly should I understand that? I mean how should I do that. Thank you!

[Aokromes]

Get TDB53 to fix your problems.

[Clonix]

Get TDB53 to fix your problems.

Which version? There are 8 different versions. The one I'm using right now is the latest one. The client I'm using is the client I used for a 3.5.5a private server.

[Aokromes]

Like i said TDB 53, there is only one TDB 53.

TDB_full_335.53_2014_03_29.7z

[Clonix]

Like i said TDB 53, there is only one TDB 53.

TDB_full_335.53_2014_03_29.7z

Alright thank you. I use HeidiSQL (since it's my first time), is there a specific way to update that's recommendable? 

[GerAgustin]

i have a problem when i will try put the sql file from "world"

 

http://puu.sh/7P5w1.png

 

any can help me?

Edited March 30, 2014 by GerAgustin

[CDawg]

i have a problem when i will try put the sql file from "world"

 

http://puu.sh/7P5w1.png

 

any can help me?

 

You hosed your mysql DB or your MySQL is extremely outdated.

Also, you insert data from a sql file "into" the DB, not "from".

[Clonix]

Like i said TDB 53, there is only one TDB 53.

TDB_full_335.53_2014_03_29.7z

I updated but I'm still getting the errors

[Aokromes]

No you can't get those errors with that db.

[Paradox]

Some people should just give up and go back to playing on someone else's server.

[CDawg]

^^  To add to what Paradox stated, we all would like to learn, but I agree at some point people should learn or read how these things work first before jumping in. (great example MySQL Databases).

You don't have to know how a car works like a mechanic, but you should know how to drive one before taking it on the streets.

There are more than enough shitty private servers out there where it will allow newbs to do low GM stuff, like give yourself gear, solo through an instance, fly around, etc...

But, most people don't know shit about running servers and the main functionality or maintenance like not knowing how to drive, then suddenly out of pure dumb luck or a miracle they somehow get a server running, then they are a operating a large bus and drive people around town??

[MrSmite]

I would recommend not using HeidiSQL, it has a tendency to not import Trinity SQL properly.

[Paradox]

I'm certain his problem is not heidisql, it is the fact that he went in and dropped all of his DBs, including the ones required for mysql to work properly.

[MrSmite]

I'm certain his problem is not heidisql, it is the fact that he went in and dropped all of his DBs, including the ones required for mysql to work properly.

 

I think there are two separate issues here. +Clonix has the "unknown field" error and is using HeidiSQL. +GerAgstin has the "missing table" error and is using SQLyog (per the screenshot in his post).

 

I forgot to note in my post that I was referring to +Clonix (well, actually anyone using HeidiSQL).

[Aokromes]

GerAgstin deleted mysql basic tables and must reinstall mysql.

[Clonix]

I've tried everything but I keep getting this error. I already updated Aokromes