Welcome, Guest

TOPIC: [FIXED] SandBox Error

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

liubov Offline Elite Member (=) 10 mn and it's ready! Posts: 279 Thank you received: 36 Karma: 22	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
	Last Edit: 06 Jun 2013 16:27 by liubov. The administrator has disabled public write access.

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

liubov
Offline
Elite Member
(=) 10 mn and it's ready!
Posts: 279
Thank you received: 36
Karma: 22

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.

Last Edit: 06 Jun 2013 19:17 by liubov.

The administrator has disabled public write access.

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

admin Offline Administrator Chef Posts: 3711 Thank you received: 987 Karma: 140	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 The administrator has disabled public write access.

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

liubov Offline Elite Member (=) 10 mn and it's ready! Posts: 279 Thank you received: 36 Karma: 22	OK, i see.... Well done, it works! Thanks
	Last Edit: 07 Jun 2013 06:29 by liubov. The administrator has disabled public write access.

Forum

Debug

Closed tickets.

[FIXED] SandBox Error

TOPIC: [FIXED] SandBox Error

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

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

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

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

Get Started

Newsletter