Prisma Studio error on load

[vicaugfer]

Bug description

I pull the latest changes and I ran npm install and npx prisma studio. I get an error message saying:

A non-recoverable error has occurred. Reload Studio to continue. Consider reporting this error to us by opening an issue on GitHub and attaching the error details.

Followed by:

Unable to process count query undefined

Please advise.

Many thanks

Victor

How to reproduce

Expected behavior

No response

Prisma information

// This is your Prisma schema file, // learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client { provider = "prisma-client-js" previewFeatures = ["referentialIntegrity"] }

datasource db { provider = "mysql" url = env("DATABASE_URL") relationMode = "prisma" }

model Example { id String @id @default(cuid()) createdAt DateTime @default(now()) updatedAt DateTime @updatedAt }

// Necessary for Next auth model Account { id String @id @default(cuid()) userId String type String provider String providerAccountId String refresh_token String? // @db.Text access_token String? // @db.Text expires_at Int? token_type String? scope String? id_token String? // @db.Text session_state String? user User @relation(fields: [userId], references: [id], onDelete: Cascade)

@@unique([provider, providerAccountId])

}

model Session { id String @id @default(cuid()) sessionToken String @unique userId String expires DateTime user User @relation(fields: [userId], references: [id], onDelete: Cascade) }

model User { id String @id @default(cuid()) name String? email String? @unique emailVerified DateTime? role String? submittedSurvey Boolean? @default(false) image String? accounts Account[] sessions Session[] }

model VerificationToken { identifier String token String @unique expires DateTime

@@unique([identifier, token])

}

//Below is the table US Export Sales

model us_export_sales { record_id String @id @default(cuid()) week_ending DateTime @db.Date weekly_exports Int? accumluated_exports Int? net_sales Int? outstanding_sales Int? next_marketing_year_net_sales Int? next_marketing_year_outstanding_sales Int? }

//Below is the table Commitment of Traders

model commitment_of_traders { record_id String @id @default(cuid()) calendar_year Int crop_year String month String week Int? report_date_as_mm_dd_yyyy DateTime @db.Date() open_interest_all Int? producer_merchant_net Int? swap_position_net Int? managed_money_net Int? other_reportables_net Int? total_reportables_net Int? non_reportables_net Int? specs_net Int? }

//Below is the table cotton_on_call

model cotton_on_call { record_id String @id @default(cuid()) season_week Int week Int season String october_sales Int? december_sales Int? march_sales Int? may_sales Int? july_sales Int? total_on_call_sales Int? october_purchases Int? december_purchases Int? march_purchases Int? may_purchases Int? july_purchases Int? total_on_call_purchases Int? total_net_u_oc_position Int? total_net_change Int? }

//Below is the table comments

model comments { record_id String @id @default(cuid()) comment String @db.VarChar(255) section String @db.VarChar(255) date_of_comment DateTime @db.Date added_by String @db.VarChar(255) }

//Below is the table future_contracts_study

model future_contracts_study { record_id String @id @default(cuid()) year String month_of_high Int? date_of_high DateTime? @db.Date() high Decimal? @default(0) @db.Decimal(16, 4) month_of_low Int? date_of_low DateTime? @db.Date() low Decimal? @default(0) @db.Decimal(16, 4) price_range_between_high_and_low Decimal? @default(0) @db.Decimal(16, 4) day_range_between_high_and_low Decimal? @default(0) @db.Decimal(16, 4) inverse String? comments String? @db.Text }

//Below is the table Cotton Contracts

model cotton_contracts { record_id String @id @default(cuid()) datetime DateTime @db.DateTime(0) contract String @db.VarChar(255) high Decimal? @default(0) @db.Decimal(16, 4) low Decimal? @default(0) @db.Decimal(16, 4) open Decimal? @default(0) @db.Decimal(16, 4) close Decimal? @default(0) @db.Decimal(16, 4) change Decimal? @default(0) @db.Decimal(16, 4) rolling_average_200_day Decimal? @default(0) @db.Decimal(16, 4) rolling_average_100_day Decimal? @default(0) @db.Decimal(16, 4) rolling_average_50_day Decimal? @default(0) @db.Decimal(16, 4) }

//Below is the table Monthly Index

model monthly_index { record_id String @id @default(cuid()) month String @db.VarChar(255) //example for this: January year Int @default(0) //example for this: every row of this column will display the same year inverse_month String @db.VarChar(255) probability_rate String @db.VarChar(255) // Int @default(0) //this is a percentage number }

//Below is the Seasonal Index

model seasonal_index { record_id String @id @default(cuid()) season String @db.VarChar(255) //One example for this would be 2022/2023 season and I wanted to treat this as a String as I don't have to do any calculations with it inverse_year String @db.VarChar(255) probability_rate String @db.VarChar(255) // Int @default(0) }

//Below is the Comparison Chart

model comparison_chart { record_id String @id @default(cuid()) date_of_close DateTime @db.Date cotton_spot_price Decimal? @default(0) @db.Decimal(16, 4) dollar_basket_spot_price Decimal? @default(0) @db.Decimal(16, 4) crude_oil_spot_price Decimal? @default(0) @db.Decimal(16, 4)

//Example for price of cotton is 61.24 (two decimal points);
//Example for price dollar basket is 93.682 (three decimal points);
//Example for price crude oil is 42.45 (two decimal points):

}

//Below is the 30 Seconds Snapshot Strategy

model snapshot_strategy { record_id String @id @default(cuid()) title_of_snapshot_strategy String @db.VarChar(255) image_of_snapshot_strategy String? @db.VarChar(255) //here i wanted to upload an image or pull in-house graph similar to this - https://www.tradingview.com/chart/USDBRL/W62o6aQ2-Gold-China-BRICS-vs-US-Dollar-Hegemony/ text_of_snapshot_strategy String @db.Text date_of_snapshot_strategy DateTime @db.Date added_by String @default("Error") @db.VarChar(255) verified Boolean @default(false) }

//Below is the Basis Cost

model basis_comparison { record_id String @id @default(cuid()) date_of_basis_report DateTime @db.Date country String @db.VarChar(255) contract_december_2023 Int @default(0) contract_december_2024 Int @default(0) added_by String @default("Vic") @db.VarChar(255) }

//Below is In Country News

model in_country_news { record_id String @id @default(cuid()) image_of_in_country_news String? @db.VarChar(255) title_of_in_country_news String @db.VarChar(255) text_of_in_country_news String @db.Text date_of_in_country_news DateTime @db.Date added_by String @default("Error") @db.VarChar(255) verified Boolean @default(false) }

//Below is Macrovesta Sentiment Survey

model sentiment_survey { record_id String @id @default(cuid()) bullish_or_bearish String @db.VarChar(255) high Decimal? @default(0) @db.Decimal(16, 4) low Decimal? @default(0) @db.Decimal(16, 4) intraday_average_points Decimal? @default(0) @db.Decimal(16, 4) open_interest Decimal? @default(0) @db.Decimal(16, 4) date_of_survey DateTime? @db.Date added_by String @default("Vic") @db.VarChar(255) }

//Below is the Comparison Charts with 17 Months Year

model comparison_charts_with_17_months_year { record_id String @id @default(cuid()) season String @db.VarChar(255) low_price Decimal? @default(0) @db.Decimal(16, 4) date_of_low DateTime @db.Date month_of_low Int @default(0) calendar_week_of_low Int @default(0) high_price Decimal? @default(0) @db.Decimal(16, 4) date_of_high DateTime @db.Date month_of_high Int @default(0) calendar_week_of_high Int @default(0) range_between_high_low Decimal? @default(0) @db.Decimal(16, 4) rank_of_price_range Int @default(0) percentage_rate_to_low Decimal? @default(0) @db.Decimal(16, 4) //this is a percentage move from high to low during the season day_range_between_high_low Int @default(0) rank_between_high_low Int @default(0) inverse_season String @db.VarChar(255) us_seasonal_inflation Decimal? @default(0) @db.Decimal(16, 4) us_inflation_cumm Decimal? @default(0) @db.Decimal(16, 4) us_interest_rate_mov Decimal? @default(0) @db.Decimal(16, 4) us_interest_cumm Decimal? @default(0) @db.Decimal(16, 4) world_population_cumm Int @default(0) world_population_mov Int @default(0) world_acreage Int @default(0) world_acreage_movement Int @default(0) }

Environment & setup

• OS:
• Browser:
• Database:

Prisma logs

victorfernandes@Victors-MacBook-Pro macrovesta.io % npx prisma studio Environment variables loaded from .env Prisma schema loaded from prisma/schema.prisma Prisma Studio is up on http://localhost:5555 warn Preview feature "referentialIntegrity" is deprecated. The functionality can be used without specifying it as a preview feature.