Database editing help

Sizeman21 · 01-29-2017, 08:48 PM

Hello anyone reading,

For the past few few weeks, I have been creating a new nation called Arrington. I have just finished adding new cities after successfully seeing the nation work on OOTP. But when I went to check that these latest cities worked, I got a strange error seen below.

http://www.ootpdevelopments.com/boar...1&d=1485740490

A friend and I tried to figure out what was wrong, but we could not. I am not good with code and there is too much in the db.

Here is the database I am using. If someone could please look and see what I am doing wrong, I would greatly appreciate it.

http://www.mediafire.com/file/cdrmum...ld_default.xml

Alex

thorpegiovanni · 01-29-2017, 09:01 PM

Did you create the nation through XML, because I have been attempting to do that recently and failing.

Sizeman21 · 01-29-2017, 09:10 PM

Quote:

Originally Posted by thorpegiovanni

Did you create the nation through XML, because I have been attempting to do that recently and failing.

Ah right. No, I have been editing it through Notebook ++. It is much easier for me than the basic look. Here is the link to download N++ if you wanna keep helping. If not, no worries. I should have stated that first

https://notepad-plus-plus.org/download/v7.3.1.html

NoOne · 01-30-2017, 04:02 PM

as long as it saved it in its original format, it shouldn't matter.. notepad++ is defintieyl superiour in many ways. i use it when someone doesn't format an xml or conf file very well... it does it for us :P

the color-coding should help if you missed a > or something. i can't read the error you posted because the forums won't allow it - maybe the file type? these forums are a bit picky about things that really don't matter or easily circumvented anyway and provide no real protection - but does cause inconvenience aplenty.

it sounds like you got somethign custom to work? so, it's probably just something minor you made a mistake on - like formatting.

if it's a subset, then you may just not be inserting it properly (just adding rows to an existing table? new table? somethgn else?)... i've never worked on teh world file, so i am of limited help on specifics for you.

find other examples of somethign similar, open up 2nd notepad and scroll to your edits to compare - best way to figure it out with no one helping... use work that is functioning and compare.

Sizeman21 · 01-30-2017, 05:48 PM

Quote:

Originally Posted by NoOne

as long as it saved it in its original format, it shouldn't matter.. notepad++ is defintieyl superiour in many ways. i use it when someone doesn't format an xml or conf file very well... it does it for us :P

the color-coding should help if you missed a > or something. i can't read the error you posted because the forums won't allow it - maybe the file type? these forums are a bit picky about things that really don't matter or easily circumvented anyway and provide no real protection - but does cause inconvenience aplenty.

it sounds like you got somethign custom to work? so, it's probably just something minor you made a mistake on - like formatting.

if it's a subset, then you may just not be inserting it properly (just adding rows to an existing table? new table? somethgn else?)... i've never worked on teh world file, so i am of limited help on specifics for you.

find other examples of somethign similar, open up 2nd notepad and scroll to your edits to compare - best way to figure it out with no one helping... use work that is functioning and compare.

Thanks, I will try this.

Sizeman21 · 01-30-2017, 07:06 PM

Sorry guys, I still can't figure this out. I know for a fact I did not edit the country of Laos.

I have scanned this countless times and don't see any glaring issues. If someone could download my DB and check, it would be greatly appreciated.

Sorry to be such a annoyance, I just don't have the eye for code and I am new to doing this for OOTP.

world_default

Name: Screenshot_1.png
Views: 431
Size: 67.1 KB

Name: Screenshot_1.png
Views: 431
Size: 67.1 KB

robwondah · 01-30-2017, 09:04 PM

Hey Sizeman, I took a look at your xml file.

I'm not at my desktop so, I can't import the xml and give it a test run and I'm not 100% sure that this will solve the issue...

...But I noticed that you have LANGUAGE id="40".

From my understanding you can only replace language and ethnicities and not add more.

I edited your xml so that for the time being Arringtonians have U.S. Modern names.

If you wouldn't mind to run this xml and see if that is the issue.

world_default.zip

If for some reason this is the case, I would replace a language and ethnicity you know that you're not going to use in your world.

Sizeman21 · 01-30-2017, 09:18 PM

Quote:

Originally Posted by robwondah

Hey Sizeman, I took a look at your xml file.

I'm not at my desktop so, I can't import the xml and give it a test run and I'm not 100% sure that this will solve the issue...

...But I noticed that you have LANGUAGE id="40".

From my understanding you can only replace language and ethnicities and not add more.

I edited your xml so that for the time being Arringtonians have U.S. Modern names.

If you wouldn't mind to run this xml and see if that is the issue.

world_default.zip

If for some reason this is the case, I would replace a language and ethnicity you know that you're not going to use in your world.

I got the same error message as above. I think I might just redo my nation. I don't wanna screw around with this too long. Thanks for the help though

Sorry to waste your time.

robwondah · 01-30-2017, 09:20 PM

It's all good man!

NoOne · 01-31-2017, 04:23 AM

start over fresh, if you've been editting the same file over and over again at this point...

more and more likely to cause a problem for yourself. start over, work through the changes you want with the new info you have and see what happens.

mosey over to teh mods section too... maybe somethign is there that relates?

01-29-2017, 08:48 PM	#1
Sizeman21 Major Leagues Join Date: Feb 2016 Location: The bleachers of Sportsman's Park Posts: 435	Database editing help Hello anyone reading, For the past few few weeks, I have been creating a new nation called Arrington. I have just finished adding new cities after successfully seeing the nation work on OOTP. But when I went to check that these latest cities worked, I got a strange error seen below. http://www.ootpdevelopments.com/boar...1&d=1485740490 A friend and I tried to figure out what was wrong, but we could not. I am not good with code and there is too much in the db. Here is the database I am using. If someone could please look and see what I am doing wrong, I would greatly appreciate it. http://www.mediafire.com/file/cdrmum...ld_default.xml Alex

01-29-2017, 09:01 PM	#2
thorpegiovanni All Star Reserve Join Date: Jul 2016 Posts: 550	Did you create the nation through XML, because I have been attempting to do that recently and failing. __________________

01-30-2017, 04:02 PM	#4
NoOne Banned Join Date: Apr 2015 Posts: 7,273 Infractions: 0/1 (3)	as long as it saved it in its original format, it shouldn't matter.. notepad++ is defintieyl superiour in many ways. i use it when someone doesn't format an xml or conf file very well... it does it for us :P the color-coding should help if you missed a > or something. i can't read the error you posted because the forums won't allow it - maybe the file type? these forums are a bit picky about things that really don't matter or easily circumvented anyway and provide no real protection - but does cause inconvenience aplenty. it sounds like you got somethign custom to work? so, it's probably just something minor you made a mistake on - like formatting. if it's a subset, then you may just not be inserting it properly (just adding rows to an existing table? new table? somethgn else?)... i've never worked on teh world file, so i am of limited help on specifics for you. find other examples of somethign similar, open up 2nd notepad and scroll to your edits to compare - best way to figure it out with no one helping... use work that is functioning and compare. Last edited by NoOne; 01-30-2017 at 04:04 PM.

01-30-2017, 07:06 PM	#6
Sizeman21 Major Leagues Join Date: Feb 2016 Location: The bleachers of Sportsman's Park Posts: 435	Sorry guys, I still can't figure this out. I know for a fact I did not edit the country of Laos. I have scanned this countless times and don't see any glaring issues. If someone could download my DB and check, it would be greatly appreciated. Sorry to be such a annoyance, I just don't have the eye for code and I am new to doing this for OOTP. world_default

01-30-2017, 09:04 PM	#7
robwondah Minors (Triple A) Join Date: Oct 2014 Location: Los Angeles, CA Posts: 287	Hey Sizeman, I took a look at your xml file. I'm not at my desktop so, I can't import the xml and give it a test run and I'm not 100% sure that this will solve the issue... ...But I noticed that you have LANGUAGE id="40". From my understanding you can only replace language and ethnicities and not add more. I edited your xml so that for the time being Arringtonians have U.S. Modern names. If you wouldn't mind to run this xml and see if that is the issue. world_default.zip If for some reason this is the case, I would replace a language and ethnicity you know that you're not going to use in your world.

01-30-2017, 09:20 PM	#9
robwondah Minors (Triple A) Join Date: Oct 2014 Location: Los Angeles, CA Posts: 287	It's all good man!

01-31-2017, 04:23 AM	#10
NoOne Banned Join Date: Apr 2015 Posts: 7,273 Infractions: 0/1 (3)	start over fresh, if you've been editting the same file over and over again at this point... more and more likely to cause a problem for yourself. start over, work through the changes you want with the new info you have and see what happens. mosey over to teh mods section too... maybe somethign is there that relates?