CONVERTİNG NXD FİLES ERROR | Final Fantasy XVI Modding | Page 1

bold ice Sep 21, 2024, 2:13 PM

#

The error I get when converting nxd files is always the same and doesn't change.There is nothing detailed in the conversion guide.There are only commands.It is impossible for someone who has never made a mod to solve it on their own.

bold ice Sep 21, 2024, 4:49 PM

#

[19:47:47] [Fatal] Unable to export to SQLite Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'all VALUES must have the same number of terms'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at FF16Tools.Files.Nex.Exporters.NexToSQLiteExporter.ExportTableToSQLite(String tableName, NexDataFile nexFile, NexTableLayout columnLayout, List`1 rows) in C:\Users\nenkai\source\repos\FF16Unpacker\FF16Tools.Files\Nex\Exporters\NexToSQLiteExporter.cs:line 203
at FF16Tools.Files.Nex.Exporters.NexToSQLiteExporter.ExportTables(String sqliteDbFile) in C:\Users\nenkai\source\repos\FF16Unpacker\FF16Tools.Files\Nex\Exporters\NexToSQLiteExporter.cs:line 76
at FF16Tools.CLI.Program.NxdToSqlite(NxdToSqliteVerbs verbs) in C:\Users\nenkai\source\repos\FF16Unpacker\FF16Tools.CLI\Program.cs:line 314

#

#

What's the reason I'm getting this error? I can't view all the nxd files in the list. Many of them are missing.

bold ice Sep 21, 2024, 8:27 PM

#

thorny canyon Sep 21, 2024, 8:44 PM

#

Did you remove some tables?

bold ice Sep 21, 2024, 9:28 PM

#

ı guess no

thorny canyon Sep 21, 2024, 9:33 PM

#

What data did you change? What's the pac.

bold ice Sep 21, 2024, 9:35 PM

#

001.en.pac

#

I am trying to extract only nxds but only 13 of them can be converted to sqlite and the remaining 38 are not converted

#

like this

thorny canyon Sep 22, 2024, 1:24 AM

#

only nxd files are meant to be converted to sqlite. Remove unecessary files and you should be good to go. I'm not sure of all the files within 0001.

bold ice Sep 22, 2024, 3:57 PM

#

Someone else got the same error I got, in the non-demo version. I will try it in the full version and check if there is the same error and write here.

bold ice Sep 23, 2024, 9:46 AM

#

Full version of the game and same error

#

bold ice Sep 23, 2024, 11:40 AM

#

CONVERTİNG NXD FİLES ERROR

dark brook Sep 23, 2024, 2:28 PM

#

I also get this exact error when trying to convert some nxd files

bold ice Sep 23, 2024, 5:56 PM

#

dark brook I also get this exact error when trying to convert some nxd files

The solution is still unknown. It gives this error when converting in batches. It does not give this error when converting piece by piece.

radiant kiln Sep 25, 2024, 11:30 PM

#

Im extracting PAC using FFXVITools GUI, then extracting NXD using FFXVITools CLI with the unofficial GUI Companion

FFXVITools
#1284921734176313385 message

GUI Companion for FFXVITools CLI
#1287216699916943380 message

Which will output you with an SQLite file, which you can use any SQLite editor to edit. most use "SQLiteStudio" as far as i know

You dont have to convert every NXD at the same time. I do have a Main SQ file of all the tables but i also have been converting one at a time for whatever testing purposes ive been doing

i copy the NXD to a separate folder and convert there rather than the entire main NXD folder

The picture from this message was notes in a text document, not what editing an NXD looks like
#🔍〡research-main message

bold ice Sep 26, 2024, 12:01 AM

#

When I convert the nxd folder to sqlite in bulk, it skips many of them. I have to convert it piece by piece. My main problem is to translate the texts in the nxd folders and import them into the game.

Should I turn it into a pac file? Or would it be better to add it as nxd? I tried both ways, but I couldn't manage to add it to the game manually. I used Reloaded II, but I couldn't add it. I also added it manually as diff.pac, but that didn't work.

radiant kiln Sep 26, 2024, 12:13 AM

#

I load the NXD by itself through reloaded. Everytime you launch the game through reloaded, it will delete modded PAC files and make new modded PAC files for any enabled mods to add changes

If you create a mod, right click and "Open Folder", then create the correct path for your specific file: FFXVI > data > 000x > nxd >*your NXD here*

#

example of that

bold ice Sep 26, 2024, 12:43 AM

#

I wanted to do a little experiment but I can't see the mode in the RII interface. I assume I entered the path correctly.

#

Could it be related to the .path file? Do I need to add the nxd files the way I extracted them, I think there is a problem when I create nxd manually?

radiant kiln Sep 26, 2024, 12:51 AM

#

what nxd are you editing

#

or what PAC if you did bulk

bold ice Sep 26, 2024, 8:31 AM

#

For now I added it as 0007.diff.pac and it seems to be fine.It would be nice if I could make the texts into a single txt and import them into sqlite files.I guess I will have to edit all the nxds separately.

bold ice Sep 26, 2024, 3:07 PM

#

I just can't convert sqlite files to nxd and I don't understand why.

dark brook Sep 26, 2024, 4:08 PM

#

If you mean nxd to sqlite then I can't do that either on some files, but I found some old sqlite files for 0007 and 0007<lang>

#

But you will need to either use an old version of FF16Tools, or change the layouts manually to how they were before more detailed column names were added to them

#

This is 0007
#🔍〡research-main message

#

This is 0007.en
#🔍〡research-main message

bold ice Sep 26, 2024, 5:04 PM

#

Thank you for this, some of them were not turning into sqlite, it was very good, but there is a problem in making nxd. For example in certain files; “command,collection” these are the problematic ones so I can't make them nxd and I can't edit them.

dark brook Sep 26, 2024, 6:10 PM

#

Yeah, that's because you need to use the old layouts probably

bold ice Sep 26, 2024, 6:25 PM

#

What exactly do you mean by old layouts?Do I need to edit in sqlite studio?

dark brook Sep 26, 2024, 6:48 PM

#

Go in to your FF16Tools.CLI folder, then Nex\Layouts, make a backup of command.layout and replace it with this one. You should now be able to convert command back to command.nxd

📎 command.layout

bold ice Sep 26, 2024, 6:52 PM

#

İt works, but equipitem gives the same error. : /

bold ice Sep 26, 2024, 7:11 PM

#

"Unable to import from SQLite System.IO.InvalidDataException: Column 'DLCFlags' for table 'equipitem' does not exist in sqlite table"

#

Is it because I don't have the dlc?

gloomy laurel Sep 26, 2024, 7:25 PM

#

same errors

gloomy laurel Sep 26, 2024, 7:43 PM

#

The layouts are pretty messed up.I have made a few attempts but I think they are still causing problems.

elder halo Oct 19, 2024, 10:28 PM

#

Hello, new to this discord, I'm having the same problem as Kairen, can anyone help me?

#

but I have all DLCs

elder halo Oct 19, 2024, 11:15 PM

#

"Unable to import from SQLite System.IO.InvalidDataException: Column 'DLCFlags' for table 'equipitem' does not exist in sqlite table"

#

It seems I can't convert the sqlite file back to nxd

sterile estuary Oct 19, 2024, 11:38 PM

#

I just tried it with the latest version of the tool (and I have the DLCs) and worked for me. I don't remember if it was this exact same error, but I solved one the other day with using the same version of the program/layouts to extract and to reimport the tables, instead of using the previously extracted ones

#CONVERTİNG NXD FİLES ERROR