help Error building Player: Extracting referenced dlls failed how to work with this?

Unity Engine
1

help… when i tried to build my scenes…2 errors have shown…
“ArgumentException: The Assembly System.Security is referenced by System.Configuration. But the dll is not allowed to be included or could not be found.” and “Error building Player: Extracting referenced dlls failed.”

i checked some forums and topics, they said that i must put System.Configuration in my project folder. So i did, but still the error shows…i tried also System.Configuration.Install but still it didn’t solve the problem. My dlls are System.Data, System.Configuration, System,Configuration.Install, Mysql.Data
what’s the problem? help please

2

If you are trying to build webplayer, then u cannot include ur plugins in webplayer.

3

no, it’s standalone…

4

Bump!

I tried to change the sql connection from IDBConnection to MySqlConnection and I also change the API compatibility from .NET 2.0 subset to .NET 2.0
then i build it, no errors and it work… but the problem is the connection seems to retrieve nothing from the database… i don’t know what’s the problem?

here’s the code snippet:

using UnityEngine;
using System;
using System.Collections;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using MySql.Data.MySqlClient;

public class QuestioningPhase1 : MonoBehaviour {
        private static MySqlConnection dbConnect;
	private static string myAnswer;
	private static string myQuestion;
	private static string[] myArray;
	private string[] theAnswers;
	private string[] unansweredID;

	private static void openSqlConnection(){
		string connectionString = "Server=localhost;" +
			"Database=luzvimin_db;" + 
				"User ID=root;" +
				"Password=rey;" +
				"Pooling=false";
		dbConnect = new MySqlConnection(connectionString);
		dbConnect.Open();
	}

	void Start(){
		myAnswer = "";
		myQuestion = "";
		myArray = new string[4];
		theAnswers = new string[4];
		openSqlConnection();
		int countQ = countQuestions("SELECT QuestionID FROM question_tbl WHERE Status='Unanswered'");
		unansweredID = new string[countQ];
		inArray("SELECT QuestionID FROM question_tbl WHERE Status='Unanswered'");
		int randQ = UnityEngine.Random.Range(0,unansweredID.Length);
		doQuery("SELECT Question,CorrectAnswer FROM question_tbl WHERE QuestionID=" + unansweredID[randQ]);
		doQuery2("SELECT Answers FROM answers_tbl WHERE QuestionID=" + unansweredID[randQ]);
		Randomize();
	}

	public int countQuestions(string sqlQuery){
		int qCount = 0;
		MySqlCommand dbCommand = dbConnect.CreateCommand();
		//IDbCommand dbCommand = dbConnect.CreateCommand();
		dbCommand.CommandText = sqlQuery;
		MySqlDataReader reader = dbCommand.ExecuteReader();
		//IDataReader reader = dbCommand.ExecuteReader();
		while(reader.Read()){
			qCount++;
		}
		reader.Close();
		reader = null;
		dbCommand.Dispose();
		dbCommand = null;
		return qCount;
	}

	void inArray(string sqlQuery){
		int ind = 0;
		MySqlCommand dbCommand = dbConnect.CreateCommand();
		//IDbCommand dbCommand = dbConnect.CreateCommand();
		dbCommand.CommandText = sqlQuery;
		MySqlDataReader reader = dbCommand.ExecuteReader();
		//IDataReader reader = dbCommand.ExecuteReader();
		while(reader.Read()){
			unansweredID[ind] = reader["QuestionID"].ToString();
			ind++;
		}
		reader.Close();
		reader = null;
		dbCommand.Dispose();
		dbCommand = null;
	}

	public static void doQuery2(string sqlQuery){
		MySqlCommand dbCommand = dbConnect.CreateCommand();
		dbCommand.CommandText = sqlQuery;
		MySqlDataReader reader = dbCommand.ExecuteReader();
		int ctr = 0;
		while(reader.Read()){
			myArray[ctr] = reader["Answers"].ToString();
			ctr++;
		}
		reader.Close();
		reader = null;
		dbCommand.Dispose();
		dbCommand = null;	
	}
}
5

First I’d make sure the database connection actually works. Try doing a simple “SELECT 1 + 2” which should return 3 as a result. If it works, then the problem is somewhere else.

Put some Debug.Log()'s when you’re reading results off your queries to make sure you’re getting the expected results.

6

remove the plugins it will definitely build