A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
I am using EasyMOD and I get the following when it does the DUMB process for SQL alterations.
3 Warning(s) reported by the SQL Parser
1. Missing semicolon, it might be an indication of further syntax errors, statement: 5
2. Inconsistent display width specified "INTEGER(255)" in column "deleted_by", statement: 1, table: "phpbb_pruned_users"
3. Identifier "data" is a reserved keyword (reference: SQL 99), statement: 1, table: "phpbb_pruned_users"
The same error appears three times on the page
I believe the errors are for the process:
CREATE TABLE phpbb_pruned_users (
id MEDIUMINT(8) NOT NULL AUTO_INCREMENT,
deleted_by INTEGER(255) NOT NULL,
delete_time INTEGER(11) NOT NULL,
data TEXT NOT NULL,
PRIMARY KEY (id)
);
OK, but I'm going to back up the SQL database first just in case.
What exactly does flagging inactive users do?
OK I figured out how to add more options to the pull down field and add the words to the pull down list for them, but I don't know how to make it search two years or more back.
Flagging users is just a way to let you keep track of user's you have notified you, or you have contacted or whatever you want it to mean, but it doesn't have any other function other than letting you know something about the user.
To make it more than two years back use 63072000 in the value in the drop down which derives from ( 60 * 60 * 24 * 365 * 2 ).
I pruned users by accident and when attempting to use the Register User add-on in the ACP to re-register them I get the following error. "This user could not be registered. Either the username or e-mail address already exists, or they have been banned." I have already removed the mod and deleted the Prune Users table from the MySQL database and it's still doing it. Please help.
According to the error messages that you received, you didn't copy the files to ALL of your template directories, and if you are still getting the SQL error, you didn't execute the SQL queries properly.
They may have registered under a different name with the same email, hence your error. As I said in my previous post, it has nothing to do with this mod.
Again, this is because you didn't properly execute the SQL query. Did you keep the table extension as phpbb_ or did you replace it accordingly to your database which is using phpbb2_
In other words, replace everything in the query that says phpbb_ with phpbb2_ and re-execute..