Installation error

Posted In General
  • jaime-metano 2 years ago
    SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `categories` add unique `categories_slug_unique`(`slug`))

    SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table categories add unique categories_slug_unique(slug))

  • jaime-metano 2 years ago
    SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'categories' already exists (SQL: create table `categories` (`id` int unsigned not null auto_increment primary key, `parent_id` int unsigned null, `order` int not null default '1', `name` varchar(255) not null, `slug` varchar(255) not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate utf8mb4_unicode_ci)

    SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'categories' already exists (SQL: create table categories (id int unsigned not null auto_increment primary key, parent_id int unsigned null, order int not null default '1', name varchar(255) not null, slug varchar(255) not null, created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate utf8mb4_unicode_ci)

  • devdojo 2 years ago
    Please try a new install and follow this forum post: [https://devdojo.com/forums/discussion/product-support/sql-error-on-installation](https://devdojo.com/forums/discussion/product-support/sql-error-on-installation)
    
    This is happening because you have an older mysql version. Go ahead and follow those instructions and they will show you how to resolve that.
    
    Let me know if that helps :)
    
    Thanks.

    Please try a new install and follow this forum post: https://devdojo.com/forums/discussion/product-support/sql-error-on-installation

    This is happening because you have an older mysql version. Go ahead and follow those instructions and they will show you how to resolve that.

    Let me know if that helps :)

    Thanks.

  • mateo-gavin 3 months ago
    I'd state which this can be a an excellent publish of the excellent individual, i am very happy to observe this particular.
    [Copthorne Accountants ](http://vpassociates.com/)
    

    I'd state which this can be a an excellent publish of the excellent individual, i am very happy to observe this particular. Copthorne Accountants

Please login or signup to leave a response.

Login

or Sign Up

Sign Up

or Login
×
Want to create your own SAAS?

I can teach you to create your own Software as a Service. Click here to learn more!

Visit SAAS Adventure!