OOTP Developments Forums - View Single Post

dangarion · 11-14-2012, 07:05 PM

Hello,

I'm trying to figuring out why I'm having this error when I attempt to unpack my reports for a MySQL dump. From the looks of it, it appears to be an issue with the way OOTP sets up the MySQL file, but there really is NO documentation on how to correct these types of errors. I also opened a Support ticket back in May and never received a response.

Please wait...
Command: tar xzf '/xxxxxx/your-league/reports/reports.tar.gz' 2>&1:
Successfully unpacked the reports.tar.gz file...

Opened reports file reports_1.txt...{query} Database Error : 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-reports WHERE (type="b" AND name="league_100_home")' at line 1 : SELECT id FROM pcjbl-reports WHERE (type="b" AND name="league_100_home")

11-14-2012, 07:05 PM	#1
dangarion All Star Reserve Join Date: Feb 2003 Location: Orange, CA Posts: 569	Unpack Reports Error Hello, I'm trying to figuring out why I'm having this error when I attempt to unpack my reports for a MySQL dump. From the looks of it, it appears to be an issue with the way OOTP sets up the MySQL file, but there really is NO documentation on how to correct these types of errors. I also opened a Support ticket back in May and never received a response. Please wait... Command: tar xzf '/xxxxxx/your-league/reports/reports.tar.gz' 2>&1: Successfully unpacked the reports.tar.gz file... Opened reports file reports_1.txt...{query} Database Error : 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-reports WHERE (type="b" AND name="league_100_home")' at line 1 : SELECT id FROM pcjbl-reports WHERE (type="b" AND name="league_100_home") __________________ DanGarion GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League PCJBL! Last edited by dangarion; 11-14-2012 at 07:06 PM.