editingfx wrote:
****************
SQL ERROR
SQL PROCESSING HALTED
An error was encountered ...
The failed line was:
INSERT INTO phpbb_config(config_name,config_value) VALUES('username_hide_inac','1');;
...
FAILED
****************
All this is telling you, is that you already have created the values to populate the database previously (by running this file -->
update_config_v1_2_1.php). There was no need to run that part of it again. You see, not everyone uses EasyMOD, especially on heavily modded boards. So when installing manually, it becomes necessary to run the "database updater" file. When using EM, it's done automatically. Notice at the begginning of the MOD installation template:
install_user_shield_v1_2_1.txt wrote:
#
#-----[ SQL ]------------------------------------------
#
# IMPORTANT ***** Remember to change the default TABLE PREFIX below if your board does not use " phpbb_ ". ***** IMPORTANT
#
INSERT INTO `phpbb_config` (`config_name`, `config_value`)
VALUES ('username_hide_inac', '1');
Then at the end, you have this "Do-it-Yourself" action:
install_user_shield_v1_2_1.txt wrote:
#
#-----[ DIY INSTRUCTIONS ]------------------------------------------
#
IMPORTANT ***** If you are NOT using EasyMOD to install User Shield, you MUST update the CONFIG table by following these instructions ***** IMPORTANT
IMPORTANT ***** Remember to change the default TABLE PREFIX in file "update_config_v1_2_1.php" if your board does not use " phpbb_ ". ***** IMPORTANT
1] Run this file: update_config_v1_2_1.php - located in the install folder off the root of your forum ( eg. In your browser URL field, type the following:
http://yoursite.com/yourforumroot/insta ... v1_2_1.php )
Once done a message confirming a successful update will be displayed along with a reminder to delete the "install" folder including it's content, before returning to your forum.
It's one or the other but not both, as you'll get that error message.
editingfx wrote:
I did not check the "Complete Installation" button in EasyMod. So what now? (lol... so much for "easy" mod)
Well, I have to admit that it's my turn to be a little confused since you've mentionned that you installed it manually. When attempting to install it with EM the second time around, it should of given you a whole bunch of "unprocessed actions" as it would not of been able to find the original lines of code, which you have manually modified. Did you restart from scratch? If you review my "introductory" post above, can you see the "memberlist filtered list" when logged in as an administrator?
editingfx wrote:
[PS - in my earlier post by "validation", I mean I ran the your .txt file through EasyMod's validation webpage, and it gave an error.
I'm sorry but I'm still not sure what you're referring to if my initial explanation was off the mark. On the other hand if you are referring to this:
- phpBB2 MOD validator tool
[/url]
... this MOD would not of been validated without being compliant.
editingfx wrote:
Thanks for the help Wolf, I apologize for my noob status.
You're very welcome indeed, and don't worry about the noobness thing, we all go through it whether we admit it or not (it is confusing the first time).
Give me some feedback,
Wolf