Monitor Reply

Support

Problem with installation of Equinox

Permalink Browser Info Environment August 22, 2016 at 1:18 AM

When trying to install the Equinox theme the following error message came up:

An exception occurred while executing 'INSERT INTO btTestimonial (bID, fID, name, position, company, companyURL, paragraph) VALUES (?, ?, ?, ?, ?, ?, ?)' with params ["199", "", "Joe Bloggs", "Director", "JB Limited", "", "Praesent bibendum mauris urna, scelerisque commodo neque elementum id. Vivamus congue purus eget placerat rutrum. Phasellus lacus dolor, laoreet eu ligula id, auctor vulputate velit. Phasellus congue mauris lacus, ut. "]: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'fID' at row 1

Please help as I have no idea what to do. Thanks!

Type:	Pre-Sale
Status:	In Progress

c5hub replied on Aug 22, 2016 at 5:34 am Permalink Reply

This error relates to an image added to a dummy testimonial block with the sample content...

We are unable to replicate the issue at present but as a work around there should be a way to fix this.

First you will beed to uninstall the 'Equinox' package and then you will need access to the packages files on your server...

You will need to open this file - packages/equinox/content.xml

Please then remove lines 812 - 844:

<blocks>
  <block type="content" name="">
    <data table="btContentLocal">
      <record>
        <content><![CDATA[<h3>  What Our Customers Say  </h3>]]></content>
      </record>
    </data>
  </block>
  <block type="testimonial" name="">
    <data table="btTestimonial">
      <record>
        <fID/>
        <name><![CDATA[Joe Bloggs]]></name>
        <position><![CDATA[Director]]></position>
        <company><![CDATA[JB Limited]]></company>

Viewing 15 lines of 33 lines. View entire code block.

 
<blocks>
  <block type="content" name="">
    <data table="btContentLocal">
      <record>
        <content><![CDATA[<h3>  What Our Customers Say  </h3>]]></content>
      </record>
    </data>
  </block>
  <block type="testimonial" name="">
    <data table="btTestimonial">
      <record>
        <fID/>
        <name><![CDATA[Joe Bloggs]]></name>
        <position><![CDATA[Director]]></position>
        <company><![CDATA[JB Limited]]></company>
        <companyURL><![CDATA[]]></companyURL>
        <paragraph><![CDATA[Praesent bibendum mauris urna, scelerisque commodo neque elementum id. Vivamus congue purus eget placerat rutrum. Phasellus lacus dolor, laoreet eu ligula id, auctor vulputate velit. Phasellus congue mauris lacus, ut. ]]></paragraph>
      </record>
    </data>
  </block>
  <block type="testimonial" name="">
    <data table="btTestimonial">
      <record>
        <fID/>
        <name><![CDATA[S. Omebody]]></name>
        <position><![CDATA[CEO]]></position>
        <company><![CDATA[Big Real Estate]]></company>
        <companyURL><![CDATA[]]></companyURL>
        <paragraph><![CDATA[Proin tellus mauris, bibendum vel convallis quis, dapibus at nunc. Cras ullamcorper nec dolor at lobortis. Donec lobortis laoreet velit in dignissim. Aliquam sit amet porttitor ipsum. Vestibulum ante ipsum. ]]></paragraph>
      </record>
    </data>
  </block>
</blocks>

Then re-install and you should no longer get an issue. I hope this helps.

Equinox

Support

Problem with installation of Equinox

Issue Reply

concrete5 Environment Information

Browser User-Agent String

Hide Post Content

Request Refund

Code

Delete Post