Editing Records - (followed the tutorial)

crea2k 10 Dec, 2011
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 :

<!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
GreyHead 13 Dec, 2011
Hi crea2k,

Did you post somewhere else that you now have this working?

Bob
crea2k 19 Dec, 2011
Yes it works now thankyou, im not sure what I did to fix it though, I was working on it late at night (never a good idea) and managed to get it working fine the next day in five mins.
This topic is locked and no more replies can be posted.