Constant error message with sims 4 studio


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

Studio Tags:

Melanatedpixels
New Member

Posts: 7

Constant error message with sims 4 studio Jul 24, 2022 12:26:07 GMT -5

Quote

Post by Melanatedpixels on Jul 24, 2022 12:26:07 GMT -5

Every time that I open S4S, I keep getting this error. I have done a clean uninstall and reinstall; Repaired my game 5x, deleted my S4 documents folder and the problem is still happening. This happened before with the old version however once I updated, it stopped.

The Sims 4 Studio - Version 3.1.6.0

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.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.Shared.AppModel.DoInit()

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

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

Last Edit: Jul 24, 2022 12:29:39 GMT -5 by Melanatedpixels

mauvemorn Global Moderator If you receive no reply from me in 24 hours, please bump the thread! Posts: 11,258	Constant error message with sims 4 studio Jul 24, 2022 14:54:45 GMT -5 Quote Select Post Deselect Post Link to Post Back to Top Post by mauvemorn on Jul 24, 2022 14:54:45 GMT -5 Hi. Unless that was a typo, you were meant to delete s4s folder from the documents, so try this. If this won't help, try doing what is listed in both replies, helped another person
	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

Melanatedpixels
New Member

Posts: 7

Constant error message with sims 4 studio Jul 24, 2022 19:14:10 GMT -5

Quote

Post by Melanatedpixels on Jul 24, 2022 19:14:10 GMT -5

Hi,

No it wasn't a typo, just misworded. I meant that I deleted the folder from the documents section, not the main game directory.
Thank you, I will try that.

EDIT: I tried the method that you shared and sadly, that did not work for me either

Last Edit: Jul 24, 2022 20:09:41 GMT -5 by Melanatedpixels

mauvemorn
Global Moderator

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

Posts: 11,258

Constant error message with sims 4 studio Jul 25, 2022 3:36:58 GMT -5

Quote

Post by mauvemorn on Jul 25, 2022 3:36:58 GMT -5

So, s4s folder, not s4, right?

And it was s4s installation folder that you gave permission, right?

Share your paths please
Also, what drive is s4s installed?

and just to make sure, your game is updated to the latest version?

Last Edit: Jul 25, 2022 3:42:56 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

Melanatedpixels
New Member

Posts: 7

Constant error message with sims 4 studio Jul 26, 2022 19:23:42 GMT -5

Quote

Post by Melanatedpixels on Jul 26, 2022 19:23:42 GMT -5

The S4S folder and then the Sims 4 folder.
I deleted the Sims 4 folder just in case something was corrupted in it and then I let the game respawn a new one.

And yes, it was.

Sims 4 path: C:\Program Files (x86)\Origin Games\The Sims 4
Documents: C:\Users\jador\Documents\Electronic Arts\The Sims 4
Blender path: C:\Program Files\Blender Foundation\Blender\blender.exe

It's installed on the local disk drive and yes, I even just updated to the recent patch

mauvemorn Global Moderator If you receive no reply from me in 24 hours, please bump the thread! Posts: 11,258	Constant error message with sims 4 studio Jul 27, 2022 2:57:16 GMT -5 Quote Select Post Deselect Post Link to Post Back to Top Post by mauvemorn on Jul 27, 2022 2:57:16 GMT -5 can you try moving s4s to a d drive, if you have it. Also, just in case, add \ at the very end of the game path so it looks like C:\Program Files (x86)\Origin Games\The Sims 4\
	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

Melanatedpixels
New Member

Posts: 7

Constant error message with sims 4 studio Jul 28, 2022 19:29:43 GMT -5

Quote

Post by Melanatedpixels on Jul 28, 2022 19:29:43 GMT -5

The only d drive that I have is the CD-ROM drive. I'm just going to give up lol.
It's exhausting and mentally frustrating to deal with. I can still use S4S to export meshes out for blender.
I just can't recolor anything because the body won't show up and that's fine for now.
Hopefully it'll fix itself for me when the next update comes out.

I really appreciate all of your help, thank you so much :D

andrew
Tech Lead

Posts: 1,868

Constant error message with sims 4 studio Jul 29, 2022 0:16:25 GMT -5 Melanatedpixels and mauvemorn like this

Quote

Post by andrew on Jul 29, 2022 0:16:25 GMT -5

Hi Melanatedpixels,
Based on the error message, I was able to make this error happen to me by putting a package with a single empty resource in my game files. That package stayed even after repairing the game. I'll try to fix this problem so Studio skips over things like this in the next version. If you want to try getting things working in the meantime, you could try completely uninstalling sims 4, check the installation folder to make sure there are no files left behind at all, and then re-install.

Please do not PM me with modding questions. Post in the Creator Help forum.

Melanatedpixels New Member Posts: 7	Constant error message with sims 4 studio Jul 29, 2022 18:27:23 GMT -5 andrew likes this Quote Select Post Deselect Post Link to Post Back to Top Post by Melanatedpixels on Jul 29, 2022 18:27:23 GMT -5 Hi andrew, Thank you so much!! It's loading correctly right now


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

Sims 4 Studio

My Studio

Constant error message with sims 4 studio

Post by Melanatedpixels on Jul 24, 2022 12:26:07 GMT -5

Post by mauvemorn on Jul 24, 2022 14:54:45 GMT -5

Post by Melanatedpixels on Jul 24, 2022 19:14:10 GMT -5

Post by mauvemorn on Jul 25, 2022 3:36:58 GMT -5

Post by Melanatedpixels on Jul 26, 2022 19:23:42 GMT -5

Post by mauvemorn on Jul 27, 2022 2:57:16 GMT -5

Post by Melanatedpixels on Jul 28, 2022 19:29:43 GMT -5

Post by andrew on Jul 29, 2022 0:16:25 GMT -5

Post by Melanatedpixels on Jul 29, 2022 18:27:23 GMT -5

Problems with registration?