A Unity ID allows you to buy and/or subscribe to Unity products and services, shop in the Asset Store and participate
in the Unity community.
Discussion in 'Assets and Asset Store' started by echo17, Jul 12, 2012.
Please see this FAQ: http://echo17.proboards.com/thread/2/faq?page=2&scrollTo=30
That is exactly what I was looking for.
Can you sort your loose scripts out, and put them in a proper namespace.. shouldn't need to be said to every asset store developer but eventually one comes across two addons who want to use the same name for a script and then the end user gets the conflict...
MainMenuButton.cs ...being the case in this instance.
just noticed another called MainMenu.cs ..I mean common
Good idea. I'll try to get this in the next service release.
Hello. I found a behavior that might need to be fixed.
I found T SimpleSQL.SimpleSQLManager.Get< T >(object pk) throws InvalidOperationException when specified record is not found, but references saids The object with the given primary key. Throws a not found exception if the object is not found.
error code is below. IEnumerable threw error.
InvalidOperationException: Sequence contains no elements
System.Linq.Enumerable.First[TSource] (System.Collections.Generic.IEnumerable`1[T] source) (at <351e49e2a5bf4fd6beabb458ce2255f3>:0)
SimpleSQL.SQLiteConnection.Get[T] (System.Object pk) (at <9d351781d88446ec91fb4a6de237d175>:0)
SimpleSQL.SimpleSQLManager.Get[T] (System.Object pk) (at <9d351781d88446ec91fb4a6de237d175>:0)
//omit the rest (below is my code)
I'm grad to you check this if you have time.
T SimpleSQL.SimpleSQLManager.Get< T >(object pk)
The object with the given primary key. Throws a not found exception if the object is not found
I don't officially support Linq with SimpleSQL, so I don't include reference to that library in my documentation or code examples. Instead, try using the built-in functions of the SimpleSQLManager like Query and QueryFirstRecord. These should be more robust and get you the data that you need.
As to the error that you are getting, that would seem to be the expected behavior if you do not have a record. I cannot speak for how the .NET developers designed Linq, but it would seem you would want an exception thrown for missing data. You can probably handle this with a try catch or just use the QueryFirstRecord method in SimpleSQLManager (which does provide an out parameter that tells you if the record exists).
var record = dbManager.QueryFirstRecord<MyORM>(out recordExists, sql);
Hi, i have the follow error (it's a conflic with Runtime Editor Asset):
Assets\Battlehub\UIControls\Menu\Scripts\UIStyle.cs(13,32): error CS1061: 'MainMenuButton' does not contain a definition for 'NormalColor' and no accessible extension method 'NormalColor' accepting a first argument of type 'MainMenuButton' could be found (are you missing a using directive or an assembly reference?)
'MainMenuButton' does not contain a definition for 'FocusedColor' and no accessible extension method 'FocusedColor' accepting a first argument of type 'MainMenuButton' could be found (are you missing a using directive or an assembly reference?)
Thanks in advance.
I plan on adding namespaces to my demo code in the next service release to avoid these conflicts. Until then, you can either add a namespace to the SimpleSQL MainMenuButton code or delete the code entirely. The only purpose it has is to allow you to navigate the demos without having to load each scene individually. You can still play each demo without it.
My game works on Unity Editor, but when I build the game on Android. It's not working. I have installed the latest version from the Asset Store and I don't know how to fix this.
Is there any way I can debug SimpleSQL when I run the game on my android device?
I had the same problem. Try this:
Tools > SimpleSQL > Options -> Android
and then run build.
In addition to the above suggestion by jacente, I would also have a look at these links for advice on debugging on Android:
Thank you so much, jacente and echo17! I got it working with a single click of a button. I wish I could always fix my games like this.
After we go through the steps to notarize our build, and only on OSX versions older than Catalina we encounter the following error.
Uploading Crash Report
DllNotFoundException: Unable to load DLL 'sqlite3': The specified module could not be found.
at SimpleSQL.SQLiteConnection..ctor (System.String databasePath) [0x00000] in <00000000000000000000000000000000>:0
We are using Unity 2019.2.21f1, and are using version 2.9.0 of SimpleSQL from the Asset Store. We have IL2CPP selected as our scripting backend and our Api Compatibility Level set to .NET 4.x.
We aren't seeing anything like this on windows, and if we test prior to notarization everything works just fine. Its worth noting that everything else in the app seems to work just fine after notarization, but it will fail as soon as that call is made to the sqlite3.dll from SimpleSQL.SQLiteConnection. Its also worth noting that after notarization the app works perfectly on Catalina, for whatever reason this only seems to affect older version of OSX for us.
Does anyone have any thoughts on this?
The first thing I would try is a different build setting in the Tools > SimpleSQL > Options menu. Try setting it to universal (Mac / PC) and then build again. The universal setting will extract the sqlite3.dll at runtime. The Mac setting does not extract a sqlite3.dll file at runtime since Mac OS has included this by default for a very long time. I'm not sure why you would be getting this error now, however.
If you already had it on Universal, try the Mac setting instead, then rebuild. Hopefully one of those two settings will help out.
I've got the similar problem on Mac App. I have tried 2019.2.17 and 2019.3.3 and using a runtime debug reporter. Following is the error:
Have tried, but this solution doesn't work for me.
My Mac verison is 10.13.6
It's possible that newer versions of the sqlite library are no longer compatible with older versions of Mac. You might try downloading an older version of the sqlite library from the sqlite website directly and putting it into your plugins folder of your project. sqlite website can be found here: https://sqlite.org/index.html
@echo17 Hello, been using this asset for over a year now and its been great. Any tips for getting this working with uwp?
Not sure. I haven't worked with UWP myself. Are you getting any particular error?
I am not seeing the database file change, but it does seem like information is being stored somewhere.
I am using Tools>SimpleSQL>Create Empty Database to make a database file named "New Database.Bytes"
Then I use this command to make a table
string sql = @"CREATE TABLE Table01(id INTEGER PRIMARY KEY, name_txt TEXT)";
Then I use this code to enter information into the database
string sql = "INSERT INTO Table01 (name_txt) VALUES (?)";
dbManager.Execute(sql, "My Name");
The information is recorded and I can later read back the information with a separate command in Unity, but the file size does not change. I open New Database.Bytes in an external SQLite editor and the editor does not see the information entered into the tables. But when I run a query on the New Database.Bytes file in Unity I can see the information that I entered into the table.
What is going on?
Check out these FAQs:
That answers my question. Thank you very much.
Does this asset work on Android phone using ARMv7l (32 bit processor)? Specifically Sony Xperia Z3 (D6603)
Sorry, I don't have an ARMv7 32 bit Android device to test on. It should work, but if it doesn't shoot me an email (located in my signature) and we'll try to see if we can get it to.
It can be tested on 64 bit Android device too. You just have to build from Unity like usual but only target architecture ARMv7. Can you please try this? Other solutions I've tried always failed to load ARMv7's SQL DLL
Yep, looks like it works for me. Here are my specs:
Mac OSX 10.15.5
Galaxy Tab A
Android 9 (Kernel 4.4.111-17420370)
Android Player Settings:
Minimum API Level: Android 9.0
Scripting Backend: IL2CPP
API Compatibility Level: .NET 4.x
Target Architectures: ARMv7
Can you add Linux support please? Or, if it's already there, can you add it to the description? Thanks.
Unfortunately, I do not have a Linux machine to test SimpleSQL on. If anyone here can confirm it works, I'll certainly add to the description.
It appears to work on Ubuntu 20.04.
I prefer to use a password-protected sqlite database on mobile. Does this support using password-protected databases?
Please see this FAQ: https://echo17.proboards.com/thread/2/faq?page=3&scrollTo=33