Reality Missing Schema

Q

.=QUACK=.Major.Pain

Valued Member!
Trying to update our Bliss database to reality, and this is the part I am trying to do:

Users Migrating from Bliss

Users migrating from Bliss to Reality using an existing database will need to run the following against the database. db_migrate.pl --host 192.168.12.175 --user redbone --pass hound --name takistan --port 3306 --schema RealityMigrate --version 0.01
Click to expand...


Issues is that in your files, stuff is missing.

Error:

C:\Users\Administrator\Downloads\DayZ-Private-master-1.7.5>perl db_migrate.pl --
host x.x.x.x --user dbuser --pass pw --name dbname --port=3306 --schema RealityMigrate --version 0.01 INFO: Trying to connect to x.x.x.x, database dbname as dbuser
./schema/RealityMigrate/mysql is not a directory! at db_migrate.pl line 54.

C:\Users\Administrator\Downloads\DayZ-Private-master-1.7.5>pause
Press any key to continue . . .
Click to expand...
 
This updates the existing database schema information table so db_migrate. pl will work. You will need to run db_migrate like normal after running the above line.
 
Someone else made a fork for Taviana and updated to 0.36, so I am guessing, I am not really using the same 0.36 version.

Going to try deleting the schema version in the db and see if it will update again.
 
Actually changed schema version to 0.35 in db and tried to update but failed.

INFO: Trying to connect to xxxxxxxxxxxxxxxxxxxxxx
INFO: Current Reality version is 0.35
INFO: Attempting migration to 0.36
FATAL: Database migration failed!

C:\Users\Administrator\Downloads\DayZ-Private-master-1.7.5>pause
Press any key to continue . . .
Click to expand...
 
That won't work, the SQL is designed to be run in order. If your schema is 0.36 then you're fine as that is the latest for Bliss/Reality.
 
Server crashes right after Mission Read.

This is the error:

Code: 
Problem signature:
  Problem Event Name:APPCRASH
  Application Name:chernarus_1.exe
  Application Version:1.62.101.480
  Application Timestamp:510a3586
  Fault Module Name:chernarus_1.exe
  Fault Module Version:1.62.101.480
  Fault Module Timestamp:510a3586
  Exception Code:c0000094
  Exception Offset:005f19ec
  OS Version:6.1.7601.2.1.0.272.7
  Locale ID:1033
  Additional Information 1:b288
  Additional Information 2:b288c5625f19259871590457de339c1f
  Additional Information 3:7288
  Additional Information 4:72884ebba14aee5d6705d37a5b21047e
 
Read our privacy statement online:
  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409
 
If the online privacy statement is not available, please read our privacy statement offline:
  C:\Windows\system32\en-US\erofflps.txt
 
Is there anything in arma2oaserver.RPT? Did it create a HiveExt.log file?

I'm getting ready to head home from work but might be able to help you over Steam/TS/Mumble later tonight.
 
No RPT or Hive log.
Updated the arma patch again and applied the files, and now it will not connect to the database.

Gonna take a break and try again either later or tomorrow.
 
Ok, just for laughs, I tried to create a new database, and it does the same thing.

Database(0): [Warning] Could not connect to MySQL database at localhost: Can't connect to MySQL server on 'localhost' [10061], retrying in 1 seconds.

It seems it's not reading the settings in the HiveExt.
 
Yea I know.
I copied the HiveExt.ini from my current working Chernarus server.
Get that error of can't connectto localhost.
Created a new db and edited the HiveExt.ini and same thing.
Can't connect to localhost.

It's not reading the HiveExt.ini I think.
 
Well this is what I found.
I took Ayans HiveExt.dll as it has a debug where the one here doesn't have one.
It tells me it couldn't find HiveExt.ini in /Expansion/beta/.
So I copied it over there and it now connects to the database, but then instantly arma2oaserver.exe crashes.

This is a fresh install. Not using any old files.
 
Ok - deleted the entire folder again and started over from scratch.
Also created a new chernarus build and edited the HiveExt.ini
Also fixed BE kick #44 for fuel.
Created a new database and ran db_migrate which installed ok to 0.36

Started the server and it did connect to the database this time as I noticed the time offset in dayz commander.
Joined the server and everything appears to be going ok.

Get to mission read part, and then in game the dayz loading screen is loading up.
Once it's loaded, I see the following which ends up in the HiveExt.log

Code: 
2013-02-05 03:11:05 Database: [Warning] Connection lost (MySQL server has gone away) during MySQLQuery SQL: 'select `name` from `profile` WHERE `unique_id` = '60839622'' , retrying...
2013-02-05 03:11:05 Database: [Warning] Connection lost (MySQL server has gone away) during MySQLStmtPrepare SQL: 'insert into profile (`unique_id`, `name`) values (?, ?)' , retrying...
2013-02-05 03:11:06 Database: [Error] Error 1146 (Table 'dayz_d175.cust_loadout' doesn't exist) in MySQLQuery SQL: 'select replace(cl.`inventory`, '"', '""') inventory, replace(cl.`backpack`, '"', '""') backpack, replace(coalesce(cl.`model`, 'Survivor2_DZ'), '"', '""') model from `cust_loadout` cl join `cust_loadout_profile` clp on clp.`cust_loadout_id` = cl.`id` where clp.`unique_id` = '60839622''

Then arma2oaserver.exe crashes.

Error appears at bottom of arma2oaserver.RPT

Code: 
Mods: @reality_1.chernarus
Distribution: 0
Version 1.62.101480
Fault address:  7096CCF3 01:0001BCF3 C:\Hosting\QUACK\Dayz Chernarus 175\@reality_1.chernarus\HiveExt.dll
file:    dayz_1 (__cur_mp)
world:    chernarus
Prev. code bytes: 4D 8C 51 50 FF D2 83 C4 0C C6 45 FC 03 8B 4D 8C
Fault code bytes: 8B 01 8B 50 04 FF D2 84 C0 0F 84 98 05 00 00 33
 
Registers:
EAX:00A69E44 EBX:00A69F00
ECX:00000000 EDX:00000400
ESI:00000010 EDI:00000001
CS:EIP:0023:7096CCF3
SS:ESP:002B:00A69E08  EBP:00A69EB8
DS:002B  ES:002B  FS:0053  GS:002B
Flags:00010212
=======================================================
note: Minidump has been generated into the file dayz_1.chernarus\arma2oaserver.mdmp

States if I read it right, the the Hive.Ext.dll is the issue.
 
[Error] Error 1146 (Table 'dayz_d175.cust_loadout' doesn't exist)
Did you apply the schema for this pkg?
 
.=QUACK=.Major.Pain said:
Ok - deleted the entire folder again and started over from scratch.
Also created a new chernarus build and edited the HiveExt.ini
Also fixed BE kick #44 for fuel.
Created a new database and ran db_migrate which installed ok to 0.36

States if I read it right, the the Hive.Ext.dll is the issue.
Click to expand...

Verify that your custom_loadout schema has been loaded up and that you only copied the keys and @dayz folders over to your server. Also, you cannot use any of the hive files from the 1.7.5.1 code, you will need to use the one from the deploy folder that is built out, so overwrite with those files. I am working on the hive now trying to get this built out and updated to the latest version.


Also, hit us up on teamspeak we can give a hand on there a lot quicker then we can here.
 
You must log in or register to reply here.
Back
Top