Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: !Hachi! on January 07, 2006, 05:45:18 AM

Title: Can't change SMTP username in 1.1rc2
Post by: !Hachi! on January 07, 2006, 05:45:18 AM
ok i am in strange problem now.
               i am using 1.1rc2  in core configuration  webmaster email address is   "[email protected]*****.net"         
                          and in        Feature Configuration     SMTP username     is    "[email protected]*********.net"      when i try to change in      Feature Configuration nothing happens page reloaded but it didn't save it.don't know why.  i used [email protected]*****.net before as webmaster email too.ut changed now with [email protected]******.net.
             i don't know why i can't change it.
Title: Re: Can't change SMTP username in 1.1rc2
Post by: Grudge on January 07, 2006, 05:53:20 AM
Do you have anything in your error logs straight after you try to save?
Title: Re: Can't change SMTP username in 1.1rc2
Post by: !Hachi! on January 07, 2006, 06:00:06 AM
Nope. nothing in forum error log.
Title: Re: Can't change SMTP username in 1.1rc2
Post by: Grudge on January 07, 2006, 08:18:09 AM
Odd, it works for me. In the meantime you can force the change by running this query in phpMyAdmin:


UPDATE {$db_prefix}settings
SET value='[email protected]'
WHERE variable = 'smtp_username'

Title: Re: Can't change SMTP username in 1.1rc2
Post by: !Hachi! on January 07, 2006, 08:34:34 AM
i tried and it says   
       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 '}settings
SET value='[email protected]*******.net'
WHERE variable =

                      i replace [email protected] with my email that i want to use.

                                   now i search it in phpmyadmin and found smtp_username as [email protected]*****.net  can i replace that email?will it works?
Title: Re: Can't change SMTP username in 1.1rc2
Post by: !Hachi! on January 07, 2006, 11:02:57 PM
any hope?
Title: Re: Can't change SMTP username in 1.1rc2
Post by: JayBachatero on January 07, 2006, 11:23:45 PM
Change {$db_preffix} to the preffix you specified when you installed SMF.  By default it's smf_  Also add ; at the end of 'smtp_username'

-JayBachatero
Title: Re: Can't change SMTP username in 1.1rc2
Post by: !Hachi! on January 07, 2006, 11:46:07 PM
no luck,
    cani change value manually by replacing email.
                  my db prefix is db1  so in   Table: db1settings can i change value by replacing new email?
Title: Re: Can't change SMTP username in 1.1rc2
Post by: JayBachatero on January 07, 2006, 11:48:21 PM
Yea you can do that.

-JayBachatero
Title: Re: Can't change SMTP username in 1.1rc2
Post by: !Hachi! on January 08, 2006, 12:44:40 AM
jay need littel help in phpmyadmin when i select my forum db i found two types of db one is backup and other is new like
         backup_db1attachments 
        and all tables and  after that
         db1attachments 
and same tables as in backup .should i delete those backup tables?
Title: Re: Can't change SMTP username in 1.1rc2
Post by: JayBachatero on January 08, 2006, 01:12:27 AM
Well it's all up to you.  Those are backus made when you upgraded your forum.  Make sure if you are going to delete them that you are not deleting the wrong stuff.  Double check it.

BTW is the problem fixed?

-JayBachatero
Title: Re: Can't change SMTP username in 1.1rc2
Post by: !Hachi! on January 08, 2006, 01:21:47 AM
no its not fixed that why i am thinking to delete all those backup dbs.
                            backup_db1settings and all other backup_xxxxx tables are safe to delete?
EDITED:    i deleted al those backup tables but problem is not fixed it shouws my password and in confirm password field it shows old password for my old email....!
                       jay whats wrong with that.i changed email in phpmyadmin for smtp_username. and it just didn't  show in configuration in acp. need your help
Title: Re: Can't change SMTP username in 1.1rc2
Post by: !Hachi! on January 08, 2006, 09:45:48 PM
not solved yet plz help
Title: Re: Can't change SMTP username in 1.1rc2
Post by: dtm.exe on January 08, 2006, 09:46:47 PM
hassan, please email or PM me your phpMyAdmin login details, database name, and what you want the information changed to.
Title: Re: Can't change SMTP username in 1.1rc2
Post by: !Hachi! on January 09, 2006, 10:41:56 AM
check you pm please
Title: Re: Can't change SMTP username in 1.1rc2
Post by: dtm.exe on January 09, 2006, 10:47:14 AM
Try it now.
Title: Re: Can't change SMTP username in 1.1rc2
Post by: !Hachi! on January 09, 2006, 10:58:13 AM
no same thing old email is showing.
Title: Re: Can't change SMTP username in 1.1rc2
Post by: dtm.exe on January 09, 2006, 11:24:57 AM
Quote from: hassan on January 09, 2006, 10:58:13 AM
no same thing old email is showing.

Hit Ctrl+F5.  Does that change anything?  Do a recount of forum statisitcs in Admin > Forum Maintenance.
Title: Re: Can't change SMTP username in 1.1rc2
Post by: !Hachi! on January 09, 2006, 11:39:52 AM
thats really really strange. recounted from stats    and when i hit ctrl+F5 it shows once my nwe email but when  loading is end its same again...
Title: Re: Can't change SMTP username in 1.1rc2
Post by: dtm.exe on January 09, 2006, 11:41:51 AM
Quote from: hassan on January 09, 2006, 11:39:52 AM
thats really really strange. recounted from stats    and when i hit ctrl+F5 it shows once my nwe email but when  loading is end its same again...

I'm not understanding what you posted, sorry.
Title: Re: Can't change SMTP username in 1.1rc2
Post by: !Hachi! on January 09, 2006, 11:55:08 AM
when i hit ctrl+F5 to refresh page while page is loading my new email is in the field but when loading is end it disappears and old email is in the field.
                 
Title: Re: Can't change SMTP username in 1.1rc2
Post by: JayBachatero on January 09, 2006, 03:05:10 PM
First time I hear this.  What browser are you using?  Try looking at it with another browser.

-JayBachatero
Title: Re: Can't change SMTP username in 1.1rc2
Post by: !Hachi! on January 09, 2006, 07:58:46 PM
"dtm.exe"  u r really man ;),thanks alot for your support.and how i can forget about jay and grudge "the great"  ;D thanks alot buddz
Title: Re: Can't change SMTP username in 1.1rc2
Post by: dtm.exe on January 09, 2006, 10:35:57 PM
Quote from: hassan on January 09, 2006, 07:58:46 PM
"dtm.exe"  u r really man ;),thanks alot for your support.and how i can forget about jay and grudge "the great"  ;D thanks alot buddz


You're very welcome :).
Title: Re: Can't change SMTP username in 1.1rc2
Post by: larryinla on January 05, 2007, 04:48:54 PM
So, in the end, is this all coming down to not using Mozilla Firefox but IE7 (or 6) to edit setting on the board? I seem to be having a similar problem with information 'stuck' in the text boxes of Feature Configuration under Server Settings in the Admin Center. So far, I haven't gotten email notications to work correctly yet.