News:

Wondering if this will always be free?  See why free is better.

Main Menu

Can't change SMTP username in 1.1rc2

Started by !Hachi!, January 07, 2006, 05:45:18 AM

Previous topic - Next topic

!Hachi!

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.
Happy Ramadan

Grudge

Do you have anything in your error logs straight after you try to save?
I'm only a half geek really...

!Hachi!

Happy Ramadan

Grudge

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'

I'm only a half geek really...

!Hachi!

#4
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?
Happy Ramadan

!Hachi!

Happy Ramadan

JayBachatero

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
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

!Hachi!

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?
Happy Ramadan

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

!Hachi!

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?
Happy Ramadan

JayBachatero

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
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

!Hachi!

#11
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
Happy Ramadan

!Hachi!

Happy Ramadan

dtm.exe

hassan, please email or PM me your phpMyAdmin login details, database name, and what you want the information changed to.

!Hachi!

Happy Ramadan


!Hachi!

Happy Ramadan

dtm.exe

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.

!Hachi!

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...
Happy Ramadan

dtm.exe

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.

Advertisement: