Problem with installation of Equinox

Permalink Browser Info Environment
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
View Replies:
c5hub replied on at Permalink Reply
c5hub
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>

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

concrete5 Environment Information

HP TouchSmart 520 PC with Windows 7 Home Premium

Browser User-Agent String

Chrome Version 52.0.2743.116 m

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.