all
/
g
/
s
/
fur
/
art
/
ai
/
3dcg
/
f
/
rp
/
req
/
p2p
/
dis
/
lit
/
kaki
chat
GUROchan!
This list is WIP...
1
2
3
So use the classic menu
Link 4
Link 5
Link 6
Link 7
List 3
Link 8
Link 9
[
Settings
]
[
Home
] [
Catalog
] [
Search
] [
Thread list
] [
Stats
] [
Reports
] [
Watcher
] [
PMs
] [
Admin
]
Discussion
[
Return
] [
Bottom
]
Posting mode: Reply
Name
E-mail
sage
Subject
Post
Comment
BBCode
B
I
U
S
Spoiler
Code
File
Animated GIF
Password
(for deletion)
Allowed file types are: gif, jpg, jpeg, png, webp, webm, mp4
Maximum file size allowed is 25000 KB.
Images greater than 255 * 255 pixels will be thumbnailed.
35
unique users in the last 30 minutes (including lurkers)
Switch form position
|
BBCode reference
|
Banned?
|
Quick reply
|
Post API
First
[1]
Last
Conversion of image numbers
Anonymous
2021/03/17
(Wed)
17:13:07
No.
12080
[
Report
]
AS
▶
Seems to be a typical conversion problem with int32/int64/float. As far as I see it, the image numbers were truncated, e.g. 1612525308027.jpg to 1612525308.jpg, which is hinting at int32 (1,612,525,308). The images that work seems to be cleanly truncated, while the missing images were rounded in some way, e.g. 1612524931999.jpg to 1612524932.jpg.
And guess what? The cleanly truncated image is still there, the given number is the start image of the 3Dhanging thread in 3dcg, which is broken in the post.
https://img.guro.wtf/3dcg/src/1612524931.jpg
Only the link in the post is rounded wrong. I guess there will still be some images missing because the truncation will have produced duplicates.
>>
1
Anonymous
2021/03/17
(Wed)
17:19:06
No.
12081
[
Report
]
▶
The real question is how we fix this
>>
2
Anonymous
2021/03/17
(Wed)
17:23:27
No.
12082
[
Report
]
▶
You'll notice on /g/, in the hanging thread for example, all of the thumbnails are there, but the full resolution images are completely gone
>>
3
Anonymous
2021/03/17
(Wed)
17:36:59
No.
12083
[
Report
]
▶
>>8
The extensions of the links to the full images are gone.
https://img.guro.wtf/g/src/1612034900
.
Seems there's even more gone wrong with the migration. As a software developer, I suggest a complete restart at that point. You likely won't fix that with a good (enough) result in any way.
>>
4
Anonymous
2021/03/17
(Wed)
18:59:36
No.
12084
[
Report
]
▶
>>9
On second thought, there may be a way.
a) Make sure these problems aren't caused by database limitations. If they are, and not simply solved by exchanging an int32 to an int64 or something, better roll back to the old site and restart the software evaluation. Everything else and you are in a world of pain. You may like that, but make a separation between gurochan fiction and web admin reality.
b) Copy the original images with their original names over to where they belong. No need to delete the broken images beforehand, you can identify them later by the shorter names, but check and verify that.
c) Extract the linking between board name / post id / image name from the old database. That's unique, there's only zero or one image per post.
d) Put the old image names into the new database where they belong, based on board name and post id. That depends heavily on the database structure, of which I don't have any idea, and you should definitely know what you're doing. Also, make sure the image number counter works correctly and starts behind the highest image number.
>>
5
Anonymous ## Mod
2021/03/17
(Wed)
20:01:53
No.
12085
[
Report
]
▶
>>10
This may be possible, but the last full image backup was on February 15th.
>>
6
Onix
2021/03/17
(Wed)
20:19:01
No.
12086
[
Report
]
▶
Not sure if that is even possible but maybe just give moderation powers to anyone on the posts where images were corrupted so uploaders will just fix those posts themselves.
In fact, it would be nice if it would be possible to use that file delete password not just for deleting the post but for editing it, and then all those problems are easy to solve.
otherwise, I don't see any good way to fix it automatically. this problem requires a human approach
>>
7
Anonymous
2021/03/17
(Wed)
20:23:19
No.
12088
[
Report
]
▶
>>11
Weeeellllll.... as I said, software developer. I've written some script for crawling this site by the HTML code, and download everything sorted by board and thread, including post ids and post texts. My last update was March 15th, two days ago before the migration. It's about 4GB with 4400 images, does that sound like the correct magnitude?
>>
8
Anonymous ## Mod
2021/03/17
(Wed)
20:27:22
No.
12089
[
Report
]
▶
>>14
Thats great, do you think you might be able to get in contact with us?
>>
9
Anonymous
2021/03/17
(Wed)
21:07:47
No.
12091
[
Report
]
▶
>>15
Currently uploading it to Mega, will take some time. Do you have a way to send a non-public message to you by the website?
>>
10
Anonymous ## Mod
2021/03/17
(Wed)
21:19:34
No.
12093
[
Report
]
▶
>>17
[email protected]
>>
11
Anonymous
2021/03/17
(Wed)
21:43:00
No.
12096
[
Report
]
▶
>>19
Not what I had in mind, but an opportunity to try an anonymous mailer for the first time. Let me know if you got a Mega link.
[
Top
]
Delete post: [
File only
]
Password:
First
[1]
Last
Style: