ERROR: 5 values for 3 columns

[Firebug]

It doesn't tell me where in my mod this error is, not a clue. So what should i be looking for?

 

[Gedemon]

It doesn't tell me where in my mod this error is, not a clue. So what should i be looking for?

You can use the time stamps in the logs to reduce the scope of your search, for example

Got this in Database.log :

[2461825.012] [Gameplay] ERROR: table Colors has 6 columns but 5 values were supplied

Found that in Modding.log :

[2461824.980] Status: UpdateDatabase - Loading NewCityStates.sql
[2461825.012] Warning: UpdateDatabase - Error Loading SQL.

 

[isau]

You might also want to have a look at this post, where I describe the simple tracker I use to help figure out which file failed to load.

https://forums.civfanatics.com/threads/tutorial-how-to-write-a-basic-debug-tracker-in-sql.613738/

 

[Firebug]

I was able to track the source of the issue to my AngloSaxon_GameDefines.sql file but sadly my lack of organisation has come back to bite me in the rear, because i can't find the error in the file for the death of me.

 

[Infixo]

Post the file, so we can take a look.

 

[Firebug]

Here's the GameDefines file. I can't find it, i hope you have better luck. Thanks a bunch.

 

[Infixo]

Can't access it, pls post it here, on the forum.

 

[Firebug]

It's MUCH too large to be posted on the forum. Pastebin is guaranteed to work.

 

[Infixo]

I don't see anything that would give such error. Pls post database.log and corresponding modding.log. I'm not sure if this is the file that causes problems.

 

[Firebug]

[2635082.416] [Gameplay] ERROR: 5 values for 3 columns
[2635082.606] [Gameplay]: Validating Foreign Key Constraints...
[2635082.630] [Gameplay]: Passed Validation.

[2635082.385] Status: UpdateDatabase - Loading Core/AngloSaxon_GameDefines.sql
[2635082.416] Warning: UpdateDatabase - Error Loading SQL.
[2635082.417] Status: UpdateDatabase - Loading Core/AngloSaxon_Uniques.xml

Here's the matching timestamp. At first i thought it was the Uniques.xml but it says Error Loading SQL.

 

[Infixo]

Please post entire log.
XML also produces sql errors because it is loaded in UpdateDatabase component.

 

[LeeS]

--==========================================================================================================================
-- CIVILIZATIONS
--==========================================================================================================================
-- CivilizationLeaders
-------------------------------------   
INSERT INTO CivilizationLeaders 
        (CivilizationType,                      LeaderType,                         CapitalName)
SELECT  'CIVILIZATION_FB_ANGLO_SAXONS',         'LEADER_FB_OFFA',           'LOC_CITY_NAME_FB_TAMWORTH'
        'CIVILIZATION_FB_ANGLO_SAXONS',         'LEADER_FB_ALFRED',         'LOC_CITY_NAME_FB_WINCHESTER'

Appears to be the very bottom of the file.

Missing a comma "," at the end of the 1st SELECT line, and a ";" at the end of the chunk.

Since you don't seme to be extracting data from some other element in the database to use in the Insert you can also just as easily get rid of the SELECT statement and use VALUES in order to cure the current issue where your code chunk is being interpretted as an attempt to stick more columns into a single row that you have specified columns for data to be sent to. (ie, your code is treating the whole thing as written as an attempt to plop all that into a single row in the table CivilizationLeaders.)

INSERT INTO CivilizationLeaders 
        (CivilizationType,			LeaderType,		CapitalName)
VALUES  ('CIVILIZATION_FB_ANGLO_SAXONS',	'LEADER_FB_OFFA',	'LOC_CITY_NAME_FB_TAMWORTH'),
        ('CIVILIZATION_FB_ANGLO_SAXONS',	'LEADER_FB_ALFRED',	'LOC_CITY_NAME_FB_WINCHESTER');

 

[LeeS]

BTW, an XML file would not normally throw that error. It would throw an error for "duplicate column names" or an error for "expected <Row> but got ......". And in most cases such an error in an xml file will also spit out an error line in the database log specifying the filename wherein the error was encountered. This is probably just about the only way xml is better than sql: syntax errors in xml files generally give much more information, including the filename.

 

[Firebug]

That's fixed it, thanks a ton.