[Hard issue] I am trying to pull data from my MongoDB but its not pulling anything.

Answered

Kromfohrländer posted this in #help-forum

KromfohrländerOP

2024-10-07T12:00:59.715Z

I have a somewhat hard issue that I cant fix. I'd like to explain in detail if someone is willing to help.

Basically,
1. User inputs info of the company they want to create on the website, company info goes to mongodb, no problem.
2. User can create a job posting, that data goes to mongodb, no problem and it shows on the page.
3. User clicks on "company" and goes to the company page where they can find more jobs of that company.
4. I want the company details to show on that page but they arent showing.

! Please let me know which tag to use here so I can use that.

Answered by Double-striped Thick-knee

He had to clear his database and workOS data. It solved the issue.

View full answer

198 Replies

@Kromfohrländer I have a somewhat hard issue that I cant fix. I'd like to explain in detail if someone is willing to help. Basically, 1. User inputs info of the company they want to create on the website, company info goes to mongodb, no problem. 2. User can create a job posting, that data goes to mongodb, no problem and it shows on the page. 3. User clicks on "company" and goes to the company page where they can find more jobs of that company. 4. I want the company details to show on that page but they arent showing. ! Please let me know which tag to use here so I can use that.

Double-striped Thick-knee

2024-10-07T12:03:25.830Z

is there any error, or getting empty response?

KromfohrländerOP

2024-10-07T12:04:13.020Z

Thank you for you interest. I have added a message saying: : (
<p>Company details are not available at this time.</p>

{companyDetails ? (
                <div className='space-y-2'>
                  <div className='flex items-center'>
                    <User className='w-5 h-5 mr-2 text-muted-foreground' />
                    <span className='capitalize'>
                      {companyDetails.newCompanyContactName}
                    </span>
                  </div>
                  <div className='flex items-center'>
                    <Mail className='w-5 h-5 mr-2 text-muted-foreground' />
                    <span>{companyDetails.newCompanyEmail}</span>
                  </div>
                  <div className='flex items-center'>
                    <Phone className='w-5 h-5 mr-2 text-muted-foreground' />
                    <span>{companyDetails.newCompanyPhone}</span>
                  </div>
                  <div className='flex items-center'>
                    <Map className='w-5 h-5 mr-2 text-muted-foreground' />
                    <span>{companyDetails.newCompanyLocation}</span>
                  </div>
                  {companyDetails.newCompanyWebsite && (
                    <div className='flex items-center'>
                      <Globe className='w-5 h-5 mr-2 text-muted-foreground' />
                      <a
                        href={companyDetails.newCompanyWebsite}
                        target='_blank'
                        rel='noopener noreferrer'
                        className='text-blue-500 hover:underline'
                      >
                        {companyDetails.newCompanyWebsite}
                      </a>
                    </div>
                  )}
                </div>
              ) : (
                <p>Company details are not available at this time.</p>
              )}

Conditional operator.

I understand this is not enough info as there are three different pages.

Double-striped Thick-knee

2024-10-07T12:06:11.340Z

can you show the query you're making to database to get company details

KromfohrländerOP

2024-10-07T12:06:16.296Z

Yup

I have a Company.ts:

import { Document, Schema, model, models } from 'mongoose';

export interface Company extends Document {
  newCompanyContactName: string;
  newCompanyPhone: string;
  newCompanyEmail: string;
  newCompanyLocation: string;
  newCompanyWebsite?: string;
  organizationId: string; // Add this field
}

const CompanySchema = new Schema<Company>({
  newCompanyContactName: { type: String, required: true },
  newCompanyPhone: { type: String, required: true },
  newCompanyEmail: { type: String, required: true },
  newCompanyLocation: { type: String, required: true },
  newCompanyWebsite: { type: String },
  organizationId: { type: String, required: true }, // Include the organizationId field
});

// Check if the model already exists in the

models

collection
export const CompanyModel =
  models.Company || model<Company>('Company', CompanySchema, 'companies');

Eveyrthing goes to mongodb as planned.

I get this error message by the way: Error fetching company details: Cast to ObjectId failed for value "org_01J9KB7TP4Q2AVC4QMP6167S0S" (type string) at path "_id" for model "Company"

Not sure if its corect. I put it in GPT and asked it to show me the error message as to why im not getting the data.

Double-striped Thick-knee

2024-10-07T12:09:07.632Z

show the code where you've called CompanyModel.find

@Kromfohrländer I have a Company.ts: `import { Document, Schema, model, models } from 'mongoose'; export interface Company extends Document { newCompanyContactName: string; newCompanyPhone: string; newCompanyEmail: string; newCompanyLocation: string; newCompanyWebsite?: string; organizationId: string; // Add this field } const CompanySchema = new Schema<Company>({ newCompanyContactName: { type: String, required: true }, newCompanyPhone: { type: String, required: true }, newCompanyEmail: { type: String, required: true }, newCompanyLocation: { type: String, required: true }, newCompanyWebsite: { type: String }, organizationId: { type: String, required: true }, // Include the organizationId field }); // Check if the model already exists in the `models` collection export const CompanyModel = models.Company || model<Company>('Company', CompanySchema, 'companies'); `

KromfohrländerOP

2024-10-07T12:09:32.407Z

That would be this.

Where i typed Company.ts

Sorry

The entire code is here. Its not big so easy to skim through

This is new-company, where the user puts in their info about the company

Lastly this is workosactions:

Double-striped Thick-knee

2024-10-07T12:12:03.713Z

thanks I'm looking into it

KromfohrländerOP

2024-10-07T12:12:23.402Z

I also have a github if thats easier

Double-striped Thick-knee

2024-10-07T12:13:11.286Z

  const companyDetails = (await CompanyModel.findOne({
    organizationId: org.id,
  }).lean()) as Company | null;

the screenshot you showed earlier from mongodb compass. I don't see any organizationId.

KromfohrländerOP

2024-10-07T12:14:19.961Z

Right 1 sec

Sorry

This is new

So i also saw that the _id and organizationid dont match and I believe they should to show correct data?

@Kromfohrländer So i also saw that the _id and organizationid dont match and I believe they should to show correct data?

Double-striped Thick-knee

2024-10-07T12:16:20.625Z

that's not required if you're not using the default _id to query

Chinese Alligator

2024-10-07T12:17:06.175Z

i m not have clue to this but u should use prims orm i can say that it is very easy to talk with database

else prims handles or else orm

@Chinese Alligator i m not have clue to this but u should use prims orm i can say that it is very easy to talk with database

Double-striped Thick-knee

2024-10-07T12:17:39.991Z

are you talking about prisma?

Chinese Alligator

2024-10-07T12:17:47.927Z

i would say the day i got or used prisma never goona do the manual one like mongoose or somethung like that

@Double-striped Thick-knee are you talking about prisma?

Chinese Alligator

2024-10-07T12:17:52.520Z

yes

KromfohrländerOP

2024-10-07T12:17:55.820Z

My github if needed: https://github.com/yasingunaydiin/yuk-yolu-full-stack-app

Chinese Alligator

2024-10-07T12:18:04.604Z

what u think about that ?

@Chinese Alligator i would say the day i got or used prisma never goona do the manual one like mongoose or somethung like that

Double-striped Thick-knee

2024-10-07T12:18:23.395Z

yeah true. tho I also use drizzle. never used mongoose again

Chinese Alligator

2024-10-07T12:18:35.656Z

durzzle orm right ?

it is similar to the prisma or have something else /

@Chinese Alligator i would say the day i got or used prisma never goona do the manual one like mongoose or somethung like that

KromfohrländerOP

2024-10-07T12:18:54.688Z

Never heard of it.. I have no idea how to use a different database now that everything is set up..

@Kromfohrländer My github if needed: https://github.com/yasingunaydiin/yuk-yolu-full-stack-app

Double-striped Thick-knee

2024-10-07T12:18:56.443Z

thanks it will be helpful

KromfohrländerOP

2024-10-07T12:19:07.938Z

Thank you so much for your time guys

Chinese Alligator

2024-10-07T12:19:30.236Z

if u have not so far with u r project u must see the orm prisama or drizlle whatever u like

@Chinese Alligator it is similar to the prisma or have something else /

Double-striped Thick-knee

2024-10-07T12:19:31.554Z

kinda similar but more performant in complex queries

Chinese Alligator

2024-10-07T12:19:52.448Z

i have error which i m solving but still i did not figure out what is casuing werror

nice

@Chinese Alligator if u have not so far with u r project u must see the orm prisama or drizlle whatever u like

Double-striped Thick-knee

2024-10-07T12:20:09.694Z

@Kromfohrländer you should definitely try prisma. it's really easy to use

@Chinese Alligator if u have not so far with u r project u must see the orm prisama or drizlle whatever u like

KromfohrländerOP

2024-10-07T12:20:26.494Z

I have everything set up its not a big project. Person creates job, person creates company thats all the data im storing.

Chinese Alligator

2024-10-07T12:20:37.840Z

yes only need one link to connect datbase and one file for prisma that is

KromfohrländerOP

2024-10-07T12:20:49.333Z

I just need the data shown on the job page thats all i need and then im done with database i think lol

@Chinese Alligator yes only need one link to connect datbase and one file for prisma that is

KromfohrländerOP

2024-10-07T12:20:56.411Z

wow

@Kromfohrländer I have everything set up its not a big project. Person creates job, person creates company thats all the data im storing.

Chinese Alligator

2024-10-07T12:21:01.563Z

it must be something like crm for jobs and company

@Chinese Alligator yes only need one link to connect datbase and one file for prisma that is

Double-striped Thick-knee

2024-10-07T12:21:28.831Z

switching database is also easy. just need to modify the schema a little bit but code stays same

KromfohrländerOP

2024-10-07T12:21:29.769Z

Im writing Prisma down but I've no idea how to set it up. that would be a differnet issue..

Chinese Alligator

2024-10-07T12:21:38.629Z

not used with other ones but it supports sqlite and postsql and cockrachdb and one more i guess

@Double-striped Thick-knee switching database is also easy. just need to modify the schema a little bit but code stays same

KromfohrländerOP

2024-10-07T12:21:41.117Z

Chinese Alligator

2024-10-07T12:21:47.626Z

it is done by command line

u have to do nothing

Double-striped Thick-knee

2024-10-07T12:22:23.771Z

@Kromfohrländer I'm going to run the project. before that, do i need any env setup?

Chinese Alligator

2024-10-07T12:22:31.831Z

just see once try and then see i m not giving guarentee that u not goona face error there but it is relatvely easy compare to whole this stufff

KromfohrländerOP

2024-10-07T12:22:45.019Z

Yeah theres a env file

@Chinese Alligator just see once try and then see i m not giving guarentee that u not goona face error there but it is relatvely easy compare to whole this stufff

KromfohrländerOP

2024-10-07T12:23:22.002Z

Theres a lot of mongodb code written though Im a beginner at this lol. first full stack project.

Chinese Alligator

2024-10-07T12:23:39.662Z

i have done mine first project 1 month ago

@Double-striped Thick-knee <@124924784055156736> I'm going to run the project. before that, do i need any env setup?

KromfohrländerOP

2024-10-07T12:24:02.133Z

Can you try to run it? I guess you need the env file.

Chinese Alligator

2024-10-07T12:24:04.972Z

used there prsima first time there

@Chinese Alligator used there prsima first time there

KromfohrländerOP

2024-10-07T12:24:19.409Z

Gonna look into it if this doesnt work. Thank you!

Chinese Alligator

2024-10-07T12:24:19.991Z

by the way what error are u facing ?

@Kromfohrländer Can you try to run it? I guess you need the env file.

Double-striped Thick-knee

2024-10-07T12:24:37.212Z

I checked, looks like I need mongodb and workos key

btw what is workos used for

Chinese Alligator

2024-10-07T12:25:25.019Z

so u do job or student ?

@Double-striped Thick-knee btw what is workos used for

KromfohrländerOP

2024-10-07T12:25:50.380Z

WorkOS is to create the company. it stores it there

As an organizaton

Its for the auth

I use their login and registration but i really dislike it. I started the project with a tutorial vid.

Chinese Alligator

2024-10-07T12:26:28.755Z

i m building a somewhere something to u making

whose tutor ?

KromfohrländerOP

2024-10-07T12:26:46.846Z

Im a recent graduate but i got into front end coding two years ago

Coding with Dawid

Chinese Alligator

2024-10-07T12:27:07.487Z

i nevr heard but have to see

coding with lewis and cooding with antmion i have heard and made mine first project from the code with antonio

KromfohrländerOP

2024-10-07T12:28:13.537Z

I liked the look of the website he made so i just went with it as it was a Job Platform.

But i dont like his style. I dont learn anything with it and he wrote everything very complex.

Chinese Alligator

2024-10-07T12:28:49.692Z

already it is subscribed somehow

i same felit from jsm one

KromfohrländerOP

2024-10-07T12:29:31.777Z

I hope I can fix this issue then I can continue with making it. Ive been trying to fix it for two days

Chinese Alligator

2024-10-07T12:29:52.392Z

i have solved an error for like 2 months on own

it is about cms

KromfohrländerOP

2024-10-07T12:30:29.611Z

Dawid wrote a LOT of code to pull data and stuff and i dont know what to delete or to keep so Im not sure about Prisma. Id just put everything into GPT and ask it to use prisma but thats so much

Chinese Alligator

2024-10-07T12:30:55.134Z

okay so u now what issue u are facing ?

in project

KromfohrländerOP

2024-10-07T12:31:15.025Z

Like i said: Basically,
User inputs info of the company they want to create on the website, company info goes to mongodb, no problem.
User can create a job posting, that data goes to mongodb, no problem and it shows on the page.
User clicks on "company" and goes to the company page where they can find more jobs of that company.
I want the company details to show on that page but they arent showing.

I can also do a screen video or we can screenshare I dont mind if you have the time. @Double-striped Thick-knee

Id like that more lol

Chinese Alligator

2024-10-07T12:32:19.295Z

so data not coming while rendering on the next js app frontend the data is not coming right ?

KromfohrländerOP

2024-10-07T12:32:39.831Z

Yeah

Chinese Alligator

2024-10-07T12:32:48.209Z

i do have after we solve u r error u can help in mine error haah

haha

@Kromfohrländer I get this error message by the way: Error fetching company details: Cast to ObjectId failed for value "org_01J9KB7TP4Q2AVC4QMP6167S0S" (type string) at path "_id" for model "Company"

KromfohrländerOP

2024-10-07T12:32:57.664Z

Im not sure if this is right but i get this error message

@Chinese Alligator i do have after we solve u r error u can help in mine error haah

KromfohrländerOP

2024-10-07T12:33:06.161Z

LOL

The annoying thing is, the jobs do come

Chinese Alligator

2024-10-07T12:33:41.103Z

then what is not coming ?

KromfohrländerOP

2024-10-07T12:33:42.836Z

The company details

Chinese Alligator

2024-10-07T12:33:57.640Z

okay

can u show the company details u fetching ?

Double-striped Thick-knee

2024-10-07T12:34:16.530Z

@Kromfohrländer can you give a .env placeholder

@Double-striped Thick-knee <@124924784055156736> can you give a .env placeholder

KromfohrländerOP

2024-10-07T12:35:04.452Z

Sorry how do i do that? Can you use my current?

Chinese Alligator

2024-10-07T12:35:18.226Z

i think u shoudl screen share

if possibe

KromfohrländerOP

2024-10-07T12:35:21.632Z

Ill just recreate evrything

Double-striped Thick-knee

2024-10-07T12:35:22.707Z

copy paste your env without the values

KromfohrländerOP

2024-10-07T12:35:26.001Z

WORKOS_API_KEY=''
WORKOS_CLIENT_ID=''
WORKOS_COOKIE_PASSWORD=""
NEXT_PUBLIC_WORKOS_REDIRECT_URI=""
MONGO_URI=""

Chinese Alligator

2024-10-07T12:36:32.184Z

it is written in javscript or typescript ?

Double-striped Thick-knee

2024-10-07T12:37:00.871Z

typescript

Chinese Alligator

2024-10-07T12:37:20.419Z

then it is good

so then there is no mess at least

so u could send me the file it fetching the company details

@Kromfohrländer My github if needed: https://github.com/yasingunaydiin/yuk-yolu-full-stack-app

Double-striped Thick-knee

2024-10-07T12:38:20.442Z

here's the github repo he sent

KromfohrländerOP

2024-10-07T12:38:25.263Z

Right

Chinese Alligator

2024-10-07T12:38:28.304Z

okay soory i didnt now that

KromfohrländerOP

2024-10-07T12:38:31.690Z

Np 😛

Chinese Alligator

2024-10-07T12:39:11.419Z

okay and this page company one is where path ?

KromfohrländerOP

2024-10-07T12:39:50.980Z

http://localhost:3000/jobs/[orgid]/page.tsx

Double-striped Thick-knee

2024-10-07T12:39:52.410Z

@Kromfohrländer where is this coming from. 🫠

KromfohrländerOP

2024-10-07T12:39:55.217Z

I think you mean this

Chinese Alligator

2024-10-07T12:40:04.098Z

i do

@Double-striped Thick-knee <@124924784055156736> where is this coming from. 🫠

KromfohrländerOP

2024-10-07T12:40:20.029Z

Thats framer motion

npm install framer-motion

Chinese Alligator

2024-10-07T12:41:02.253Z

yes animation libray if i m not wrong i used in mine portfolio website

KromfohrländerOP

2024-10-07T12:41:28.451Z

Yup :p

Chinese Alligator

2024-10-07T12:42:53.938Z

so at which line does it perfect at that file ?

Double-striped Thick-knee

2024-10-07T12:43:03.475Z

it finally ran but I don't understand the language 💀

Chinese Alligator

2024-10-07T12:43:13.238Z

haha

if it works dont touch it

KromfohrländerOP

2024-10-07T12:43:23.632Z

Uhhm

Want me to wuickly make it all enlgihs?

Chinese Alligator

2024-10-07T12:44:01.625Z

so u solved it bug ?

@Kromfohrländer Want me to wuickly make it all enlgihs?

Double-striped Thick-knee

2024-10-07T12:44:17.744Z

you can tell me where to click. I have logged in

@Chinese Alligator so u solved it bug ?

Double-striped Thick-knee

2024-10-07T12:44:27.826Z

no, trying to recreate

KromfohrländerOP

2024-10-07T12:44:32.220Z

1 sec

Chinese Alligator

2024-10-07T12:44:42.742Z

okay i guess u doing reverse engonnering

KromfohrländerOP

2024-10-07T12:44:43.469Z

On the homepage giriş

@Chinese Alligator okay i guess u doing reverse engonnering

Double-striped Thick-knee

2024-10-07T12:44:54.636Z

yeah

@Kromfohrländer Login

Double-striped Thick-knee

2024-10-07T12:44:58.690Z

i did

KromfohrländerOP

2024-10-07T12:45:20.572Z

Then create a job by clicking on the big yellow button

Double-striped Thick-knee

2024-10-07T12:45:38.900Z

Chinese Alligator

2024-10-07T12:45:58.412Z

which language is this ?

KromfohrländerOP

2024-10-07T12:46:10.064Z

turkish

you havent logged in

Click on Giris

Chinese Alligator

2024-10-07T12:46:29.008Z

so u are from turkey ?

KromfohrländerOP

2024-10-07T12:46:29.863Z

the login page is english

Double-striped Thick-knee

2024-10-07T12:46:33.787Z

okay, whats the redirectUrl btw

KromfohrländerOP

2024-10-07T12:46:34.519Z

Im originally from Holland

Chinese Alligator

2024-10-07T12:46:51.524Z

i never hear of holland rather i heard of Polland

KromfohrländerOP

2024-10-07T12:46:54.137Z

http://localhost:3000/api/auth/callback

sorry

The Netherlands

Chinese Alligator

2024-10-07T12:47:07.973Z

okay i heard netherlands

i m from india

@Kromfohrländer http://localhost:3000/api/auth/callback

Double-striped Thick-knee

2024-10-07T12:47:15.239Z

owh thanks, I put ...3000/

Chinese Alligator

2024-10-07T12:47:18.265Z

if u knew then

KromfohrländerOP

2024-10-07T12:47:26.189Z

Yes Bharat 🙂

Chinese Alligator

2024-10-07T12:47:32.600Z

wow dude

how u knew bharat thing ?

KromfohrländerOP

2024-10-07T12:48:08.269Z

i do my research 🙂

@Chinese Alligator i m from india

Double-striped Thick-knee

2024-10-07T12:48:14.214Z

where in india

Chinese Alligator

2024-10-07T12:48:31.484Z

but i would u saying that u r code works at which point it dosnt work on file ?

u from india too ?

@Chinese Alligator u from india too ?

Double-striped Thick-knee

2024-10-07T12:49:07.854Z

I'm from Bangladesh. ap kyase ho?

Chinese Alligator

2024-10-07T12:49:21.076Z

okay i m from india guj

so everything okay in bangladesh ?

@Chinese Alligator so everything okay in bangladesh ?

Double-striped Thick-knee

2024-10-07T12:50:20.208Z

It's better than July

KromfohrländerOP

2024-10-07T12:50:31.803Z

After logging in, click on the big yellow button, then click on sirket olustur (create company), then write company name, a human name, phone number (12345) email, location and a random website.

Chinese Alligator

2024-10-07T12:50:48.370Z

i heard u there is not things well so

@Chinese Alligator i heard u there is not things well so

Double-striped Thick-knee

2024-10-07T12:51:11.575Z

from news I assume?

@Kromfohrländer After logging in, click on the big yellow button, then click on sirket olustur (create company), then write company name, a human name, phone number (12345) email, location and a random website.

Double-striped Thick-knee

2024-10-07T12:51:19.560Z

Chinese Alligator

2024-10-07T12:52:12.553Z

so u have for or clone repo in the locally ?

Double-striped Thick-knee

2024-10-07T12:52:13.215Z

do i need to do something in workOS dashboard @Kromfohrländer

Chinese Alligator

2024-10-07T12:52:15.817Z

i guess

KromfohrländerOP

2024-10-07T12:52:16.978Z

i have no idea. i can login with new account

checking

joulev

2024-10-07T12:52:48.923Z

This thread has become a bit too long. Please wrap it up.

@Chinese Alligator so u have for or clone repo in the locally ?

Double-striped Thick-knee

2024-10-07T12:52:50.373Z

yh, I have cloned it locally, now trying to run it

@joulev This thread has become a bit too long. Please wrap it up.

KromfohrländerOP

2024-10-07T12:53:28.169Z

We arent even close to fixing my issue though. Sajid hasnt seen the issue yet

Chinese Alligator

2024-10-07T12:54:48.690Z

even not i figure it really what is bug flow even

i think we should dm

@Kromfohrländer okay ?

@Chinese Alligator <@124924784055156736> okay ?

KromfohrländerOP

2024-10-07T12:58:27.632Z

Sure 1 sec

Chinese Alligator

2024-10-07T13:04:45.633Z

pkay

so now what is going on ?

KromfohrländerOP

2024-10-07T13:44:04.649Z

@Double-striped Thick-knee Helped me out, he's a real bro. ❤️

Double-striped Thick-knee

2024-10-07T13:45:46.287Z

He had to clear his database and workOS data. It solved the issue.

Answer

KromfohrländerOP

2024-10-07T13:45:47.080Z

Trying to find where to mark as solved lol

@Kromfohrländer Trying to find where to mark as solved lol

Double-striped Thick-knee

2024-10-07T13:46:21.804Z

lol, looks like the issue is somewhere we can't find

KromfohrländerOP

2024-10-07T13:46:30.383Z

I did it