search

prisma / studio

🎙️ The easiest way to explore and manipulate your data in all of your Prisma projects.
https://www.prisma.io/studio
1.9k stars 47 forks source link

A non-recoverable error has occured and studio needs to be restarted. #781

Closed islamian1337 closed 3 years ago

islamian1337 commented 3 years ago

  1. Prisma version (prisma -v or npx prisma -v): 3.1.1

  2. Logs from Developer Tools Console or Command line, if any:

    Error starting Prisma Client: {
"stack": "Error: \u001b[91m\u001b[1mSchema parsing\u001b[22m\u001b[39m\n\u001b[91m\u001b[1m\u001b[22m\u001b[39m\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type MediumText of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:1753\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m1752 | \u001b[0m\n\u001b[1;94m1753 | \u001b[0m\u001b[1;91mmodel cms_block {\u001b[0m\n\u001b[1;94m1754 | \u001b[0m  block_id        Int               @id @default(autoincrement()) @db.SmallInt\n\u001b[1;94m1755 | \u001b[0m  title           String            @db.VarChar(255)\n\u001b[1;94m1756 | \u001b[0m  identifier      String            @db.VarChar(255)\n\u001b[1;94m1757 | \u001b[0m  content         String?           @db.MediumText\n\u001b[1;94m1758 | \u001b[0m  creation_time   DateTime          @default(now()) @db.Timestamp(0)\n\u001b[1;94m1759 | \u001b[0m  update_time     DateTime          @default(now()) @db.Timestamp(0)\n\u001b[1;94m1760 | \u001b[0m  is_active       Int               @default(1) @db.SmallInt\n\u001b[1;94m1761 | \u001b[0m  cms_block_store cms_block_store[]\n\u001b[1;94m1762 | \u001b[0m\n\u001b[1;94m1763 | \u001b[0m  @@index([title, identifier, content], map: \"CMS_BLOCK_TITLE_IDENTIFIER_CONTENT\")\n\u001b[1;94m1764 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type Text of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:1776\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m1775 | \u001b[0m\n\u001b[1;94m1776 | \u001b[0m\u001b[1;91mmodel cms_page {\u001b[0m\n\u001b[1;94m1777 | \u001b[0m  page_id                  Int              @id @default(autoincrement()) @db.SmallInt\n\u001b[1;94m1778 | \u001b[0m  title                    String?          @db.VarChar(255)\n\u001b[1;94m1779 | \u001b[0m  page_layout              String?          @db.VarChar(255)\n\u001b[1;94m1780 | \u001b[0m  meta_keywords            String?          @db.Text\n\u001b[1;94m1781 | \u001b[0m  meta_description         String?          @db.Text\n\u001b[1;94m1782 | \u001b[0m  identifier               String?          @db.VarChar(100)\n\u001b[1;94m1783 | \u001b[0m  content_heading          String?          @db.VarChar(255)\n\u001b[1;94m1784 | \u001b[0m  content                  String?          @db.MediumText\n\u001b[1;94m1785 | \u001b[0m  creation_time            DateTime         @default(now()) @db.Timestamp(0)\n\u001b[1;94m1786 | \u001b[0m  update_time              DateTime         @default(now()) @db.Timestamp(0)\n\u001b[1;94m1787 | \u001b[0m  is_active                Int              @default(1) @db.SmallInt\n\u001b[1;94m1788 | \u001b[0m  sort_order               Int              @default(0) @db.SmallInt\n\u001b[1;94m1789 | \u001b[0m  layout_update_xml        String?          @db.Text\n\u001b[1;94m1790 | \u001b[0m  custom_theme             String?          @db.VarChar(100)\n\u001b[1;94m1791 | \u001b[0m  custom_root_template     String?          @db.VarChar(255)\n\u001b[1;94m1792 | \u001b[0m  custom_layout_update_xml String?          @db.Text\n\u001b[1;94m1793 | \u001b[0m  layout_update_selected   String?          @db.VarChar(128)\n\u001b[1;94m1794 | \u001b[0m  custom_theme_from        DateTime?        @db.Date\n\u001b[1;94m1795 | \u001b[0m  custom_theme_to          DateTime?        @db.Date\n\u001b[1;94m1796 | \u001b[0m  meta_title               String?          @db.VarChar(255)\n\u001b[1;94m1797 | \u001b[0m  cms_page_store           cms_page_store[]\n\u001b[1;94m1798 | \u001b[0m\n\u001b[1;94m1799 | \u001b[0m  @@index([identifier], map: \"CMS_PAGE_IDENTIFIER\")\n\u001b[1;94m1800 | \u001b[0m  @@index([title, meta_keywords, meta_description, identifier, content], map: \"CMS_PAGE_TITLE_META_KEYWORDS_META_DESCRIPTION_IDENTIFIER_CONTENT\")\n\u001b[1;94m1801 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type Text of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:2109\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m2108 | \u001b[0m\n\u001b[1;94m2109 | \u001b[0m\u001b[1;91mmodel customer_grid_flat {\u001b[0m\n\u001b[1;94m2110 | \u001b[0m  entity_id          Int       @id @db.UnsignedInt\n\u001b[1;94m2111 | \u001b[0m  name               String?   @db.Text\n\u001b[1;94m2112 | \u001b[0m  email              String?   @db.VarChar(255)\n\u001b[1;94m2113 | \u001b[0m  group_id           Int?\n\u001b[1;94m2114 | \u001b[0m  created_at         DateTime? @db.Timestamp(0)\n\u001b[1;94m2115 | \u001b[0m  website_id         Int?\n\u001b[1;94m2116 | \u001b[0m  confirmation       String?   @db.VarChar(255)\n\u001b[1;94m2117 | \u001b[0m  created_in         String?   @db.Text\n\u001b[1;94m2118 | \u001b[0m  dob                DateTime? @db.Date\n\u001b[1;94m2119 | \u001b[0m  gender             Int?\n\u001b[1;94m2120 | \u001b[0m  taxvat             String?   @db.VarChar(255)\n\u001b[1;94m2121 | \u001b[0m  lock_expires       DateTime? @db.Timestamp(0)\n\u001b[1;94m2122 | \u001b[0m  shipping_full      String?   @db.Text\n\u001b[1;94m2123 | \u001b[0m  billing_full       String?   @db.Text\n\u001b[1;94m2124 | \u001b[0m  billing_firstname  String?   @db.VarChar(255)\n\u001b[1;94m2125 | \u001b[0m  billing_lastname   String?   @db.VarChar(255)\n\u001b[1;94m2126 | \u001b[0m  billing_telephone  String?   @db.VarChar(255)\n\u001b[1;94m2127 | \u001b[0m  billing_postcode   String?   @db.VarChar(255)\n\u001b[1;94m2128 | \u001b[0m  billing_country_id String?   @db.VarChar(255)\n\u001b[1;94m2129 | \u001b[0m  billing_region     String?   @db.VarChar(255)\n\u001b[1;94m2130 | \u001b[0m  billing_region_id  Int?\n\u001b[1;94m2131 | \u001b[0m  billing_street     String?   @db.VarChar(255)\n\u001b[1;94m2132 | \u001b[0m  billing_city       String?   @db.VarChar(255)\n\u001b[1;94m2133 | \u001b[0m  billing_fax        String?   @db.VarChar(255)\n\u001b[1;94m2134 | \u001b[0m  billing_vat_id     String?   @db.VarChar(255)\n\u001b[1;94m2135 | \u001b[0m  billing_company    String?   @db.VarChar(255)\n\u001b[1;94m2136 | \u001b[0m\n\u001b[1;94m2137 | \u001b[0m  @@index([billing_country_id], map: \"CUSTOMER_GRID_FLAT_BILLING_COUNTRY_ID\")\n\u001b[1;94m2138 | \u001b[0m  @@index([confirmation], map: \"CUSTOMER_GRID_FLAT_CONFIRMATION\")\n\u001b[1;94m2139 | \u001b[0m  @@index([created_at], map: \"CUSTOMER_GRID_FLAT_CREATED_AT\")\n\u001b[1;94m2140 | \u001b[0m  @@index([dob], map: \"CUSTOMER_GRID_FLAT_DOB\")\n\u001b[1;94m2141 | \u001b[0m  @@index([gender], map: \"CUSTOMER_GRID_FLAT_GENDER\")\n\u001b[1;94m2142 | \u001b[0m  @@index([group_id], map: \"CUSTOMER_GRID_FLAT_GROUP_ID\")\n\u001b[1;94m2143 | \u001b[0m  @@index([website_id], map: \"CUSTOMER_GRID_FLAT_WEBSITE_ID\")\n\u001b[1;94m2144 | \u001b[0m  @@index([name, email, created_in, taxvat, shipping_full, billing_full, billing_firstname, billing_lastname, billing_telephone, billing_postcode, billing_region, billing_city, billing_fax, billing_company], map: \"FTI_8746F705702DD5F6D45B8C7CE7FE9F2F\")\n\u001b[1;94m2145 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type Text of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:5757\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m5756 | \u001b[0m\n\u001b[1;94m5757 | \u001b[0m\u001b[1;91mmodel search_synonyms {\u001b[0m\n\u001b[1;94m5758 | \u001b[0m  group_id      BigInt        @id @default(autoincrement()) @db.UnsignedBigInt\n\u001b[1;94m5759 | \u001b[0m  synonyms      String        @db.Text\n\u001b[1;94m5760 | \u001b[0m  store_id      Int           @default(0) @db.UnsignedSmallInt\n\u001b[1;94m5761 | \u001b[0m  website_id    Int           @default(0) @db.UnsignedSmallInt\n\u001b[1;94m5762 | \u001b[0m  store         store         @relation(fields: [store_id], references: [store_id], onDelete: Cascade, onUpdate: Restrict, map: \"SEARCH_SYNONYMS_STORE_ID_STORE_STORE_ID\")\n\u001b[1;94m5763 | \u001b[0m  store_website store_website @relation(fields: [website_id], references: [website_id], onDelete: Cascade, onUpdate: Restrict, map: \"SEARCH_SYNONYMS_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID\")\n\u001b[1;94m5764 | \u001b[0m\n\u001b[1;94m5765 | \u001b[0m  @@index([store_id], map: \"SEARCH_SYNONYMS_STORE_ID\")\n\u001b[1;94m5766 | \u001b[0m  @@index([synonyms], map: \"SEARCH_SYNONYMS_SYNONYMS\")\n\u001b[1;94m5767 | \u001b[0m  @@index([website_id], map: \"SEARCH_SYNONYMS_WEBSITE_ID\")\n\u001b[1;94m5768 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\nValidation Error Count: 4\n    at getDmmfNodeAPI (C:\\Vue-Storefront\\server\\starter\\node_modules\\prisma\\build\\index.js:100548:13)\n    at processTicksAndRejections (internal/process/task_queues.js:95:5)\n    at async getDMMF5 (C:\\Vue-Storefront\\server\\starter\\node_modules\\prisma\\build\\index.js:100529:14)\n    at async Object.getGenerators (C:\\Vue-Storefront\\server\\starter\\node_modules\\prisma\\build\\index.js:102718:18)\n    at async Object.getGenerator2 [as getGenerator] (C:\\Vue-Storefront\\server\\starter\\node_modules\\prisma\\build\\index.js:105149:30)\n    at async PCW.getDMMF (C:\\Vue-Storefront\\server\\starter\\node_modules\\prisma\\build\\index.js:110811:41)\n    at async PrismaService.respond (C:\\Vue-Storefront\\server\\starter\\node_modules\\prisma\\build\\index.js:111115:50)\n    at async C:\\Vue-Storefront\\server\\starter\\node_modules\\prisma\\build\\index.js:111289:35",
"message": "\u001b[91m\u001b[1mSchema parsing\u001b[22m\u001b[39m\n\u001b[91m\u001b[1m\u001b[22m\u001b[39m\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type MediumText of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:1753\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m1752 | \u001b[0m\n\u001b[1;94m1753 | \u001b[0m\u001b[1;91mmodel cms_block {\u001b[0m\n\u001b[1;94m1754 | \u001b[0m  block_id        Int               @id @default(autoincrement()) @db.SmallInt\n\u001b[1;94m1755 | \u001b[0m  title           String            @db.VarChar(255)\n\u001b[1;94m1756 | \u001b[0m  identifier      String            @db.VarChar(255)\n\u001b[1;94m1757 | \u001b[0m  content         String?           @db.MediumText\n\u001b[1;94m1758 | \u001b[0m  creation_time   DateTime          @default(now()) @db.Timestamp(0)\n\u001b[1;94m1759 | \u001b[0m  update_time     DateTime          @default(now()) @db.Timestamp(0)\n\u001b[1;94m1760 | \u001b[0m  is_active       Int               @default(1) @db.SmallInt\n\u001b[1;94m1761 | \u001b[0m  cms_block_store cms_block_store[]\n\u001b[1;94m1762 | \u001b[0m\n\u001b[1;94m1763 | \u001b[0m  @@index([title, identifier, content], map: \"CMS_BLOCK_TITLE_IDENTIFIER_CONTENT\")\n\u001b[1;94m1764 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type Text of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:1776\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m1775 | \u001b[0m\n\u001b[1;94m1776 | \u001b[0m\u001b[1;91mmodel cms_page {\u001b[0m\n\u001b[1;94m1777 | \u001b[0m  page_id                  Int              @id @default(autoincrement()) @db.SmallInt\n\u001b[1;94m1778 | \u001b[0m  title                    String?          @db.VarChar(255)\n\u001b[1;94m1779 | \u001b[0m  page_layout              String?          @db.VarChar(255)\n\u001b[1;94m1780 | \u001b[0m  meta_keywords            String?          @db.Text\n\u001b[1;94m1781 | \u001b[0m  meta_description         String?          @db.Text\n\u001b[1;94m1782 | \u001b[0m  identifier               String?          @db.VarChar(100)\n\u001b[1;94m1783 | \u001b[0m  content_heading          String?          @db.VarChar(255)\n\u001b[1;94m1784 | \u001b[0m  content                  String?          @db.MediumText\n\u001b[1;94m1785 | \u001b[0m  creation_time            DateTime         @default(now()) @db.Timestamp(0)\n\u001b[1;94m1786 | \u001b[0m  update_time              DateTime         @default(now()) @db.Timestamp(0)\n\u001b[1;94m1787 | \u001b[0m  is_active                Int              @default(1) @db.SmallInt\n\u001b[1;94m1788 | \u001b[0m  sort_order               Int              @default(0) @db.SmallInt\n\u001b[1;94m1789 | \u001b[0m  layout_update_xml        String?          @db.Text\n\u001b[1;94m1790 | \u001b[0m  custom_theme             String?          @db.VarChar(100)\n\u001b[1;94m1791 | \u001b[0m  custom_root_template     String?          @db.VarChar(255)\n\u001b[1;94m1792 | \u001b[0m  custom_layout_update_xml String?          @db.Text\n\u001b[1;94m1793 | \u001b[0m  layout_update_selected   String?          @db.VarChar(128)\n\u001b[1;94m1794 | \u001b[0m  custom_theme_from        DateTime?        @db.Date\n\u001b[1;94m1795 | \u001b[0m  custom_theme_to          DateTime?        @db.Date\n\u001b[1;94m1796 | \u001b[0m  meta_title               String?          @db.VarChar(255)\n\u001b[1;94m1797 | \u001b[0m  cms_page_store           cms_page_store[]\n\u001b[1;94m1798 | \u001b[0m\n\u001b[1;94m1799 | \u001b[0m  @@index([identifier], map: \"CMS_PAGE_IDENTIFIER\")\n\u001b[1;94m1800 | \u001b[0m  @@index([title, meta_keywords, meta_description, identifier, content], map: \"CMS_PAGE_TITLE_META_KEYWORDS_META_DESCRIPTION_IDENTIFIER_CONTENT\")\n\u001b[1;94m1801 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type Text of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:2109\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m2108 | \u001b[0m\n\u001b[1;94m2109 | \u001b[0m\u001b[1;91mmodel customer_grid_flat {\u001b[0m\n\u001b[1;94m2110 | \u001b[0m  entity_id          Int       @id @db.UnsignedInt\n\u001b[1;94m2111 | \u001b[0m  name               String?   @db.Text\n\u001b[1;94m2112 | \u001b[0m  email              String?   @db.VarChar(255)\n\u001b[1;94m2113 | \u001b[0m  group_id           Int?\n\u001b[1;94m2114 | \u001b[0m  created_at         DateTime? @db.Timestamp(0)\n\u001b[1;94m2115 | \u001b[0m  website_id         Int?\n\u001b[1;94m2116 | \u001b[0m  confirmation       String?   @db.VarChar(255)\n\u001b[1;94m2117 | \u001b[0m  created_in         String?   @db.Text\n\u001b[1;94m2118 | \u001b[0m  dob                DateTime? @db.Date\n\u001b[1;94m2119 | \u001b[0m  gender             Int?\n\u001b[1;94m2120 | \u001b[0m  taxvat             String?   @db.VarChar(255)\n\u001b[1;94m2121 | \u001b[0m  lock_expires       DateTime? @db.Timestamp(0)\n\u001b[1;94m2122 | \u001b[0m  shipping_full      String?   @db.Text\n\u001b[1;94m2123 | \u001b[0m  billing_full       String?   @db.Text\n\u001b[1;94m2124 | \u001b[0m  billing_firstname  String?   @db.VarChar(255)\n\u001b[1;94m2125 | \u001b[0m  billing_lastname   String?   @db.VarChar(255)\n\u001b[1;94m2126 | \u001b[0m  billing_telephone  String?   @db.VarChar(255)\n\u001b[1;94m2127 | \u001b[0m  billing_postcode   String?   @db.VarChar(255)\n\u001b[1;94m2128 | \u001b[0m  billing_country_id String?   @db.VarChar(255)\n\u001b[1;94m2129 | \u001b[0m  billing_region     String?   @db.VarChar(255)\n\u001b[1;94m2130 | \u001b[0m  billing_region_id  Int?\n\u001b[1;94m2131 | \u001b[0m  billing_street     String?   @db.VarChar(255)\n\u001b[1;94m2132 | \u001b[0m  billing_city       String?   @db.VarChar(255)\n\u001b[1;94m2133 | \u001b[0m  billing_fax        String?   @db.VarChar(255)\n\u001b[1;94m2134 | \u001b[0m  billing_vat_id     String?   @db.VarChar(255)\n\u001b[1;94m2135 | \u001b[0m  billing_company    String?   @db.VarChar(255)\n\u001b[1;94m2136 | \u001b[0m\n\u001b[1;94m2137 | \u001b[0m  @@index([billing_country_id], map: \"CUSTOMER_GRID_FLAT_BILLING_COUNTRY_ID\")\n\u001b[1;94m2138 | \u001b[0m  @@index([confirmation], map: \"CUSTOMER_GRID_FLAT_CONFIRMATION\")\n\u001b[1;94m2139 | \u001b[0m  @@index([created_at], map: \"CUSTOMER_GRID_FLAT_CREATED_AT\")\n\u001b[1;94m2140 | \u001b[0m  @@index([dob], map: \"CUSTOMER_GRID_FLAT_DOB\")\n\u001b[1;94m2141 | \u001b[0m  @@index([gender], map: \"CUSTOMER_GRID_FLAT_GENDER\")\n\u001b[1;94m2142 | \u001b[0m  @@index([group_id], map: \"CUSTOMER_GRID_FLAT_GROUP_ID\")\n\u001b[1;94m2143 | \u001b[0m  @@index([website_id], map: \"CUSTOMER_GRID_FLAT_WEBSITE_ID\")\n\u001b[1;94m2144 | \u001b[0m  @@index([name, email, created_in, taxvat, shipping_full, billing_full, billing_firstname, billing_lastname, billing_telephone, billing_postcode, billing_region, billing_city, billing_fax, billing_company], map: \"FTI_8746F705702DD5F6D45B8C7CE7FE9F2F\")\n\u001b[1;94m2145 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type Text of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:5757\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m5756 | \u001b[0m\n\u001b[1;94m5757 | \u001b[0m\u001b[1;91mmodel search_synonyms {\u001b[0m\n\u001b[1;94m5758 | \u001b[0m  group_id      BigInt        @id @default(autoincrement()) @db.UnsignedBigInt\n\u001b[1;94m5759 | \u001b[0m  synonyms      String        @db.Text\n\u001b[1;94m5760 | \u001b[0m  store_id      Int           @default(0) @db.UnsignedSmallInt\n\u001b[1;94m5761 | \u001b[0m  website_id    Int           @default(0) @db.UnsignedSmallInt\n\u001b[1;94m5762 | \u001b[0m  store         store         @relation(fields: [store_id], references: [store_id], onDelete: Cascade, onUpdate: Restrict, map: \"SEARCH_SYNONYMS_STORE_ID_STORE_STORE_ID\")\n\u001b[1;94m5763 | \u001b[0m  store_website store_website @relation(fields: [website_id], references: [website_id], onDelete: Cascade, onUpdate: Restrict, map: \"SEARCH_SYNONYMS_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID\")\n\u001b[1;94m5764 | \u001b[0m\n\u001b[1;94m5765 | \u001b[0m  @@index([store_id], map: \"SEARCH_SYNONYMS_STORE_ID\")\n\u001b[1;94m5766 | \u001b[0m  @@index([synonyms], map: \"SEARCH_SYNONYMS_SYNONYMS\")\n\u001b[1;94m5767 | \u001b[0m  @@index([website_id], map: \"SEARCH_SYNONYMS_WEBSITE_ID\")\n\u001b[1;94m5768 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\nValidation Error Count: 4"
}
Error: Error starting Prisma Client: {
"stack": "Error: \u001b[91m\u001b[1mSchema parsing\u001b[22m\u001b[39m\n\u001b[91m\u001b[1m\u001b[22m\u001b[39m\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type MediumText of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:1753\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m1752 | \u001b[0m\n\u001b[1;94m1753 | \u001b[0m\u001b[1;91mmodel cms_block {\u001b[0m\n\u001b[1;94m1754 | \u001b[0m  block_id        Int               @id @default(autoincrement()) @db.SmallInt\n\u001b[1;94m1755 | \u001b[0m  title           String            @db.VarChar(255)\n\u001b[1;94m1756 | \u001b[0m  identifier      String            @db.VarChar(255)\n\u001b[1;94m1757 | \u001b[0m  content         String?           @db.MediumText\n\u001b[1;94m1758 | \u001b[0m  creation_time   DateTime          @default(now()) @db.Timestamp(0)\n\u001b[1;94m1759 | \u001b[0m  update_time     DateTime          @default(now()) @db.Timestamp(0)\n\u001b[1;94m1760 | \u001b[0m  is_active       Int               @default(1) @db.SmallInt\n\u001b[1;94m1761 | \u001b[0m  cms_block_store cms_block_store[]\n\u001b[1;94m1762 | \u001b[0m\n\u001b[1;94m1763 | \u001b[0m  @@index([title, identifier, content], map: \"CMS_BLOCK_TITLE_IDENTIFIER_CONTENT\")\n\u001b[1;94m1764 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type Text of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:1776\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m1775 | \u001b[0m\n\u001b[1;94m1776 | \u001b[0m\u001b[1;91mmodel cms_page {\u001b[0m\n\u001b[1;94m1777 | \u001b[0m  page_id                  Int              @id @default(autoincrement()) @db.SmallInt\n\u001b[1;94m1778 | \u001b[0m  title                    String?          @db.VarChar(255)\n\u001b[1;94m1779 | \u001b[0m  page_layout              String?          @db.VarChar(255)\n\u001b[1;94m1780 | \u001b[0m  meta_keywords            String?          @db.Text\n\u001b[1;94m1781 | \u001b[0m  meta_description         String?          @db.Text\n\u001b[1;94m1782 | \u001b[0m  identifier               String?          @db.VarChar(100)\n\u001b[1;94m1783 | \u001b[0m  content_heading          String?          @db.VarChar(255)\n\u001b[1;94m1784 | \u001b[0m  content                  String?          @db.MediumText\n\u001b[1;94m1785 | \u001b[0m  creation_time            DateTime         @default(now()) @db.Timestamp(0)\n\u001b[1;94m1786 | \u001b[0m  update_time              DateTime         @default(now()) @db.Timestamp(0)\n\u001b[1;94m1787 | \u001b[0m  is_active                Int              @default(1) @db.SmallInt\n\u001b[1;94m1788 | \u001b[0m  sort_order               Int              @default(0) @db.SmallInt\n\u001b[1;94m1789 | \u001b[0m  layout_update_xml        String?          @db.Text\n\u001b[1;94m1790 | \u001b[0m  custom_theme             String?          @db.VarChar(100)\n\u001b[1;94m1791 | \u001b[0m  custom_root_template     String?          @db.VarChar(255)\n\u001b[1;94m1792 | \u001b[0m  custom_layout_update_xml String?          @db.Text\n\u001b[1;94m1793 | \u001b[0m  layout_update_selected   String?          @db.VarChar(128)\n\u001b[1;94m1794 | \u001b[0m  custom_theme_from        DateTime?        @db.Date\n\u001b[1;94m1795 | \u001b[0m  custom_theme_to          DateTime?        @db.Date\n\u001b[1;94m1796 | \u001b[0m  meta_title               String?          @db.VarChar(255)\n\u001b[1;94m1797 | \u001b[0m  cms_page_store           cms_page_store[]\n\u001b[1;94m1798 | \u001b[0m\n\u001b[1;94m1799 | \u001b[0m  @@index([identifier], map: \"CMS_PAGE_IDENTIFIER\")\n\u001b[1;94m1800 | \u001b[0m  @@index([title, meta_keywords, meta_description, identifier, content], map: \"CMS_PAGE_TITLE_META_KEYWORDS_META_DESCRIPTION_IDENTIFIER_CONTENT\")\n\u001b[1;94m1801 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type Text of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:2109\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m2108 | \u001b[0m\n\u001b[1;94m2109 | \u001b[0m\u001b[1;91mmodel customer_grid_flat {\u001b[0m\n\u001b[1;94m2110 | \u001b[0m  entity_id          Int       @id @db.UnsignedInt\n\u001b[1;94m2111 | \u001b[0m  name               String?   @db.Text\n\u001b[1;94m2112 | \u001b[0m  email              String?   @db.VarChar(255)\n\u001b[1;94m2113 | \u001b[0m  group_id           Int?\n\u001b[1;94m2114 | \u001b[0m  created_at         DateTime? @db.Timestamp(0)\n\u001b[1;94m2115 | \u001b[0m  website_id         Int?\n\u001b[1;94m2116 | \u001b[0m  confirmation       String?   @db.VarChar(255)\n\u001b[1;94m2117 | \u001b[0m  created_in         String?   @db.Text\n\u001b[1;94m2118 | \u001b[0m  dob                DateTime? @db.Date\n\u001b[1;94m2119 | \u001b[0m  gender             Int?\n\u001b[1;94m2120 | \u001b[0m  taxvat             String?   @db.VarChar(255)\n\u001b[1;94m2121 | \u001b[0m  lock_expires       DateTime? @db.Timestamp(0)\n\u001b[1;94m2122 | \u001b[0m  shipping_full      String?   @db.Text\n\u001b[1;94m2123 | \u001b[0m  billing_full       String?   @db.Text\n\u001b[1;94m2124 | \u001b[0m  billing_firstname  String?   @db.VarChar(255)\n\u001b[1;94m2125 | \u001b[0m  billing_lastname   String?   @db.VarChar(255)\n\u001b[1;94m2126 | \u001b[0m  billing_telephone  String?   @db.VarChar(255)\n\u001b[1;94m2127 | \u001b[0m  billing_postcode   String?   @db.VarChar(255)\n\u001b[1;94m2128 | \u001b[0m  billing_country_id String?   @db.VarChar(255)\n\u001b[1;94m2129 | \u001b[0m  billing_region     String?   @db.VarChar(255)\n\u001b[1;94m2130 | \u001b[0m  billing_region_id  Int?\n\u001b[1;94m2131 | \u001b[0m  billing_street     String?   @db.VarChar(255)\n\u001b[1;94m2132 | \u001b[0m  billing_city       String?   @db.VarChar(255)\n\u001b[1;94m2133 | \u001b[0m  billing_fax        String?   @db.VarChar(255)\n\u001b[1;94m2134 | \u001b[0m  billing_vat_id     String?   @db.VarChar(255)\n\u001b[1;94m2135 | \u001b[0m  billing_company    String?   @db.VarChar(255)\n\u001b[1;94m2136 | \u001b[0m\n\u001b[1;94m2137 | \u001b[0m  @@index([billing_country_id], map: \"CUSTOMER_GRID_FLAT_BILLING_COUNTRY_ID\")\n\u001b[1;94m2138 | \u001b[0m  @@index([confirmation], map: \"CUSTOMER_GRID_FLAT_CONFIRMATION\")\n\u001b[1;94m2139 | \u001b[0m  @@index([created_at], map: \"CUSTOMER_GRID_FLAT_CREATED_AT\")\n\u001b[1;94m2140 | \u001b[0m  @@index([dob], map: \"CUSTOMER_GRID_FLAT_DOB\")\n\u001b[1;94m2141 | \u001b[0m  @@index([gender], map: \"CUSTOMER_GRID_FLAT_GENDER\")\n\u001b[1;94m2142 | \u001b[0m  @@index([group_id], map: \"CUSTOMER_GRID_FLAT_GROUP_ID\")\n\u001b[1;94m2143 | \u001b[0m  @@index([website_id], map: \"CUSTOMER_GRID_FLAT_WEBSITE_ID\")\n\u001b[1;94m2144 | \u001b[0m  @@index([name, email, created_in, taxvat, shipping_full, billing_full, billing_firstname, billing_lastname, billing_telephone, billing_postcode, billing_region, billing_city, billing_fax, billing_company], map: \"FTI_8746F705702DD5F6D45B8C7CE7FE9F2F\")\n\u001b[1;94m2145 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type Text of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:5757\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m5756 | \u001b[0m\n\u001b[1;94m5757 | \u001b[0m\u001b[1;91mmodel search_synonyms {\u001b[0m\n\u001b[1;94m5758 | \u001b[0m  group_id      BigInt        @id @default(autoincrement()) @db.UnsignedBigInt\n\u001b[1;94m5759 | \u001b[0m  synonyms      String        @db.Text\n\u001b[1;94m5760 | \u001b[0m  store_id      Int           @default(0) @db.UnsignedSmallInt\n\u001b[1;94m5761 | \u001b[0m  website_id    Int           @default(0) @db.UnsignedSmallInt\n\u001b[1;94m5762 | \u001b[0m  store         store         @relation(fields: [store_id], references: [store_id], onDelete: Cascade, onUpdate: Restrict, map: \"SEARCH_SYNONYMS_STORE_ID_STORE_STORE_ID\")\n\u001b[1;94m5763 | \u001b[0m  store_website store_website @relation(fields: [website_id], references: [website_id], onDelete: Cascade, onUpdate: Restrict, map: \"SEARCH_SYNONYMS_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID\")\n\u001b[1;94m5764 | \u001b[0m\n\u001b[1;94m5765 | \u001b[0m  @@index([store_id], map: \"SEARCH_SYNONYMS_STORE_ID\")\n\u001b[1;94m5766 | \u001b[0m  @@index([synonyms], map: \"SEARCH_SYNONYMS_SYNONYMS\")\n\u001b[1;94m5767 | \u001b[0m  @@index([website_id], map: \"SEARCH_SYNONYMS_WEBSITE_ID\")\n\u001b[1;94m5768 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\nValidation Error Count: 4\n    at getDmmfNodeAPI (C:\\Vue-Storefront\\server\\starter\\node_modules\\prisma\\build\\index.js:100548:13)\n    at processTicksAndRejections (internal/process/task_queues.js:95:5)\n    at async getDMMF5 (C:\\Vue-Storefront\\server\\starter\\node_modules\\prisma\\build\\index.js:100529:14)\n    at async Object.getGenerators (C:\\Vue-Storefront\\server\\starter\\node_modules\\prisma\\build\\index.js:102718:18)\n    at async Object.getGenerator2 [as getGenerator] (C:\\Vue-Storefront\\server\\starter\\node_modules\\prisma\\build\\index.js:105149:30)\n    at async PCW.getDMMF (C:\\Vue-Storefront\\server\\starter\\node_modules\\prisma\\build\\index.js:110811:41)\n    at async PrismaService.respond (C:\\Vue-Storefront\\server\\starter\\node_modules\\prisma\\build\\index.js:111115:50)\n    at async C:\\Vue-Storefront\\server\\starter\\node_modules\\prisma\\build\\index.js:111289:35",
"message": "\u001b[91m\u001b[1mSchema parsing\u001b[22m\u001b[39m\n\u001b[91m\u001b[1m\u001b[22m\u001b[39m\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type MediumText of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:1753\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m1752 | \u001b[0m\n\u001b[1;94m1753 | \u001b[0m\u001b[1;91mmodel cms_block {\u001b[0m\n\u001b[1;94m1754 | \u001b[0m  block_id        Int               @id @default(autoincrement()) @db.SmallInt\n\u001b[1;94m1755 | \u001b[0m  title           String            @db.VarChar(255)\n\u001b[1;94m1756 | \u001b[0m  identifier      String            @db.VarChar(255)\n\u001b[1;94m1757 | \u001b[0m  content         String?           @db.MediumText\n\u001b[1;94m1758 | \u001b[0m  creation_time   DateTime          @default(now()) @db.Timestamp(0)\n\u001b[1;94m1759 | \u001b[0m  update_time     DateTime          @default(now()) @db.Timestamp(0)\n\u001b[1;94m1760 | \u001b[0m  is_active       Int               @default(1) @db.SmallInt\n\u001b[1;94m1761 | \u001b[0m  cms_block_store cms_block_store[]\n\u001b[1;94m1762 | \u001b[0m\n\u001b[1;94m1763 | \u001b[0m  @@index([title, identifier, content], map: \"CMS_BLOCK_TITLE_IDENTIFIER_CONTENT\")\n\u001b[1;94m1764 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type Text of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:1776\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m1775 | \u001b[0m\n\u001b[1;94m1776 | \u001b[0m\u001b[1;91mmodel cms_page {\u001b[0m\n\u001b[1;94m1777 | \u001b[0m  page_id                  Int              @id @default(autoincrement()) @db.SmallInt\n\u001b[1;94m1778 | \u001b[0m  title                    String?          @db.VarChar(255)\n\u001b[1;94m1779 | \u001b[0m  page_layout              String?          @db.VarChar(255)\n\u001b[1;94m1780 | \u001b[0m  meta_keywords            String?          @db.Text\n\u001b[1;94m1781 | \u001b[0m  meta_description         String?          @db.Text\n\u001b[1;94m1782 | \u001b[0m  identifier               String?          @db.VarChar(100)\n\u001b[1;94m1783 | \u001b[0m  content_heading          String?          @db.VarChar(255)\n\u001b[1;94m1784 | \u001b[0m  content                  String?          @db.MediumText\n\u001b[1;94m1785 | \u001b[0m  creation_time            DateTime         @default(now()) @db.Timestamp(0)\n\u001b[1;94m1786 | \u001b[0m  update_time              DateTime         @default(now()) @db.Timestamp(0)\n\u001b[1;94m1787 | \u001b[0m  is_active                Int              @default(1) @db.SmallInt\n\u001b[1;94m1788 | \u001b[0m  sort_order               Int              @default(0) @db.SmallInt\n\u001b[1;94m1789 | \u001b[0m  layout_update_xml        String?          @db.Text\n\u001b[1;94m1790 | \u001b[0m  custom_theme             String?          @db.VarChar(100)\n\u001b[1;94m1791 | \u001b[0m  custom_root_template     String?          @db.VarChar(255)\n\u001b[1;94m1792 | \u001b[0m  custom_layout_update_xml String?          @db.Text\n\u001b[1;94m1793 | \u001b[0m  layout_update_selected   String?          @db.VarChar(128)\n\u001b[1;94m1794 | \u001b[0m  custom_theme_from        DateTime?        @db.Date\n\u001b[1;94m1795 | \u001b[0m  custom_theme_to          DateTime?        @db.Date\n\u001b[1;94m1796 | \u001b[0m  meta_title               String?          @db.VarChar(255)\n\u001b[1;94m1797 | \u001b[0m  cms_page_store           cms_page_store[]\n\u001b[1;94m1798 | \u001b[0m\n\u001b[1;94m1799 | \u001b[0m  @@index([identifier], map: \"CMS_PAGE_IDENTIFIER\")\n\u001b[1;94m1800 | \u001b[0m  @@index([title, meta_keywords, meta_description, identifier, content], map: \"CMS_PAGE_TITLE_META_KEYWORDS_META_DESCRIPTION_IDENTIFIER_CONTENT\")\n\u001b[1;94m1801 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type Text of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:2109\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m2108 | \u001b[0m\n\u001b[1;94m2109 | \u001b[0m\u001b[1;91mmodel customer_grid_flat {\u001b[0m\n\u001b[1;94m2110 | \u001b[0m  entity_id          Int       @id @db.UnsignedInt\n\u001b[1;94m2111 | \u001b[0m  name               String?   @db.Text\n\u001b[1;94m2112 | \u001b[0m  email              String?   @db.VarChar(255)\n\u001b[1;94m2113 | \u001b[0m  group_id           Int?\n\u001b[1;94m2114 | \u001b[0m  created_at         DateTime? @db.Timestamp(0)\n\u001b[1;94m2115 | \u001b[0m  website_id         Int?\n\u001b[1;94m2116 | \u001b[0m  confirmation       String?   @db.VarChar(255)\n\u001b[1;94m2117 | \u001b[0m  created_in         String?   @db.Text\n\u001b[1;94m2118 | \u001b[0m  dob                DateTime? @db.Date\n\u001b[1;94m2119 | \u001b[0m  gender             Int?\n\u001b[1;94m2120 | \u001b[0m  taxvat             String?   @db.VarChar(255)\n\u001b[1;94m2121 | \u001b[0m  lock_expires       DateTime? @db.Timestamp(0)\n\u001b[1;94m2122 | \u001b[0m  shipping_full      String?   @db.Text\n\u001b[1;94m2123 | \u001b[0m  billing_full       String?   @db.Text\n\u001b[1;94m2124 | \u001b[0m  billing_firstname  String?   @db.VarChar(255)\n\u001b[1;94m2125 | \u001b[0m  billing_lastname   String?   @db.VarChar(255)\n\u001b[1;94m2126 | \u001b[0m  billing_telephone  String?   @db.VarChar(255)\n\u001b[1;94m2127 | \u001b[0m  billing_postcode   String?   @db.VarChar(255)\n\u001b[1;94m2128 | \u001b[0m  billing_country_id String?   @db.VarChar(255)\n\u001b[1;94m2129 | \u001b[0m  billing_region     String?   @db.VarChar(255)\n\u001b[1;94m2130 | \u001b[0m  billing_region_id  Int?\n\u001b[1;94m2131 | \u001b[0m  billing_street     String?   @db.VarChar(255)\n\u001b[1;94m2132 | \u001b[0m  billing_city       String?   @db.VarChar(255)\n\u001b[1;94m2133 | \u001b[0m  billing_fax        String?   @db.VarChar(255)\n\u001b[1;94m2134 | \u001b[0m  billing_vat_id     String?   @db.VarChar(255)\n\u001b[1;94m2135 | \u001b[0m  billing_company    String?   @db.VarChar(255)\n\u001b[1;94m2136 | \u001b[0m\n\u001b[1;94m2137 | \u001b[0m  @@index([billing_country_id], map: \"CUSTOMER_GRID_FLAT_BILLING_COUNTRY_ID\")\n\u001b[1;94m2138 | \u001b[0m  @@index([confirmation], map: \"CUSTOMER_GRID_FLAT_CONFIRMATION\")\n\u001b[1;94m2139 | \u001b[0m  @@index([created_at], map: \"CUSTOMER_GRID_FLAT_CREATED_AT\")\n\u001b[1;94m2140 | \u001b[0m  @@index([dob], map: \"CUSTOMER_GRID_FLAT_DOB\")\n\u001b[1;94m2141 | \u001b[0m  @@index([gender], map: \"CUSTOMER_GRID_FLAT_GENDER\")\n\u001b[1;94m2142 | \u001b[0m  @@index([group_id], map: \"CUSTOMER_GRID_FLAT_GROUP_ID\")\n\u001b[1;94m2143 | \u001b[0m  @@index([website_id], map: \"CUSTOMER_GRID_FLAT_WEBSITE_ID\")\n\u001b[1;94m2144 | \u001b[0m  @@index([name, email, created_in, taxvat, shipping_full, billing_full, billing_firstname, billing_lastname, billing_telephone, billing_postcode, billing_region, billing_city, billing_fax, billing_company], map: \"FTI_8746F705702DD5F6D45B8C7CE7FE9F2F\")\n\u001b[1;94m2145 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\u001b[1;91merror\u001b[0m: \u001b[1mYou cannot define an index on fields with Native type Text of MySQL.\u001b[0m\n  \u001b[1;94m-->\u001b[0m  \u001b[4mschema.prisma:5757\u001b[0m\n\u001b[1;94m   | \u001b[0m\n\u001b[1;94m5756 | \u001b[0m\n\u001b[1;94m5757 | \u001b[0m\u001b[1;91mmodel search_synonyms {\u001b[0m\n\u001b[1;94m5758 | \u001b[0m  group_id      BigInt        @id @default(autoincrement()) @db.UnsignedBigInt\n\u001b[1;94m5759 | \u001b[0m  synonyms      String        @db.Text\n\u001b[1;94m5760 | \u001b[0m  store_id      Int           @default(0) @db.UnsignedSmallInt\n\u001b[1;94m5761 | \u001b[0m  website_id    Int           @default(0) @db.UnsignedSmallInt\n\u001b[1;94m5762 | \u001b[0m  store         store         @relation(fields: [store_id], references: [store_id], onDelete: Cascade, onUpdate: Restrict, map: \"SEARCH_SYNONYMS_STORE_ID_STORE_STORE_ID\")\n\u001b[1;94m5763 | \u001b[0m  store_website store_website @relation(fields: [website_id], references: [website_id], onDelete: Cascade, onUpdate: Restrict, map: \"SEARCH_SYNONYMS_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID\")\n\u001b[1;94m5764 | \u001b[0m\n\u001b[1;94m5765 | \u001b[0m  @@index([store_id], map: \"SEARCH_SYNONYMS_STORE_ID\")\n\u001b[1;94m5766 | \u001b[0m  @@index([synonyms], map: \"SEARCH_SYNONYMS_SYNONYMS\")\n\u001b[1;94m5767 | \u001b[0m  @@index([website_id], map: \"SEARCH_SYNONYMS_WEBSITE_ID\")\n\u001b[1;94m5768 | \u001b[0m}\n\u001b[1;94m   | \u001b[0m\n\nValidation Error Count: 4"
}
at ki.init (http://localhost:5555/assets/index.js:1:104126)

  3. Does the issue persist even after updating to the latest prisma alpha? (npm i -D @prisma/cli@dev)

  4. Prisma schema (if relevant):

sdnts commented 3 years ago

Hey @islamian1337, looking at the error, it looks like your schema has a few issues. This is likely not related to Studio. Can you try running prisma generate? You should see the same error.

Let me know if this only happens on Studio, and I'll reopen!

islamian1337 commented 3 years ago

@madebysid brother! There are 4 issues with my schema. Got it.