Loading...   

  • Created By Uleat On: 07:17 PM October 22, 2018
  • Link

[Update] No script update necessary...
[Update] Bots database up to Date: Continuing World Bootup...

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>> EQEmu Server Main Menu >>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

 [database]     Enter database management menu
 [assets]       Manage server assets
 [new_server]   New folder EQEmu/PEQ install - Assumes MySQL/Perl installed
 [setup_bots]   Enables bots on server - builds code and database requirements
 [conversions]  Routines used for conversion of scripts/data

 exit

Enter a command #> database

>>> Database Menu

 [backup_database]              Back up database to backups/ directory
 [backup_player_tables]         Back up player tables to backups/ directory
 [backup_database_compressed]   Back up database compressed to backups/ director
y

 [check_db_updates]             Checks for database updates manually
 [check_bot_db_updates]         Checks for bot database updates

 [aa_tables]                    Downloads and installs clean slate AA data from
PEQ
 [remove_duplicate_rules]       Removes duplicate rules from rule_values table
 [drop_bots_db_schema]          Removes bot database schema

> main - go back to main menu
**************************************************************************************************************************
Enter a command #> check_db_updates
**************************************************************************************************************************
[Database] Retrieving latest database manifest...
[Download] Saved: (db_update/db_update_manifest.txt) from https://raw.githubuser
content.com/EQEmu/Server/master/utils/sql/db_update_manifest.txt
[Database] Reading manifest...
ERROR 1146 (42S02) at line 1: Table 'emu1.inventory_versions' doesn't exist
[Database] has update: 9129 - '2018_08_13_inventory_update.sql'
[Database] missing update: 9128 '2018_08_13_inventory_version_update.sql'
[Download] Saved: (db_update/2018_08_13_inventory_version_update.sql) from https
://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2018_08_
13_inventory_version_update.sql
[Database] missing update: 9127 '2018_09_07_NPCMaxAggroDist.sql'
[Download] Saved: (db_update/2018_09_07_NPCMaxAggroDist.sql) from https://raw.gi
thubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2018_09_07_NPCMax
AggroDist.sql
[Database] missing update: 9126 '2018_09_07_FastRegen.sql'
[Download] Saved: (db_update/2018_09_07_FastRegen.sql) from https://raw.githubus
ercontent.com/EQEmu/Server/master/utils/sql/git/required/2018_09_07_FastRegen.sq
l
[Database] missing update: 9125 '2018_07_20_task_emote.sql'
[Download] Saved: (db_update/2018_07_20_task_emote.sql) from https://raw.githubu
sercontent.com/EQEmu/Server/master/utils/sql/git/required/2018_07_20_task_emote.
sql
[Database] missing update: 9124 '2018_07_09_tasks.sql'
[Download] Saved: (db_update/2018_07_09_tasks.sql) from https://raw.githubuserco
ntent.com/EQEmu/Server/master/utils/sql/git/required/2018_07_09_tasks.sql
[Database] missing update: 9123 '2018_07_07_data_buckets.sql'
[Download] Saved: (db_update/2018_07_07_data_buckets.sql) from https://raw.githu
busercontent.com/EQEmu/Server/master/utils/sql/git/required/2018_07_07_data_buck
ets.sql

[Database] Running Update: 9123 - 2018_07_07_data_buckets.sql
[Database] Running Update: 9124 - 2018_07_09_tasks.sql
[Database] Running Update: 9125 - 2018_07_20_task_emote.sql
[Database] Running Update: 9126 - 2018_09_07_FastRegen.sql
[Database] Running Update: 9127 - 2018_09_07_NPCMaxAggroDist.sql
[Database] Running Update: 9128 - 2018_08_13_inventory_version_update.sql
[Database] missing update: 9129 '2018_08_13_inventory_update.sql'
[Download] Saved: (db_update/2018_08_13_inventory_update.sql) from https://raw.g
ithubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2018_08_13_inven
tory_update.sql
[Database] has update: 9128 - '2018_08_13_inventory_version_update.sql'
[Database] has update: 9127 - '2018_09_07_NPCMaxAggroDist.sql'
[Database] has update: 9126 - '2018_09_07_FastRegen.sql'
[Database] has update: 9125 - '2018_07_20_task_emote.sql'
[Database] has update: 9124 - '2018_07_09_tasks.sql'
[Database] has update: 9123 - '2018_07_07_data_buckets.sql'


>>> Database Menu

 [backup_database]              Back up database to backups/ directory
 [backup_player_tables]         Back up player tables to backups/ directory
 [backup_database_compressed]   Back up database compressed to backups/ director
y

 [check_db_updates]             Checks for database updates manually
 [check_bot_db_updates]         Checks for bot database updates

 [aa_tables]                    Downloads and installs clean slate AA data from
PEQ
 [remove_duplicate_rules]       Removes duplicate rules from rule_values table
 [drop_bots_db_schema]          Removes bot database schema

> main - go back to main menu
**************************************************************************************************************************
Enter a command #> check_db_updates
**************************************************************************************************************************
[Database] Running Update: 9129 - 2018_08_13_inventory_update.sql
@pre_timestamp := UNIX_TIMESTAMP(NOW())
1540253701
pre-transform count..   total   bit21   bit22
pre-transform count..   2988    2908    80
post-transform count..  total   bit21   bit22
post-transform count..  2988    80      2908
@post_timestamp := UNIX_TIMESTAMP(NOW())
1540253707
[Database] has update: 9129 - '2018_08_13_inventory_update.sql'
[Database] has update: 9128 - '2018_08_13_inventory_version_update.sql'
[Database] has update: 9127 - '2018_09_07_NPCMaxAggroDist.sql'
[Database] has update: 9126 - '2018_09_07_FastRegen.sql'
[Database] has update: 9125 - '2018_07_20_task_emote.sql'
[Database] has update: 9124 - '2018_07_09_tasks.sql'
[Database] has update: 9123 - '2018_07_07_data_buckets.sql'

[Database] No updates need to be run...
[Database] Setting Database to Binary Version (9129) if not already...

[Database] Retrieving latest database manifest...
[Download] Saved: (db_update/db_update_manifest.txt) from https://raw.githubuser
content.com/EQEmu/Server/master/utils/sql/db_update_manifest.txt
[Database] Reading manifest...
[Database] has update: 9129 - '2018_08_13_inventory_update.sql'
[Database] has update: 9128 - '2018_08_13_inventory_version_update.sql'
[Database] has update: 9127 - '2018_09_07_NPCMaxAggroDist.sql'
[Database] has update: 9126 - '2018_09_07_FastRegen.sql'
[Database] has update: 9125 - '2018_07_20_task_emote.sql'
[Database] has update: 9124 - '2018_07_09_tasks.sql'
[Database] has update: 9123 - '2018_07_07_data_buckets.sql'


>>> Database Menu

 [backup_database]              Back up database to backups/ directory
 [backup_player_tables]         Back up player tables to backups/ directory
 [backup_database_compressed]   Back up database compressed to backups/ director
y

 [check_db_updates]             Checks for database updates manually
 [check_bot_db_updates]         Checks for bot database updates

 [aa_tables]                    Downloads and installs clean slate AA data from
PEQ
 [remove_duplicate_rules]       Removes duplicate rules from rule_values table
 [drop_bots_db_schema]          Removes bot database schema

> main - go back to main menu
Enter a command #>

Raw Paste Data