• 0
Butterzeugs

Server dont start

Question

i think i have some db problem but iam not sure.

here is my log file:

extDB2: Found extdb-conf.ini
extDB2: Detected 8 Cores, Setting up 6 Worker Threads


[18:16:42:749351 +02:00] [Thread 3416] extDB2: Input from Server: 9:VERSION
[18:16:42:749351 +02:00] [Thread 3416] extDB2: Output to Server: 65
[18:16:42:749351 +02:00] [Thread 3416] extDB2: Input from Server: 9:ADD_DATABASE:exile
[18:16:42:749351 +02:00] [Thread 3416] extDB2: Database Type: MySQL
[18:16:42:876358 +02:00] [Thread 3416] extDB2: Database Session Pool Started
[18:16:42:876358 +02:00] [Thread 3416] extDB2: Output to Server: [1]
[18:16:42:876358 +02:00] [Thread 3416] extDB2: Input from Server: 9:ADD_DATABASE_PROTOCOL:exile:SQL_CUSTOM_V2:832376:exile
[18:16:42:877358 +02:00] [Thread 3416] extDB2: SQL_CUSTOM_V2: Loading Template Filename: E:\UserFiles\OLIVERR1\GameServers\TC15083508381486110071651\@ExileServer\extDB\sql_custom_v2\exile.ini
[18:16:42:877358 +02:00] [Thread 3416] extDB2: SQL_CUSTOM_V2: Version 8 Detected, Latest Version 12 Available
[18:16:42:879358 +02:00] [Thread 3416] extDB2: Output to Server: [1]
[18:16:42:879358 +02:00] [Thread 3416] extDB2: Input from Server: 9:TIME
[18:16:42:879358 +02:00] [Thread 3416] extDB2: Output to Server: [1,[2015, 9, 28, 16, 16]]
[18:16:42:879358 +02:00] [Thread 3416] extDB2: Input from Server: 9:LOCK
[18:16:42:879358 +02:00] [Thread 3416] extDB2: Output to Server: [1]
[18:16:47:295611 +02:00] [Thread 3416] extDB2: Input from Server: 0:832376:loadTerriotryIdPage:0:100
[18:16:47:295611 +02:00] [Thread 3416] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadTerriotryIdPage:0:100
[18:16:47:318612 +02:00] [Thread 3416] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Table '108853_clientdb.territory' doesn't exist [mysql_stmt_errno]: 1146 [mysql_stmt_sqlstate]: 42S02 [statemnt]: SELECT id FROM territory LIMIT ?,?
[18:16:47:318612 +02:00] [Thread 3416] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:16:47:318612 +02:00] [Thread 3416] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadTerriotryIdPage:0:100
[18:16:47:318612 +02:00] [Thread 3416] extDB2: Output to Server: [0,"Error Statement Exception"]
[18:17:08:860844 +02:00] [Thread 3416] extDB2: Input from Server: 0:832376:isKnownAccount:76561197973930643
[18:17:08:860844 +02:00] [Thread 3416] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: isKnownAccount:76561197973930643
[18:17:08:883846 +02:00] [Thread 3416] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Table '108853_clientdb.account' doesn't exist [mysql_stmt_errno]: 1146 [mysql_stmt_sqlstate]: 42S02 [statemnt]: SELECT CASE WHEN EXISTS(SELECT uid FROM account WHERE uid = ?) THEN 'true' ELSE 'false' END
[18:17:08:883846 +02:00] [Thread 3416] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:17:08:883846 +02:00] [Thread 3416] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: isKnownAccount:76561197973930643
[18:17:08:883846 +02:00] [Thread 3416] extDB2: Output to Server: [0,"Error Statement Exception"]

i dont really understand this at all.. 

Share this post


Link to post
Share on other sites

6 answers to this question

  • 0

That white on black is god awful to read.

Looks like you are missing some tables from your database, namely territory and account:

[Comment]: mysql_stmt_prepare error: Table '108853_clientdb.territory' doesnt exist
[Comment]: mysql_stmt_prepare error: Table '108853_clientdb.account' doesnt exist 

Can you verify those two tables are in your database?

Edited by Dredd

Share this post


Link to post
Share on other sites
  • 0

sorry for that black/white problem...

it looks like there is not one table in my database ???

shoudend the exile.ini create the tables if there are no ?

Share this post


Link to post
Share on other sites
Advertisement
  • 0

i tried it two times like the guide says but it dont work. I think i just have not the permissions to import a sql in my database.

 

if i try to import the exlie.sqf with phpMyAdmin i get this error:

-- Dumping database structure for exile
CREATE DATABASE IF NOT EXISTS `exile` /*!40100 DEFAULT CHARACTER SET utf8 */;

 

MySQL said: Documentation

#1044 - Access denied for user '108853'@'%' to database 'exile' 

 

Share this post


Link to post
Share on other sites
  • 0

Are you running the server yourself or are you using a third party hosting like Vilayer or GTX?

Share this post


Link to post
Share on other sites
  • 0

im having this issue : how to fix it ? yesterday was fine

Spoiler

[17:02:27:543844 +01:00] [Thread 6948] extDB2: Database Type: MySQL
[17:02:27:597114 +01:00] [Thread 6948] extDB2: Database Session Pool Started
[17:02:27:598277 +01:00] [Thread 6948] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Arma\Server\@exileserver\extDB\sql_custom_v2\exile.ini
[17:02:27:598378 +01:00] [Thread 6948] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[17:02:35:626630 +01:00] [Thread 13020] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'exile19051.territory' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: DELETE FROM territory WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[17:02:35:626754 +01:00] [Thread 13020] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[17:02:35:681529 +01:00] [Thread 4448] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'exile19051.container' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: UPDATE container SET abandoned = NOW(), pin_code = '0000' WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
[17:02:35:681589 +01:00] [Thread 4448] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[17:02:35:717380 +01:00] [Thread 13020] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteUnpaidTerritories:7
[17:02:35:717384 +01:00] [Thread 4448] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: addAbandonedSafes:7
[17:02:35:731551 +01:00] [Thread 9144] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'exile19051.container' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: DELETE FROM container WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
[17:02:35:731574 +01:00] [Thread 9144] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[17:02:35:731690 +01:00] [Thread 12008] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'exile19051.construction' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: DELETE FROM construction WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
[17:02:35:731713 +01:00] [Thread 12008] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[17:02:35:735983 +01:00] [Thread 10816] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'exile19051.vehicle' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: DELETE FROM vehicle WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[17:02:35:736006 +01:00] [Thread 10816] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[17:02:35:771480 +01:00] [Thread 9144] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldContainers:10
[17:02:35:771502 +01:00] [Thread 12008] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldConstructions:2
[17:02:35:771506 +01:00] [Thread 10816] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldVehicles:3
[17:02:35:785662 +01:00] [Thread 6948] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'exile19051.territory' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: SELECT id FROM territory LIMIT ?,?
[17:02:35:785782 +01:00] [Thread 6948] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[17:02:35:785818 +01:00] [Thread 6948] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadTerriotryIdPage:0:100

Untitled.jpg

Share this post


Link to post
Share on other sites
Advertisement

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.