devastor
-
Posts
9 -
Joined
-
Last visited
Posts posted by devastor
-
-
i dont make the server for first time just now i dont know what is problem :S the problem is in characters.lfg_date is not exist .... and with update characters_2012_02_13_2012_05_19 i cant fix it :/
-
i fixed it and again
2012-06-04 00:31:11 Using configuration file worldserver.conf.
2012-06-04 00:31:11 Using SSL version: OpenSSL 1.0.1c 10 May 2012 (library: OpenSSL 1.0.1c 10 May 2012)
2012-06-04 00:31:11 Using ACE version: 5.8.3
2012-06-04 00:31:11 TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release) (worldserver-daemon)
2012-06-04 00:31:11 <Ctrl-C> to stop.
2012-06-04 00:31:11 ______ __
2012-06-04 00:31:11 /__ _ __ __/ __
2012-06-04 00:31:11 /_/ / _ __ /_ ___ /_ , _ __ __
2012-06-04 00:31:11 /`'__/ /' _ `/ / / /
2012-06-04 00:31:11 / / / _ _
2012-06-04 00:31:11 _ _ _ _ _ _ __/`____
2012-06-04 00:31:11 /_//_/ /_//_//_//_//__/ `/___/>
2012-06-04 00:31:11 C O R E /___/
2012-06-04 00:31:11 http://TrinityCore.org /__/
2012-06-04 00:31:12 ERROR: DatabasePool characters NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
2012-06-04 00:31:12 ERROR: Cannot connect to Character database 127.0.0.1;3306;trinity;trinity;characters
i got this error with auth database but update auth_2012_02_13_2012_05_19 fixed the auth error when im tring to update characters its said:
Warrning in was 2 query :/
I did 2 3 times reinstal on TC and again this problem :/
-
i did it and again character database cannot connect ..............
-
OMG now i got
2012-06-03 23:18:16 Using configuration file worldserver.conf.
2012-06-03 23:18:16 Using SSL version: OpenSSL 1.0.1c 10 May 2012 (library: OpenSSL 1.0.1c 10 May 2012)
2012-06-03 23:18:16 Using ACE version: 5.8.3
2012-06-03 23:18:16 TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release) (worldserver-daemon)
2012-06-03 23:18:16 <Ctrl-C> to stop.
2012-06-03 23:18:16 ______ __
2012-06-03 23:18:16 /__ _ __ __/ __
2012-06-03 23:18:16 /_/ / _ __ /_ ___ /_ , _ __ __
2012-06-03 23:18:16 /`'__/ /' _ `/ / / /
2012-06-03 23:18:16 / / / _ _
2012-06-03 23:18:16 _ _ _ _ _ _ __/`____
2012-06-03 23:18:16 /_//_/ /_//_//_//_//__/ `/___/>
2012-06-03 23:18:16 C O R E /___/
2012-06-03 23:18:16 http://TrinityCore.org /__/
2012-06-03 23:18:16 ERROR: DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
2012-06-03 23:18:16 ERROR: Cannot connect to world database 127.0.0.1;3306;root;ascent;world
-
damn
2012-06-03 22:07:06 Using configuration file worldserver.conf.
2012-06-03 22:07:06 Using SSL version: OpenSSL 1.0.1c 10 May 2012 (library: OpenSSL 1.0.1c 10 May 2012)
2012-06-03 22:07:06 Using ACE version: 5.8.3
2012-06-03 22:07:06 TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release) (worldserver-daemon)
2012-06-03 22:07:06 <Ctrl-C> to stop.
2012-06-03 22:07:06 ______ __
2012-06-03 22:07:06 /__ _ __ __/ __
2012-06-03 22:07:06 /_/ / _ __ /_ ___ /_ , _ __ __
2012-06-03 22:07:06 /`'__/ /' _ `/ / / /
2012-06-03 22:07:06 / / / _ _
2012-06-03 22:07:06 _ _ _ _ _ _ __/`____
2012-06-03 22:07:06 /_//_/ /_//_//_//_//__/ `/___/>
2012-06-03 22:07:06 C O R E /___/
2012-06-03 22:07:06 http://TrinityCore.org /__/
2012-06-03 22:07:07 ERROR: DatabasePool characters NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
2012-06-03 22:07:07 ERROR: Cannot connect to Character database 127.0.0.1;3306;root;ascent;characters
-
it said 2 warrnings in last query whene i import characters_2012_02_13_2012_05_19
Hmm i re-build all DB and when import character_database from IC again this warrning.
Its the last rows from DB filter
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2011-04-04 21:03:41
;
/* Affected rows: 4 Found rows: 0 Warnings: 2 Duration for 686 queries: 6,030 sec. */
SHOW WARNINGS LIMIT 5;
-
When importing C:\Trinity\sql\base\character_database.sql.
I got a warrning: Your query produced 2 warnings.
Have i to skip it ?
"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page
in Help and Support
Posted · Edited by devastor
I did everything what u said and when it didnt help me i used this updates ..............
OMG Seriously ?!?!?!!? I did restart on my PC and now all work perfect ...................