0
Welcome Guest! Login
0 items Join Now

All parts of a PRIMARY KEY must be NOT NULL

Last Post
Search Topic

  • All parts of a PRIMARY KEY must be NOT NULL

    Posted 8 years 10 months ago
    • I'm getting the following error when installing RokGallery on a fresh Joomla 3.5.1 site. From what I have read about similar errors, I think RokGallery is not compatible with newer versions of MySQL. I'm on MySQL 5.7.12, which is what installs by default on Ubuntu 16.04.
      All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead SQL=CREATE TABLE IF NOT EXISTS `#__rokgallery_files` ( `id` INT UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT , `filename` VARCHAR(255) NOT NULL , `guid` CHAR(36) NOT NULL , `md5` CHAR(32) NOT NULL , `title` VARCHAR(200) NOT NULL , `description` TEXT NULL DEFAULT NULL , `license` VARCHAR(255) NULL DEFAULT NULL , `xsize` INT UNSIGNED NOT NULL , `ysize` INT UNSIGNED NOT NULL , `filesize` INT UNSIGNED NOT NULL , `type` CHAR(20) NOT NULL , `published` TINYINT(1) NOT NULL DEFAULT '0' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , `slug` VARCHAR(255) NULL DEFAULT NULL , UNIQUE INDEX (`id` ASC) , UNIQUE INDEX (`guid` ASC) , INDEX `#__rokgallery_files_published_idx` (`published` ASC) , INDEX `#__rokgallery_files_md5_idx` (`md5` ASC) , INDEX `#__rokgallery_files_guid_idx` (`guid` ASC) , UNIQUE INDEX `#__files_sluggable_idx` (`slug` ASC) , PRIMARY KEY (`id`) ) ENGINE = InnoDB;
    #1295658
    • MrT's Avatar
    • MrT
    • Preeminent Rocketeer
    • Posts: 101084
    • Thanks: 13484
    • Web Designer/Developer

    Re: All parts of a PRIMARY KEY must be NOT NULL

    Posted 8 years 10 months ago
    • Please would you post your URL, superuser id and pswd in the secure tab of your post and i'll have a look for you.

      Regards, Mark.
    • Please search forums before posting. Please make sure your post includes the version of the CMS you are using and a link to the problem. Annotations on screenshots can also be helpful to explain problems/goals. Please use the "secure" tab for confidential information.
    #1295690

  • Re: All parts of a PRIMARY KEY must be NOT NULL

    Posted 8 years 10 months ago
    • There's no external access. I have sites exhibiting the issue on an internal dev server and a virtual machine. I can DropBox a copy of the virtual machine to you if you want.
    • Last Edit: 8 years 10 months ago by Jim Grusendorf.
    #1295907
    • MrT's Avatar
    • MrT
    • Preeminent Rocketeer
    • Posts: 101084
    • Thanks: 13484
    • Web Designer/Developer

    Re: All parts of a PRIMARY KEY must be NOT NULL

    Posted 8 years 10 months ago
    • I've raised a bug ticket about this as I have reproduced the same issue locally myself.. I think it's to do with the mysql version but I need our developers to investigate.

      Regards, Mark.

    • The following users have thanked you: Jim Grusendorf

    • Please search forums before posting. Please make sure your post includes the version of the CMS you are using and a link to the problem. Annotations on screenshots can also be helpful to explain problems/goals. Please use the "secure" tab for confidential information.
    #1295909
    • MrT's Avatar
    • MrT
    • Preeminent Rocketeer
    • Posts: 101084
    • Thanks: 13484
    • Web Designer/Developer

    Re: All parts of a PRIMARY KEY must be NOT NULL

    Posted 8 years 10 months ago
    • This message contains only secure information that is visible to MrT, moderators and administrators
    • Please search forums before posting. Please make sure your post includes the version of the CMS you are using and a link to the problem. Annotations on screenshots can also be helpful to explain problems/goals. Please use the "secure" tab for confidential information.
    #1295910

Time to create page: 0.071 seconds