Projects status not changing for several hours after being listed from admin panel

[LatifatAbdullahi]

After successfully creating a new Project on Stage and the Projects has been Listed and Verified, When Users attempts to search for the new Projects by its Title, it returns no results found

Steps to reproduce the behavior: 1.Given User has created a New Project on Stage (https://staging.giveth.io/)

2. And The Projects has been Listed and Verified
3. And User navigates to the "All Projects" page
4. And User clicks on the search icon
5. When Users Pastes the Title of the New Project in the search bar
6. And User clicks on "Enter"
7. Then it returns "No records", sometimes "500:Internal Server error"

Expected behavior When a Newly created valid Project which has been listed and verified is searched by Title, the Projects should be returned

Desktop OS: Windows 11 Browser : Chrome Version 126.0.6478.127 (Official Build) (64-bit)

Additional context I have observed, it takes hours before Users can find the newly created Projects when searched

[divine-comedian]

@LatifatAbdullahi - I tested this out and wasn't able to reproduce it, is there a specific project that is not being returned on search or is it when searching for ANY keyword in the search bar?

[LatifatAbdullahi]

@divine-comedian

I have created a new Project, updated the status at the Admin

Project Title: YProjectsByLatifat

Search for the Project here (All Products page) https://staging.giveth.io/projects/all?searchTerm

[divine-comedian]

@LatifatAbdullahi - could be related to this specific project - looks like the search feature is working, but not for this proeject - this one also doesn't show up under the projects related to your profile https://staging.giveth.io/user/0xd30e526d3b5a65c68c0224fdad1096c9023b4f1b?tab=projects

We can however search and find successfully some other projects that you have made

[divine-comedian]

@RamRamez - can you check this one out too

[LatifatAbdullahi]

@divine-comedian

Yes, you are right, by tomorrow, I will be able to find the Project when I search for it.

The issue happens for newly created projects...the same Project when searched that is returning 'No results found" will return expected results by tomorrow.

That is what I have observed.

[RamRamez]

The project YProjectsByLatifat was not Listed, we only show listed projects on projects page.

I just changed the reviewStatus to Listed and it's being shown now.

https://staging.giveth.io/projects/all?searchTerm=YProjectsByLatifat

[divine-comedian]

very strange - let's try to reproduce this - @LatifatAbdullahi try to make a new project, set it as listed in the admin and test again if the UI shows it as listed on the project details page and if it can be searched for

[LatifatAbdullahi]

Sure

On Wed, 3 Jul 2024, 14:42 Mitch, @.***> wrote:

very strange - let's try to reproduce this - @LatifatAbdullahi https://github.com/LatifatAbdullahi try to make a new project, set it as listed in the admin and test again if the UI shows it as listed on the project details page and if it can be searched for

— Reply to this email directly, view it on GitHub https://github.com/Giveth/giveth-dapps-v2/issues/4364#issuecomment-2206109094, or unsubscribe https://github.com/notifications/unsubscribe-auth/A2YPQ6Q6ZM2HMO76RREGLVTZKP5THAVCNFSM6AAAAABKG7BQIKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMBWGEYDSMBZGQ . You are receiving this because you were mentioned.Message ID: @.***>

[divine-comedian]

I chatted with @LatifatAbdullahi and we were able to reproduce this issue

She creates a project then lists it in the admin panel

the UI shows the project as listed, however it cannot be found on the all projects page, by search or on the public view of the user profile page.

Only after a few hours does the project finally show on the UI, even though it's already been listed for several hours from the admin panel

@RamRamez - looks like there is a bug here, could be related to the instability of staging.

[RamRamez]

@divine-comedian We have a cache time of one minute on staging and production for projects page so it should be listed after one minute.

I just created this project "yprojects2bylatifat" and it was shown in search right after creating and listing.

https://staging.giveth.io/projects/all?searchTerm=yprojects2bylatifat

let's schedule a call and reproduce this, because everything seems fine.

[LatifatAbdullahi]

@RamRamez Lets connect tomorrow about this please

[LatifatAbdullahi]

@divine-comedian

Test completed Test Status: Pass

@RamRamez and I connected and tried different scenarios and the projects when searched is found immediately after being listed