|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
|
Thread Tools |
03-23-2019, 08:46 AM | #1 |
Minors (Rookie Ball)
Join Date: Apr 2010
Posts: 22
|
OOTP20 SQL Export - Format Change?
Are there any (undocumented) changes to the SQL exports in the new OOTP20?
This error message is popping up on roster pages for our league: "Could not run query: Column 'Position' in field list is ambiguous" |
03-27-2019, 08:16 AM | #2 |
All Star Starter
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,158
|
I only noticed a couple of small changes to the tables I use, none of them to do with position.
However, the error you describe should be fairly easy to fix if you have access to the query that’s being run. You should just need to re-write the query with that column as table.column rather than just column. Sent from my iPhone using Tapatalk
__________________
MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP Logo Gallery |
03-27-2019, 04:07 PM | #3 |
Minors (Rookie Ball)
Join Date: Apr 2010
Posts: 22
|
Thanks! I'll give that a try.
|
Bookmarks |
Thread Tools | |
|
|