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

  Joomla Developpers won't be able to live without J-Cook's Component Creator! Check it out - it'll save you a heap of time coding so you can concentrate on the creative part of developing!
Mind-Your-Biz-Online

Get Started