[SOLVED] SQLite.SQLiteException error


Studio Name:
Studio Icon (32x32):
Show Download Count (Public):
Banner Image URL:
My Terms of Use:

Studio Tags:

liss01182
New Member

Posts: 6

[SOLVED] SQLite.SQLiteException error Feb 6, 2022 17:51:15 GMT -5

Quote

Post by liss01182 on Feb 6, 2022 17:51:15 GMT -5

SOLUTION: repair your game

So I just updated to the newest version of S4S and I keep getting this error message:

The Sims 4 Studio - Version 3.1.5.6

System.AggregateException: One or more errors occurred. ---> SQLite.SQLiteException: near "VALUES": syntax error

at SQLite.SQLite3.Prepare2(IntPtr db, String query)

at SQLite.SQLiteCommand.Prepare()

at SQLite.SQLiteCommand.ExecuteNonQuery()

at SQLite.SQLiteConnection.Execute(String query, Object[] args)

at S4Studio.Data.FileDb.Sims4FileTable.InsertPackage(SQLiteConnection connection, Int32 gameId, Int32 priority, PackageType type, String filename, String fullpath)

at S4Studio.Data.FileDb.Sims4FileTable.InsertDLC(SQLiteConnection connection, String product, String install, String delta_path, Boolean is_reinit, Boolean load_simulation)

at S4Studio.Data.FileDb.Sims4FileTable.Init(Boolean load_simulation, Boolean is_reinit)

at S4Studio.Data.FileDb.Sims4FileTable.Init(Boolean load_simulation, Boolean is_reinit)

at S4Studio.Shared.AppModel.DoInit()

at System.Threading.Tasks.Task.InnerInvoke()

at System.Threading.Tasks.Task.Execute()

--- End of inner exception stack trace ---

---> (Inner Exception #0) SQLite.SQLiteException: near "VALUES": syntax error

at SQLite.SQLite3.Prepare2(IntPtr db, String query)

at SQLite.SQLiteCommand.Prepare()

at SQLite.SQLiteCommand.ExecuteNonQuery()

at SQLite.SQLiteConnection.Execute(String query, Object[] args)

at S4Studio.Data.FileDb.Sims4FileTable.InsertPackage(SQLiteConnection connection, Int32 gameId, Int32 priority, PackageType type, String filename, String fullpath)

at S4Studio.Data.FileDb.Sims4FileTable.InsertDLC(SQLiteConnection connection, String product, String install, String delta_path, Boolean is_reinit, Boolean load_simulation)

at S4Studio.Data.FileDb.Sims4FileTable.Init(Boolean load_simulation, Boolean is_reinit)

at S4Studio.Data.FileDb.Sims4FileTable.Init(Boolean load_simulation, Boolean is_reinit)

at S4Studio.Shared.AppModel.DoInit()

at System.Threading.Tasks.Task.InnerInvoke()

at System.Threading.Tasks.Task.Execute()<---

I have added an exception to my anti-virus already and made sure that all the paths were configured correctly, so I'm not sure what to do next. The last version I had worked just fine. Is there anyway to go back to an older version? SOMEONE PLEASE HELP!!!!

Last Edit: Feb 7, 2022 8:46:09 GMT -5 by mauvemorn

mauvemorn
Global Moderator

If you receive no reply from me in 24 hours, please bump the thread!

Posts: 11,109

[SOLVED] SQLite.SQLiteException error Feb 6, 2022 18:17:06 GMT -5

Quote

Post by mauvemorn on Feb 6, 2022 18:17:06 GMT -5

Feb 6, 2022 17:51:15 GMT -5 liss01182 said:

So I just updated to the newest version of S4S and I keep getting this error message:

The Sims 4 Studio - Version 3.1.5.6

System.AggregateException: One or more errors occurred. ---> SQLite.SQLiteException: near "VALUES": syntax error

at SQLite.SQLite3.Prepare2(IntPtr db, String query)

at SQLite.SQLiteCommand.Prepare()

at SQLite.SQLiteCommand.ExecuteNonQuery()

at SQLite.SQLiteConnection.Execute(String query, Object[] args)

at S4Studio.Data.FileDb.Sims4FileTable.InsertPackage(SQLiteConnection connection, Int32 gameId, Int32 priority, PackageType type, String filename, String fullpath)

at S4Studio.Data.FileDb.Sims4FileTable.InsertDLC(SQLiteConnection connection, String product, String install, String delta_path, Boolean is_reinit, Boolean load_simulation)

at S4Studio.Data.FileDb.Sims4FileTable.Init(Boolean load_simulation, Boolean is_reinit)

at S4Studio.Data.FileDb.Sims4FileTable.Init(Boolean load_simulation, Boolean is_reinit)

at S4Studio.Shared.AppModel.DoInit()

at System.Threading.Tasks.Task.InnerInvoke()

at System.Threading.Tasks.Task.Execute()

--- End of inner exception stack trace ---

---> (Inner Exception #0) SQLite.SQLiteException: near "VALUES": syntax error

at SQLite.SQLite3.Prepare2(IntPtr db, String query)

at SQLite.SQLiteCommand.Prepare()

at SQLite.SQLiteCommand.ExecuteNonQuery()

at SQLite.SQLiteConnection.Execute(String query, Object[] args)

at S4Studio.Data.FileDb.Sims4FileTable.InsertPackage(SQLiteConnection connection, Int32 gameId, Int32 priority, PackageType type, String filename, String fullpath)

at S4Studio.Data.FileDb.Sims4FileTable.InsertDLC(SQLiteConnection connection, String product, String install, String delta_path, Boolean is_reinit, Boolean load_simulation)

at S4Studio.Data.FileDb.Sims4FileTable.Init(Boolean load_simulation, Boolean is_reinit)

at S4Studio.Data.FileDb.Sims4FileTable.Init(Boolean load_simulation, Boolean is_reinit)

at S4Studio.Shared.AppModel.DoInit()

at System.Threading.Tasks.Task.InnerInvoke()

at System.Threading.Tasks.Task.Execute()<---

I have added an exception to my anti-virus already and made sure that all the paths were configured correctly, so I'm not sure what to do next. The last version I had worked just fine. Is there anyway to go back to an older version? SOMEONE PLEASE HELP!!!!

Hi. Please tell us where s4s is installed and show us your paths in s4s settings

Last Edit: Feb 6, 2022 18:18:28 GMT -5 by mauvemorn

PLEASE FOLLOW THE RULES OF CREATOR HELP:

• describe your problem and provide a picture of it (if possible);

• provide download link(s) to .package and .blend files.

If you have a Gmail acc, you can host all of the above on Google Drive

liss01182
New Member

Posts: 6

[SOLVED] SQLite.SQLiteException error Feb 6, 2022 18:58:28 GMT -5

Quote

Post by liss01182 on Feb 6, 2022 18:58:28 GMT -5

Feb 6, 2022 18:17:06 GMT -5 mauvemorn said:

Feb 6, 2022 17:51:15 GMT -5 liss01182 said:

So I just updated to the newest version of S4S and I keep getting this error message:

The Sims 4 Studio - Version 3.1.5.6

System.AggregateException: One or more errors occurred. ---> SQLite.SQLiteException: near "VALUES": syntax error

at SQLite.SQLite3.Prepare2(IntPtr db, String query)

at SQLite.SQLiteCommand.Prepare()

at SQLite.SQLiteCommand.ExecuteNonQuery()

at SQLite.SQLiteConnection.Execute(String query, Object[] args)

at S4Studio.Data.FileDb.Sims4FileTable.InsertPackage(SQLiteConnection connection, Int32 gameId, Int32 priority, PackageType type, String filename, String fullpath)

at S4Studio.Data.FileDb.Sims4FileTable.InsertDLC(SQLiteConnection connection, String product, String install, String delta_path, Boolean is_reinit, Boolean load_simulation)

at S4Studio.Data.FileDb.Sims4FileTable.Init(Boolean load_simulation, Boolean is_reinit)

at S4Studio.Data.FileDb.Sims4FileTable.Init(Boolean load_simulation, Boolean is_reinit)

at S4Studio.Shared.AppModel.DoInit()

at System.Threading.Tasks.Task.InnerInvoke()

at System.Threading.Tasks.Task.Execute()

--- End of inner exception stack trace ---

---> (Inner Exception #0) SQLite.SQLiteException: near "VALUES": syntax error

at SQLite.SQLite3.Prepare2(IntPtr db, String query)

at SQLite.SQLiteCommand.Prepare()

at SQLite.SQLiteCommand.ExecuteNonQuery()

at SQLite.SQLiteConnection.Execute(String query, Object[] args)

at S4Studio.Data.FileDb.Sims4FileTable.InsertPackage(SQLiteConnection connection, Int32 gameId, Int32 priority, PackageType type, String filename, String fullpath)

at S4Studio.Data.FileDb.Sims4FileTable.InsertDLC(SQLiteConnection connection, String product, String install, String delta_path, Boolean is_reinit, Boolean load_simulation)

at S4Studio.Data.FileDb.Sims4FileTable.Init(Boolean load_simulation, Boolean is_reinit)

at S4Studio.Data.FileDb.Sims4FileTable.Init(Boolean load_simulation, Boolean is_reinit)

at S4Studio.Shared.AppModel.DoInit()

at System.Threading.Tasks.Task.InnerInvoke()

at System.Threading.Tasks.Task.Execute()<---

I have added an exception to my anti-virus already and made sure that all the paths were configured correctly, so I'm not sure what to do next. The last version I had worked just fine. Is there anyway to go back to an older version? SOMEONE PLEASE HELP!!!!

Hi. Please tell us where s4s is installed and show us your paths in s4s settings

S4S is install : C:\Program Files (x86)\Sims 4 Studio

And my paths are as follows:

Sims 4 Path= C:/Program Files/The Sims 4

Sims 4 Documents= C:/Users/liss0/OneDrive/Documents/Electronic Arts/The Sims 4

Blender Path= C:/Program Files/Blender Foundation/Blender/blender.exe

I tried to attach the image but I couldn't figure out how so I just typed it out Exactly

Last Edit: Feb 6, 2022 18:59:35 GMT -5 by liss01182

mauvemorn
Global Moderator

If you receive no reply from me in 24 hours, please bump the thread!

Posts: 11,109

[SOLVED] SQLite.SQLiteException error Feb 6, 2022 19:45:55 GMT -5 liss01182 likes this

Quote

Post by mauvemorn on Feb 6, 2022 19:45:55 GMT -5

Hm, the fact that your documents folder is on one drive is strange but it shouldn’t be the one causing this type of error.
If my memory serves me well, this type of error is related to the problem with game files, so you can try repairing the game.
But before you do that, try putting \ at the end of your game path, then restart s4s. If won’t help, try running it as admin. And if won’t help again, repair the game. And if even this won’t help, try giving access to s4s folder as shown here (in both replies)

PLEASE FOLLOW THE RULES OF CREATOR HELP:

• describe your problem and provide a picture of it (if possible);

• provide download link(s) to .package and .blend files.

If you have a Gmail acc, you can host all of the above on Google Drive

liss01182
New Member

Posts: 6

[SOLVED] SQLite.SQLiteException error Feb 6, 2022 20:45:06 GMT -5

Quote

Post by liss01182 on Feb 6, 2022 20:45:06 GMT -5

Feb 6, 2022 19:45:55 GMT -5 mauvemorn said:

Hm, the fact that your documents folder is on one drive is strange but it shouldn’t be the one causing this type of error.
If my memory serves me well, this type of error is related to the problem with game files, so you can try repairing the game.
But before you do that, try putting \ at the end of your game path, then restart s4s. If won’t help, try running it as admin. And if won’t help again, repair the game. And if even this won’t help, try giving access to s4s folder as shown here (in both replies)

This Worked!! Thank you so much for your help!


Screenshot URL:
Title:
Enable Comments:
Show Download Count (Public):
Download Link:
Tags:

Sims 4 Studio

My Studio

[SOLVED] SQLite.SQLiteException error

Post by liss01182 on Feb 6, 2022 17:51:15 GMT -5

Post by mauvemorn on Feb 6, 2022 18:17:06 GMT -5

Post by liss01182 on Feb 6, 2022 18:58:28 GMT -5

Post by mauvemorn on Feb 6, 2022 19:45:55 GMT -5

Post by liss01182 on Feb 6, 2022 20:45:06 GMT -5

Problems with registration?