Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

[FIXED] SandBox Error 06 Jun 2013 10:22 #7383

  • liubov
  • liubov's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
  • (=) 10 mn and it's ready!
  • Posts: 279
  • Thank you received: 36
Hi,

So I ve restart my Project in V2 environment, but can not go far due to the same SandBox Crash I had previously, in Install Component Step

JInstaller: :Install: Error SQL DB function failed with error number 1071

www.j-cook.pro/builder :
Projet: HPC7000
SandBox: J16-17-25

Could you check where is the trouble please ?

Marc

Please Log in or Create an account to join the conversation.

Last edit: by liubov.

Re: SandBox Error 06 Jun 2013 19:14 #7387

  • liubov
  • liubov's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
  • (=) 10 mn and it's ready!
  • Posts: 279
  • Thank you received: 36
I found the bug of the SandBox installer. (without seeing the code, just result of SQL installer ...

In my Projet, HPC7000, I ve a table named 'reseaux' with 3 fields (id, name, vlan_id).

'name' and 'vlan_id' are Unique so I checked Required and Unique in Properties => SandBox Crash! :(

Bug is here :
JInstaller: :Install: Error SQL DB function failed with error number 1071
Specified key was too long; max key length is 1000 bytes SQL=CREATE TABLE IF NOT EXISTS `[PREFIX]demo9139_reseaux` ( `id` int(11) NOT NULL auto_increment, `params` text NOT NULL DEFAULT '', `name` VARCHAR(255) NOT NULL , `vlan_id` VARCHAR(255) NOT NULL , PRIMARY KEY (`id`), UNIQUE(name, vlan_id) );



I f only 'name' is checked => no SandBox crash. :)

Please Log in or Create an account to join the conversation.

Last edit: by liubov.

Re: SandBox Error 07 Jun 2013 05:52 #7389

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
I think I know, but I am not sure...

Try to reduce the size of id(11) or name(255) or vlan_id(255),

Because unique key can only handle a total size of 255.

This issue is not handled by cook. It has been discovered by audibleid if I remember well.
Coding is now a piece of cake

Please Log in or Create an account to join the conversation.

Re: SandBox Error 07 Jun 2013 06:26 #7390

  • liubov
  • liubov's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
  • (=) 10 mn and it's ready!
  • Posts: 279
  • Thank you received: 36
OK, i see....

Well done, it works!

Thanks

Please Log in or Create an account to join the conversation.

Last edit: by liubov.
  • Page:
  • 1
Time to create page: 0.078 seconds

Although I found this tool some time ago I just started learning experimenting and building this first component on Monday and now on Thursday afternoon it's already online. Although I already had a working version done with another tool this is much easier to build and at the end you have the freedom to own your own component. Once you know how to use Cook you will boost your productivity as the learning curve is really moderate compared to many other tools.
Giori (Forum)

Get Started