Missing tables in Adminer for Custom/Old .LENS

[Jbla0712]

Hi Patrick @ptrumpis

There are missing tables in Adminer MySQL.
I had modified some lenses (the Blendmode), and I used to access the table via the ID number in previous server versions.
However, since version 3.3 or 3.4, many tables are missing, and now I can't use my .Lens files because I can't find them.

Could you also add a function to allow adding a folder that would be scanned by Docker to retrieve custom .lens files?
It would be even easier, right?

Thanks, Pat. I understand what I'm doing, but I'm not a developer.
I just know a little Python. However, I fully understand what I’m doing when I redirect my database links.
I’ve noticed how you use Wayback Machine; it’s clever.
But my IP is often blocked since I spam SnapCamera (lmao), and I don't fully understand everything in the server.
But hey, I learn quickly.
Thanks again for your work, good luck!

[ptrumpis]

I assume you are talking about the rows of the unlock table?

Migration to v3.3.1 removed invalid unlock rows with an empty url.
But these rows would not point to lens files anyway.

I don't know about anything else that would match your description.

You also no longer need Adminer to import, since uploading modified lenses can be done with the Individual Lens Upload Mode of https://ptrumpis.github.io/snap-lens-cache-import/

[Jbla0712]

The import tells me the ID is invalid. :(
Example with "Lens Subtle Glam"
I inserted the lens link into SnapCamera, and Docker tells me: "😕 Unable to activate this lens currently: 63198310892."
I have the .lens file (modified with the tool with blendmode=13)
because I retrieved it with "snapcamera tool" a long time ago. My .lens was working before.
(It is fixed with blendmode=13 instead of 16)

So
I point to the .lens from my import file, plus the lens link or the ID, and I get an invalid ID from the import server. I don't understand how to use my .Lens.
So how do I get the lens to work because I was able to do it before 3.3.1???
I have a lot of unusable .lens now 🤔😟
I don't understand how to get out of this, I can't find the corresponding unlock tables anymore.

How can I recreate them? (tables )

Here is the lens, it's just an example, but I have the .lens of this lens and I know it works after modifying the blendmode via the tool.
Lens:
https://www.snapchat.com/lens/6a53eeee779f4c018ec29bd4044b9c49

Sorry, I do what I can, and before, I was the one helping others.😭
Thanks Pat, have a nice day. 😁

ANd How to retrieve the .lens via the tool? It no longer works, forbidden URL. Is it Snapchat that's blocking it? Thanks

Edit:
Yes, with an existing lens, the import works. (It tells me I already have it.)
So how do I find the old "empty tables" that were useful to me?
I don't know how to recreate them.

[Jbla0712]

Ok I found it, just recreate the tables
but it's long :( @ptrumpis

[Jbla0712]

Well, for old lenses, it's forbidden to download them via the Snap Camera tool. Since January 1, 2025.
Snapchat has forbidden links!! 😓😭

I understand the Wayback Machine craze :)
However, for my old lenses, I'd better keep the backup.

Patrick, if you come back here, I'd like an automatic table editor.
If you have time, otherwise I'll try to do it using GPT.
Anyway, I'll leave this here for people who might be in the same situation.

Anyway, you know there are people in my situation with unusable .lens due to missing tables compare older version of server.
Nothing serious, but it would be good to redo a Wiki section of the tables.
Kiss Pat
Love and GL