Custom Block installation fails

Permalink
Hi,

I developed a custom block for concrete5 and I installed it on my localhost, after trying to install it in my website it fails.

Procedure:
- I upload the block
- I go to the 'add functionality'
- I install my custom block

and thats it, concrete5 give me the message, that it has been installed but it isn't

I would appreciate any help

thanks in advance

 
12345j replied on at Permalink Reply
12345j
can you see it in the add functionality page? is there a permission issue? have you cleared cache?
nufuk replied on at Permalink Reply
Hi,
yes I cleared the cache,
and I can see it in the add functionality page
and the folder and all files have the same permission as the basicTest block, which can be installed.
Maybe other issues?
My page runs on version: 5.4.0.5
nufuk replied on at Permalink Reply
after upgrading I got the following error:
mysql 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 ' language VARCHAR, showurl VARCHAR, ' at line 3] in EXECUTE("CREATE TABLE btLikeButton ( bID INTEGER UNSIGNED NOT NULL, apiKey VARCHAR, language VARCHAR, showurl VARCHAR, PRIMARY KEY (bID) )")

which is caused by the following XML lines:
<schema version="0.3">
   <table name="btLikeButton">
      <field name="bID" type="I">
         <key />
         <unsigned />
      </field>
      <field name="apiKey" type="C">
      </field>
      <field name="language" type="C">
      </field>
      <field name="showurl" type="C">
      </field>
   </table>
</schema>


anyone here got maybe a similar problem?
nufuk replied on at Permalink Best Answer Reply
After ugrading it, the error message got better.

So, if the XML for the database is wrong it give in a older version of Concrete5 no error message and just gives the same respond as it is installed succesfully

After fixing my wrong XML schema the installation was successfull

<schema version="0.3">
   <table name="btLikeButton">
      <field name="bID" type="I">
         <key />
         <unsigned />
      </field>
      <field name="apiKey" type="C" size="32">
      </field>
      <field name="language" type="C" size="8">
      </field>
      <field name="showurl" type="C" size="4">
      </field>
   </table>
</schema>

The size was missing for the varchars