There is a database in which you need to write the values ​​from the "check-in" fields when trying to write, it gives an error Unable to open Assets/youtube.bytes.db: Check external application preferences .

When checking through try catch writes:

Mono.Data.Sqlite.SqliteException: SQLite error no such table: Users Mono.Data.Sqlite.SQLite3.Prepare (Mono.Data.Sqlite.SqliteConnection cnn, System.String strSql, Mono.Data.Sqlite.SqliteStatementntu, UInt32, Mono.Data. , System.String & strRemain) Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () UnityEngine.EventSystems.EventSystem: Update ()

how to fix it and what is it? desktop application

 using System.Collections; using UnityEngine; using Mono.Data.Sqlite; using System.Data; using System.IO; using System; using UnityEngine.UI; public class db_controller : MonoBehaviour { public SqliteConnection con_db; public SqliteCommand cmd_db; public SqliteDataReader rdr; public string path; public Text text; string id; string log; string pass; public InputField idfield; public InputField login; public InputField password; // Use this for initialization void Start () { } // Update is called once per frame void Update () { } public void Connection() { path = Application.dataPath + "/youtube.bytes"; con_db = new SqliteConnection ("URI=file:" + path); con_db.Open (); } public void SetDB(){ Connection(); id=idfield.text.ToString(); log=login.text.ToString(); pass=password.text.ToString(); cmd_db=new SqliteCommand("INSERT INTO Users(id,login,pass) VALUES('"+id+"','"+log+"','"+pass+"')", con_db); cmd_db.ExecuteNonQuery (); Disconnect(); } private void Disconnect(){ con_db.Close (); } }

bd

  • The table, I think, is clear, but what is the base? - nick_n_a
  • The problem may not be with the table, but with the database connection. Make sure you follow these steps: answers.unity3d.com/questions/743400/… - Valera Kvip
  • The question is not answered with a green daw .. and besides .. the answer is not very clear. Which extension was changed is not indicated ... maybe the question is simply to close? - nick_n_a

1 answer 1

problem solved, fixed DB extension