|
By: Anthony
Date: 2012-04-26
Time: 20:00
|
Parameter 'noerr' Seems to Not Work in Certain Situations
I am getting this error message:
TinyButStrong Error in field [degreeblock.yearofstudy...]: item 'yearofstudy' is not an existing key in the array. This message can be cancelled using parameter 'noerr'.
TinyButStrong Error in field [degreeblock.semester...]: item 'semester' is not an existing key in the array. This message can be cancelled using parameter 'noerr'.
TinyButStrong Error in field [degreeblock.yearofstudy...]: item 'yearofstudy' is not an existing key in the array. This message can be cancelled using parameter 'noerr'.
TinyButStrong Error in field [degreeblock.semester...]: item 'semester' is not an existing key in the array. This message can be cancelled using parameter 'noerr'.
|
However, I have a 'noerr' parameter in the TBS tags, so what is my problem?
<h4 class="classYear">[degreeblock.yearofstudy;if [val]=1;then 'First';if [val]=2;then 'Second';if [val]=3;then 'Third';if [val]=4;then 'Fourth';if [val]=5;then 'Fifth';block=h4+div;parentgrp=yearofstudy;noerr] Year <span class="expand">-</span></h4>
<h5>Semester [degreeblock.semester;block=h5+ol;parentgrp=semester;noerr]</h5>
|
|
|
By: Skrol29
Date: 2012-04-26
Time: 23:11
|
Re: Parameter 'noerr' Seems to Not Work in Certain Situations
This is strange indeed,
Can you post or send to me a snippet to reproduce the problem?
|
|
By: Anthony
Date: 2012-04-27
Time: 03:53
|
Re: Parameter 'noerr' Seems to Not Work in Certain Situations
Here's the page template:
[onload;file=../global/header_global.html;noerr]
<div id="wrapper">
<div id="left_col">
[onload;file=side_menu_academics.html;noerr]
</div>
<div id="right_col">
<h2>[onshow.section_title; noerr], [degreeblock.ID;block=h2+h3+p+h3;headergrp=degree;noerr]</h2>
<h3>About</h3>
<p>[degreeblock.description;noerr]</p>
<h3>Schedule of Classes</h3>
<h4 class="classYear">[degreeblock.yearofstudy;if [val]=1;then 'First';if [val]=2;then 'Second';if [val]=3;then 'Third';if [val]=4;then 'Fourth';if [val]=5;then 'Fifth';block=h4+div;parentgrp=yearofstudy;noerr] Year <span class="expand">-</span></h4>
<div class="courseBlock">
<h5>Semester [degreeblock.semester;block=h5+ol;parentgrp=semester;noerr]</h5>
<ol>
<li><span class="courseName">[degreeblock.course_description;att=span#class;if ''='[val]';then '';else 'courseName';noerr][degreeblock.course; block=li;noerr]</span>
<span class="courseDescription">[degreeblock.course_description;noerr]</span></li>
</ol>
</div>
</div>
</div>
[onload;file=../global/footer_global.html;noerr]
|
Here's the section of the php script that determines which query is used. In one particular case, some of the fields are not used and so are not in the array.
I was planning to just modify my template to not display the section that uses those fields.
if (!file_exists($html)) { // don't continue if html template not found
PageNotFound();
exit;
}
$TBS->LoadTemplate($html);
// Connection to the database
try {
# MySQL with PDO_MYSQL and Set Connection to Use UTF-8
$DBConn = new PDO("mysql:host=$dbhost;dbname=$dbname",
$dbuser, $dbpass,array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
/*** set the error reporting attribute ***/
$DBConn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
if ($recordID == "C.W.D.") {
$sql = "SELECT d.ID AS ID, d.name AS degree, d.description AS description, d.requirements AS requirements
FROM degrees d
WHERE d.ID = '" . $recordID . "' ";
}
else {
$sql = "SELECT d.ID AS ID, d.name AS degree, d.description AS description, d.requirements AS requirements,
c.name AS course, c.description AS course_description,
dd.yearofstudy AS yearofstudy, dd.semester AS semester
FROM degrees d
INNER JOIN degrees_details dd ON dd.degreeID = d.ID
INNER JOIN courses c ON c.ID = dd.courseID
WHERE d.ID = '" . $recordID . "' " .
"ORDER BY dd.yearofstudy,dd.semester,dd.order";
}
$tbs_source = ($DBConn===false) ? 'clear' : $DBConn;
// Merge data and close connection
$TBS->MergeBlock('degreeblock', $tbs_source, $sql);
$TBS->Show();
|
|
|
By: Skrol29
Date: 2012-04-27
Time: 18:09
|
Re: Parameter 'noerr' Seems to Not Work in Certain Situations
Hi Anthony,
Thank you for your snippet, I've reproduced the bug.
The error is in the error message. In fact TBS means that "parentgrp=yearofstudy" and "parentgrp=semester" cannot be processed because the column does not exist.
This error cannot be fixed by "noerr".
I put this error message to be fixed in the todo.
|
|
By: Anthony
Date: 2012-04-27
Time: 18:52
|
Re: Parameter 'noerr' Seems to Not Work in Certain Situations
Ok, thanks for the info. I will revise either the template or php script to avoid the problem.
|
|
By: Anthony
Date: 2013-01-16
Time: 19:59
|
Re: Parameter 'noerr' Seems to Not Work in Certain Situations
Were you ever able to address this issue to get noerr to work properly in the situation describe in this thread?
Regards,
AB
|
|
By: Skrol29
Date: 2013-01-19
Time: 00:21
|
Re: Parameter 'noerr' Seems to Not Work in Certain Situations
|
|
Posting in progress.
Please wait...
|