In the database what is the default value for these settings, ( under Additional Contact Information) Is it null?
I need to reset all these for all users on my board, and I want to put them back to the original values
NOT null and default is not defined
(2015-01-02, 04:41 PM).m. Wrote: [ -> ]NOT null and default is not defined
thanks, so what is sql statement to reset to the default value if you don't mind tellingĀ
ALTER TABLE `mybb_users` CHANGE `mybb_icq` `mybb_icq` varchar(10) NOT NULL default '',
ALTER TABLE `mybb_users` CHANGE `mybb_aim` `mybb_aim` varchar(50) NOT NULL default '',
ALTER TABLE `mybb_users` CHANGE `mybb_yahoo` `mybb_yahoo` varchar(50) NOT NULL default '',
ALTER TABLE `mybb_users` CHANGE `mybb_msn` `mybb_msn` varchar(75) NOT NULL default '';