Welcome to RCF - WHF

Nightrider · Sep 25, 2004

EM has no trouble with alternate prefixes since it uses the setting from your config.php file. But the code I gave you above did expect the table prefix to be phpbb_, so that would explain why it didn't work. So is the table prefix on your board phpb1 or phpb1_ ???

dontknow

mrbimble · Apr 18, 2007

phpb1_

Nightrider · Sep 25, 2004

Ok, try running this file which is modified to use your table prefeix phpb1_...

em_blank_pwd.zip

You will follow the same instructions I provided from Step 1 in my first replay to this topic...

munky2

mrbimble · Apr 18, 2007

I got this message back

Nightrider · Sep 25, 2004

Sure enough. I accidentally left off the last quote in the SQL query. Try this again:

em_blank_pwd.zip

Embarassed

mrbimble · Apr 18, 2007

frustratingly close

Nightrider · Sep 25, 2004

So the name of your database is phpb1. But your table prefix is phpbb_, which is the standard. So the first file at the top of this topic that I provide should work...

But since you are in phpMyAdmin already, just go ahead and manually change the password using option 2...

phpMyAdmin - Manually Changing the EM Password

The following is how you manually modify your EM password using phpMyAdmin. You can get into your database through your CPanel by clicking on phpMyAdmin. Follow the following instructions:

I'm sure that every host is different. I will tell you how I run my queries manually and hopefully it will be close to what you have available to you. The following may or may not be similar to what you have...

Log into your domain Control Panel and find the database icons. You should be able to find the phpMyAdmin icon. Click on it...

Hopefully that will log you into your phpAdmin panel. You may need to provide a username and password...

In the phpMyAdmin panel, click on the Databases hyperlink...

Hopefully that should take you where you can select your database. You may only have one. Select your database hyperlink...

That should open up the display of all the tables in your database. Ignore them. Somewhere on the page, you should see something similar to this:

Click on the phpbb_config table in the Left column navigation bar:

Then on the top left of the right window, click on the Browse button:

Then to display all the records, change the row settings to 500 starting with record 0, then press the Show button:

Scroll down to the EM Password field, then click on the little pencil icon next to the record to edit it:

Enter the following into the config_value Value editbox:

mrbimble · Apr 18, 2007

Although I have EM options in my phpBB administration menu, I do not have any entries in the config table that start with EM. I don't think the initial installation worked correctly. Can I roll things back and run through the install again?

Nightrider · Sep 25, 2004

The default setting in phpMyAdmin is to display only 30 records from the table. So you need to change it to display all of the records in the table...

Change the row settings to 500 starting with record 0, then press the Show button. There are probably only about 100-150 records in your phpbb_config table, so 500 should be good enough to guarantee that all records are displayed...

munky2