Problem with a search box function

Hello everyone !
I recently created a website and I have one feature (including the use of search box in a database) which is not working on the live website, but still works in staging (dev version).

I recreated all the feature including workflows and database but it still does not work on the live website. The dropdown function which should display the list of choices never appear. Here is also the screenshot of what I have on my account

Do you have any ideas why ?

Here is the link of the website, please scroll to ā€œaccords met/vinā€ on the home page further down, when entering ā€œSaladeā€ for example, nothing appear here:
https://oenogo.vin
but it appears well here on the dev version,
https://oenogo.vin/version-test?debug_mode=true
If you could help me, Iā€™d be really grateful because it gives me headaches !

Have a great day and year everybody :wink:
Tristan

Is there any data in your ā€˜liveā€™ database?

First, thank you so much for trying to help me :slight_smile:

Yes sadly there are all same datas on the live part

Hard to tell without looking at your code. Does it use geolocation? Are you integrating with Google maps? If so, you might need to adjust your Google settings (ie: youā€™ve hit a limit for queries). I just had a look at your test site and nothing is coming up there for me.

Oh really ? When typing a word (for example ā€œsaladeā€) you have nothing appearing ?

Actually, would be even glad to give you the edit rights on the website as Iā€™m desperate to find a solution.

It doesnā€™t includes any google maps settings, actually, it just gives you a specific wine depending on the food you selected in the list (after typing a few letters)

So itā€™s only about the database ā€œfoodā€ in the bubble back office ā€œapp dataā€

@tr.roznowski, I agree, without being able to see more itā€™s impossible to say what the issue may be.

The only ā€˜obviousā€™ thing would be if you havenā€™t deployed your app to ā€˜liveā€™ since setting the data for the search box, otherwise there must be something more complex going on.

If you post a link to the editor (read-only) on here Iā€™ll be happy to take a quick look for you to see if I can figure it out.

Would be happy to share this editor link, where can I find it ? :slight_smile:
I have this link her with everyone can view function


Thanks again

Ok, got itā€¦

The data in your ā€˜live databaseā€™ is empty, aside from a few fields (see below)

Your search box is searching for an empty field, so thatā€™s where the issue lies.

Iā€™m not sure why itā€™s empty (the dev data is all there, so perhaps there was an error copying the data from the dev to live database).

Try copying it over again, that should fix it.

1 Like

Wow thank you so much, such a stupid mistake. The file I downloaded on the dev part to paste it on the live database was not complete because the tab was not appearing full on bubble (I had to click simply on ā€œadd all columnsā€

Truly grateful for the time you took to help me, this means a lot,

Enjoy the rest of your day :slight_smile:

You can copy the dev database automatically to the live version from the app data tab in your app - so no need to download or upload files to do it (and avoid any mistakes).

Just use the ā€˜copy and restore databaseā€™ button above your data and choose ā€˜copy development data into live databaseā€™. You can select which datatypes to copy, or you can copy all of them.