Sign in to follow this  
VileAce

DB help

4 posts in this topic

I am about to move a exile server to another dedicated server.  On the new server I did a new install then added any scripts and mods that we are using.  I am having a couple errors in the new servers RPT related to the DB, so I exported the database structure and tables minus and data and did a compare of the outputs using Notepad ++.  Some of the DB structure is different between the two versions, but not by a lot.  I was wondering,  if someone with a mostly unmodified DB would be willing to export their DB structure without data and post it so I can do one more comparison. Or if you know what might be causing my issue.  I am far from an Exile expert.

A couple differences in my DB are 

exile.construction`damage` tinyint(1) unsigned DEFAULT '0'
exile.construction`damage` tinyint(3) unsigned DEFAULT '0' 

exile.container`last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 
exile.container`last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

and the order of the columns is differnt in a couple tables

  `deleted_at` datetime DEFAULT NULL,
  `money` int(11) unsigned NOT NULL DEFAULT '0',
  `abandoned` datetime DEFAULT NULL,

  `abandoned` datetime DEFAULT NULL,
  `money` int(10) unsigned DEFAULT '100000',
  `deleted_at` datetime DEFAULT NULL,

I do not know if the order will be an issue or not.

Errors I am seeing in the RPT include:

Spoiler

 1:24:22 Error in expression <"extDB2" callExtension _query);
switch (_result select 0) do
{
case 0:
{
(format>
 1:24:22   Error position: <_result select 0) do
{
case 0:
{
(format>
 1:24:22   Error Undefined variable in expression: _result
 1:24:22 File exile_server\code\ExileServer_system_database_query_selectSingle.sqf, line 16
 1:24:22 Error in expression <texture = _data select 21;
try 
{
if !((vectorMagnitude _vectorUp) isEqualTo 1) >
 1:24:22   Error position: <vectorMagnitude _vectorUp) isEqualTo 1) >
 1:24:22   Error Type Any, expected Number
 1:24:22 File mpmissions\__cur_mp.ALTIS\overrides\ExileServer_object_vehicle_database_load.sqf, line 22
 1:24:22 Error in expression <000)
];
_vehicleObject = createVehicle [_vehicleClassName, _temporaryPositionInO>
 1:24:22   Error position: <_vehicleClassName, _temporaryPositionInO>
 1:24:22   Error Undefined variable in expression: _vehicleclassname
 1:24:22 File exile_server\code\ExileServer_object_vehicle_carefulCreateVehicle.sqf, line 23
 1:24:22 Error in expression <ode = _this select 4;
_vehicleObject = [_className, _position, _direction, _useP>
 1:24:22   Error position: <_className, _position, _direction, _useP>
 1:24:22   Error Undefined variable in expression: _classname
 1:24:22 File exile_server\code\ExileServer_object_vehicle_createPersistentVehicle.sqf, line 18
 1:24:22 Error in expression <
_items = _this select 1;
if ((typeName _items) isEqualTo "ARRAY") then 
{
if!(_>
 1:24:22   Error position: <_items) isEqualTo "ARRAY") then 
{
if!(_>
 1:24:22   Error Undefined variable in expression: _items
 1:24:22 File exile_server\code\ExileServer_util_fill_fillItems.sqf, line 15
 1:24:22 Error in expression <gazines = _this select 1;
if ((typeName _magazines) isEqualTo "ARRAY") then 
{    
>
 1:24:22   Error position: <_magazines) isEqualTo "ARRAY") then 
{    
>
 1:24:22   Error Undefined variable in expression: _magazines
 1:24:22 File exile_server\code\ExileServer_util_fill_fillMagazines.sqf, line 15
 1:24:22 Error in expression <weapons = _this select 1;
if ((typeName _weapons) isEqualTo "ARRAY") then
{
if!(>
 1:24:22   Error position: <_weapons) isEqualTo "ARRAY") then
{
if!(>
 1:24:22   Error Undefined variable in expression: _weapons
 1:24:22 File exile_server\code\ExileServer_util_fill_fillWeapons.sqf, line 15
 1:24:22 Error in expression <tabase_query_selectSingle;
_position = [_data select 8, _data select 9, _data se>
 1:24:22   Error position: <_data select 8, _data select 9, _data se>
 1:24:22   Error Undefined variable in expression: _data
 1:24:22 File mpmissions\__cur_mp.ALTIS\overrides\ExileServer_object_vehicle_database_load.sqf, line 15

The custom ExileServer_object_vehicle_database_load.sqf I am using is from 

Thanks in advance.

Edited by VileAce

Share this post


Link to post
Share on other sites

Hello @VileAce,

I waited to see if someone who knows DB's better than me to supply you with an answer....oh well...   :(

What I can tell you is this:

If you made a 100% copy of your old server and ported over to a new one, EVERYTHING WOULD WORK.

Since this is NOT the case, these 2 servers are NOT the same.  'Something' is different, this is why it does not work.

What could it be?  Many things.

I would suggest you 'zip up' your old server (with verify of files) and the do a standard DB export of the data.  Then unzip the server files on the new computer and then import the old DB into the new DB server.  THIS WILL WORK.

You 'got off the trail' somewhere and who knows what else you might have missed, thus the advice to START OVER.

:)

 

Share this post


Link to post
Share on other sites
Advertisement

Thanks for the reply.  I may repost my question in the Vehicle Protection System post and see if anyone has seen similar errors.

The reason I did it this way, is the server was started by another individual and he was using extDB3, but I was not 100% confident in the implementation.  The extDB3 install talks about deleting specific files and those files still exist. So instead of doing an exact copy I choose to do a new install and install each script and mod.  The error above is the only error I am getting, so Im guessing my install is very close to 100% working.  To be honest, even with the error, everything seems to be "working".

 

 

  • Like 1

Share this post


Link to post
Share on other sites

You CAN NOT use the scripts with ExtDB3 WITHOUT MODIFYING THEMALL scripts are written for ExtDB2 ONLY!

This is the 'proper order':

#1 - 32b ARMA Server.Exe + MySQL + ExtDB2 Scripts = Working Server

#2 - 64b ARMA Server.Exe + MySQL + ExtDB3 MODIFIED Scripts = Working Server

#3 - 32b ARMA Server.Exe + MySQL + ExtDB3 MODIFIED Scripts <> Working Server

#4 - 32b ARMA Server.Exe + MySQL + ExtDB3 NORMAL Scripts <> Working Server

 

You can NOT mix and match these items.  It MUST be either #1 OR #2!

 

Actually if you use the 32 bit ARMA with ExtDB3 (#3 or #4), it will not even load the server!

 

This sounds like this is what you're doing...'mixing and matching'.  This is why I said "...these 2 servers are NOT the same.  'Something' is different, this is why it does not work..."

Also, Errors = Improper Server Setup - PERIOD!  Because you do not 'see the error' TODAY, does not mean 'all is ok'.  I have NONE of the errors you list...NONE.  This is a CLEAR indication that your server is NOT SET UP PROPERLY.  Ignore the errors at your own risk, or should I say at your player's risk;)

 

ExtDB3 is also NOT RECOMMENDED as well.

See: 

 

Pick one or the other.  EVERYTHING is written for ExtDB2.  You also have 100% support for ExtDB2 as well.

If the original DB is a ExtDB3 format, I have no idea on how to 'convert it' to a ExtDB2 format, if such even exists.  You might have to start 'clean' (wipe), which is good sometimes anyway.

:)

 

Edited by Z80CPU

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
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.