Forum rules DO NOT give out any FTP passwords to anyone! There is no reason to do so! If you need help badly enough, create a temporary FTP account that is restricted to only the files that you need help with and give the information for that. Giving out FTP information can be very dangerous!
Warning: require(../includes/sql/sql_parser.php): failed to open stream: No such file or directory in /apache/htdocs/studorg/uars/phpBB2/admin/admin_easymod.php on line 3030
I recently upgraded from 2.0.20 to 2.0.22, does that mean I have to re-install EasyMod or is there something I'm missing? I've checked and the file structure is correct and the file sql_parser.php is in /phpBB2/admin/mods/easymod/includes/sql/.
Yes, you should probably reinstall EM. It sounds like when you updated, you replaced your old forum files with the udpated files, so you lost the EM files in your includes/sql folder. Once EM is installed, it no longer uses any of the files stored in your admin/mods/easymod folder, so it doesn't matter whether the EM files are found there or not...
EM Version Change
Before you can reinstall EM, you need to decrease the EM version number in your phpbb_config table...
EM Version Change Option 1
I created this DB Update file that you can run from your browser. Download and unzip the following file, then upload it to your phpBB root and run it from your browser:
If you already had EM 0.3.0 installed, then you will need to change the EM Version back so that the install will think that this is an Upgrade. You can use this tool to change your EM Version so that you can reinstall EM on your board:
Once the EM Version Changer is installed, set the EM version to 0.1.13 or 0.2.0...
EM Version Change (Manual Option 3)
If you want to manually change the EM version, you can do so in your phpbb_config table. Just look for the record beginning with EM_version. Then you can change the related field to 0.1.13. You could also delete all the records in the phpbb_config table that begin with EM_ and delete the phpbb_easymod table too to have the new install recreate everything...
phpMyAdmin - Manually Changing the EM Version Number
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 version field, then click on the little pencil icon next to the record to edit it:
Enter the following into the config_value Value editbox. Any version less than your current version will work...