EEZY-E

MySQL undefined variable

5 posts in this topic

I just installed a3 server and it runs perfect. I added the exileserver and exile mod and modified the config files and now it gives me this MySQL error. It doesn't generate extDB log files so i cant show you those. It gives me this error:

if (_numberOfClans > 0) then
>
18:49:43 Error Undefined variable in expression: _clanids
18:49:43 File exile_server\code\ExileServer_world_loadAllClans.sqf line 20
18:49:43 Error in expression <"extDB2" callExtension _query);
switch (_result select 0) do
{
case 0:
{
(format>
18:49:43 Error position <_result select 0) do
{
case 0:
{
(format>
18:49:43 Error Undefined variable in expression: _result
18:49:43 File exile_server\code\ExileServer_system_database_query_selectFull.sqf, line 16
18:49:43 Error in expression <uery_selectFull;
_numberOfClans = count _clanIDS;
if (_numberOfClans > 0) then
>
18:49:43 Error position: <_clanIDs;
                                    if (_numberOfClans > 0) then
  >
  18:49:43 Error Undefined variable in expression: _clanids
  18:49:43 File exile_server\code\ExileServer_world_loadAllClans.sqf, line 20

I already tried deleting and creating the exile MySQL database but that didn't help either. I defined the database in the extdb-conf.ini file as "exile" is that correct aswell?

Share this post


Link to post
Share on other sites

check your extdb logs, it will tell you if there is a problem in the mysql

Share this post


Link to post
Share on other sites
Advertisement
5 minutes ago, tinboye said:

check your extdb logs, it will tell you if there is a problem in the mysql

It doesn't generate logs though. The folder isn't there and when i create the logs folder it wont create any logs.

Share this post


Link to post
Share on other sites

then your extdb-conf.ini is not connecting to your db, or its possible you need to disable strict mode.

it will always generate logs if it actually communicates with your db.

A successful connection will be something like

Spoiler

extDB2: Version: 70
extDB2: https://github.com/Torndeco/extDB2
extDB2: Windows Version
Message: All development for extDB2 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB2 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 20/02/15


extDB2: Found extdb-conf.ini
extDB2: Detected 8 Cores, Setting up 6 Worker Threads


[16:25:44:519498 +01:00] [Thread 15992] extDB2: Database Type: MySQL
[16:25:44:526336 +01:00] [Thread 15992] extDB2: Database Session Pool Started
[16:25:44:531724 +01:00] [Thread 15992] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\server\@ExileServer\extDB\sql_custom_v2\exile.ini
[16:25:44:532394 +01:00] [Thread 15992] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available

 

 

Share this post


Link to post
Share on other sites

Im having this same issue,  Strict Mode is disabled, and No logs under @extdb folder,    restarted Sql,    

Using windows 2012 r2 

sql 5.6

trying to launch 64bit version     * 32bit verison launchs with no issues

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.