Elon Report

1 hour ago, Sonya* said:

Have you rebuilt search index in ACP? Take a look at core_search_index in your database. Can you see your record there?

Rebuilding solved the problem.  Thanks for the extra troubleshooting tip as well!

It is MySQL - but I will look into a elastic server!

That was not the problem.  I changed the title to text, and made the value 00002

Searching produces the same result - none.

OK, I am now trying to search actual data, and running into an issue.  Was going to start a new thread but this one was at the top.  🙂

I have a database (#4) on a page, and I am able to upload a record to it.   I can see it on the page. However, I always get no results found via the api.

{{base_url}}?/core/search&q=2&type=cms_records4

The title is "2".  I've tried playing with variables but nothing gets returned when there are no filters at all!

58 minutes ago, Sonya* said:

You need a page. The database itself has no url, the page has. If there is no URL, nothing can be accessed or searched.

That was the solution!   I was able to create records without a url though.

For anyone else that stumbles with this issue:

My database id is 3.   My new page id is 4.

The contenttype is cms_records3

Thanks all.

10 hours ago, Marc Stridgen said:

You are better to wait until things are released rather than trying to prepare for things without the knowledge of how they work, to be honest.

I'm too eager.  😞  Let me do a couple out of context analogies so I can appear smarter while admitting you are correct:

Should I stop dreaming about living on the moon now that I know we are going there?
Should I stop preparing my child's room until I know what gender they prefer?

Thanks Marc.  🙂

Yes it is.

What contenttype am I looking for if I want to search database 3?    Is it supposed to be cms_records3 or something else?

11 minutes ago, Daniel F said:

 

Are you sure that there's a DB 3? If yes, is it placed on a frontend page?

Yes, there is database 3.   It is not placed on a page - do I need to do that to access the data?

REST API keys, instead of the OAuth.

7 hours ago, Stuart Silvester said:

Are you using OAuth tokens? If so, the member you're connecting as most likely doesn't have permission to see the database.

No, I am using REST API.   I tried cms_records3, but that did not work.   

I want to search a title in a database to make sure the record is not already there.   I found the different search types I can do:

    "contenttypes": [
        "core_statuses_status",
        "calendar_event",
        "cms_pages_pageitem",
        "cms_records1",
        "cms_records2",
        "forums_topic",
        "nexus_package_item",
        "links_link"
    ]

What contenttype do I use if I want to search database #3?

Look into Wasabi.  They use AWS but they do not charge for data egress.

When creating a forum, I can make it as Discussion or Questions.   Is there a way a single forum can have both?

Otherwise, do I need to create a second forum for any topic I want to provide experts on?

53 minutes ago, Daniel F said:

The temp_ban column in the core_members table contains the banned state.

0 means not banned

-1 means banned 

any other integer in this column is the timestamp until the user should be banned

Sorry,  this is not the issue.  temp_ban is 0.

I get the error when visiting my front page, not after logging in.  I can still access the admin area.

Have any of you ever said "shut" to your Google Assistant?  😛

We all know it's coming - the day they will take over.

I guess I told my Google Assistant to "shut" too many times, so in retaliation it blocked me from my website.

BANNED

You do not have permission to view this site.

LIttle does the AI know I self host so I can access the database.  I just don't know what to edit to remove my IP from the ban list.

Please help!

bio lives matter

I basically got a F you when asking for my money back.  They told me they could not refund me because there was usage on my account - usage caused by their support staff!

I never had a single zap work.

On 1/9/2024 at 4:35 AM, Marc Stridgen said:

no problem. Please let us know how you do with that

Ended up cancelling my account today.  I'm getting better with API's, so if they cannot solve such a basic issue, why do I need them?

Support really sucks on the "Starter" plan.   It takes support 2-3 days to reply.   I was supposedly put in contact with a higher level of support and I sent a message on Thursday morn to reset my account, but I have not heard anything, so I cancelled today.

I asked for my $ back since I was not able to get a single Zap working how I wanted it with Invision.  I'll see what they say.   I only used them because of the Invision integration!  In the meantime, I am going to look at some alternatives. 

Quote

We have no way in which to change your Zapier API key. 

Ok, so the Zapier key is tied to meta data on my account.  I have asked them if thy can wipe their record of me, so I can start again.

11 hours ago, Jim M said:

Glad at least you have a direction to try.

Thanks.  You are staff - did you reset my key?

11 hours ago, Daniel F said:

Do you see any errors in the browsers JS console?

No.  We are at the troubleshooting step of resetting my account.

Please let me know when you reset my Zapier API so I can continue troubleshooting.

Martin

Did you guys regenerate a new API key for me?   I tried reconnecting but not sure if they key changed.  It's still not working, so I need to let them know if we tried this step or not.

I request my Zapier API key be re-generated.  

Zapier support cannot figure out what's going on.  I see the fields load quickly before vanishing on the screen.  Hoping there is some corruption in my existing record, so I need a new key.

Still dealing with Zapier support - they reply every 24-36 hours with redundant copy/paste responses.    

I've found a workaround using the API, but I will post the solution (when found) in case this happens to someone else.

See image - Above each "Fields" there should be a database name.   Would this be related to my theme?

Still working with their support.

I have tried setting a default value for both fields, but I still get the error.

Does default value here work the same as default value in mysql?  i.e.  If I don't send the title field, would the default value be applied?  

8 hours ago, Marc Stridgen said:

Have you checked the permissions on those fields to ensure you are not restricting them in any way?

Good suggestion!   All permissions are set to full for everyone.

Any others?   Zapier support should come back tomorrow, hopefully.