PHP Notice : statsapi.php

Project:RUcore Statistics
Version:7.6
Component:Code
Category:bug report
Priority:normal
Assigned:chadmills
Status:closed
Description

Found in PHP_error log

[05-May-2015 11:14:50 America/New_York] PHP Notice: Undefined variable: sql in /home/httpd/html/rucore/api/stats/statsapi.php on line 705

Comments

#1

Assigned to:jgeng» chadmills
Status:active» test

Please test.

#2

Assigned to:chadmills» jgeng
Status:test» active

Still found in the log.

[07-May-2015 10:39:37 America/New_York] PHP Notice: Undefined variable: sql in /home/httpd/html/rucore/api/stats/statsapi.php on line 705

From the Apache access log this request looks to be causing the problem.

<a href="https://rucore-test.libraries.rutgers.edu/api/stats/top10downloads/?key=statsreport&amp;portalid=soar&amp;end_date=2015-05-07" title="https://rucore-test.libraries.rutgers.edu/api/stats/top10downloads/?key=statsreport&amp;portalid=soar&amp;end_date=2015-05-07">https://rucore-test.libraries.rutgers.edu/api/stats/top10downloads/?key=...</a>

#3

Assigned to:jgeng» chadmills
Status:active» test

please test.

#4

Assigned to:chadmills» jgeng
Status:test» active

No error but now when I visit the top10downloads method the following is outputted.

URL: <a href="https://rucore-test.libraries.rutgers.edu/api/stats/top10downloads/?key=statsreport&amp;portalid=soar&amp;end_date=2015-05-07" title="https://rucore-test.libraries.rutgers.edu/api/stats/top10downloads/?key=statsreport&amp;portalid=soar&amp;end_date=2015-05-07">https://rucore-test.libraries.rutgers.edu/api/stats/top10downloads/?key=...</a>

Output :

Error loading XML
Opening and ending tag mismatch: p line 6 and body
Opening and ending tag mismatch: body line 5 and html
Premature end of data in tag html line 1
Query failed: 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 ')' at line 1<br />

#5

Assigned to:jgeng» chadmills
Status:active» test

Fixed.

#6

Status:test» fixed

Ran method, no errors in log.

#7

Status:fixed» closed

Back to top