Home | Webstore
Latest News: OOTP Update 20.5.47 - OOTP 20 Available - FHM 5 Available

Collection Missions for Perfect Team Released!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 20 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 03-23-2019, 08:46 AM   #1
PoorBoy2001
Bat Boy
 
Join Date: Apr 2010
Posts: 9
Thanks: 1
Thanked 1x in 1 post
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"
PoorBoy2001 is offline   Reply With Quote
Old 03-27-2019, 08:16 AM   #2
cavebutter
All Star Starter
 
cavebutter's Avatar
 
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,045
Thanks: 333
Thanked 561x in 342 posts
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
cavebutter is offline   Reply With Quote
Old 03-27-2019, 04:07 PM   #3
PoorBoy2001
Bat Boy
 
Join Date: Apr 2010
Posts: 9
Thanks: 1
Thanked 1x in 1 post
Thanks! I'll give that a try.
PoorBoy2001 is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 04:54 PM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments