Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Posts could not be saved to database: bun: Insert(empty *reflect.rtype) #4

Open
abesnowman opened this issue Oct 26, 2021 · 12 comments
Labels
bug Something isn't working

Comments

@abesnowman
Copy link

abesnowman commented Oct 26, 2021

Describe the bug

After auto-updating to 0.6.0, recieved the following and the program halts.

fansyloader / v0.6.0

SUCCESS Configuration file loaded: C:\Apps\fansyloader\config\config.toml
DEBUG Application start
SUCCESS Webserver listening on 127.0.0.1:8080
• Step 1: Open the Chrome or Firefox browser and do NOT use private mode
• Step 2: Log in to REDACTED with the same browser
• Step 3: Open the url http://127.0.0.1:8080 with the same browser
• Step 4: Stay logged in

SUCCESS Request received
SUCCESS User-agent detected
SUCCESS Browser database found
SUCCESS Authentication successful. User: Abe Snowman - Yeti Vigilante ☃️ ()
INFO Download will be started

INFO Load purchased posts (offset=0)
DEBUG Purchased posts loaded
DEBUG Save posts in db
WARNING Posts could not be saved to database: bun: Insert(empty *reflect.rtype)
ERROR Error while scraping the files: bun: Insert(empty *reflect.rtype)
ERROR Links could not be downloaded: bun: Insert(empty *reflect.rtype)

Desktop (please complete the following information):

  • OS: Windows 11 Home Version 21H2, Build 22000.282
  • Browser: Firefox Version 93.0
  • Auth: Sideloading

Logs emailed.

@abesnowman
Copy link
Author

FYI, within seconds of posting this issue (before redacting the URL of the content host and my twitter username, for OAUTH), my OF account was banned/deleted.

@montroly
Copy link
Owner

Hi, first of all thanks for the issue. But WTF? How does the ban show?

Does anyone else have a problem with this? I run the scraper several times a day and haven't had a ban yet.

@montroly
Copy link
Owner

SUCCESS Authentication successful. User: Abe Snowman - Yeti Vigilante snowman_with_snow ()

Is that your real username at the top of the console pulldown? 🙈

@abesnowman
Copy link
Author

abesnowman commented Oct 26, 2021

It was, before I removed it - doesn't matter now, I reckon. (username) was what within the parenthesis.

Edited by montroly: username replaced

@abesnowman
Copy link
Author

I suspect they have a scraper (ironically) trolling github for possible usernames of OF users, and drop the banhammer when there's a match. I ranted about it a bit, but also noticed that their TOS effectively prohibit anyone from accessing the site, so .... anyways, not sure how much I can help debug this, now.

I did go in and flip the last 3 entries in the sqlite db to "downloaded == 0" and it made no noticeable difference. I also flipped the log bit and the debug bit in the config file.

@montroly
Copy link
Owner

I have created a release which should solve the problem, but unfortunately this does not bring you anything anymore. I don't think that the ban has anything to do with the error, because it only refers to the local installation.

It was, before I removed it - doesn't matter now, I reckon. (username) was what within the parenthesis.

So you replaced the name in the issue opening? (Username and display name)

I suspect they have a scraper (ironically) trolling github for possible usernames of OF users, and drop the banhammer when there's a match. I ranted about it a bit, but also noticed that their TOS effectively prohibit anyone from accessing the site, so .... anyways, not sure how much I can help debug this, now.

I find it strange how quickly the ban was applied. Maybe they really use a scraper but it's crazy to just ban usernames from Github. I also saw an issue about a ban on another scraper, but didn't expect to read about it here so quickly. :-/

@montroly montroly added the bug Something isn't working label Oct 26, 2021
@abesnowman
Copy link
Author

Correct - originally, the line was:
SUCCESS Authentication successful. User: Abe Snowman - Yeti Vigilante ☃️ (abesnowman)

@montroly
Copy link
Owner

montroly commented Oct 27, 2021

I'm just a little confused because you removed the username but not the display name? Best I remove the username output from the program.

If you do not know how to get a new account, you may find help in this forum: https://forum.sexy-egirls.com/forums/helping-the-community.11/

@abesnowman
Copy link
Author

abesnowman commented Oct 27, 2021

The display name is a variable that can be easily changed by the user on Twitter, and often is - and is not required to be unique. The username is much more static and does not change frequently because it is unique across the service, and thus would be the ideal key for a user on OF created by Twitter OAUTH, and potentially the most useful data to pull out of a search for potential violators of the AUP based on github projects.

Does that make sense?

@montroly
Copy link
Owner

Does that make sense?

Yes, that makes sense. But the display name is also in the OF database and can be used to identify users if it is unique. The username would be better of course but I think the display name should be sufficient for OF to identify a user in most cases. Thus I think I should not output both of them.

@abesnowman
Copy link
Author

Yes, I would remove any identifying data, and also the name of the service being scraped - in case it's also in the search criteria.

@aukeba
Copy link

aukeba commented Jun 25, 2022

I'm having this problem as well but without the ban as far as I can see. I've tried everything but the manual mode as quite frankly I can't figure that one out. Is there any fixes for this?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants