Welcome, Guest
Username: Password: Remember me

TOPIC: JInstaller: :Install: Error SQL DB function failed

JInstaller: :Install: Error SQL DB function failed 29 Jan 2013 06:05 #6548

  • organicwebs
  • organicwebs's Avatar
  • Offline
  • Premium Member
  • Chris
  • Posts: 112
  • Thank you received: 19
  • Karma: 8
Getting JInstaller error in the sandbox. I'm not using anything complex - just basic tables and form fields. Happened after changing the form. I think JCook gui has gotten confused?? (Like me :blink: )

Help!

V2.0 Beta,
JS Framework: jQUERY
Embed Framework: No
Form style: Condensed
Features: JDom complete
TODO: No

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]demo6062_members` ( `id` int(11) NOT NULL auto_increment, `params` text NOT NULL DEFAULT '', `membership_number` VARCHAR(255) , `joomla_user` INT(11) , `username` VARCHAR(255) NOT NULL , `member_name` VARCHAR(255) NOT NULL , `password` VARCHAR(255) , `email` VARCHAR(255) NOT NULL , `company_id` INT(11) , `address` VARCHAR(255) , `state` VARCHAR(255) , `postcode` VARCHAR(255) , `phone` VARCHAR(255) , `mobile` VARCHAR(255) , `notes` TEXT , `ordering` INT(11) , `access` INT(11) DEFAULT 1 , `created_by` INT(11) , `created_date` DATE , `modified_by` INT(11) , `modification_date` DATE , `checked_out` INT(11) NOT NULL DEFAULT 0 , `checked_out_time` DATETIME , `published` TINYINT , PRIMARY KEY (`id`), UNIQUE(username, email) );
SQL =

CREATE TABLE IF NOT EXISTS `#__demo6062_members` (
	`id` int(11) NOT NULL auto_increment,
	`params` text NOT NULL DEFAULT '',
	`membership_number` VARCHAR(255) ,
	`joomla_user` INT(11) ,
	`username` VARCHAR(255) NOT NULL ,
	`member_name` VARCHAR(255) NOT NULL ,
	`password` VARCHAR(255) ,
	`email` VARCHAR(255) NOT NULL ,
	`company_id` INT(11) ,
	`address` VARCHAR(255) ,
	`state` VARCHAR(255) ,
	`postcode` VARCHAR(255) ,
	`phone` VARCHAR(255) ,
	`mobile` VARCHAR(255) ,
	`notes` TEXT ,
	`ordering` INT(11) ,
	`access` INT(11) DEFAULT 1 ,
	`created_by` INT(11) ,
	`created_date` DATE ,
	`modified_by` INT(11) ,
	`modification_date` DATE ,
	`checked_out` INT(11) NOT NULL DEFAULT 0 ,
	`checked_out_time` DATETIME ,
	`published` TINYINT ,

	PRIMARY KEY  (`id`),
	UNIQUE(username, email)
);
Just call me Chris :)
The administrator has disabled public write access.

Re: JInstaller: :Install: Error SQL DB function failed 29 Jan 2013 06:40 #6549

  • organicwebs
  • organicwebs's Avatar
  • Offline
  • Premium Member
  • Chris
  • Posts: 112
  • Thank you received: 19
  • Karma: 8
It happens when setting a table field "username" or "email" to Unique, in the JCook table gui,

But it works if I set field any other field like "membership_number" as unique.

Even when I rename "username" and "email" to something else and set it to unique - it fails.

Weird...

Similar issue to this I guess - but I am not joining strings or have control over the sandbox MySQL...
www.j-cook.pro/forum/32-trouble-shooting...le-fails-at-sql#3873
Just call me Chris :)
The administrator has disabled public write access.

Re: JInstaller: :Install: Error SQL DB function failed 29 Jan 2013 07:12 #6550

  • JoomGuy
  • JoomGuy's Avatar
  • Offline
  • Moderator
  • Joomla Enthusiast, Lover of Cooking
  • Posts: 1115
  • Thank you received: 195
  • Karma: 68
It's because the max potential length of the input fields is too great. Indexes on these columns would be too large.
*******ADD*******
UTF-8 encoded characters can take up to 6 bytes each. The length of both fields you are creating indexes on total 510 characters and therefore, they too large to index. You can change the max length of each field by specifying a length property for each in the field's properties.
********************

Gez
Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!!
Last Edit: 30 Jan 2013 13:14 by JoomGuy. Reason: ADD
The administrator has disabled public write access.
The following user(s) said Thank You: organicwebs

Re: JInstaller: :Install: Error SQL DB function failed 30 Jan 2013 13:06 #6559

  • JoomGuy
  • JoomGuy's Avatar
  • Offline
  • Moderator
  • Joomla Enthusiast, Lover of Cooking
  • Posts: 1115
  • Thank you received: 195
  • Karma: 68
Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!!
The administrator has disabled public write access.
The following user(s) said Thank You: organicwebs
Time to create page: 0.069 seconds

Get Started