There was a problem with a Velocity script
Pagerich-template
ErrorInvocation of method 'getRelatedInSchedule' in class com.prestosports.render.storage.database.DatabasePage threw exception java.lang.RuntimeException: java.sql.SQLException: Got error 28 from storage engine @ rich-template[236,29]
Page source:
1: #if ($browser.getIphone() || $browser.getMobile())
2: 	
3: 	##MOBILE TEMPLATE
4: 	$website.include("options")
5: 	#set ($options = $request.getAttribute("options"))
6: 
7: 	## DEFAULT VALUES
8: 	#set ($showDate = true)
9: 	#set ($facebookLike = false)
10: 	#set ($showThumb = true)
11: 	#set ($showCaption = true)
12: 	#set ($thumbWidth = 150)
13: 	
14: 	#set ($showDate = $options.get("article_show_date"))
15: 	#set ($facebookLike = $options.get("article_facebook_like"))
16: 	#set ($showThumb = $options.get("article_show_thumb"))
17: 	#set ($showCaption = $options.get("article_show_caption"))
18: 	#set ($thumbWidth = $options.get("article_mobile_thumb_width"))
19: 	
20: 	## ADD THIS
21: 	#if ($page.date && $facebookLike == true)
22: 	
23: 	#end
24: 					
25: 	<div class="mobile-article">
26: 		## PAGE TITLE
27: 		<h1>$!page.title</h1>
28: 
29: 		#if ($showDate == true and $page.date)
30: 			<span class="page-date">$formatter.formatLongDate($!page.date)</span>
31: 		#end
32: 		
33: 		<div class="clear"></div>
34: 		
35: 		#if ($page.thumbnailURL && $showThumb == true)
36: 			<div class="thumb">
37: 				<img src="$page.thumbnailURL?max_width=276" alt="$!page.thumbnailPage.title" />
38: 				#if ($page.thumbnailPage.buyURL)
39: 					<a href="$website.storeURL($page.thumbnailPage)" class="buynow-button" title="Buy Now"></a>
40: 				#end
41: 				#if ($showCaption == true && $page.thumbnailPage.title.length() > 0)
42: 					<h5 class="thumb-title">$!page.thumbnailPage.title</h5>
43: 				#end
44: 			</div> ## ends thumb
45: 		#end
46: 		
47: 		## PAGE BODY
48: 		$body
49: 		
50: 		<div class="clear"></div>
51: 		
52: 		#if ($facebookLike == true)
53: 			## FACEBOOK LIKE
54: 			##<div class="mobile-facebook-like">
55: 				##<fb:like href="http://${request.serverName}${page.url}" show_faces="false" width="300" height="30" />
56: 			##</div>
57: 		#end
58: 		
59: 		#if ($wiki.valid())
60: 			<div class="wiki">$wiki</div>
61: 		#end
62: 	</div>
63: #else 
64: 
65: ##########################
66: ## AUTHOR: FAISAL CHISHTI ##
67: ## VERSION: 1.0.2         ##
68: ##########################
69: 
70: ## DEFAULT VALUES
71: #set ($showDate = true)
72: #set ($facebookLike = false)
73: #set ($showThumb = false)
74: #set ($showBoxscore = true)
75: #set ($showGallery = true)
76: #set ($thumbWidth = 450)
77: #set ($headlineStyle = "h1")
78: #set ($showCaption = true)
79: #set ($showOnlyBody = false)
80: 
81: ## PICK UP OPTIONS
82: $website.include("options")
83: #set ($options = $request.getAttribute("options"))
84: 
85: ## SET VARIABLES FROM OPTIONS
86: #set ($showDate = $options.get("article_show_date"))
87: #set ($facebookLike = $options.get("article_facebook_like"))
88: #set ($showThumb = $options.get("article_show_thumb"))
89: #set ($showBoxscore = $options.get("article_show_boxscore"))
90: #set ($showGallery = $options.get("article_show_gallery"))
91: #if ($tool.math.toInteger($options.get("article_thumb_width")))
92:   #set ($thumbWidth = $options.get("article_thumb_width"))
93: #end
94: #set ($headlineStyle = $options.get("article_headline_style"))
95: #set ($showCaption = $options.get("article_show_caption"))
96: #set ($showOnlyBody = $options.get("article_only_body"))
97: #set ($adspot = $options.get("adspot"))
98: 
99: <head>
100: <style type="text/css">
101: .rich {
102:   clear: both;
103: }
104: 
105: .related {
106:   width: 100%;
107:   padding-top: 8px;
108:   margin: 2px 0 5px;
109:   background: #e3e3e3;
110:   filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#f5f5f5', endColorstr='#e3e3e3'); /* for IE *
111:   background: -webkit-gradient(linear, left top, left bottom, from(#f5f5f5), to(#e3e3e3)); /* for webkit safari, chrome */
112:   background: -moz-linear-gradient(top,  #f5f5f5,  #e3e3e3); /* for firefox 3.6 */
113: }
114: 
115: .related-links {
116:   width: 49%;
117:   float: left;
118:   padding-top: 2px;
119:   padding-bottom: 5px;
120:   padding-left: 1%;
121: }
122: 
123: .related-links a {
124:   text-decoration: none;
125: }
126: 
127: .facebook-like {
128:   width: 300px;
129:   height: 30px;
130:   float: right;
131: }
132: 
133: .sidebar {
134:   width: ${thumbWidth}px;
135:   float: right;
136:   clear: right;
137:   margin-left: 10px;
138:   margin-bottom: 10px;
139: }
140: 
141: .sidebar td {
142:   vertical-align: top;
143: }
144: 
145: .sidebar .thumb {
146:   margin-bottom: 10px;
147: }
148: 
149: .sidebar .thumb .image {
150:   width: ${thumbWidth}px;
151:   position: relative;
152: }
153: 
154: .sidebar .thumb .image .buynow-button {
155:   display: block;
156:   width: 80px;
157:   height: 50px;
158:   background: url(/info/marketplace/buy-now-80-X-50.png) no-repeat left top;
159:   position: absolute;
160:   right: 10px;
161:   bottom: 10px;
162: }
163: 
164: #set ($relatedBoxWidth = $tool.math.sub($thumbWidth, 12))
165: 
166: .mini-boxscore,
167: .mini-gallery {
168:   width: ${relatedBoxWidth}px;
169:   padding: 5px;
170:   border: solid 1px #c2c2c2;
171:   margin-bottom: 30px;
172:   position: relative;
173: }
174: 
175: .mini-boxscore .more,
176: .mini-gallery .more {
177:   font-size: 9px;
178:   color: #fff;
179:   text-decoration: none;
180:   padding: 2px 5px;
181:   background: #2f2f2f;
182:   -moz-border-radius-bottomright: 3px;
183:   border-bottom-right-radius: 3px;
184:   position: absolute;
185:   right: -1px;
186:   bottom: -19px;
187: }
188: 
189: .mini-boxscore .more:hover,
190: .mini-gallery .more:hover {
191:   background: #000;
192: }
193: </style>
194: </head>
195: 
196: #if ($showOnlyBody == true)
197: 
198: $body
199: 
200: #else
201: 
202: ## FACEBOOK LIKE
203: #if ($page.date && $facebookLike == true)
204: <head>
205: 	<meta property="og:type" content="article" />
206: 	<meta property="og:title" content="$!page.title" />
207: 	<meta property="og:url" content="http://${request.serverName}${page.url}" />
208: 	#if ($page.thumbnailURL.length() > 0)
209: 	<meta property="og:image" content="http://${request.serverName}${page.thumbnailURL}" />
210: 	#else
211: 	<meta property="og:image" content="http://${request.serverName}/images/setup/thumbnail_default.jpg" />
212: 	#end
213: 	<meta property="og:site_name" content="$website.profile.siteName" />
214: 	<meta property="og:description" content="$!page.leadIn" />
215: 	<meta property="fb:app_id" content="280467664480" />
216: 
217: 	<script src="http://connect.facebook.net/en_US/all.js"></script>
218: 	<script>
219: 	  FB.init({
220: 		status : true, // check login status
221: 		cookie : true, // enable cookies to allow the server to access the session
222: 		xfbml  : true  // parse XFBML
223: 	  });
224: 	</script>
225: </head>
226: #end
227: 
228: <div class="rich clearfix">
229: 
230: ## PAGE DATE
231: #if ($showDate == true)
232: #if ($page.date)<span class="page-date">$formatter.formatLongDate($!page.date)</span>#end
233: #end
234: 
235: ## RELATED LINKING
236: #set ($relatedPages = $page.relatedInSchedule)
237: 
238: #if($page.date)
239: #if ($facebookLike == true)
240: <div class="related clearfix">
241: 
242: #if ($relatedPages.size() > 1)
243: $request.setAttribute("disable_related_links", "y")
244: 
245: <div class="related-links">
246: #foreach ($related in $relatedPages)
247:     #if ($velocityCount > 1) | #end
248:     #if ($related.id == $page.id)<strong>#else<a href="$related.url" #if($website.isExternalLink($related.url))target="_blank"#end id="$related.mapType">#end${related.mapLabel}#if($related.id == $page.id)</strong>#else</a>#end
249: #end
250: </div>
251: #end
252: 
253: ## FACEBOOK LIKE
254: <div class="facebook-like">
255: <fb:like href="http://${request.serverName}${page.url}" show_faces="false" width="300" height="30" />
256: </div>
257: 
258: </div> ## ends related block
259: 
260: #end
261: #end
262: 
263: ## PAGE TITLE
264: #if ($page.title.length() > 0)
265:   #if ($headlineStyle == "none")
266:     <span class="article-title">$!page.title</span>
267:   #else
268:     <${headlineStyle} class="article-title">$!page.title</${headlineStyle}>
269:   #end
270:   <div style="clear:both"></div>
271: #end
272: 
273: ## SIDEBAR
274: #set ($hasSidebarContent = false)
275: #if ($page.thumbnailURL && $showThumb == true)
276:   #set ($hasSidebarContent = true)
277: #end
278: 
279: #foreach ($related in $relatedPages)
280:   #if ($showBoxscore == true && $related.contentType.startsWith("statcrew") && $related.mapType == "BS")
281:     #set ($hasSidebarContent = true)
282:   #end
283: #end
284: 
285: #foreach ($related in $relatedPages)
286:   #if ($showGallery == true && $related.mapType == "GA" && $website.isExternalLink($related.url) != true)
287:     #set ($hasSidebarContent = true)
288:   #end
289: #end
290: 
291: #if ($hasSidebarContent == true)
292: <div class="sidebar">
293: #end
294: 
295: #if ($page.thumbnailURL && $showThumb == true)
296: <div class="thumb">
297: 
298:   <div class="image">
299:       <img src="$page.thumbnailURL?max_width=${thumbWidth}" alt="$!page.thumbnailPage.title" />
300: 
301:   #if ($page.thumbnailPage.buyURL)
302:       <a href="$website.storeURL($page.thumbnailPage)" class="buynow-button clearfix"></a>
303:   #end
304: 
305:   </div> ## ends image
306: 
307:   #if ($showCaption == true && $page.thumbnailPage.title.length() > 0)
308:       <div class="align-center thumbnail-caption">$!page.thumbnailPage.title</div>
309:   #end
310: 
311: </div> ## ends thumb
312: #end
313: 
314: #if ($relatedPages.size() > 1 && $page.date)
315: #foreach ($related in $relatedPages)
316:   #if ($showBoxscore == true && $related.contentType.startsWith("statcrew") && $related.mapType == "BS")
317:     <div class="mini-boxscore">
318:       $website.include("$related.url?tmpl=mini-boxscore-template")
319:       <a href="$related.url" class="more">full stats</a>
320:     </div>
321:   #end
322: #end
323: 
324: #foreach ($related in $relatedPages)
325:   #if ($showGallery == true && $related.mapType == "GA" && $website.isExternalLink($related.url) != true)
326:     <div class="mini-gallery">
327:       $website.include("$related.url?tmpl=mini-gallery-template&width=${thumbWidth}")
328:       <a href="$related.url" class="more">full gallery</a>
329:     </div>
330:   #end
331: #end
332: #end
333: 
334: #if ($hasSidebarContent == true)
335: </div>  ## ends sidebar
336: #end
337: 
338: ## PAGE BODY
339:   $body
340: 
341: </div> ## ends rich
342: 
343: #end  ## ends only-body check
344: 
345: $wiki
346: 
347: #end