So...I have worked with thompsw8 to try and get the reports working in the past hour and this is the result:
Code:
Please wait...
Command: tar xzf '/home2/waynet2010/public_html/league_reports/reports.tar.gz' 2>&1:
Successfully unpacked the reports.tar.gz file...
Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home2/waynet2010/public_html/league_reports/unpackreports.php on line 64
Successfully touched table waynet20_sblreports
Successfully touched table waynet20_sblreports_content_a
Successfully touched table waynet20_sblreports_content_b
Successfully touched table waynet20_sblreports_content_c
Successfully touched table waynet20_sblreports_content_d
Successfully touched table waynet20_sblreports_content_e
Successfully touched table waynet20_sblreports_content_f
Successfully touched table waynet20_sblreports_content_g
Successfully touched table waynet20_sblreports_content_h
Successfully touched table waynet20_sblreports_content_i
Successfully touched table waynet20_sblreports_content_j
Successfully touched table waynet20_sblreports_content_k
Successfully touched table waynet20_sblreports_content_l
Successfully touched table waynet20_sblreports_content_m
Successfully touched table waynet20_sblreports_content_n
Successfully touched table waynet20_sblreports_content_o
Successfully touched table waynet20_sblreports_content_p
Successfully touched table waynet20_sblreports_content_q
Successfully touched table waynet20_sblreports_content_r
Successfully touched table waynet20_sblreports_content_s
Successfully touched table waynet20_sblreports_content_t
Successfully touched table waynet20_sblreports_content_u
Successfully touched table waynet20_sblreports_content_v
Successfully touched table waynet20_sblreports_content_w
Successfully touched table waynet20_sblreports_content_x
Successfully touched table waynet20_sblreports_content_y
Successfully touched table waynet20_sblreports_content_z
Opened reports file reports_1.txt...{query} Database Error : 1054 : Unknown column 'md5hash' in 'field list' : SELECT id, md5hash FROM waynet20_sblreports WHERE (type="b" AND name="league_100_home") LIMIT 1
The unpackreports.php script is using a deprecated function that needs to be replaced. This is why the database reports might not be working on some servers.
Quote:
|
Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home2/waynet2010/public_html/league_reports/unpackreports.php on line 64
|
We made sure that all the server scripts were updated and that the FTP info was directed to the proper place. Seems like the problem is not with the FTP options, but a miscommunication with the database. All the text files are unpacked, but nothing happens when the script is supposed to be sending the reports to the database.
We tried running the script with php 5.5 and 5.6 on the server with the same result each time.
I have a friend who works with php as his job and this is what he had to say about the script error for mysqlconnect():
Quote:
PHP functions are being worked on all time time. eventually the developers come up with newer functions that work better than the older ones and the old ones become deprecated so unneeded... eventually these unneeded functions with a PHP upgrade will just be eliminated and not able to be used anymore.
the mysql_connect function is one of those functions. Its an old function that they have deemed to be unneeded and old. There are other ways to connect to mysql databases one being making database objects called mysqli
|
So, not to be a killjoy, but even the updated script is deprecated and would need to be rewritten to be "up to date" with today's MySQL standards.
This is the info from php.net
http://php.net/manual/en/function.mysql-connect.php
Hopefully this is something that will be looked at as it may cause headaches to a lot more than a handful of Commishes in the OOTP community...