View Single Post
  #1  
Old 05-13-2019, 04:02 PM
Xanathol
Sarnak
 
Join Date: Oct 2009
Posts: 52
Default faction_base_data?

Since finally getting the latest build up & running (thanks Huppy!) and installing the nightly PEQ dump, I noticed that one server launch, the quests are all backed up (annonying...) and I get a number of errors in the world.exe screen trying to locate old DB updates from github (that don't appear in the log files that I have found) and I get a ton of errors trying to locate 'faction_base_data' in the DB for some lookups. According to the schema (https://github.com/EQEmu/Server/wiki/Database-Schema) it should be there but checking my DB and the nightly files, I don't see it.

Any ideas? Where to find it if needed or to remove references to it if dated? Not to mention stop the autobackups?

Thanks!



Edit: re the DB update, I finally caught the start of it:
Code:
Update] No script update necessary...
[Info] For EQEmu Server management utilities - run eqemu_server.pl
The system cannot find the path specified.
The system cannot find the path specified.
[Database] Table 'db_version' does not exist.... Creating...

The system cannot find the path specified.
The system cannot find the path specified.
[Update] Database not up to date with binaries... Automatically updating...
[Update] Issuing database backup first...
[Update] No script update necessary...
[Database] Performing database backup....

Todays Date: 05_13_2019
Operating System is: MSWin32
[db_dumper.pl] Database is PEQ_5_2019
[db_dumper.pl] Backup Directory: backups
[db_dumper.pl] Compression SET
[db_dumper.pl] Directory currently exists... Adding files to it...
[db_dumper.pl] Backing up Database PEQ_5_2019...
[db_dumper.pl] Command [mysqldump -u***** --host localhost  --max_allowed_packet=512M --password="***********" PEQ_5_2019 > "backups\PEQ_5_2019_05_13_2019.sql"]
[db_dumper.pl] Backup DONE... DB Backup File Size '252702393' (241.00 MiB)
[db_dumper.pl]  ::: You have WinRAR installed as 64 Bit...
[db_dumper.pl] Compressing Database with WinRAR...
[db_dumper.pl] Command ["C:\Program Files\WinRAR\rar" a "backups\PEQ_5_2019_05_13_2019.rar" "backups\PEQ_5_2019_05_13_2019.sql" ]

Updating archive backups\PEQ_5_2019_05_13_2019.rar

Updating  backups\PEQ_5_2019_05_13_2019.sql                           OK
Done
[db_dumper.pl]
Deleting RAW .sql Dump...
[db_dumper.pl] Command [del "backups\PEQ_5_2019_05_13_2019.sql" ]
[db_dumper.pl] Final file located: backups\PEQ_5_2019_05_13_2019.rar
[Update] Updating database...
[Database] Retrieving latest database manifest...
[Download] Saved: (db_update/db_update_manifest.txt) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/db_update_manifest.txt
[Database] Reading manifest...
The system cannot find the path specified.
The system cannot find the path specified.
[Database] missing update: 5001 '1_task_system.sql'
[Download] Saved: (db_update/1_task_system.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/svn/1_task_system.sql
The system cannot find the path specified.
[Database] has update (5004) '35_task_stepped.sql'
The system cannot find the path specified.
[Database] missing update: 5005 '42_task_min_maxlevel.sql'
[Download] Saved: (db_update/42_task_min_maxlevel.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/svn/42_task_min_maxlevel.sql
The system cannot find the path specified.
[Database] missing update: 5006 '55_zone_shutdowndeleay.sql'
[Download] Saved: (db_update/55_zone_shutdowndeleay.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/svn/55_zone_shutdowndeleay.sql
The system cannot find the path specified.
[Database] missing update: 5009 '104_traps.sql'
[Download] Saved: (db_update/104_traps.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/svn/104_traps.sql
The system cannot find the path specified.
[Database] missing update: 5011 '120_damageshieldtypes.sql'
[Download] Saved: (db_update/120_damageshieldtypes.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/svn/120_damageshieldtypes.sql
The system cannot find the path specified.
[Database] missing update: 5016 '133_task_repeatable.sql'
[Download] Saved: (db_update/133_task_repeatable.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/svn/133_task_repeatable.sql
The system cannot find the path specified.
[Database] missing update: 5017 '142_deathpeace_and_lifetap_aas.sql'
[Download] Saved: (db_update/142_deathpeace_and_lifetap_aas.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/svn/142_deathpeace_and_lifetap_aas.sql
The system cannot find the path specified.
[Database] missing update: 5020 '189_character_.sql'
[Download] Saved: (db_update/189_character_.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/svn/189_character_.sql
The system cannot find the path specified.
[Database] missing update: 5021 '196_trader.sql'
[Download] Saved: (db_update/196_trader.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/svn/196_trader.sql
The system cannot find the path specified.
[Database] missing update: 5023 '222_buyer.sql'
[Download] Saved: (db_update/222_buyer.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/svn/222_buyer.sql
The system cannot find the path specified.
[Database] missing update: 5025 '230_spells_table.sql'
[Download] Saved: (db_update/230_spells_table.sql) from https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/svn/230_spells_table.sql
The system cannot find the path specified.
...

and so on...

The faction stuff looks like:
Code:
...
Unknown Faction: ':Faction' FACTION VALUE: '429'
The system cannot find the path specified.
The system cannot find the path specified.
Unknown Faction: ':Faction' FACTION VALUE: '448'
The system cannot find the path specified.
The system cannot find the path specified.
Unknown Faction: ':Faction' FACTION VALUE: '430'
The system cannot find the path specified.
The system cannot find the path specified.
Unknown Faction: ':Faction' FACTION VALUE: '406'
The system cannot find the path specified.
The system cannot find the path specified.
...
Reply With Quote