Last 7 days

• Dec 10, 2009

  issue 5 (limited number of users) commented on by dtk.johnson   -   Any idea how many users you had/have?

  Any idea how many users you had/have?
• Dec 10, 2009

  issue 9 (False SQL query in ByInitials.php report) commented on by dtk.johnson   -   I've attached a patch file with this change, since I don't have commit access to the trunk.

  I've attached a patch file with this change, since I don't have commit access to the trunk.

Last 30 days

• Dec 01, 2009

  issue 10 (Help pop-up contents) reported by valintrusa   -   What steps will reproduce the problem? 1.Click on Report page link at bottom, labeled "Import Data to Excel" or on Add Question Page link labeled "Backdate" What is the expected output? What do you see instead? I expect the resulting pop-up window to have content, rather than the empty window. For example, the Wisconsin version of this popup http://www.wendt.wisc.edu/projects/libstats-demo/help.do?advice=6 has content while the original zip download file does not. I only see that the first three cases (help_id) are accounted for on the content/admin/help.php file. Does this mean that we have to hard-code content in there for help_id values 4-6? Not very helpful for non-programmers... What version of the product are you using? On what operating system? 1.0.6 Windows Please provide any additional information below. if you have an answer as to how to address this in order to fill the pop-ups with helpful content, please email me at mayz@nova.edu. Thanks!

  What steps will reproduce the problem? 1.Click on Report page link at bottom, labeled "Import Data to Excel" or on Add Question Page link labeled "Backdate" What is the expected output? What do you see instead? I expect the resulting pop-up window to have content, rather than the empty window. For example, the Wisconsin version of this popup http://www.wendt.wisc.edu/projects/libstats-demo/help.do?advice=6 has content while the original zip download file does not. I only see that the first three cases (help_id) are accounted for on the content/admin/help.php file. Does this mean that we have to hard-code content in there for help_id values 4-6? Not very helpful for non-programmers... What version of the product are you using? On what operating system? 1.0.6 Windows Please provide any additional information below. if you have an answer as to how to address this in order to fill the pop-ups with helpful content, please email me at mayz@nova.edu. Thanks!

Earlier this year

• Nov 12, 2009

  issue 9 (False SQL query in ByInitials.php report) reported by jedij...@gmail.com   -   What steps will reproduce the problem? 1. Run the current commit of the ByInitials report 2. Report return will only list "In-Person" rather than all question format types What is the expected output? What do you see instead? All of the question format types for each initial should display in the report What version of the product are you using? On what operating system? 1.0.6 Please provide any additional information below. The sql query need to be changed... Line 36: GROUP BY initials, questions.time_spent_id Should be: GROUP BY initials, questions.question_format_id

  What steps will reproduce the problem? 1. Run the current commit of the ByInitials report 2. Report return will only list "In-Person" rather than all question format types What is the expected output? What do you see instead? All of the question format types for each initial should display in the report What version of the product are you using? On what operating system? 1.0.6 Please provide any additional information below. The sql query need to be changed... Line 36: GROUP BY initials, questions.time_spent_id Should be: GROUP BY initials, questions.question_format_id
• Nov 05, 2009

  Reports_for_1_0_6 (Info for Reports 1.0.6.) Wiki page edited by erinlovestechno   -   Revision r64 Edited wiki page through web user interface.

  Revision r64 Edited wiki page through web user interface.
• Nov 05, 2009

  Help_With_Reports (Info for Reports 1.0.5.) Wiki page edited by erinlovestechno   -   Revision r63 Updated to state it's for 1.0.5.

  Revision r63 Updated to state it's for 1.0.5.
• Nov 04, 2009

  Reports_for_1_0_6 (Info for Reports 1.0.6.) Wiki page added by erinlovestechno   -   Revision r62 This is an explanation of reports for 1.0.6.

  Revision r62 This is an explanation of reports for 1.0.6.
• Oct 27, 2009

  r61 (Modifications were made to allow for an individual report to...) committed by erinlovestechno   -   Modifications were made to allow for an individual report to be exported into a CSV file so it could be imported into a spreadsheet- e.i. Excel

  Modifications were made to allow for an individual report to be exported into a CSV file so it could be imported into a spreadsheet- e.i. Excel
• Oct 27, 2009

  r60 (Changed reports, more specifically the array returned in per...) committed by erinlovestechno   -   Changed reports, more specifically the array returned in perform() and the array looped in display()

  Changed reports, more specifically the array returned in perform() and the array looped in display()
• Oct 05, 2009

  issue 8 (Problems with AddField code) reported by pkit...@mtsac.edu   -   What steps will reproduce the problem? 1. following (nearly) exactly http://code.google.com/p/libstats/wiki/AddField 2. modifying this with new field/column name: # Modify QuestionEditForm.php similar to the above * LINES 55-64 <div class = "inputBox"> <h5>Time Spent</h5> <?php echo( $optionFunction( 'timeSpent', $rInfo['timeSpentOpts'], 'time_spent_id', 'time_spent', $rInfo['question']['time_spent_id'], 5) ); ?> </div> 3. I get either errors (I'll list them in a moment, or I get the libstats to 'sort of work' with the new field giving errors What is the expected output? What do you see instead? in attached file What version of the product are you using? On what operating system? 1,0.6 - red hat linux, enterprise version, I believe Please provide any additional information below. attached in file A note: In the Wiki where it indicates adding the material in the admin table, I have to browse that table to find the (in my case) timeframe_types etc. Paul

  What steps will reproduce the problem? 1. following (nearly) exactly http://code.google.com/p/libstats/wiki/AddField 2. modifying this with new field/column name: # Modify QuestionEditForm.php similar to the above * LINES 55-64 <div class = "inputBox"> <h5>Time Spent</h5> <?php echo( $optionFunction( 'timeSpent', $rInfo['timeSpentOpts'], 'time_spent_id', 'time_spent', $rInfo['question']['time_spent_id'], 5) ); ?> </div> 3. I get either errors (I'll list them in a moment, or I get the libstats to 'sort of work' with the new field giving errors What is the expected output? What do you see instead? in attached file What version of the product are you using? On what operating system? 1,0.6 - red hat linux, enterprise version, I believe Please provide any additional information below. attached in file A note: In the Wiki where it indicates adding the material in the admin table, I have to browse that table to find the (in my case) timeframe_types etc. Paul
• Oct 03, 2009

  r59 (Fixed ByInitials.php per Heidi Senior post. Created new ByTi...) committed by erinlovestechno   -   Fixed ByInitials.php per Heidi Senior post. Created new ByTimeType.php report per jedijoel's post

  Fixed ByInitials.php per Heidi Senior post. Created new ByTimeType.php report per jedijoel's post
• Oct 03, 2009

  r58 (Fixed the login blank screen per Al Morita's fix; corrected ...) committed by erinlovestechno   -   Fixed the login blank screen per Al Morita's fix; corrected error in libstats.mysql.

  Fixed the login blank screen per Al Morita's fix; corrected error in libstats.mysql.
• Sep 29, 2009

  Help_With_Reports (Brief guide for providing tips and assistance for creating n...) Wiki page commented on by jedij...@gmail.com   -   =Questions by Question Type and Time Spent Report= The following is a modification of the ByInitials report. This new report gives a breakdown of the time spent on each question type. You have to add an average time to the description field of the time_spent_options table in the Libstats DB for the "Approximate Time Spent" calculations to work. The following code should be pasted into a file called ByTypeTime.php and placed in the Reports folder: {{{ <?php class ByTypeTime extends Report { /** * store report information: name of report and description of report * @return : an array containing info on the report */ function info() { $report_info["name"] = "Questions By Type - Question Time"; $report_info["desc"] = "This report will provide individual statistics based on the question type recorded and the average time spent."; return ($report_info); } /** * the SQL query/statement for the report * @param = sql : the WHERE clause clauses * @param = param : parameters from the form * @return : result of perform the SQL query */ function perform($sql, $param) { // don't lose the db! $db = $_REQUEST['db']; $this->db = $db; // gather $result $fullQuery = <<<QUERYSTRING SELECT COUNT(questions.question) as questions_count, questions.question_type_id, question_types.question_type, questions.time_spent_id, time_spent_options.time_spent, time_spent_options.description FROM questions JOIN time_spent_options ON (questions.time_spent_id = time_spent_options.time_spent_id) JOIN question_types ON (questions.question_type_id = question_types.question_type_id) $sql GROUP BY questions.question_type_id, questions.time_spent_id QUERYSTRING; $result = $this->db->getAll($fullQuery, $param); return $result; } /** * display the results of the report * @param = rInfo : a multi-dimensional array pertaining to the report, including results */ function display($rInfo) { echo "<h3>{$rInfo['library_name']}"; if (isset($rInfo['location_name'])){ echo " > location: {$rInfo['location_name']}"; } if(isset($rInfo['question_type'])){ echo " > question type: {$rInfo['question_type']}"; } if(isset($rInfo['patron_type'])){ echo " > patron type: {$rInfo['patron_type']}"; } if(isset($rInfo['question_format'])){ echo " > question format: {$rInfo['question_format']}"; } echo "</h3><h3>{$rInfo['reportList']['name']} from {$rInfo['date1']} through {$rInfo['date2']}- Full Report</h3>"; foreach ($rInfo['reportResults'] as $report) { $questiontypes[$report["question_type"]][$report["time_spent_id"]] = $report["questions_count"]; @$questiontypes[$report["question_type"]]["count"] += $report["questions_count"]; $spent[$report["time_spent_id"]]["spent"] = $report["time_spent"]; $spent[$report["time_spent_id"]]["val"] = $report["description"]; } // make my report table header... echo '<table id= "questionTable"> <tr> <th>Question Type</th> <th>Time Spent</th> <th>Time Spent Count</th> <th>Approximate Time Spent</th> </tr> <tr><td colspan=4></td></tr> <tbody> '; // get my report table data... $arrayIndex = 0; $count = array(); $percentage = array(); foreach ($questiontypes as $index => $questiontype) { echo "<th colspan=4 align=left>$index</th>"; foreach ($spent as $time_index => $time) { echo "<tr><td></td> <td>{$time['spent']}</td> <td>" . @$questiontype[$time_index] . "</td> <td>" . $time["val"] * @$questiontype[$time_index] . "</td> <td></td></tr>"; @$count_total += $questiontype[$time_index]; @$time_total += $questiontype[$time_index] * $time["val"]; @$count_grand += $questiontype[$time_index]; @$time_grand += $questiontype[$time_index] * $time["val"]; } echo "<tr><td></td><td align=right>Totals</td> <td>$count_total</td> <td>$time_total</td> </tr> <tr><td colspan=4></td></tr> "; unset($count_total); unset($time_total); } echo '</tbody>'; // total report summary $questionSum = array_sum($count); $questionPercentage = array_sum($percentage); echo "<tr><td></td><td><strong>Grand Totals</strong></td><td><strong>$count_grand</strong></td>" . "<td><strong>$time_grand</strong></td></tr></table>"; } /** * still unclear why this is here; inherited from previous method of reporting * @return : true */ function isAuthenticationRequired() { return true; } } ?> }}}

  =Questions by Question Type and Time Spent Report= The following is a modification of the ByInitials report. This new report gives a breakdown of the time spent on each question type. You have to add an average time to the description field of the time_spent_options table in the Libstats DB for the "Approximate Time Spent" calculations to work. The following code should be pasted into a file called ByTypeTime.php and placed in the Reports folder: {{{ <?php class ByTypeTime extends Report { /** * store report information: name of report and description of report * @return : an array containing info on the report */ function info() { $report_info["name"] = "Questions By Type - Question Time"; $report_info["desc"] = "This report will provide individual statistics based on the question type recorded and the average time spent."; return ($report_info); } /** * the SQL query/statement for the report * @param = sql : the WHERE clause clauses * @param = param : parameters from the form * @return : result of perform the SQL query */ function perform($sql, $param) { // don't lose the db! $db = $_REQUEST['db']; $this->db = $db; // gather $result $fullQuery = <<<QUERYSTRING SELECT COUNT(questions.question) as questions_count, questions.question_type_id, question_types.question_type, questions.time_spent_id, time_spent_options.time_spent, time_spent_options.description FROM questions JOIN time_spent_options ON (questions.time_spent_id = time_spent_options.time_spent_id) JOIN question_types ON (questions.question_type_id = question_types.question_type_id) $sql GROUP BY questions.question_type_id, questions.time_spent_id QUERYSTRING; $result = $this->db->getAll($fullQuery, $param); return $result; } /** * display the results of the report * @param = rInfo : a multi-dimensional array pertaining to the report, including results */ function display($rInfo) { echo "<h3>{$rInfo['library_name']}"; if (isset($rInfo['location_name'])){ echo " > location: {$rInfo['location_name']}"; } if(isset($rInfo['question_type'])){ echo " > question type: {$rInfo['question_type']}"; } if(isset($rInfo['patron_type'])){ echo " > patron type: {$rInfo['patron_type']}"; } if(isset($rInfo['question_format'])){ echo " > question format: {$rInfo['question_format']}"; } echo "</h3><h3>{$rInfo['reportList']['name']} from {$rInfo['date1']} through {$rInfo['date2']}- Full Report</h3>"; foreach ($rInfo['reportResults'] as $report) { $questiontypes[$report["question_type"]][$report["time_spent_id"]] = $report["questions_count"]; @$questiontypes[$report["question_type"]]["count"] += $report["questions_count"]; $spent[$report["time_spent_id"]]["spent"] = $report["time_spent"]; $spent[$report["time_spent_id"]]["val"] = $report["description"]; } // make my report table header... echo '<table id= "questionTable"> <tr> <th>Question Type</th> <th>Time Spent</th> <th>Time Spent Count</th> <th>Approximate Time Spent</th> </tr> <tr><td colspan=4></td></tr> <tbody> '; // get my report table data... $arrayIndex = 0; $count = array(); $percentage = array(); foreach ($questiontypes as $index => $questiontype) { echo "<th colspan=4 align=left>$index</th>"; foreach ($spent as $time_index => $time) { echo "<tr><td></td> <td>{$time['spent']}</td> <td>" . @$questiontype[$time_index] . "</td> <td>" . $time["val"] * @$questiontype[$time_index] . "</td> <td></td></tr>"; @$count_total += $questiontype[$time_index]; @$time_total += $questiontype[$time_index] * $time["val"]; @$count_grand += $questiontype[$time_index]; @$time_grand += $questiontype[$time_index] * $time["val"]; } echo "<tr><td></td><td align=right>Totals</td> <td>$count_total</td> <td>$time_total</td> </tr> <tr><td colspan=4></td></tr> "; unset($count_total); unset($time_total); } echo '</tbody>'; // total report summary $questionSum = array_sum($count); $questionPercentage = array_sum($percentage); echo "<tr><td></td><td><strong>Grand Totals</strong></td><td><strong>$count_grand</strong></td>" . "<td><strong>$time_grand</strong></td></tr></table>"; } /** * still unclear why this is here; inherited from previous method of reporting * @return : true */ function isAuthenticationRequired() { return true; } } ?> }}}
• Sep 14, 2009

  issue 7 (Change time zone in timestamp) reported by britainw   -   What steps will reproduce the problem? 1. Add a question 2. Timestamp is server's clock. What is the expected output? What do you see instead? We are probably a special case -- our server lives in a different timezone. We would like to adjust the time stamps to reflect our time zone. What version of the product are you using? On what operating system? libstats 1.0.6 on Apache 2.2.11/PHP 5.2.9

  What steps will reproduce the problem? 1. Add a question 2. Timestamp is server's clock. What is the expected output? What do you see instead? We are probably a special case -- our server lives in a different timezone. We would like to adjust the time stamps to reflect our time zone. What version of the product are you using? On what operating system? libstats 1.0.6 on Apache 2.2.11/PHP 5.2.9
• Jul 14, 2009

  Help_With_Reports (Brief guide for providing tips and assistance for creating n...) Wiki page commented on by jedijoel   -   =Replacement of steps 2 and 3= Insert the following code into the file reports/QuestionByQuestionType.php The name, description, and report info have been moved from the reports table to the report file. Between the class definition and the sql preform function insert the info code {{{ function info() { $report_info["name"] = "Questions by Question Type"; $report_info["desc"] = "This report provides the count of questions for every question type."; return ($report_info); } }}} Together it should look like this: {{{ // Then again, subclasses aren't that much better... function info() { $report_info["name"] = "Questions by Question Type"; $report_info["desc"] = "This report provides the count of questions for every question type."; return ($report_info); } function perform($sql, $param) { }}} The display info has also moved from reportReturn.php to the report file itself, again in the reports/QuestionByQuestionType.php file insert the following code for the display information. Notice the authentication has simply moved to the end and should not occur twice the report file. {{{ /** * display the results of the report * @param = rInfo : a multi-dimensional array pertaining to the report, including results */ function display($rInfo) { #echo "<h3>rInfo</h3><pre>"; print_r($rInfo); echo "</pre>"; echo "<h3>{$rInfo['library_name']}"; if(isset($rInfo['location_name'])){ echo " | {$rInfo['location_name']}"; } // format the start and end dates $dateStart = (date('Ymd',strtotime($rInfo['date1']))); $dateEnd = (date('Ymd',strtotime($rInfo['date2']))); echo "</h3><h3>{$rInfo['reportList']['name']} from $dateStart through $dateEnd- Full Report</h3>"; // ^^ the above is a standard header ^^ // make my report table header... echo '<table id= "questionTable"> <tr> <th>Question Type</th> <th>Question Count</th> <th>Percentage</th> </tr>'; // get my report table data... $arrayIndex = 0; $count = array(); $percentage = array(); $numberReportQuestionCount = $rInfo['reportQuestionCount'] + 0; echo '<tbody>'; //loop through to display and calculate results foreach ($rInfo["reportResults"] as $report) { echo "<tr> <td>{$report['question_type']}</td> <td>" . ($report["questions"] + 0) . "</td> <td>" . round(((($report["questions"] + 0) / $numberReportQuestionCount)*100), 1) . "%</td></tr>"; $arrayIndex++; $count[$arrayIndex] = $report["questions"]; $percentage[$arrayIndex] = round(((($report["questions"] + 0) / $numberReportQuestionCount)*100), 1); } echo '</tbody>'; // total report summary $questionSum = array_sum($count); $questionPercentage = array_sum($percentage); echo "<tr><td><strong>Totals</strong></td><td><strong>$questionSum </strong></td>" . "<td><strong>$questionPercentage%</strong></td></tr></table>"; } function isAuthenticationRequired() { return true; } } ?> }}}

  =Replacement of steps 2 and 3= Insert the following code into the file reports/QuestionByQuestionType.php The name, description, and report info have been moved from the reports table to the report file. Between the class definition and the sql preform function insert the info code {{{ function info() { $report_info["name"] = "Questions by Question Type"; $report_info["desc"] = "This report provides the count of questions for every question type."; return ($report_info); } }}} Together it should look like this: {{{ // Then again, subclasses aren't that much better... function info() { $report_info["name"] = "Questions by Question Type"; $report_info["desc"] = "This report provides the count of questions for every question type."; return ($report_info); } function perform($sql, $param) { }}} The display info has also moved from reportReturn.php to the report file itself, again in the reports/QuestionByQuestionType.php file insert the following code for the display information. Notice the authentication has simply moved to the end and should not occur twice the report file. {{{ /** * display the results of the report * @param = rInfo : a multi-dimensional array pertaining to the report, including results */ function display($rInfo) { #echo "<h3>rInfo</h3><pre>"; print_r($rInfo); echo "</pre>"; echo "<h3>{$rInfo['library_name']}"; if(isset($rInfo['location_name'])){ echo " | {$rInfo['location_name']}"; } // format the start and end dates $dateStart = (date('Ymd',strtotime($rInfo['date1']))); $dateEnd = (date('Ymd',strtotime($rInfo['date2']))); echo "</h3><h3>{$rInfo['reportList']['name']} from $dateStart through $dateEnd- Full Report</h3>"; // ^^ the above is a standard header ^^ // make my report table header... echo '<table id= "questionTable"> <tr> <th>Question Type</th> <th>Question Count</th> <th>Percentage</th> </tr>'; // get my report table data... $arrayIndex = 0; $count = array(); $percentage = array(); $numberReportQuestionCount = $rInfo['reportQuestionCount'] + 0; echo '<tbody>'; //loop through to display and calculate results foreach ($rInfo["reportResults"] as $report) { echo "<tr> <td>{$report['question_type']}</td> <td>" . ($report["questions"] + 0) . "</td> <td>" . round(((($report["questions"] + 0) / $numberReportQuestionCount)*100), 1) . "%</td></tr>"; $arrayIndex++; $count[$arrayIndex] = $report["questions"]; $percentage[$arrayIndex] = round(((($report["questions"] + 0) / $numberReportQuestionCount)*100), 1); } echo '</tbody>'; // total report summary $questionSum = array_sum($count); $questionPercentage = array_sum($percentage); echo "<tr><td><strong>Totals</strong></td><td><strong>$questionSum </strong></td>" . "<td><strong>$questionPercentage%</strong></td></tr></table>"; } function isAuthenticationRequired() { return true; } } ?> }}}
• Jul 14, 2009

  Help_With_Reports (Brief guide for providing tips and assistance for creating n...) Wiki page commented on by jedijoel   -   With the 1.0.6 version there is no reports table in the database. I believe this wiki can be reduced to one step with the report code and the report display all in one php file titled after the report. Am I correct in this?

  With the 1.0.6 version there is no reports table in the database. I believe this wiki can be reduced to one step with the report code and the report display all in one php file titled after the report. Am I correct in this?
• Jul 10, 2009

  AddField (These modification will add an additional input field to you...) Wiki page edited by steven.d.shelton
• Jul 10, 2009

  AddField (These modification will add an additional input field to you...) Wiki page edited by steven.d.shelton
• Jul 10, 2009

  AddField (These modification will add an additional input field to you...) Wiki page edited by steven.d.shelton
• Jul 10, 2009

  AddField (These modification will add an additional input field to you...) Wiki page edited by steven.d.shelton
• Jul 10, 2009

  issue 6 (Problems with READ types modifications) commented on by cgrimland   -   Problem solved. MySQL doesn't like "reads" as the JOIN alias. I changed it to "readtypes" and it all works. So, line 27 should look something like this: $fullQuery = "SELECT COUNT(questions.question) as questions, read_types.read_type as readtypes FROM questions JOIN read_types ON (questions.read_type_id = read_types.read_type_id) $sql GROUP BY readtypes"; And line 74 should be changed to match: <td>{$report["readtypes"]}</td>

  Problem solved. MySQL doesn't like "reads" as the JOIN alias. I changed it to "readtypes" and it all works. So, line 27 should look something like this: $fullQuery = "SELECT COUNT(questions.question) as questions, read_types.read_type as readtypes FROM questions JOIN read_types ON (questions.read_type_id = read_types.read_type_id) $sql GROUP BY readtypes"; And line 74 should be changed to match: <td>{$report["readtypes"]}</td>
• Jul 10, 2009

  issue 6 (Problems with READ types modifications) commented on by cgrimland   -   Using the mysql client, if I execute the "SELECT COUNT..." query (minus the WHERE clause) on the patron_types table, I get results. If I execute the same query with all instances of "patron" changed to "read", I get a syntax error. I must have made a mistake somewhere else, but I can't seem to track it down. mysql> select count(questions.question) as questions, patron_types.patron_type as patrons from questions join patron_types on (questions.patron_type_id = patron_types.patron_type_id) group by patrons; +-----------+---------------------+ | questions | patrons | +-----------+---------------------+ | 2144 | Community | | 1179 | Faculty/Staff | | 2450 | Student - Graduate | | 23193 | Student - Undergrad | | 1421 | Unknown | +-----------+---------------------+ 5 rows in set (0.14 sec) mysql> select count(questions.question) as questions, read_types.read_type as reads from questions join read_types on (questions.read_type_id = read_types.read_type_id) group by reads; ERROR 1064 (42000): 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 'reads from questions join read_types on (questions.read_type_id = read_types.rea' at line 1 mysql>

  Using the mysql client, if I execute the "SELECT COUNT..." query (minus the WHERE clause) on the patron_types table, I get results. If I execute the same query with all instances of "patron" changed to "read", I get a syntax error. I must have made a mistake somewhere else, but I can't seem to track it down. mysql> select count(questions.question) as questions, patron_types.patron_type as patrons from questions join patron_types on (questions.patron_type_id = patron_types.patron_type_id) group by patrons; +-----------+---------------------+ | questions | patrons | +-----------+---------------------+ | 2144 | Community | | 1179 | Faculty/Staff | | 2450 | Student - Graduate | | 23193 | Student - Undergrad | | 1421 | Unknown | +-----------+---------------------+ 5 rows in set (0.14 sec) mysql> select count(questions.question) as questions, read_types.read_type as reads from questions join read_types on (questions.read_type_id = read_types.read_type_id) group by reads; ERROR 1064 (42000): 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 'reads from questions join read_types on (questions.read_type_id = read_types.rea' at line 1 mysql>
• Jul 10, 2009

  issue 6 (Problems with READ types modifications) commented on by cgrimland   -   Using the mysql client, if I execute they "SELECT COUNT..." query (minus the where clause) on the patron_types table, I get results. f I execute the same query with all instances of "patron" changed to "read", I get a syntax error. I must have made a mistake somewhere else, but I can't seem to track it down. mysql> select count(questions.question) as questions, patron_types.patron_type as patrons from questions join patron_types on (questions.patron_type_id = patron_types.patron_type_id) group by patrons; +-----------+---------------------+ | questions | patrons | +-----------+---------------------+ | 2144 | Community | | 1179 | Faculty/Staff | | 2450 | Student - Graduate | | 23193 | Student - Undergrad | | 1421 | Unknown | +-----------+---------------------+ 5 rows in set (0.14 sec) mysql> select count(questions.question) as questions, read_types.read_type as reads from questions join read_types on (questions.read_type_id = read_types.read_type_id) group by reads; ERROR 1064 (42000): 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 'reads from questions join read_types on (questions.read_type_id = read_types.rea' at line 1 mysql>

  Using the mysql client, if I execute they "SELECT COUNT..." query (minus the where clause) on the patron_types table, I get results. f I execute the same query with all instances of "patron" changed to "read", I get a syntax error. I must have made a mistake somewhere else, but I can't seem to track it down. mysql> select count(questions.question) as questions, patron_types.patron_type as patrons from questions join patron_types on (questions.patron_type_id = patron_types.patron_type_id) group by patrons; +-----------+---------------------+ | questions | patrons | +-----------+---------------------+ | 2144 | Community | | 1179 | Faculty/Staff | | 2450 | Student - Graduate | | 23193 | Student - Undergrad | | 1421 | Unknown | +-----------+---------------------+ 5 rows in set (0.14 sec) mysql> select count(questions.question) as questions, read_types.read_type as reads from questions join read_types on (questions.read_type_id = read_types.read_type_id) group by reads; ERROR 1064 (42000): 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 'reads from questions join read_types on (questions.read_type_id = read_types.rea' at line 1 mysql>
• Jul 10, 2009

  issue 6 (Problems with READ types modifications) commented on by cgrimland   -   Using the mysql client, if I execute they "SELECT COUNT..." query (minus the where clause) on the patron_types table, I get results. f I execute the same query with all instances of "patron" changed to "read", I get a syntax error. I must have made a mistake somewhere else, but I can't seem to track it down. mysql> select count(questions.question) as questions, patron_types.patron_type as patrons from questions join patron_types on (questions.patron_type_id = patron_types.patron_type_id) group by patrons; +-----------+---------------------+ | questions | patrons | +-----------+---------------------+ | 2144 | Community | | 1179 | Faculty/Staff | | 2450 | Student - Graduate | | 23192 | Student - Undergrad | | 1421 | Unknown | +-----------+---------------------+ 5 rows in set (0.14 sec) mysql> select count(questions.question) as questions, read_types.read_type as reads from questions join read_types on (questions.read_type_id = read_types.patron_type_id) group by reads; ERROR 1064 (42000): 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 'reads from questions join read_types on (questions.read_type_id = read_types.pat' at line 1 mysql>

  Using the mysql client, if I execute they "SELECT COUNT..." query (minus the where clause) on the patron_types table, I get results. f I execute the same query with all instances of "patron" changed to "read", I get a syntax error. I must have made a mistake somewhere else, but I can't seem to track it down. mysql> select count(questions.question) as questions, patron_types.patron_type as patrons from questions join patron_types on (questions.patron_type_id = patron_types.patron_type_id) group by patrons; +-----------+---------------------+ | questions | patrons | +-----------+---------------------+ | 2144 | Community | | 1179 | Faculty/Staff | | 2450 | Student - Graduate | | 23192 | Student - Undergrad | | 1421 | Unknown | +-----------+---------------------+ 5 rows in set (0.14 sec) mysql> select count(questions.question) as questions, read_types.read_type as reads from questions join read_types on (questions.read_type_id = read_types.patron_type_id) group by reads; ERROR 1064 (42000): 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 'reads from questions join read_types on (questions.read_type_id = read_types.pat' at line 1 mysql>
• Jul 09, 2009

  Help_With_Reports (Brief guide for providing tips and assistance for creating n...) Wiki page commented on by holt9106   -   Stupid question. What is the "reports" database?

  Stupid question. What is the "reports" database?
• Jul 09, 2009

  issue 6 (Problems with READ types modifications) reported by cgrimland   -   What steps will reproduce the problem? 1. I followed the steps at http://code.google.com/p/libstats/wiki/AddField What is the expected output? What do you see instead? The "Questions By READ Type" report doesn't work. By uncommenting the debugging statement around line 44 of reports/ByReadType.php (see the full output in the attached file), I see that MySQL is reporting a syntax error with the "SELECT COUNT..." query, but I can't find anything wrong with the query. It certainly doesn't appear to be any different than the query executed by ByPatronType.php. What version of the product are you using? On what operating system? 1.0.6 on RHEL5 Please provide any additional information below.

  What steps will reproduce the problem? 1. I followed the steps at http://code.google.com/p/libstats/wiki/AddField What is the expected output? What do you see instead? The "Questions By READ Type" report doesn't work. By uncommenting the debugging statement around line 44 of reports/ByReadType.php (see the full output in the attached file), I see that MySQL is reporting a syntax error with the "SELECT COUNT..." query, but I can't find anything wrong with the query. It certainly doesn't appear to be any different than the query executed by ByPatronType.php. What version of the product are you using? On what operating system? 1.0.6 on RHEL5 Please provide any additional information below.
• Jun 09, 2009

  AddField (These modification will add an additional input field to you...) Wiki page edited by steven.d.shelton
• Jun 09, 2009

  AddField (These modification will add an additional input field to you...) Wiki page edited by steven.d.shelton
• Jun 09, 2009

  AddField Wiki page added by steven.d.shelton
• May 29, 2009

  issue 5 (limited number of users) reported by jean.ferguson   -   What steps will reproduce the problem? 1. we seemed to have created the limit on the number of users. 2. 3. What is the expected output? What do you see instead? i tried to add more users, but then with each new i added, it deleted the last added user. i expected that it would just add on another user to the list. What version of the product are you using? On what operating system? not sure what version - spring 08 download - mainly on windows xp Please provide any additional information below. i'm also unable to delete existing users. instead, i went through our list and changed any that weren't being used to generic name so that i could rename them when i needed new accounts.

  What steps will reproduce the problem? 1. we seemed to have created the limit on the number of users. 2. 3. What is the expected output? What do you see instead? i tried to add more users, but then with each new i added, it deleted the last added user. i expected that it would just add on another user to the list. What version of the product are you using? On what operating system? not sure what version - spring 08 download - mainly on windows xp Please provide any additional information below. i'm also unable to delete existing users. instead, i went through our list and changed any that weren't being used to generic name so that i could rename them when i needed new accounts.
• May 29, 2009

  issue 4 (delete an existing library) reported by jean.ferguson   -   What steps will reproduce the problem? 1. deleting an existing library What is the expected output? What do you see instead? i don't see a way to delete an existing library. what i was able to do was to blank it out, but that left a layer of empty spaces above the libraries we do use. What version of the product are you using? On what operating system? not sure what version, but we installed it in the spring of 08. mostly used on windows xp - although we have it running on a server in our library and are accessing it on the web. Please provide any additional information below.

  What steps will reproduce the problem? 1. deleting an existing library What is the expected output? What do you see instead? i don't see a way to delete an existing library. what i was able to do was to blank it out, but that left a layer of empty spaces above the libraries we do use. What version of the product are you using? On what operating system? not sure what version, but we installed it in the spring of 08. mostly used on windows xp - although we have it running on a server in our library and are accessing it on the web. Please provide any additional information below.
• May 08, 2009

  libstats-1.0.6.zip (release 1.0.6 - minor edits, change of reports, md5 encoded ...) file uploaded by server.goon   -  

  Labels: Featured

  Labels: Featured
• May 08, 2009

  r50 (modified the User Administration part. needed to wrap md5() ...) committed by erinlovestechno   -   modified the User Administration part. needed to wrap md5() around the password.

  modified the User Administration part. needed to wrap md5() around the password.
• May 07, 2009

  issue 1 (LDAP Authentication Feature) commented on by server.goon   -   added the changes to the repository. And changes are in most recent download available.

  added the changes to the repository. And changes are in most recent download available.
• May 07, 2009

  r49 (updated CHANGELOG) committed by server.goon   -   updated CHANGELOG

  updated CHANGELOG
• May 07, 2009

  libstats-1.0.6.zip (release 1.0.6 - minor edits, change of reports, md5 encoded ...) file uploaded by server.goon   -  

  Labels: Featured

  Labels: Featured
• May 07, 2009

  r48 (updated CHANGELOG) committed by server.goon   -   updated CHANGELOG

  updated CHANGELOG
• May 07, 2009

  r47 (updated CHANGELOG) committed by server.goon   -   updated CHANGELOG

  updated CHANGELOG
• May 07, 2009

  r46 (corrected short tag) committed by server.goon   -   corrected short tag

  corrected short tag
• May 07, 2009

  r45 (added path and LDAP authentication) committed by server.goon   -   added path and LDAP authentication

  added path and LDAP authentication
• May 07, 2009

  r44 (added path and LDAP configuration information) committed by server.goon   -   added path and LDAP configuration information

  added path and LDAP configuration information
• May 07, 2009

  r43 (changed the contact information that shows up on the page) committed by server.goon   -   changed the contact information that shows up on the page

  changed the contact information that shows up on the page
• May 07, 2009

  r42 (changed the contact information that shows up on the page) committed by server.goon   -   changed the contact information that shows up on the page

  changed the contact information that shows up on the page
• May 07, 2009

  r41 (Modifications were made to various files to allow for a cale...) committed by erinlovestechno   -   Modifications were made to various files to allow for a calendar widget to easily be added in the questionAddForm and reportList. This is done by using CAL_WIDGET as a global and various conditional statements. See wiki guide for orginal steps

  Modifications were made to various files to allow for a calendar widget to easily be added in the questionAddForm and reportList. This is done by using CAL_WIDGET as a global and various conditional statements. See wiki guide for orginal steps
• May 07, 2009

  issue 2 (Problem changing locations and patron types. etc.. it's like...) commented on by cauley.shane   -   We were running php5/phpdb/ mysql/apache on Windows server 2003. This may not happen on linux/unix based machines. Shane Cauley network lead technician Laramie County Library System

  We were running php5/phpdb/ mysql/apache on Windows server 2003. This may not happen on linux/unix based machines. Shane Cauley network lead technician Laramie County Library System
• May 07, 2009

  issue 2 (Problem changing locations and patron types. etc.. it's like...) commented on by cauley.shane   -   Gerald Teano, Webmaster from the Laramie County Library System fixed this issue with this code: Go to the finders folder and open LibraryFinder.php. Go to line 54. Edit from.... function addLibrary($option_pk, $short_name, $full_name) { // Just add it... it should be easy ;-) $table = 'libraries'; $field_values = array( 'library_id' => '', 'full_name' => $full_name, 'short_name' => $short_name ); to function addLibrary($option_pk, $short_name, $full_name) { // Just add it... it should be easy ;-) $table = 'libraries'; $field_values = array( 'full_name' => $full_name, 'short_name' => $short_name ); gteano@gmail.com

  Gerald Teano, Webmaster from the Laramie County Library System fixed this issue with this code: Go to the finders folder and open LibraryFinder.php. Go to line 54. Edit from.... function addLibrary($option_pk, $short_name, $full_name) { // Just add it... it should be easy ;-) $table = 'libraries'; $field_values = array( 'library_id' => '', 'full_name' => $full_name, 'short_name' => $short_name ); to function addLibrary($option_pk, $short_name, $full_name) { // Just add it... it should be easy ;-) $table = 'libraries'; $field_values = array( 'full_name' => $full_name, 'short_name' => $short_name ); gteano@gmail.com
• May 07, 2009

  r40 (Changed the Init file. basically reorganized it and added me...) committed by erinlovestechno   -   Changed the Init file. basically reorganized it and added meaningful comments in order to make configuring libstats easier and more intuitive

  Changed the Init file. basically reorganized it and added meaningful comments in order to make configuring libstats easier and more intuitive
• May 07, 2009

  r39 (Modfied finders/LibraryFinder.php to resolve the issue some ...) committed by erinlovestechno   -   Modfied finders/LibraryFinder.php to resolve the issue some where having when passing NULL values

  Modfied finders/LibraryFinder.php to resolve the issue some where having when passing NULL values
• May 06, 2009

  r38 (Added new reports which are subclasses. These new reports ar...) committed by erinlovestechno   -   Added new reports which are subclasses. These new reports are self contained. Deleting old reports; they will no longer work and are not needed.

  Added new reports which are subclasses. These new reports are self contained. Deleting old reports; they will no longer work and are not needed.
• May 06, 2009

  r37 (This is for the core modification for the reporting overhaul...) committed by erinlovestechno   -   This is for the core modification for the reporting overhaul. Does not include the new reports themselves. This allows for reports to be self contained within subclasses of Report.

  This is for the core modification for the reporting overhaul. Does not include the new reports themselves. This allows for reports to be self contained within subclasses of Report.