• 1
DirtySanchez

Database error on startup on multiple servers/owners

Question

Hey everyone.

Was just looking through some rpt's for a few fellow server owners and noticed a common error at startup.

The other servers are not currently running my addon so I have ruled it out at this time.

Here is the error:

23:27:07 "ExileServer - Trying to get a second session ID!"
23:27:08 Inventory item with given name: [Rangefinder] not found
23:27:08 "ExileServer - Database Error: Error Incorrect Number of Inputs"
23:27:08 Error in expression <ase_handleBig;
};
};
(_result select 1) select 0>
23:27:08   Error position: <select 0>
23:27:08   Error Generic error in expression
23:27:08 File exile_server\code\ExileServer_system_database_query_selectSingle.sqf, line 27

Now we have done a test server and first startup this does not happen. Once a player is inserted into the database for account and player and the server restarts this happens everytime. Don't have the time to look into this any more but I'm sure there is a good answer as to why its happening.

1 person likes this

Share this post


Link to post
Share on other sites

12 answers to this question

  • 0

I get that plus a whole heap more

Spoiler

18:10:20 Error in expression <81934,29441.0839844,0,1,0,0,0,1,[[],[]],<null>,<null>,"1411"]]]>

18:10:20 Error position: <<null>,<null>,"1411"]]]>

18:10:20 Error Invalid number in expression

18:10:20 Error in expression <81934,29441.0839844,0,1,0,0,0,1,[[],[]],<null>,<null>,"1411"]]]>

18:10:20 Error position: <<null>,<null>,"1411"]]]>

18:10:20 Error Invalid number in expression

18:10:20 Error in expression <"extDB2" callExtension _query);

switch (_result select 0) do

{

case 0:

{

(format>

18:10:20 Error position: <_result select 0) do

{

case 0:

{

(format>

18:10:20 Error Undefined variable in expression: _result

18:10:20 File exile_server\code\ExileServer_system_database_query_selectSingle.sqf, line 16

18:10:20 Error in expression <000)

];

_vehicleObject = createVehicle [_vehicleClassName, _temporaryPositionInO>

18:10:20 Error position: <_vehicleClassName, _temporaryPositionInO>

18:10:20 Error Undefined variable in expression: _vehicleclassname

18:10:20 File exile_server\code\ExileServer_object_vehicle_carefulCreateVehicle.sqf, line 23

18:10:20 Error in expression <ode = _this select 4;

_vehicleObject = [_className, _position, _direction, _useP>

18:10:20 Error position: <_className, _position, _direction, _useP>

18:10:20 Error Undefined variable in expression: _classname

18:10:20 File exile_server\code\ExileServer_object_vehicle_createPersistentVehicle.sqf, line 18

18:10:20 Error in expression <

_items = _this select 1;

if ((typeName _items) isEqualTo "ARRAY") then

{

if!(_>

18:10:20 Error position: <_items) isEqualTo "ARRAY") then

{

if!(_>

18:10:20 Error Undefined variable in expression: _items

18:10:20 File exile_server\code\ExileServer_util_fill_fillItems.sqf, line 15

18:10:20 Error in expression <gazines = _this select 1;

if ((typeName _magazines) isEqualTo "ARRAY") then

{

>

18:10:20 Error position: <_magazines) isEqualTo "ARRAY") then

{

>

18:10:20 Error Undefined variable in expression: _magazines

18:10:20 File exile_server\code\ExileServer_util_fill_fillMagazines.sqf, line 15

18:10:20 Error in expression <weapons = _this select 1;

if ((typeName _weapons) isEqualTo "ARRAY") then

{

if!>

18:10:20 Error position: <_weapons) isEqualTo "ARRAY") then

{

if!>

18:10:20 Error Undefined variable in expression: _weapons

18:10:20 File exile_server\code\ExileServer_util_fill_fillWeapons.sqf, line 15

18:10:21 Error in expression <tabase_query_selectSingle;

_position = [_data select 8, _data select 9, _data se>

18:10:21 Error position: <_data select 8, _data select 9, _data se>

18:10:21 Error Undefined variable in expression: _data

18:10:21 File exile_server\code\ExileServer_object_vehicle_database_load.sqf, line 15

doesn't seem to stop the load but my server restart time has doubled

Share this post


Link to post
Share on other sites
  • 0

I get same error. It definitely affects startup and server performance.

Share this post


Link to post
Share on other sites
Advertisement
  • 0
On 09.01.2016 at 11:46 PM, DirtySanchez said:

Here is the error:


23:27:07 "ExileServer - Trying to get a second session ID!"
23:27:08 Inventory item with given name: [Rangefinder] not found
23:27:08 "ExileServer - Database Error: Error Incorrect Number of Inputs"
23:27:08 Error in expression <ase_handleBig;
};
};
(_result select 1) select 0>
23:27:08   Error position: <select 0>
23:27:08   Error Generic error in expression
23:27:08 File exile_server\code\ExileServer_system_database_query_selectSingle.sqf, line 27

 

Hello!

sorry for my English:)

Edited by SAYREXX

Share this post


Link to post
Share on other sites
  • 0

I get this..

Spoiler

17:00:44 c:\w\stable\futura\lib\network\networkserver.cpp NetworkServer::OnClientStateChanged:NOT IMPLEMENTED - briefing!
17:00:44 Error in expression <1,-0.875615,-0.427417,-0.224973,[[],[]],<null>,<null>,"1111"]]]>
17:00:44   Error position: <<null>,<null>,"1111"]]]>
17:00:44   Error Invalid number in expression
17:00:44 Error in expression <1,-0.875615,-0.427417,-0.224973,[[],[]],<null>,<null>,"1111"]]]>
17:00:44   Error position: <<null>,<null>,"1111"]]]>
17:00:44   Error Invalid number in expression
17:00:44 Error in expression <"extDB2" callExtension _query);
switch (_result select 0) do
{
case 0:
{
(format>
17:00:44   Error position: <_result select 0) do
{
case 0:
{
(format>
17:00:44   Error Undefined variable in expression: _result
17:00:44 File exile_server\code\ExileServer_system_database_query_selectSingle.sqf, line 16
17:00:44 Error in expression <000)
];
_vehicleObject = createVehicle [_vehicleClassName, _temporaryPositionInO>
17:00:44   Error position: <_vehicleClassName, _temporaryPositionInO>
17:00:44   Error Undefined variable in expression: _vehicleclassname
17:00:44 File exile_server\code\ExileServer_object_vehicle_carefulCreateVehicle.sqf, line 23
17:00:44 Error in expression <ode = _this select 4;
_vehicleObject = [_className, _position, _direction, _useP>
17:00:44   Error position: <_className, _position, _direction, _useP>
17:00:44   Error Undefined variable in expression: _classname
17:00:44 File exile_server\code\ExileServer_object_vehicle_createPersistentVehicle.sqf, line 18
17:00:44 Error in expression <
_items = _this select 1;
if ((typeName _items) isEqualTo "ARRAY") then 
{
if!(_>
17:00:44   Error position: <_items) isEqualTo "ARRAY") then 
{
if!(_>
17:00:44   Error Undefined variable in expression: _items
17:00:44 File exile_server\code\ExileServer_util_fill_fillItems.sqf, line 15
17:00:44 Error in expression <gazines = _this select 1;
if ((typeName _magazines) isEqualTo "ARRAY") then 
{    
>
17:00:44   Error position: <_magazines) isEqualTo "ARRAY") then 
{    
>
17:00:44   Error Undefined variable in expression: _magazines
17:00:44 File exile_server\code\ExileServer_util_fill_fillMagazines.sqf, line 15
17:00:44 Error in expression <weapons = _this select 1;
if ((typeName _weapons) isEqualTo "ARRAY") then 
{
if!>
17:00:44   Error position: <_weapons) isEqualTo "ARRAY") then 
{
if!>
17:00:44   Error Undefined variable in expression: _weapons
17:00:44 File exile_server\code\ExileServer_util_fill_fillWeapons.sqf, line 15
17:00:44 Error in expression <tabase_query_selectSingle;
_position = [_data select 8, _data select 9, _data se>
17:00:44   Error position: <_data select 8, _data select 9, _data se>
17:00:44   Error Undefined variable in expression: _data
17:00:44 File exile_server\code\ExileServer_object_vehicle_database_load.sqf, line 15

 

not sure if this helps in finding a solution.  

Share this post


Link to post
Share on other sites
  • 0

Hey guys thanks for replying here. 

I have since been able to clear up my issues by doing a lot of searching through the database for bad items.  Make sure all 'any' are proper default.  Check for any addons you use making database saves and changes and make sure to keep your database maintained

Edited by DirtySanchez
1 person likes this

Share this post


Link to post
Share on other sites
  • 0
On 1/24/2016 at 7:04 PM, DirtySanchez said:

Hey guys thanks for replying here. 

I have since been able to clear up my issues by doing a lot of searching through the database for bad items.  Make sure all 'any' are proper default.  Check for any addons you use making database saves and changes and make sure to keep your database maintained

Mind shedding a bit more light on this?  What do you mean 'any'.. also.. do you know of any addons that make database saves and changes.. I use CUP MAS and HVP.  Thank you!! 
RP

Share this post


Link to post
Share on other sites
  • 0

The point you were suppose to get is that those errors mean something is wrong with data in your database.

You are going to have to search and find anything that looks out of place.

Non of those mods you mentioned write anything to the exile configured database AFAIK

2 people like this

Share this post


Link to post
Share on other sites
  • 0

Thanks for clearing that up.  I figured it had to do with the database. I'll start digging around in there.

 

Share this post


Link to post
Share on other sites
  • 0

I had this exact error and found I had <nul> values in various fields in my 'Vehicle' table.  I cleaned up the DB and these errors disappeared.

Share this post


Link to post
Share on other sites
  • 0

Yea, I Had a bunch of bikes with <nul>. Removed, errors gone. Except this one:

Spoiler

Error in expression <al [0, 0, 0];

_attachToObject setPosATL _position;

_position = [0, 0, 0];

};

_tr>

21:05:27   Error position: <_position;

_position = [0, 0, 0];

};

_tr>

21:05:27   Error Undefined variable in expression: _position

21:05:27 File exile_client\code\ExileClient_object_trader_create.sqf, line 34

21:05:27 Error in expression <e = _this select 0;

_traderFace = _this select 1;

_animations = _this select 2;

>

21:05:27   Error position: <select 1;

_animations = _this select 2;

>

21:05:27   Error Zero divisor

21:05:27 File exile_client\code\ExileClient_object_trader_create.sqf, line 14

Thoughts?

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.