delete author and id gallery

Hi @simo2010,

Thanks for reaching out, and I’m sorry for the trouble and the late reply.

I can confirm that the “Author” column has been deprecated since the Imagely Gallery 4.0 UI update. However, the gallery ID was re-added in one of the recent versions, so it should now be available again.

Regarding the “deleted user” message in the legacy options (NextGEN Gallery > Manage Galleries), this occurs when there’s a mismatch between the user ID that created the galleries and the one currently logged in.

Is it possible that you used a different account when creating those galleries?

Please let me know if there’s anything else I can assist with.

Best regards,

• This reply was modified 5 months ago by Mihai.

Hi @simo2010 ,

Thanks for the follow-up.

This makes sense — you don’t need to have deleted a user for this to appear.

What’s likely happening is that some of your older galleries have 0 stored as the author ID in the database (which can happen during imports, folder scans, or galleries created with earlier NextGEN Gallery versions). WordPress treats user ID 0 as non-existent, so the admin displays “Deleted user”.

You can fix this with a database query but please approach this with caution and ensure you have a site and database backup in place.

Replace 1 in the query below with your actual WordPress user ID (you can find it in Users → All Users — hover your username and check the URL for user_id=):

UPDATE wp_ngg_gallery
SET author = 1
WHERE author = 0
OR author NOT IN (SELECT ID FROM wp_users);

Note: If your database uses a custom prefix (not wp_), adjust the table names accordingly (yourprefix_ngg_gallery and yourprefix_users).

You can run this in phpMyAdmin → SQL, or via WP-CLI:

wp db query "UPDATE wp_ngg_gallery SET author = 1 WHERE author = 0 OR author NOT IN (SELECT ID FROM wp_users);"

After running it, refresh the Imagely > Galleries page and all galleries should show your name.

Let me know if you run into any trouble!

Best regards,
Mihai