Jump to the post that solved this thread.
Not Solved Add Private Message Contact Line In User Profile
#11
Not Solved
you can use SQL queries like below
UPDATE `mybb_users` SET `receivepms` = '1' 
ALTER TABLE `mybb_users` MODIFY COLUMN `receivepms` tinyint(1) NOT NULL default '1';

[common SQL queries guidance]
Reply
#12
Not Solved
This user has been denied support. This user has been denied support.
(2020-03-13, 12:48 PM).m. Wrote: you can use SQL queries like below
UPDATE `mybb_users` SET `receivepms` = '1' 
ALTER TABLE `mybb_users` MODIFY COLUMN `receivepms` tinyint(1) NOT NULL default '1';

[common SQL queries guidance]

do i need to run both queries 1 by 1 in SQL tab box ?
Reply
#13
Not Solved
^ you can use both at once in the same box or use them one by one
Reply
#14
Not Solved
This user has been denied support. This user has been denied support.
(2020-03-13, 01:25 PM).m. Wrote: ^ you can use both at once in the same box or use them one by one

Don't have any other way bro ? coz i am little bit scared of running queries in SQL because if any error comes and forum mysql database corrupt on index page, then i will be in big trouble lol, because last time i have installed " Thanks Plugin " and it generated the thanks myuser something table in sql and my whole site shuts down and even mysql error on index page, that took me 24 hour to fix that lmao.

@.m. Also please take a look at the below thread if you can do something.

https://community.mybb.com/thread-226709...45069.html

thanks
Reply
#15
Not Solved
^ above given queries are safe to use.
earlier you might have got problem due to strict mode of server.
Reply
#16
Not Solved
This user has been denied support. This user has been denied support.
(2020-03-13, 01:44 PM).m. Wrote: ^ above given queries are safe to use.
earlier you might have got problem due to strict mode of server.

Heart  Thank you very much bro for help, it's working now, Send Private message contact detail shown now Heart , you are the best bro.
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 3 Guest(s)