[verified] Uninstalling EM

Having problems installing EM? Let's fix that
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!
Locked
Baer
Registered User
Posts: 10
Joined: Tue Dec 02, 2003 7:10 am
Location: Clausthal-Zellerfeld / Harz
Contact:

Re: Uninstalling EM

Post by Baer »

A_Jelly_Doughnut wrote: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
Life is like a roll of toilet paper, when the end is near we panic!
User avatar
A_Jelly_Doughnut
Registered User
Posts: 1780
Joined: Wed Jun 04, 2003 4:23 pm

Re: Uninstalling EM

Post by A_Jelly_Doughnut »

In the mysql installation, there is C:\mysql\bin\mysql.exe that will run queries :)
A_Jelly_Doughnut
Baer
Registered User
Posts: 10
Joined: Tue Dec 02, 2003 7:10 am
Location: Clausthal-Zellerfeld / Harz
Contact:

Re: Uninstalling EM

Post by 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
:|
Life is like a roll of toilet paper, when the end is near we panic!
Baer
Registered User
Posts: 10
Joined: Tue Dec 02, 2003 7:10 am
Location: Clausthal-Zellerfeld / Harz
Contact:

Re: Uninstalling EM

Post by 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.
Life is like a roll of toilet paper, when the end is near we panic!
dgshaffer
Registered User
Posts: 1
Joined: Thu Dec 11, 2003 10:44 am

Re: Uninstalling EM

Post by 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
Registered User
Posts: 19
Joined: Mon Nov 24, 2003 11:05 pm

Re: Uninstalling EM

Post by coasterguy »

A_Jelly_Doughnut wrote: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
Registered User
Posts: 10
Joined: Tue Dec 02, 2003 7:10 am
Location: Clausthal-Zellerfeld / Harz
Contact:

Re: Uninstalling EM

Post by Baer »

dgshaffer wrote: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 :D
Life is like a roll of toilet paper, when the end is near we panic!
Locked