Hello Ian,

I am not too sure if I understand you correctly here but the file that is responsible to generate a new user data in the #__easyblog_users table is located in /administrator/components/com_easyblog/tables/profile.php

Hi Mark,

Thanks for your reply, but this is not what I'm looking for. I'll try to explain in another way.

Let's suppose that I look at my list of users (components > easyblog > users) and I find that the last registered user occupies ID 178, and I notice that 10 spammers have signed up and I decide to delete them. In theory, the next available user ID would be 169 (178 - 10 +1). In practice, the next user to sign up will be with ID 179, because there is a record counter somewhere that I can't find. Continuing with my example, I want to locate that ID counter to reduce it from 178 to 168, so that the next user to sign up will be 169.

I know that the individual user records are registered in the database easyblog_users, but I can't find where the last ID is kept.

Hello Ian,

It because the ID table is set to auto increment, the memory in your MySQL has the last record of 179, even after deleting a few roes. You could alter the counter by inserting something like this

ALTER TABLE prefix_tablename AUTO_INCREMENT = the ID you want SQL to start counting.

Hope that helps.

Thanks:)