[verified] Uninstalling EM

[Baer]

Hello,
Baer: You want a step-by-step tutorial?

Flautist: I think this SQL query will work:

Code: Select all

DELETE FROM phpbb_config WHERE em IN config_name;

but I'm not sure how far I'd trust me on that.

OK, how do I send SQL commands to my database? Is there a nice program included in the mysql-installation?

Regs
Baer

[A_Jelly_Doughnut]

In the mysql installation, there is C:\mysql\bin\mysql.exe that will run queries

[Baer]

Sorry to bother again, but this seems to be one of my worst weeks. I tried the following:

Code: Select all

heine@oscar:~$ mysql -u phpbb2 -p --exec="DELETE FROM phpbb_config WHERE em IN config_name;"
Enter password:
ERROR 1064 at line 1: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'config_name' at line 1

[Baer]

OK, did it the hard way:

Code: Select all

heine@oscar:~$ mysql -u phpbb2 -p --exec="DELETE FROM phpbb_config WHERE config_name = '[i]em_rows[/i]';" phpbb2

That produces a lot of lines, you have to do it for EM_password, EM_read, EM_write, EM_move, EM_ftp_dir, EM_ftp_user. You can check, if there are other EM lines with

Code: Select all

heine@oscar:~$ mysql -u phpbb2 -p --exec="SELECT * FROM phpbb_config;" phpbb2

And look, where are EM_rows remaining.

Regs
Rob

PS: phpbb2 is my username in mysql, [-p] is only req'd, if you have a passwd to access your database and the last phpbb2 is the name for my database in mysql.

[dgshaffer]

heine@oscar:~$ mysql -u phpbb2 -p --exec="DELETE FROM phpbb_config WHERE config_name = 'em_rows';" phpbb2

I tried running the above text but I get this message:

You have an error in your SQL syntax near 'heine@oscar * ~ $ mysql - u loginname - password * - exec = "DELETE FROM phpbb_' at line 1

What am I doing wrong? I've managed to remove anything relating to MOD in my DB but there must be lines of code stuck within a few of the files because I tried reinstalling easymod and received the error saying it's already installed.

Thanks for any help you might offer

Don

[coasterguy]

Hello,
Baer: You want a step-by-step tutorial?

Flautist: I think this SQL query will work:

Code: Select all

DELETE FROM phpbb_config WHERE em IN config_name;

but I'm not sure how far I'd trust me on that.

I did that and I get this error. I used the queury generator here http://www.phpbbhacks.com/forums/db_generator.php" target="_blank and I get this error.

Code: Select all

DELETE FROM phpbb_config WHERE em IN config_name
+++ Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'config_name' at line 1

[Baer]

You have an error in your SQL syntax near 'heine@oscar * ~ $ mysql - u loginname - password * - exec = "DELETE FROM phpbb_' at line 1

*lolz*
Skip the heine@oscar:~$ . It's just my login shell