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.109 seconds

This is what you call a component builder. I was able to master using this in a very short time and the resulting component works like a charm. Not just a basic component builder but a fully working component builder with forms fields tables all ready to go. You can make the list and item views to display in the front and back end. Also there is a great forum just starting to evolve and I'm sure this will grow very rapidly when you all realise how good this tool is.
Kevin (JED)

         

Get Started