Hi, I have followed the tutorial for the DB MULTI RECORD LOADER, when loading the display form it displays all the records that have been added using the adding form. The problem I have having is the edit function isnt working. When I click the edit button it takes me to :
http://127.0.0.1:4001/chandlers/index.php?option=com_chronoforms&chronoform=addupdatelead&token=b6f8dcfa61bec33f0b570723d21255d2
but for some reason isnt loading the data into the form fields, I just get a blank form, the form appears to work for entering data though and after submitting appears in the database and on the the viewer page but for some reason isnt loading the data into the fields as it should.
This is the form I have designed :
This is the debug info when the edit button is pressed :
http://127.0.0.1:4001/chandlers/index.php?option=com_chronoforms&chronoform=addupdatelead&token=b6f8dcfa61bec33f0b570723d21255d2
but for some reason isnt loading the data into the form fields, I just get a blank form, the form appears to work for entering data though and after submitting appears in the database and on the the viewer page but for some reason isnt loading the data into the fields as it should.
This is the form I have designed :
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style>.form-field {margin-left:5px;} .section-title {font-weight:bold;} body{font-size:13px;} tr, td {border:none !important;}#all {width:2000px !important;} </style>
</head>
<body>
<table style="border:none;" width="1176" border="0">
<tr>
<td width="153"><input type="submit" name="viewallleads" id="viewallleads" value="View All Leads" /></td>
<td width="66" align="right"> </td>
<td width="450" class="section-title">Add / Update A Lead</td>
<td width="489" rowspan="5" valign="top"><table width="450" border="0">
<tr>
<td colspan="3" class="section-title">Lead Marketing History</td>
<td width="101"> </td>
</tr>
<tr>
<td width="142">Sent Letter</td>
<td width="63"><select name="sentletterday" id="sentletterday">
<option value="NA" selected="selected">NA</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select></td>
<td width="126"><select name="sentlettermonth" class="form-field" id="sentlettermonth">
<option value="NA" selected="selected">NA</option>
<option value="january">January</option>
<option value="february">February</option>
<option value="march">March</option>
<option value="april">April</option>
<option value="may">May</option>
<option value="june">June</option>
<option value="july">July</option>
<option value="august">August</option>
<option value="septemeber">September</option>
<option value="october">October</option>
<option value="november">November</option>
<option value="december">December</option>
</select></td>
<td><select name="sentletteryear" id="sentletteryear">
<option value="NA" selected="selected">NA</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
<option value="2021">2021</option>
<option value="2022">2022</option>
<option value="2023">2023</option>
<option value="2024">2024</option>
<option value="2025">2025</option>
<option value="2026">2026</option>
<option value="2027">2027</option>
<option value="2028">2028</option>
<option value="2029">2029</option>
<option value="2030">2030</option>
</select></td>
</tr>
<tr>
<td>Send Postcard</td>
<td><select name="sentpostcardday" id="sentpostcardday">
<option value="NA" selected="selected">NA</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select></td>
<td><select name="sentpostcardmonth" class="form-field" id="sentpostcardmonth">
<option value="NA" selected="selected">NA</option>
<option value="january">January</option>
<option value="february">February</option>
<option value="march">March</option>
<option value="april">April</option>
<option value="may">May</option>
<option value="june">June</option>
<option value="july">July</option>
<option value="august">August</option>
<option value="septemeber">September</option>
<option value="october">October</option>
<option value="november">November</option>
<option value="december">December</option>
</select></td>
<td><select name="sentpostcardyear" id="sentpostcardyear">
<option value="NA" selected="selected">NA</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
<option value="2021">2021</option>
<option value="2022">2022</option>
<option value="2023">2023</option>
<option value="2024">2024</option>
<option value="2025">2025</option>
<option value="2026">2026</option>
<option value="2027">2027</option>
<option value="2028">2028</option>
<option value="2029">2029</option>
<option value="2030">2030</option>
</select></td>
</tr>
<tr>
<td>Sent Quote</td>
<td><select name="sentquoteday" id="sentquoteday">
<option value="NA" selected="selected">NA </option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select></td>
<td><select name="sentquotemonth" class="form-field" id="sentquotemonth">
<option value="NA" selected="selected">NA</option>
<option value="january">January</option>
<option value="february">February</option>
<option value="march">March</option>
<option value="april">April</option>
<option value="may">May</option>
<option value="june">June</option>
<option value="july">July</option>
<option value="august">August</option>
<option value="septemeber">September</option>
<option value="october">October</option>
<option value="november">November</option>
<option value="december">December</option>
</select></td>
<td><select name="sentquoteyear" id="sentquoteyear">
<option value="NA" selected="selected">NA</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
<option value="2021">2021</option>
<option value="2022">2022</option>
<option value="2023">2023</option>
<option value="2024">2024</option>
<option value="2025">2025</option>
<option value="2026">2026</option>
<option value="2027">2027</option>
<option value="2028">2028</option>
<option value="2029">2029</option>
<option value="2030">2030</option>
</select></td>
</tr>
</table></td>
</tr>
<tr>
<td><input type="submit" name="addnewlead" id="addnewlead" value="Add New Lead" /></td>
<td align="right" valign="middle">Name</td>
<td><span class="ccms_form_element cfdiv_text">
<input id="leadname" maxlength="150" size="30" class="form-field" title="leadname" label_over="0" hide_label="0" type="text" value="" name="leadname" />
</span></td>
</tr>
<tr>
<td><input type="submit" name="messagetemplates" id="messagetemplates" value="Message Templates" /></td>
<td align="right" valign="middle">Salutation</td>
<td><span class="ccms_form_element cfdiv_text">
<input id="salutation" maxlength="150" size="30" class="form-field" title="salutation" label_over="0" hide_label="0" type="text" value="" name="salutation" />
</span></td>
</tr>
<tr>
<td><input type="submit" name="emailmanagement" id="emailmanagement" value="Email Management" /></td>
<td align="right" valign="middle">Business </td>
<td><span class="ccms_form_element cfdiv_text">
<input id="businessname" maxlength="150" size="30" class="form-field" title="businessname" label_over="0" hide_label="0" type="text" value="" name="businessname" />
</span></td>
</tr>
<tr>
<td> </td>
<td align="right" valign="middle">Address 1</td>
<td><span class="ccms_form_element cfdiv_text">
<input id="address1" maxlength="150" size="30" class="form-field" title="address1" label_over="0" hide_label="0" type="text" value="" name="address1" />
</span></td>
</tr>
<tr>
<td><input style="background:#FAE5E5" type="submit" name="deletelead" id="deletelead" value="Delete Lead" /></td>
<td align="right" valign="middle">Address 2</td>
<td><span class="ccms_form_element cfdiv_text">
<input id="address2" maxlength="150" size="30" class="form-field" title="address2" label_over="0" hide_label="0" type="text" value="" name="address2" />
</span></td>
<td style="border-bottom:solid #000 1px;"> </td>
</tr>
<tr>
<td> </td>
<td align="right" valign="middle">Address 3</td>
<td><span class="ccms_form_element cfdiv_text">
<input id="address3" maxlength="150" size="30" class="form-field" title="address3" label_over="0" hide_label="0" type="text" value="" name="address3" />
</span></td>
<td> </td>
</tr>
<tr>
<td height="27"> </td>
<td align="right" valign="middle">Address 4</td>
<td><span class="ccms_form_element cfdiv_text">
<input id="address4" maxlength="150" size="30" class="form-field" title="address4" label_over="0" hide_label="0" type="text" value="" name="address4" />
</span></td>
<td rowspan="6" valign="top"><table width="450" border="0">
<tr>
<td colspan="2" class="section-title">Lead Communication - Emails</td>
<td width="99" class="section-title">Last Sent</td>
</tr>
<tr>
<td width="139"><input type="submit" name="thankyouemail" id="thankyouemail" value="Thank You" /></td>
<td width="198">For seeing me</td>
<td>None Sent</td>
</tr>
<tr>
<td><input type="submit" name="sorryemail" id="sorryemail" value="Sorry" /></td>
<td>If they were upset at the call/visit</td>
<td>None Sent</td>
</tr>
<tr>
<td><input type="submit" name="reminderemail" id="reminderemail" value="Reminder" /></td>
<td>No Contact Recently</td>
<td>None Sent</td>
</tr>
<tr>
<td><input type="submit" name="orderthankyouemail" id="orderthankyouemail" value="Order Thank You" /></td>
<td>Prospect Ordered</td>
<td>None Sent</td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
<td align="right" valign="middle">County</td>
<td><span class="ccms_form_element cfdiv_text">
<input id="county" maxlength="150" size="30" class="form-field" title="county" label_over="0" hide_label="0" type="text" value="" name="county" />
</span></td>
</tr>
<tr>
<td> </td>
<td align="right" valign="middle">Post Code</td>
<td><span class="ccms_form_element cfdiv_text">
<input id="postcode" maxlength="150" size="30" class="form-field" title="postcode" label_over="0" hide_label="0" type="text" value="" name="postcode" />
</span></td>
</tr>
<tr>
<td height="24"> </td>
<td align="right" valign="middle">Gas Oil</td>
<td rowspan="4"><table width="450" border="0">
<tr>
<td width="30"><span class="ccms_form_element cfdiv_text">
<input name="gasoiluser" type="checkbox" class="form-field" id="gasoiluser" value="yes" />
</span></td>
<td width="222">Annual Consumption (Litres)</td>
<td width="61"><span class="ccms_form_element cfdiv_text">
<input id="annualconsgasoil" maxlength="150" size="8" class="form-field" title="annualconsgasoil" label_over="0" hide_label="0" type="text" value="" name="annualconsgasoil" />
</span></td>
<td width="54" align="center">Margin</td>
<td width="61"><span class="ccms_form_element cfdiv_text">
<input id="gasoilmargin" maxlength="150" size="8" class="form-field" title="gasoilmargin" label_over="0" hide_label="0" type="text" value="" name="gasoilmargin" />
</span></td>
</tr>
<tr>
<td><span class="ccms_form_element cfdiv_text">
<input name="dervuser" type="checkbox" class="form-field" id="dervuser" value="yes" />
</span></td>
<td>Annual Consumption (Litres)</td>
<td><span class="ccms_form_element cfdiv_text">
<input id="annualconsderv" maxlength="150" size="8" class="form-field" title="annualconsderv" label_over="0" hide_label="0" type="text" value="" name="annualconsgasderv" />
</span></td>
<td align="center">Margin</td>
<td><span class="ccms_form_element cfdiv_text">
<input id="dervmargin" maxlength="150" size="8" class="form-field" title="dervmargin" label_over="0" hide_label="0" type="text" value="" name="dervmargin" />
</span></td>
</tr>
<tr>
<td><span class="ccms_form_element cfdiv_text">
<input name="kerouser" type="checkbox" class="form-field" id="kerouser" value="yes" />
</span></td>
<td>Annual Consumption (Litres)</td>
<td><span class="ccms_form_element cfdiv_text">
<input id="annualconskero" maxlength="150" size="8" class="form-field" title="annualconskero" label_over="0" hide_label="0" type="text" value="" name="annualconskero" />
</span></td>
<td align="center">Margin</td>
<td><span class="ccms_form_element cfdiv_text">
<input id="keromargin" maxlength="150" size="8" class="form-field" title="keromargin" label_over="0" hide_label="0" type="text" value="" name="keromargin" />
</span></td>
</tr>
</table></td>
</tr>
<tr>
<td height="17"> </td>
<td align="right" valign="middle"> </td>
</tr>
<tr>
<td height="17"> </td>
<td align="right" valign="middle">Derv </td>
</tr>
<tr>
<td height="24"> </td>
<td align="right" valign="middle">Kero </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td align="right" valign="middle">Fuel Details</td>
<td rowspan="4" valign="top"><textarea name="fueldetails" cols="50" rows="6" class="form-field" id="fueldetails"></textarea></td>
<td style="border-top:solid #000 1px;"> </td>
</tr>
<tr>
<td> </td>
<td align="right" valign="middle"> </td>
<td rowspan="5" valign="top"><table width="450" border="0">
<tr>
<td colspan="2" class="section-title">Lead Communication - Post / PDF</td>
<td width="98" class="section-title">Last Sent</td>
</tr>
<tr>
<td width="139"><input type="submit" name="thankyoupostPDF" id="thankyoupostPDF" value="Thank You" /></td>
<td width="199">For seeing me</td>
<td>None Sent</td>
</tr>
<tr>
<td><input type="submit" name="sorrypostPDF" id="sorrypostPDF" value="Sorry" /></td>
<td>If they were upset at the call/visit</td>
<td>None Sent</td>
</tr>
<tr>
<td><input type="submit" name="remindpostPDF" id="remindpostPDF" value="Reminder" /></td>
<td>No Contact Recently</td>
<td>None Sent</td>
</tr>
<tr>
<td><input type="submit" name="orderthankyoupostPDF" id="orderthankyoupostPDF" value="Order Thank You" /></td>
<td>Prospect Ordered</td>
<td>None Sent</td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
<td align="right" valign="middle"> </td>
</tr>
<tr>
<td height="24"> </td>
<td align="right" valign="middle"> </td>
</tr>
<tr>
<td height="43"> </td>
<td align="right" valign="middle">Lubes Details</td>
<td rowspan="3" valign="top"><textarea name="lubesdetails" cols="50" rows="6" class="form-field" id="lubesdetails"></textarea></td>
</tr>
<tr>
<td height="43"> </td>
<td align="right" valign="middle"> </td>
</tr>
<tr>
<td> </td>
<td align="right" valign="middle"> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td align="right" valign="middle">Other Notes</td>
<td rowspan="5" valign="top"><textarea name="othernotes" cols="50" rows="6" class="form-field" id="othernotes"></textarea></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td align="right" valign="middle"> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td align="right" valign="middle"> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td align="right" valign="middle"> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td align="right" valign="middle"> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td align="right" valign="middle"> </td><input name="cf_id" type="hidden" id="cf_id" value="" />
<td><input type="submit" name="updatelead" id="updatelead" value="Update" /></td>
<td> </td>
</tr>
</table>
</body>
</html>
This is the debug info when the edit button is pressed :
Profile Information
Application 0.002 seconds (+0.002); 0.74 MB (+0.737) - afterLoad
Application 0.073 seconds (+0.071); 3.53 MB (+2.790) - afterInitialise
Application 0.086 seconds (+0.013); 4.06 MB (+0.529) - afterRoute
Application 0.147 seconds (+0.061); 5.29 MB (+1.238) - afterDispatch
Application 0.170 seconds (+0.023); 5.99 MB (+0.701) - beforeRenderModule mod_menu (Main Menu)
Application 0.181 seconds (+0.011); 6.10 MB (+0.102) - afterRenderModule mod_menu (Main Menu)
Application 0.182 seconds (+0.000); 6.09 MB (-0.004) - beforeRenderModule mod_login (Login Form)
Application 0.187 seconds (+0.005); 6.12 MB (+0.026) - afterRenderModule mod_login (Login Form)
Application 0.188 seconds (+0.001); 6.12 MB (-0.002) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.193 seconds (+0.006); 6.18 MB (+0.062) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.196 seconds (+0.003); 6.26 MB (+0.083) - afterRender
Memory Usage
6.28 MB (6,588,936 Bytes)
12 Queries Logged
SELECT `data`
FROM `hqfjt_session`
WHERE `session_id` = '53dc3944fd95fa953ede2ab086da529e'
SELECT folder AS type, element AS name, params
FROM hqfjt_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
SELECT extension_id AS "id", element AS "option", params, enabled
FROM hqfjt_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM hqfjt_menu AS m
LEFT JOIN hqfjt_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT extension_id AS "id", element AS "option", params, enabled
FROM hqfjt_extensions
WHERE `type` = 'component'
AND `element` = 'com_chronoforms'
SELECT *
FROM hqfjt_languages
WHERE published=1
ORDER BY ordering ASC
SELECT id, home, template, s.params
FROM hqfjt_template_styles as s
LEFT JOIN hqfjt_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT *
FROM `hqfjt_chronoforms`
WHERE `name` = 'addupdatelead'
AND `published` = '1'
SELECT *
FROM `hqfjt_chronoform_actions`
WHERE `chronoform_id` = '4'
ORDER BY `
order`
SELECT *
FROM `hqfjt_extensions`
WHERE `element` = 'com_chronoforms'
AND `type` = 'component'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM hqfjt_modules AS m
LEFT JOIN hqfjt_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN hqfjt_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2011-12-10 22:25:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-12-10 22:25:25')
AND m.access IN (1,1,2,3)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
UPDATE `hqfjt_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:149;s:19:\"session.timer.start\";i:1323533825;s:18:\"session.timer.last\";i:1323555657;s:17:\"session.timer.now\";i:1323555924;s:22:\"session.client.browser\";s:106:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.121 Safari/535.2\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:0:{}}}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:19:\"crea@cruiseit.co.uk\";s:8:\"password\";s:65:\"0c67f7fe9b9e97139ed2719123d1ed7a:p5UbCNazRakiJq01ICE6GPh4JfJpbhAH\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-12-09 18:42:46\";s:13:\"lastvisitDate\";s:19:\"2011-12-10 17:20:27\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"999946154443da0266d143c48401b78f\";}__eb81adcc4edfeccb1ba0f16dfe1a737f|a:1:{s:19:\"chrono_verification\";s:32:\"d49e8617258efe65782c83e2e6e51c89\";}', `time` = 1323555925
WHERE `session_id` = '53dc3944fd95fa953ede2ab086da529e'
11 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT extension_id AS "id", element AS "option", params, enabled FROM hqfjt_extensions
1 × SELECT * FROM `hqfjt_chronoform_actions`
1 × SELECT * FROM `hqfjt_extensions`
1 × SELECT * FROM `hqfjt_chronoforms`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM hqfjt_modules AS m LEFT JOIN hqfjt_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN hqfjt_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT * FROM hqfjt_languages
1 × SELECT folder AS type, element AS name, params FROM hqfjt_extensions
1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM hqfjt_menu AS m LEFT JOIN hqfjt_extensions AS e ON m.component_id = e.extension_id
1 × SELECT `data` FROM `hqfjt_session`
1 × SELECT id, home, template, s.params FROM hqfjt_template_styles as s LEFT JOIN hqfjt_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
OTHER Tables:
1 × UPDATE `hqfjt_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:149;s:19:\"session.timer.start\";i:1323533825;s:18:\"session.timer.last\";i:1323555657;s:17:\"session.timer.now\";i:1323555924;s:22:\"session.client.browser\";s:106:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.121 Safari/535.2\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:0:{}}}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:19:\"crea@cruiseit.co.uk\";s:8:\"password\";s:65:\"0c67f7fe9b9e97139ed2719123d1ed7a:p5UbCNazRakiJq01ICE6GPh4JfJpbhAH\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-12-09 18:42:46\";s:13:\"lastvisitDate\";s:19:\"2011-12-10 17:20:27\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"999946154443da0266d143c48401b78f\";}__eb81adcc4edfeccb1ba0f16dfe1a737f|a:1:{s:19:\"chrono_verification\";s:32:\"d49e8617258efe65782c83e2e6e51c89\";}', `time` = 1323555925
This topic is locked and no more replies can be posted.