Page 1 of 1
Page stalling/hanging up
Posted: Thu Mar 18, 2010 5:37 pm
by zaidcrowe
Hi Guys,
I'm having a problem where the page featured in the code below fails to load.
I've ascertained that its something in the head section of the html - basically something to do with one of the smarty tags.
I can't narrow it down to any particular one - if I remove them one at a time, i still have the issue - if I remove them all the page loads no problem every time I try.
I've tried everything between the {stylesheet} and tag in both the metadata for the page, and directly in the template, with caching on and off - and the issues the same.
Any ideas suggestions or solutions out there??
Many thanks!
Code: Select all
{process_pagedata}
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<__html xmlns="http://www.w3.org/1999/xhtml">
<head>
{metadata}
<title>{sitename} - {title}</title>
{stylesheet}
{$feu_smarty->get_user_properties($customcontent_loggedin,'userprops')}
{literal}
<link href="/facebox/facebox.css" media="screen" rel="stylesheet" type="text/css"/>
<__script__ src="/facebox/facebox.js" type="text/javascript"></__script>
<__script__ type="text/javascript" src="/modules/FORMfields/src/FORMfields.js"></__script>
<__script__ type="text/javascript">
if($.cookie('album_info_done')){
//window.location = '/create-new-release/upload.html';
}
function restrict(){return false;}
var theBarcode;
var selectLN = {/literal}{is_this_product_in_cart product = $actionparams.product}{if $exists}true;{else}false;{/if}{literal}
var doneLabel = false;
function arm_form(){
if(ownLabelName){
$('#label').append('<option value="'+ownLabelName+'" selected="selected">'+ownLabelName+'</option>');
}
$("#release_date_start_calendar_link img").attr("width","128px");
$("#release_date_start_calendar_link img").attr("height","128px");
$("a[href*='http://www.formfields.com']").parent().hide();
$('#customer_id').val({/literal}'{$customcontent_loggedin}'{literal});
$('#audio_folder').val('');
$('#your_label_name').attr('readonly',true);
if(selectLN == true){
$('#label option[value="name-reg-label"]').attr('selected', 'selected');
$('#your_label_name').removeAttr('readonly');
$('#your_label_name').val('');
}
$('.quantity').parents('form').ajaxForm({success:updateCart,url:'/'});
$('#barcode_UPC').parent().append('<a href="javascript:void(0);" id="gen_upc" class="btn">Generate this for me (free)</a>');
$('#label').change(function(){//START LABEL CHANGE
if($(this).val() == 'name-reg-label'){
//alert('update cart +/- name label');
//alert('reg label');
$.cookie('name-reg-label','false');
$.cookie('name-own-label','false');
doCart(1,true);
//return false;
}else if($(this).val() == 'use-own-label'){
//alert('use own');
$.cookie('name-reg-label','false');
$.cookie('name-own-label','true');
$('#your_label_name').removeAttr('readonly').val('').focus();
doCart(0,true);
//return false;
}else{
//alert('use-ditto');
$.cookie('name-reg-label','false');
$.cookie('name-own-label','false');
doCart(0,false);
//return false;
}
$('.quantity').parents('form').submit();
//alert('tried to submit');
});//END LABEL CHANGE
$('#gen_upc').click(function(){
$(this).html('Generating please wait...');
$.ajax({url:'/create-new-release/generate-barcode.html',success:function(data){
$('#barcode_UPC').val(data.substr(2,13));
$('#gen_upc').hide();
}});
});
$('.ffForm form').ajaxForm({url:'/modules/FORMfields/forms/generated/album_details.php',beforeSubmit: preloader,
success:function(data){
$response = $(data);
$('.ffForm').html($response.filter('.ffForm').html());
$('.ffForm').show();
if($('.ffConfirmation').length != 0){
$.cookie('album_info_done', theBarcode, { path: '/'});
$('.ffConfirmation').html('Thanks for your submission, you\'ll now be taken to upload your tracks!');
$('.ffRedirectNote').hide();
$('#besure').hide();
$('#gototracks').effect("pulsate", { times:3 }, 1000);
//alert($('#gototracks a').attr("href")+'?r='+theBarcode);
$('#gototracks a').attr("href", $('#gototracks a').attr("href")+'?r='+theBarcode);
$('#loading').remove();
alert("Thanks for your submission, you'll now be taken to upload your tracks!");
window.location = '/create-new-release/upload.html';
}else{
$('#loading').remove();
arm_form();
}
}});
}
function preloader(){
if($('#barcode_UPC').length !=0){
theBarcode = $('#barcode_UPC').val();
}
$('.ffForm').hide();
$('.big_tab').append('<div id="loading" style="text-align:center;"><img src="/images/ajax-loader.gif" style="display:inline;align:center;"><br/><strong>Processing...please wait...don\'t touch your keyboard...</strong></div>');
}
function setFocus(){return false;}
function doCart(myval,allowlabel){
//alert('docart-'+myval);
if(allowlabel){
$('#your_label_name').removeAttr('readonly');
$('#your_label_name').val('').focus();
}else{
$('#your_label_name').val('Select the appropriate option above to use this.');
$('#your_label_name').attr('readonly',true);
}
var quantityBox = $('#name-lebel-form form .quantity');
quantityBox.val(myval);
$('#cart').html('updating your cart...');
}
function updateCart(){
$.ajax({url:'/index.php?page=view-cart',success:function(data){
$('#cart').html(data);
$('a[rel*=facebox]').facebox();
}});
}
var ownLabelName = '{/literal}{$userprops.your_label_name}{literal}';
$(document).ready(function() {
$.cookie('name-own-label',null,{ path: '/', expires: 10 });
$('#cart').html('Getting cart...')
$.ajax({url:'/index.php?page=view-cart',success:function(data){
$('#cart').html(data);
$('a[rel*=facebox]').facebox();
}});
$('a[rel*=facebox]').facebox();
$('.big_tab').load('/modules/FORMfields/forms/generated/album_details.php .ffForm', function(){
arm_form();
}
);
});
</__script>
<style>
.FORMfields{background-color:#D9D2D2;}
select{background-color:#fff!important;display:inline!important;}
#release_date_start_calendar_link img{width:128px;height:128px;}
.display a img{width:200px;height:200px;}
</style>
{/literal}
</head>
</__body>
<!--Wrapper-->
<div id="wrapper">
<div class="round_big_top">
<ul>
<li><a href="javascript:void(0);"class="active">RELEASE INFO</a><span>//</span></li>
<li><a href="javascript:void(0);" >UPLOAD CONTENT</a><span>//</span></li>
<li><a href="javascript:void(0);">TRACK INFO</a><span>//</span></li>
<li><a href="javascript:void(0);">RETAILERS</a><span>//</span></li>
<li><a href="javascript:void(0);">PAY</a></li>
</ul>
</div>
<div id="country-picker">
<div id="set_us"></div> <div id="set_uk"></div>
<p>Select your currency:</p>
</div>
<!--Full round -->
<div class="fullround_box">
<!--Full round Nav-->
<div class="fullround_box_nav" id="floatMenu">
{global_content name='sub_menu'}
<div class="right" id="cart">{*Cart action='mycart'*}</div>
<!--End Full round Nav-->
</div>
<!--Full round box container-->
<div class="fullround_box_container" style="padding-top:40px;">
<div class="left" style="width:500px;">
<h3 class="margin_none">Your Release Info</h3>
{content}
</div>
<div class="right btn" id="gototracks">
<a href="/create-new-release/upload.html"><img src="images/arrow.png" alt="arrow" class="left" /> <h3>UPLOAD TRACKS</h3></a>
</div>
<div class="clear"></div><BR/>
<div class="big_tab" style="text-align:center;">
<img src="/images/ajax-loader.gif">
</div>
<div class="clear"></div><br/>
<div style="text-align:center" id="besure">Once you submit this data, it cannot be amended!</div>
<div class="clear"></div>
<br/>
<!--End Full round box container-->
</div>
<!--End Full round-->
</div>
<!--End Wrapper-->
</div>
<div id="name-lebel-form" style="display:none;">
{Products action='details' productid='21'}
</div>
<__body>
</__html>
Re: Page stalling/hanging up
Posted: Thu Mar 18, 2010 5:58 pm
by zaidcrowe
i dont know if this helps - but with debug mode on - the page also renders fine.
here's the debug output:
Code: Select all
Generated in 0.45365 seconds by CMS Made Simple using 78 SQL queries and 13882048 bytes of memory (peak memory usage was 14316508)
Debug: (0.009128) - (677216)
loading smarty
Debug: (0.012521) - (949468)
loading adodb
Debug: (0.014016) - (1033940)
loading page functions
Debug: (0.016399) - (1208960)
loading content functions
Debug: (0.018613) - (1406892)
loading pageinfo functions
Debug: (0.019287) - (1439588)
loading translation functions
Debug: (0.019781) - (1456880)
loading events functions
Debug: (0.020948) - (1539364)
loading php4 entity decode functions
Debug: (0.022527) - (1742048)
done loading files
Debug: (0.031216) - (2417528)
<br>
(mysql): SET NAMES 'utf8'<br>
Error (0): <br>
Debug: (0.031876) - (2432668)
<br>
(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs<br>
Error (0): <br>
Debug: (0.036308) - (2587204)
<br>
(mysql): SELECT * FROM cms_userplugins<br>
Error (0): <br>
Debug: (0.043307) - (3167584)
<br>
(mysql): SELECT * FROM cms_modules WHERE admin_only = 0 AND active = 1 ORDER by module_name<br>
Error (0): <br>
Debug: (0.057534) - (3931436)
<br>
(mysql): SET NAMES 'utf8'<br>
Error (0): <br>
Debug: (0.057713) - (3930924)
<br>
(mysql): SELECT COUNT(*) FROM cms_modules WHERE module_name = 'Antz' AND `status` = 'installed'<br>
Error (0): <br>
Debug display of 'Load Content Operations':(0.069836) - (4756836)
Debug display of 'End Load Content Operations':(0.076118) - (5293940)
Debug: (0.076273) - (5295912)
<br>
(mysql): SELECT content_id FROM cms_content WHERE default_content = 1<br>
Error (0): <br>
Debug display of 'End of include':(0.213787) - (11138756)
Debug: (0.21512) - (11141728)
<br>
(mysql): SELECT c.content_id, c.content_name, c.content_alias, c.menu_text, c.titleattribute, c.hierarchy, c.metadata, c.id_hierarchy, c.prop_names, c.create_date AS c_create_date, c.modified_date AS c_date, c.cachable, c.last_modified_by,t.template_id, t.encoding, t.modified_date AS t_date FROM cms_templates t INNER JOIN cms_content c ON c.template_id = t.template_id WHERE c.content_alias = 'release-info' AND c.active = 1<br>
Error (0): <br>
Debug: (0.21544) - (11146224)
<br>
(mysql): SELECT MAX(modified_date) AS thedate FROM cms_content c<br>
Error (0): <br>
Debug display of 'Start Loading Hierarchy Manager':(0.215957) - (11145808)
Debug display of 'starting tree':(0.216009) - (11145808)
Debug: (0.219521) - (11274896)
file needs loading
Debug display of 'ending tree':(0.220828) - (11371532)
Debug display of 'End Loading Hierarchy Manager':(0.22088) - (11353692)
Debug: (0.220927) - (11353736)
start findNodeByTag
Debug: (0.221037) - (11353780)
end findNodeByTag
Debug: (0.221355) - (11357168)
<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = '59' AND active = 1 ORDER BY hierarchy<br>
Error (0): <br>
Debug: (0.221816) - (11395160)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id IN (91,60,61,63,109,124,126) ORDER BY content_id<br>
Error (0): <br>
Debug: (0.242295) - (11783304)
<br>
(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates WHERE template_id = '29'<br>
Error (0): <br>
Debug: (0.254322) - (12430328)
<br>
(mysql): SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM cms_event_handlers eh
INNER JOIN cms_events e ON e.event_id = eh.event_id
ORDER BY eh.handler_order ASC<br>
Error (0): <br>
Debug: (0.266662) - (12453984)
start findNodeByTag
Debug: (0.266796) - (12454412)
end findNodeByTag
Debug: (0.286339) - (12555528)
start global_content_get_template
Debug: (0.288599) - (12626232)
<br>
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'sub_menu'<br>
Error (0): <br>
Debug: (0.288852) - (12626884)
end global_content_get_template
Debug: (0.288923) - (12626884)
start global_content_get_timestamp
Debug: (0.288987) - (12626988)
end global_content_get_timestamp
Debug display of 'Start of Menu Manager Display':(0.300361) - (12714044)
Debug: (0.300706) - (12718460)
<br>
(mysql): SELECT content_id FROM cms_content WHERE content_alias = 'sub-menu'<br>
Error (0): <br>
Debug: (0.300818) - (12718928)
start findNodeByTag
Debug: (0.301057) - (12719064)
end findNodeByTag
Debug: (0.301326) - (12719256)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '75'<br>
Error (0): <br>
Debug: (0.302835) - (12761964)
<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = '75' AND active = 1 ORDER BY hierarchy<br>
Error (0): <br>
Debug: (0.303263) - (12781092)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id IN (76,81,85,89,90,100,104) ORDER BY content_id<br>
Error (0): <br>
Debug: (0.309205) - (13008676)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '58'<br>
Error (0): <br>
Debug: (0.309894) - (13010136)
<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = '76' ORDER BY hierarchy<br>
Error (0): <br>
Debug: (0.311395) - (13045408)
load properties called
Debug: (0.31163) - (13045840)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '77'<br>
Error (0): <br>
Debug: (0.312084) - (13046272)
load properties called
Debug: (0.312337) - (13046860)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '78'<br>
Error (0): <br>
Debug: (0.312808) - (13047208)
load properties called
Debug: (0.313028) - (13047368)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '80'<br>
Error (0): <br>
Debug: (0.313515) - (13048140)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '90'<br>
Error (0): <br>
Debug: (0.314197) - (13059936)
<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = '80' ORDER BY hierarchy<br>
Error (0): <br>
Debug: (0.31503) - (13061928)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '82'<br>
Error (0): <br>
Debug: (0.315694) - (13073452)
<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = '81' ORDER BY hierarchy<br>
Error (0): <br>
Debug: (0.317797) - (13163704)
load properties called
Debug: (0.318026) - (13164292)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '82'<br>
Error (0): <br>
Debug: (0.318565) - (13164852)
load properties called
Debug: (0.318785) - (13165672)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '118'<br>
Error (0): <br>
Debug: (0.319246) - (13166252)
load properties called
Debug: (0.319465) - (13167384)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '83'<br>
Error (0): <br>
Debug: (0.319834) - (13167912)
load properties called
Debug: (0.320052) - (13168640)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '84'<br>
Error (0): <br>
Debug: (0.320449) - (13169252)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '80'<br>
Error (0): <br>
Debug: (0.320873) - (13179820)
load properties called
Debug: (0.321096) - (13181552)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '80'<br>
Error (0): <br>
Debug: (0.321627) - (13182660)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '90'<br>
Error (0): <br>
Debug: (0.322339) - (13194796)
<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = '84' ORDER BY hierarchy<br>
Error (0): <br>
Debug: (0.323725) - (13212780)
load properties called
Debug: (0.323959) - (13213628)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '116'<br>
Error (0): <br>
Debug: (0.32446) - (13215324)
load properties called
Debug: (0.324684) - (13216364)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '105'<br>
Error (0): <br>
Debug: (0.325397) - (13218080)
<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = '85' ORDER BY hierarchy<br>
Error (0): <br>
Debug: (0.326641) - (13265460)
load properties called
Debug: (0.326877) - (13266672)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '86'<br>
Error (0): <br>
Debug: (0.327296) - (13267280)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '91'<br>
Error (0): <br>
Debug: (0.328013) - (13279388)
load properties called
Debug: (0.328241) - (13280168)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '87'<br>
Error (0): <br>
Debug: (0.329111) - (13282624)
<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = '90' ORDER BY hierarchy<br>
Error (0): <br>
Debug: (0.330393) - (13325144)
load properties called
Debug: (0.330643) - (13326716)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '92'<br>
Error (0): <br>
Debug: (0.331101) - (13328424)
load properties called
Debug: (0.331331) - (13329656)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '93'<br>
Error (0): <br>
Debug: (0.331787) - (13331280)
load properties called
Debug: (0.332006) - (13332636)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '94'<br>
Error (0): <br>
Debug: (0.332637) - (13335476)
<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = '100' ORDER BY hierarchy<br>
Error (0): <br>
Debug: (0.334258) - (13402780)
load properties called
Debug: (0.3345) - (13403868)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '123'<br>
Error (0): <br>
Debug: (0.334959) - (13406796)
load properties called
Debug: (0.33523) - (13407924)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '101'<br>
Error (0): <br>
Debug: (0.335686) - (13409760)
load properties called
Debug: (0.335905) - (13410824)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '102'<br>
Error (0): <br>
Debug: (0.336283) - (13411756)
load properties called
Debug: (0.336497) - (13412268)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '103'<br>
Error (0): <br>
Debug: (0.336936) - (13413044)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '90'<br>
Error (0): <br>
Debug: (0.339606) - (13516768)
<br>
(mysql): SELECT content from cms_module_templates WHERE module_name = 'MenuManager' and template_name = 'sub_menu'<br>
Error (0): <br>
Debug: (0.339905) - (13518532)
<br>
(mysql): SELECT module_name,template_name,modified_date
FROM cms_module_templates<br>
Error (0): <br>
Debug display of 'End of Menu Manager Display':(0.373422) - (13520120)
Debug: (0.373758) - (13437832)
start findNodeByTag
Debug: (0.373882) - (13437832)
end findNodeByTag
Debug: (0.3832) - (13910228)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1268924978<br>
Error (0): <br>
Debug: (0.383552) - (13911132)
<br>
(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1268924978<br>
Error (0): <br>
Debug: (0.383949) - (13911688)
<br>
(mysql): SELECT userid FROM cms_module_feusers_loggedin WHERE sessionid='kk60ttn7mr0tivsukdfbnve727'<br>
Error (0): <br>
Debug: (0.384852) - (13912372)
<br>
(mysql): UPDATE cms_module_feusers_loggedin SET lastused = 1268934977 where sessionid = 'kk60ttn7mr0tivsukdfbnve727'<br>
Error (0): <br>
Debug: (0.385135) - (13912452)
<br>
(mysql): SELECT * FROM cms_module_feusers_users WHERE id='907'<br>
Error (0): <br>
Debug: (0.385404) - (13912632)
<br>
(mysql): SELECT * FROM cms_module_feusers_belongs WHERE userid='907'<br>
Error (0): <br>
Debug: (0.385667) - (13912944)
<br>
(mysql): SELECT * FROM cms_module_feusers_groups WHERE id='1'<br>
Error (0): <br>
Debug: (0.385949) - (13913260)
<br>
(mysql): SELECT * FROM cms_module_feusers_users WHERE id='907'<br>
Error (0): <br>
Debug: (0.386221) - (13913512)
<br>
(mysql): SELECT * FROM cms_module_feusers_belongs WHERE userid='907'<br>
Error (0): <br>
Debug: (0.386477) - (13913696)
<br>
(mysql): SELECT * FROM cms_module_feusers_groups WHERE id='1'<br>
Error (0): <br>
Debug: (0.392341) - (13873208)
<br>
(mysql): SELECT A.*, B.hierarchy_id FROM cms_module_products A
LEFT JOIN cms_module_products_prodtohier B
ON A.id = B.product_id
WHERE A.id = 21<br>
Error (0): <br>
Debug: (0.394191) - (13908304)
<br>
(mysql): SELECT * FROM cms_module_products_fielddefs WHERE public > 0 ORDER BY item_order<br>
Error (0): <br>
Debug: (0.394568) - (13912264)
<br>
(mysql): SELECT b.* FROM cms_module_products_fielddefs a, cms_module_products_fieldvals b WHERE a.id = b.fielddef_id AND a.public > 0 and b.product_id = '21'<br>
Error (0): <br>
Debug: (0.395868) - (13919780)
<br>
(mysql): SELECT hierarchy_id FROM cms_module_products_prodtohier
WHERE product_id = 21 LIMIT 1<br>
Error (0): <br>
Debug: (0.396138) - (13920260)
<br>
(mysql): SELECT * FROM cms_module_products_hierarchy
WHERE id = '-1'<br>
Error (0): <br>
Debug: (0.396389) - (13920580)
<br>
(mysql): SELECT * FROM cms_module_products_attribsets
WHERE product_id = 21<br>
Error (0): <br>
Debug: (0.396638) - (13921372)
<br>
(mysql): SELECT * FROM cms_module_products_attributes
WHERE attrib_set_id IN () ORDER BY attrib_set_id ASC<br>
Error (1064): 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 ') ORDER BY attrib_set_id ASC' at line 2<br>
Debug: (0.396871) - (13921504)
<br>
(mysql): SELECT * FROM cms_module_products_categories<br>
Error (0): <br>
Debug: (0.397124) - (13922704)
<br>
(mysql): SELECT * FROM cms_module_products_category_fields
WHERE category_id = ?<br>
Error (1064): 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 2<br>
Debug: (0.397335) - (13923460)
<br>
(mysql): SELECT * FROM cms_module_products_category_fields
WHERE category_id = ?<br>
Error (1064): 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 2<br>
Debug: (0.397557) - (13923824)
<br>
(mysql): SELECT c.* FROM cms_module_products_product_categories c WHERE c.product_id = 21 ORDER BY c.category_id<br>
Error (0): <br>
Debug: (0.398359) - (13970712)
<br>
(mysql): SELECT content from cms_module_templates WHERE module_name = 'Products' and template_name = 'detail_Sample'<br>
Error (0): <br>
Debug: (0.408587) - (14048300)
<br>
(mysql): SELECT * FROM cms_module_products
WHERE id = 21<br>
Error (0): <br>
Debug: (0.411361) - (14159896)
start findNodeByTag
Debug: (0.411489) - (14160064)
end findNodeByTag
Debug: (0.411936) - (14162340)
<br>
(mysql): SELECT * FROM cms_module_products_attribsets
WHERE product_id = 21<br>
Error (0): <br>
Debug: (0.412616) - (14207904)
<br>
(mysql): SELECT content from cms_module_templates WHERE module_name = 'Cart' and template_name = 'addtocart_Sample'<br>
Error (0): <br>
Debug: (0.450752) - (14114524)
<br>
(mysql): SELECT * FROM cms_module_feusers_properties WHERE userid='907'<br>
Error (0): <br>
Debug: (0.451302) - (14041148)
<br>
(mysql): SELECT DISTINCT A.css_id,A.media_type,B.assoc_order
FROM cms_css A, cms_css_assoc B
WHERE A.css_id = B.assoc_css_id
AND B.assoc_type = 'template'
AND B.assoc_to_id = '29'
ORDER BY B.assoc_order<br>
Error (0): <br>
Debug: (0.451821) - (14009920)
calling module TinyMCE from event ContentPostRender
Debug: (0.452624) - (14009920)
calling module FrontEndUsers from event ContentPostRender
Re: Page stalling/hanging up
Posted: Thu Mar 18, 2010 6:05 pm
by Nullig
Try moving the {literal} tag, from:
{literal}
to:
{literal}
Nullig
Re: Page stalling/hanging up
Posted: Thu Mar 18, 2010 9:56 pm
by zaidcrowe
Thanks for the reply
I tried as you suggested - but get the same issue - sort of! Oddly the page now loads every other time, I dont know if this is a coincidence...?
The page is here:
http://www.dittosignup.com/?page=release-info-new - keep refreshing and you'll see the problem for yourself.
Re: Page stalling/hanging up
Posted: Thu Mar 18, 2010 10:21 pm
by zaidcrowe
another observation - again, dont know if this helps.
When I create new pages, their Titles have spaces replace with '+''s.
So 'Im a title' becomes 'Im+a+title'
Is this a know issue?
Re: Page stalling/hanging up
Posted: Thu Mar 18, 2010 11:49 pm
by Nullig
Don't know about the "+" problem, but you also have some MySQL errors in the Debug output:
(mysql): SELECT * FROM cms_module_products_attributes
WHERE attrib_set_id IN () ORDER BY attrib_set_id ASC
Error (1064): 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 ') ORDER BY attrib_set_id ASC' at line 2
Debug: (0.396871) - (13921504)
(mysql): SELECT * FROM cms_module_products_categories
Error (0):
Debug: (0.397124) - (13922704)
(mysql): SELECT * FROM cms_module_products_category_fields
WHERE category_id = ?
Error (1064): 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 2
Debug: (0.397335) - (13923460)
(mysql): SELECT * FROM cms_module_products_category_fields
WHERE category_id = ?
Error (1064): 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 2
Debug: (0.397557) - (13923824)
Nullig
Re: Page stalling/hanging up
Posted: Fri Mar 19, 2010 2:54 pm
by zaidcrowe
I've now removed the products tag ....same issue!
The only thing that makes the page normally is stripping out the smarty tags from within the head.
Any more ideas? Would anyone be willing to investigate this for a fee??
Zaid
Re: Page stalling/hanging up
Posted: Fri Mar 19, 2010 6:52 pm
by Nullig
I would try this:
Move the style info from the template to a stylesheet attached to the template.
Code: Select all
.FORMfields{background-color:#D9D2D2;}
select{background-color:#fff!important;display:inline!important;}
#release_date_start_calendar_link img{width:128px;height:128px;}
.display a img{width:200px;height:200px;}
Move the javascript to a to a Global Content Block, called "formfields":
Code: Select all
{literal}
if($.cookie('album_info_done')){
//window.location = '/create-new-release/upload.html';
}
function restrict(){return false;}
var theBarcode;
var selectLN = {/literal}{is_this_product_in_cart product = $actionparams.product}{if $exists}true;{else}false;{/if}{literal}
var doneLabel = false;
function arm_form(){
if(ownLabelName){
$('#label').append('<option value="'+ownLabelName+'" selected="selected">'+ownLabelName+'</option>');
}
$("#release_date_start_calendar_link img").attr("width","128px");
$("#release_date_start_calendar_link img").attr("height","128px");
$("a[href*='http://www.formfields.com']").parent().hide();
$('#customer_id').val({/literal}'{$customcontent_loggedin}'{literal});
$('#audio_folder').val('');
$('#your_label_name').attr('readonly',true);
if(selectLN == true){
$('#label option[value="name-reg-label"]').attr('selected', 'selected');
$('#your_label_name').removeAttr('readonly');
$('#your_label_name').val('');
}
$('.quantity').parents('form').ajaxForm({success:updateCart,url:'/'});
$('#barcode_UPC').parent().append('<a href="javascript:void(0);" id="gen_upc" class="btn">Generate this for me (free)</a>');
$('#label').change(function(){//START LABEL CHANGE
if($(this).val() == 'name-reg-label'){
//alert('update cart +/- name label');
//alert('reg label');
$.cookie('name-reg-label','false');
$.cookie('name-own-label','false');
doCart(1,true);
//return false;
}else if($(this).val() == 'use-own-label'){
//alert('use own');
$.cookie('name-reg-label','false');
$.cookie('name-own-label','true');
$('#your_label_name').removeAttr('readonly').val('').focus();
doCart(0,true);
//return false;
}else{
//alert('use-ditto');
$.cookie('name-reg-label','false');
$.cookie('name-own-label','false');
doCart(0,false);
//return false;
}
$('.quantity').parents('form').submit();
//alert('tried to submit');
});//END LABEL CHANGE
$('#gen_upc').click(function(){
$(this).html('Generating please wait...');
$.ajax({url:'/create-new-release/generate-barcode.html',success:function(data){
$('#barcode_UPC').val(data.substr(2,13));
$('#gen_upc').hide();
}});
});
$('.ffForm form').ajaxForm({url:'/modules/FORMfields/forms/generated/album_details.php',beforeSubmit: preloader,
success:function(data){
$response = $(data);
$('.ffForm').html($response.filter('.ffForm').html());
$('.ffForm').show();
if($('.ffConfirmation').length != 0){
$.cookie('album_info_done', theBarcode, { path: '/'});
$('.ffConfirmation').html('Thanks for your submission, you\'ll now be taken to upload your tracks!');
$('.ffRedirectNote').hide();
$('#besure').hide();
$('#gototracks').effect("pulsate", { times:3 }, 1000);
//alert($('#gototracks a').attr("href")+'?r='+theBarcode);
$('#gototracks a').attr("href", $('#gototracks a').attr("href")+'?r='+theBarcode);
$('#loading').remove();
alert("Thanks for your submission, you'll now be taken to upload your tracks!");
window.location = '/create-new-release/upload.html';
}else{
$('#loading').remove();
arm_form();
}
}});
}
function preloader(){
if($('#barcode_UPC').length !=0){
theBarcode = $('#barcode_UPC').val();
}
$('.ffForm').hide();
$('.big_tab').append('<div id="loading" style="text-align:center;"><img src="/images/ajax-loader.gif" style="display:inline;align:center;"><br/><strong>Processing...please wait...don\'t touch your keyboard...</strong></div>');
}
function setFocus(){return false;}
function doCart(myval,allowlabel){
//alert('docart-'+myval);
if(allowlabel){
$('#your_label_name').removeAttr('readonly');
$('#your_label_name').val('').focus();
}else{
$('#your_label_name').val('Select the appropriate option above to use this.');
$('#your_label_name').attr('readonly',true);
}
var quantityBox = $('#name-lebel-form form .quantity');
quantityBox.val(myval);
$('#cart').html('updating your cart...');
}
function updateCart(){
$.ajax({url:'/index.php?page=view-cart',success:function(data){
$('#cart').html(data);
$('a[rel*=facebox]').facebox();
}});
}
var ownLabelName = '{/literal}{$userprops.your_label_name}{literal}';
$(document).ready(function() {
$.cookie('name-own-label',null,{ path: '/', expires: 10 });
$('#cart').html('Getting cart...')
$.ajax({url:'/index.php?page=view-cart',success:function(data){
$('#cart').html(data);
$('a[rel*=facebox]').facebox();
}});
$('a[rel*=facebox]').facebox();
$('.big_tab').load('/modules/FORMfields/forms/generated/album_details.php .ffForm', function(){
arm_form();
}
);
});
{/literal}
Then simplify your template like this:
Code: Select all
{process_pagedata}
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<__html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>{sitename} - {title}</title>
{metadata}
{stylesheet}
{$feu_smarty->get_user_properties($customcontent_loggedin,'userprops')}
<link href="/facebox/facebox.css" media="screen" rel="stylesheet" type="text/css"/>
<__script__ src="/facebox/facebox.js" type="text/javascript"></__script>
<__script__ type="text/javascript" src="/modules/FORMfields/src/FORMfields.js"></__script>
<__script__ type="text/javascript" src="/modules/FORMfields/src/FORM.js"></__script>
{global_content name='formfields'}
</head>
</__body>
<!--Wrapper-->
<div id="wrapper">
<div class="round_big_top">
<ul>
<li><a href="javascript:void(0);"class="active">RELEASE INFO</a><span>//</span></li>
<li><a href="javascript:void(0);">UPLOAD CONTENT</a><span>//</span></li>
<li><a href="javascript:void(0);">TRACK INFO</a><span>//</span></li>
<li><a href="javascript:void(0);">RETAILERS</a><span>//</span></li>
<li><a href="javascript:void(0);">PAY</a></li>
</ul>
</div>
<div id="country-picker">
<div id="set_us"></div>
<div id="set_uk"></div>
<p>Select your currency:</p>
</div>
<!--Full round -->
<div class="fullround_box">
<!--Full round Nav-->
<div class="fullround_box_nav" id="floatMenu">
{global_content name='sub_menu'}
<div class="right" id="cart">{* Cart action='mycart' *}</div>
<!--End Full round Nav-->
</div>
<!--Full round box container-->
<div class="fullround_box_container" style="padding-top:40px;">
<div class="left" style="width:500px;">
<h3 class="margin_none">Your Release Info</h3>
{content}
</div>
<div class="right btn" id="gototracks">
<a href="/create-new-release/upload.html"><img src="images/arrow.png" alt="arrow" class="left" /> <h3>UPLOAD TRACKS</h3></a>
</div>
<div class="clear"></div><br />
<div class="big_tab" style="text-align:center;">
<img src="/images/ajax-loader.gif">
</div>
<div class="clear"></div><br />
<div style="text-align:center" id="besure">Once you submit this data, it cannot be amended!</div>
<div class="clear"></div><br />
<!--End Full round box container-->
</div>
<!--End Full round-->
</div>
<!--End Wrapper-->
</div>
<div id="name-lebel-form" style="display:none;">
{Products action='details' productid='21'}
</div>
<__body>
</__html>
Nullig
Re: Page stalling/hanging up
Posted: Fri Mar 19, 2010 6:56 pm
by zaidcrowe
I'll try this ASAP!
Thankyou so so much for putting your time into this, will keep you updated!
Zaid
Re: Page stalling/hanging up
Posted: Fri Mar 19, 2010 7:06 pm
by Nullig
Sorry, there's a line to delete in the template:
It's not needed. Originally, I was thinking you could put the javascript into a .js file, but then realised there was some smarty stuff in it.
Nullig
Re: Page stalling/hanging up
Posted: Fri Mar 19, 2010 8:03 pm
by zaidcrowe
You are a god amongst men - its working perfectly now
I can see how you've told me to do this is very much a best practise, tidy better way to have laid out and structure things - but can you hazard a guess as too why it caused the page to break?? Simple overload in processing the template?
Re: Page stalling/hanging up
Posted: Fri Mar 19, 2010 8:23 pm
by zaidcrowe
seems i spoke to soon
the page is again responding intermittently
Re: Page stalling/hanging up
Posted: Fri Mar 19, 2010 9:13 pm
by Nullig
It's working for me - in fact, this is the first time I've actually seen the page.
What is your operating environment? Can you post your "System Info"? and perhaps your config.php, xxx'ing out private info. Do you have a .htaccess file? If so, can you post it?
Nullig
Re: Page stalling/hanging up
Posted: Fri Mar 19, 2010 9:29 pm
by zaidcrowe
I'm going to live with it for a while, but I think it's working!
At some point in my tinkering I'd turned the cache option on in my config file, with your changes, and this in it's default off state it seems
to be working a charm.
I can't thank you enough
Re: Page stalling/hanging up
Posted: Sat Mar 20, 2010 4:19 am
by Dr.CSS
If the page uses FEU it needs to have the cache turned of on the page options tab...