robertohuertasm / SQLite4Unity3d

SQLite made easy for Unity3d
MIT License
1.28k stars 265 forks source link

Game Compiled on Windows don't work but on editor do! #42

Closed GilbertoBitt closed 8 years ago

GilbertoBitt commented 8 years ago

i have a problem i want to work on both android and Windows but on Windows the sqlite don't work! how i make it work? the interesting is that on Windows it work! and i wonder why! someone please help!

robertohuertasm commented 8 years ago

Have you followed the video tutorials?

GilbertoBitt commented 8 years ago

but the vídeo tutorial that exist on readme isn't just about the Windows phone and UWP?

robertohuertasm commented 8 years ago

You have a tutorial for each platform. All you have to do is configure the settings accordingly whenever you want to deploy to a specific platform.

GilbertoBitt commented 8 years ago

@robertohuertasm i will try now and answer with the result!

GilbertoBitt commented 8 years ago

@robertohuertasm here is configuration.. whem i compile the game.. he don't read at all the sqlitedb and i don't know why! it's like neve was a sqlite db there. what u recomend to me to find a solution?

here is my build settings 2016-05-18_20-24-36

here is my localdb content! 2016-05-18_20-32-51

here is the problem that i get! https://gfycat.com/DeadComplexIndiancow

robertohuertasm commented 8 years ago

@gilbertobitt I thought you were talking about Windows Store apps... I don't have now access to my windows machine. As soon as I can get to it I will let you know. But if it runs in the editor it should also run in your pc.

GilbertoBitt commented 8 years ago

@robertohuertasm that's is the problem.. is that is running corretly on editor but when compiled to windows x86 or windows x86_x64 both don't run! it's like never was a code to acess sqlitedb!

Borhenec commented 8 years ago

hi, I have the same problem when I compile I have this error : SqliteExeption : no such table : Score but it's running correctly on editor.

robertohuertasm commented 8 years ago

Sorry guys but I'm a little busy these days so I won't be able to help you as I would like. I promise to take a look at it asap and let you know.

GilbertoBitt commented 8 years ago

no answer yet? so.. i probably should search for another solution for sqlite connection with unity!

robertohuertasm commented 8 years ago

Hey, it's completely up to you. I guess you know this is an open source project and I have no special interest in you using it. If it does not get the job done then it's time to move on and collaborate with the project or seek for another tool. Is that simple.

robertohuertasm commented 8 years ago

@Borhenec @gilbertobitt I've just tried using the example and it works without any problem as you can see in this video:

example video

It must certainly be something specific of your code. Can you get any error message? Have you tried to debug it?

GilbertoBitt commented 8 years ago

i will try here updating unity to a new version because i was watching the change log of the updates after mine version o unity (Unity 5.3.4p5 (64-bit)) about fixes on assets bundle on load assets streaming probably must be it! and i will do what u told me.. and like u said is open source.. i will try update/upgrade and let it more easy to manager!

robertohuertasm commented 8 years ago

If there's nothing new here I will proceed to close it. Feel free to continue the thread and I will reopen it again.

mubeenfahmed commented 5 years ago

Hi @robertohuertasm , I am experiencing a similar problem, but in my I am targeting UWP Desktop. I've followed your windows tutorial and did everything accordingly, but when I run the application on VS 2017, upon inserting values in db I get the following output.

Exception thrown at 0x00007FF9B395A388 in Orbit-Ed.exe: Microsoft C++ exception: Il2CppExceptionWrapper at memory location 0x0000002BAEAFDB50. Exception thrown at 0x00007FF9B395A388 in Orbit-Ed.exe: Microsoft C++ exception: Il2CppExceptionWrapper at memory location 0x0000002BAEAFDD20. Exception thrown at 0x00007FF9B395A388 in Orbit-Ed.exe: Microsoft C++ exception: Il2CppExceptionWrapper at memory location 0x0000002BAEAFE160. Exception thrown at 0x00007FF9B395A388 in Orbit-Ed.exe: Microsoft C++ exception: Il2CppExceptionWrapper at memory location 0x0000002BAEAFE2E0. Exception thrown at 0x00007FF9B395A388 in Orbit-Ed.exe: Microsoft C++ exception: Il2CppExceptionWrapper at memory location 0x0000002BAEAFE2E0. SQLiteException: ReadOnly at SQLite4Unity3d.PreparedSqlLiteInsertCommand.ExecuteNonQuery (System.Object[] source) [0x00000] in :0 at SQLite4Unity3d.SQLiteConnection.Insert (System.Object obj, System.String extra, System.Type objType) [0x00000] in :0 at SQLite4Unity3d.SQLiteConnection.Insert (System.Object obj) [0x00000] in :0 at SQLite4Unity3d.SQLiteConnection+<>c__DisplayClass95_0.b0 () [0x00000] in :0 at System.Action.Invoke () [0x00000] in :0 at SQLite4Unity3d.SQLiteConnection.RunInTransaction (System.Action action) [0x00000] in :0 at SQLite4Unity3d.SQLiteConnection.InsertAll (IEnumerable objects) [0x00000] in :0 at loginService+d36.MoveNext () [0x00000] in :0 at UnityEngine.SetupCoroutine.InvokeMoveNext (IEnumerator enumerator, IntPtr returnValueAddress) [0x00000] in :0

Kindly help, I am stuck.