Can you try to execute the following SQL query from your database and see how it goes?

ALTER TABLE `#__social_apps_map` MODIFY `position` VARCHAR(50) NOT NULL DEFAULT '';

Remember to replace #_ with your current table prefix.

If the issue still persists, can you update your site FTP and database access so we can better have a check?

You SQL doesn’t help
I updated the Optional Information already. I added Cpanel and PHPMYADMIN login also..
thank u

I've help you execute the following SQL queries on your site, can you give it a check again?

ALTER TABLE `#__social_apps_map` MODIFY `position` VARCHAR(50) NOT NULL DEFAULT '';

ALTER TABLE `#__social_apps_map` MODIFY `params` text NULL;

ALTER TABLE `#__social_oauth` MODIFY `last_pulled` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';

ALTER TABLE `#__social_oauth` MODIFY `last_pushed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';

set global sql_mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

I get this error when I try to sign in with new users through Gmail.
Here is the error
object(PHPMailer\PHPMailer\Exception)#1621 (7) { ["message":protected]=> string(82) "SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(2) ["file":protected]=> string(78) "/home/admin/public_html/libraries/vendor/phpmailer/phpmailer/src/PHPMailer.php" ["line":protected]=> int(1961) ["trace":"Exception":private]=> array(17) { [0]=> array(6) { ["file"]=> string(78) "/home/admin/public_html/libraries/vendor/phpmailer/phpmailer/src/PHPMailer.php" ["line"]=> int(1638) ["function"]=> string(8) "smtpSend" ["class"]=> string(29) "PHPMailer\PHPMailer\PHPMailer" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(315) "Date: Mon, 4 Oct 2021 04:56:42 +0000 To: sokheng52500@gmail.com From: SeekKhmer Reply-To: info@seekkhmer.com Subject: Sok Savry joined the group HIGH SCHOOL Message-ID: MIME-Version: 1.0 Content-Type: text/html; charset=utf-8 " [1]=> string(10667) "
} } [1]=> array(6) { ["file"]=> string(78) "/home/admin/public_html/libraries/vendor/phpmailer/phpmailer/src/PHPMailer.php" ["line"]=> int(1471) ["function"]=> string(8) "postSend" ["class"]=> string(29) "PHPMailer\PHPMailer\PHPMailer" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [2]=> array(6) { ["file"]=> string(51) "/home/admin/public_html/libraries/src/Mail/Mail.php" ["line"]=> int(170) ["function"]=> string(4) "send" ["class"]=> string(29) "PHPMailer\PHPMailer\PHPMailer" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [3]=> array(6) { ["file"]=> string(90) "/home/admin/public_html/administrator/components/com_easysocial/includes/mailer/mailer.php" ["line"]=> int(238) ["function"]=> string(4) "Send" ["class"]=> string(20) "Joomla\CMS\Mail\Mail" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [4]=> array(6) { ["file"]=> string(90) "/home/admin/public_html/administrator/components/com_easysocial/includes/mailer/mailer.php" ["line"]=> int(386) ["function"]=> string(4) "send" ["class"]=> string(12) "SocialMailer" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> array(10) { [0]=> object(SocialTableMailer)#1614 (33) { ["id"]=> int(110192) ["sid"]=> int(0) ["sender_name"]=> string(9) "SeekKhmer" ["replyto_email"]=> string(18) "info@seekkhmer.com" ["sender_email"]=> string(18) "info@seekkhmer.com" ["recipient_name"]=> string(13) "Sokheng X You" ["recipient_email"]=> string(22) "sokheng52500@gmail.com" ["title"]=> string(48) "COM_EASYSOCIAL_EMAILS_GROUP_JOINED_GROUP_SUBJECT" ["content"]=> NULL ["template"]=> string(17) "site/group/joined" ["html"]=> int(1) ["state"]=> int(0) ["created"]=> string(19) "2021-10-04 04:54:20" ["params"]=> string(709) "{"actor":"Sok Savry","group":"HIGH SCHOOL","userName":"Sok Savry","userLink":"https:\/\/seekkhmer.com\/index.php\/profile-layout\/1337-sok-savry-98","userAvatar":"https:\/\/seekkhmer.com\/media\/com_easysocial\/avatars\/users\/1337\/0296bfabb48e3dd925819fe81481ad64_large.jpg","groupName":"HIGH SCHOOL","groupAvatar":"https:\/\/seekkhmer.com\/media\/com_easysocial\/defaults\/avatars\/group\/medium.png","groupLink":"https:\/\/seekkhmer.com\/index.php\/group\/34-high-school","posterName":"Sok Savry","posterAvatar":"https:\/\/seekkhmer.com\/media\/com_easysocial\/avatars\/text\/user\/d53aeb78abc83a52ab8982f5c82a3d5b.png","posterLink":"https:\/\/seekkhmer.com\/index.php\/profile-layout\/1337-sok-savry-74"}" ["priority"]=> int(2) ["language"]=> string(5) "en-GB" ["composite":"SocialTable":private]=> array(0) { } ["privacy":protected]=> NULL ["_supportNullValue":protected]=> bool(true) ["_tbl":protected]=> string(16) "#__social_mailer" ["_tbl_key":protected]=> string(2) "id" ["_tbl_keys":protected]=> array(1) { [0]=> string(2) "id" } ["_db":protected]=> object(Joomla\Database\Mysqli\MysqliDriver)#177 (24) { ["connection":protected]=> object(mysqli)#208 (18) { ["affected_rows"]=> int(1) ["client_info"]=> string(14) "mysqlnd 7.4.15" ["client_version"]=> int(70415) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(5) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(6) "5.7.33" ["server_version"]=> int(50733) ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(355089) ["warning_count"]=> int(0) } ["name"]=> string(6) "mysqli" ["nameQuote":protected]=> string(1) "`" ["nullDate":protected]=> string(19) "0000-00-00 00:00:00" ["utf8mb4":protected]=> bool(true) ["mariadb":protected]=> bool(false) ["database":"Joomla\Database\DatabaseDriver":private]=> string(7) "khmer99" ["serverType"]=> NULL ["count":protected]=> int(37) ["cursor":protected]=> NULL ["executed":protected]=> bool(false) ["limit":protected]=> int(0) ["offset":protected]=> int(0) ["options":protected]=> array(14) { ["driver"]=> string(6) "mysqli" ["host"]=> string(9) "localhost" ["user"]=> string(7) "khmer99" ["password"]=> string(10) "B85.SVp7]n" ["database"]=> string(7) "khmer99" ["prefix"]=> string(6) "jos3y_" ["utf8mb4"]=> bool(true) ["select"]=> bool(true) ["factory"]=> object(Joomla\Database\DatabaseFactory)#176 (0) { } ["monitor"]=> NULL ["port"]=> int(3306) ["socket"]=> NULL ["sqlModes"]=> array(3) { [0]=> string(19) "STRICT_TRANS_TABLES" [1]=> string(26) "ERROR_FOR_DIVISION_BY_ZERO" [2]=> string(22) "NO_ENGINE_SUBSTITUTION" } ["ssl"]=> array(0) { } } ["sql":protected]=> object(Joomla\Database\Mysqli\MysqliQuery)#1682 (30) { ["nullDatetimeList":protected]=> array(2) { [0]=> string(19) "0000-00-00 00:00:00" [1]=> string(19) "1000-01-01 00:00:00" } ["bounded":protected]=> array(0) { } ["parameterMapping":protected]=> array(5) { ["boolean"]=> string(7) "boolean" ["int"]=> string(3) "int" ["lob"]=> string(3) "lob" ["null"]=> string(4) "null" ["string"]=> string(6) "string" } ["db":protected]=> *RECURSION* ["sql":protected]=> NULL ["type":protected]=> string(6) "select" ["alias":protected]=> NULL ["element":protected]=> NULL ["select":protected]=> object(Joomla\Database\Query\QueryElement)#1681 (3) { ["name":protected]=> string(6) "SELECT" ["elements":protected]=> array(1) { [0]=> string(1) "*" } ["glue":protected]=> string(1) "," } ["delete":protected]=> NULL ["update":protected]=> NULL ["insert":protected]=> NULL ["from":protected]=> object(Joomla\Database\Query\QueryElement)#1642 (3) { ["name":protected]=> string(4) "FROM" ["elements":protected]=> array(1) { [0]=> string(14) "#__social_urls" } ["glue":protected]=> string(1) "," } ["join":protected]=> NULL ["set":protected]=> NULL ["where":protected]=> object(Joomla\Database\Query\QueryElement)#1641 (3) { ["name":protected]=> string(5) "WHERE" ["elements":protected]=> array(1) { [0]=> string(45) "`sefurl` = 'profile-layout/editnotifications'" } ["glue":protected]=> string(5) " AND " } ["group":protected]=> NULL ["having":protected]=> NULL ["columns":protected]=> NULL ["values":protected]=> NULL ["order":protected]=> NULL ["autoIncrementField":protected]=> bool(false) ["call":protected]=> NULL ["exec":protected]=> NULL ["merge":protected]=> NULL ["querySet":protected]=> NULL ["selectRowNumber":protected]=> NULL ["offset":protected]=> int(0) ["limit":protected]=> int(0) ["preparedIndex":protected]=> int(0) } ["statement":protected]=> object(Joomla\Database\Mysqli\MysqliStatement)#1679 (11) { ["bindedValues":protected]=> NULL ["parameterKeyMapping":protected]=> NULL ["parameterTypeMapping":protected]=> array(5) { ["boolean"]=> string(1) "i" ["int"]=> string(1) "i" ["lob"]=> string(1) "s" ["null"]=> string(1) "s" ["string"]=> string(1) "s" } ["columnNames":protected]=> array(5) { [0]=> string(2) "id" [1]=> string(6) "sefurl" [2]=> string(6) "rawurl" [3]=> string(6) "params" [4]=> string(6) "custom" } ["connection":protected]=> object(mysqli)#208 (18) { ["affected_rows"]=> int(1) ["client_info"]=> string(14) "mysqlnd 7.4.15" ["client_version"]=> int(70415) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(5) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(6) "5.7.33" ["server_version"]=> int(50733) ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(355089) ["warning_count"]=> int(0) } ["defaultFetchStyle":protected]=> int(4) ["query":protected]=> string(83) "SELECT * FROM jos3y_social_urls WHERE `sefurl` = 'profile-layout/editnotifications'" ["result":"Joomla\Database\Mysqli\MysqliStatement":private]=> bool(false) ["rowBindedValues":protected]=> array(5) { [0]=> int(65375) [1]=> string(32) "profile-layout/editnotifications" [2]=> string(37) "layout=editNotifications&view=profile" [3]=> NULL [4]=> int(0) } ["statement":protected]=> object(mysqli_stmt)#1678 (10) { ["affected_rows"]=> int(1) ["insert_id"]=> int(0) ["num_rows"]=> int(0) ["param_count"]=> int(0) ["field_count"]=> int(5) ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["sqlstate"]=> string(5) "00000" ["id"]=> int(37) } ["typesKeyMapping":protected]=> NULL } ["tablePrefix":protected]=> string(6) "jos3y_" ["utf":protected]=> bool(true) ["errorNum":protected]=> int(0) ["errorMsg":protected]=> NULL ["transactionDepth":protected]=> int(0) ["factory":protected]=> object(Joomla\Database\DatabaseFactory)#176 (0) { } ["monitor":protected]=> NULL ["dispatcher":"Joomla\Database\DatabaseDriver":private]=> object(Joomla\Event\Dispatcher)#132 (2) { ["events":protected]=> array(0) { } ["listeners":protected]=> array(73) { ["session.start"]=> object(Joomla\Event\ListenersPriorityQueue)#133 (1) { ["listeners":"Joomla\Event\ListenersPriorityQueue":private]=> array(2) { [2]=> array(1) { [0]=> array(2) { [0]=> object(Joomla\CMS\Application\SiteApplication)#146 (29) { ["language_filter":protected]=> bool(false) ["detect_browser":protected]=> bool(false) ["docOptions":protected]=> array(0) { } ["scope"]=> string(14) "com_easysocial" ["clientId":protected]=> int(0) ["messageQueue":protected]=> array(0) { } ["name":protected]=> string(4) "site" ["profiler":protected]=> NULL ["template":protected]=> object(stdClass)#817 (6) { ["id"]=> int(9) ["home"]=> string(1) "1" ["template"]=> string(8) "t4_blank" ["params"]=> object(Joomla\Registry\Registry)#1109 (3) { ["data":protected]=> object(stdClass)#1117 (13) { ["tplhelper"]=> string(2) "{}" ["typelist-site"]=> string(7) "default" ["typelist-navigation"]=> string(7) "default" ["typelist-theme"]=> string(7) "default" ["typelist-layout"]=> string(7) "default" ["sub-layout"]=> string(7) "default" ["system_optimizecss_exclude"]=> string(0) "" ["system_optimizejs_exclude"]=> string(0) "" ["system_advancedCodeAfterHead"]=> string(1473) " " ["system_advancedCodeBeforeHead"]=> string(0) "" ["system_advancedCodeAfterBody"]=> string(0) "" ["system_advancedCodeBeforeBody"]=> string(0) "" ["system_addons"]=> array(3) { [0]=> string(13) "font.awesome5" [1]=> string(13) "font.awesome4" [2]=> string(13) "font.iconmoon" } } ["initialized":protected]=> bool(true) ["separator"]=> string(1) "." } ["inheritable"]=> int(0) ["parent"]=> string(0) "" } ["pathway":protected]=> NULL ["authenticationPluginType":protected]=> string(14) "authentication" ["document":protected]=> object(Joomla\CMS\Document\ErrorDocument)#1586 (41) { ["debug"]=> bool(false) ["error"]=> *RECURSION* ["_error":protected]=> *RECURSION* ["_links"]=> array(0) { } ["_custom"]=> array(0) { } ["template"]=> string(8) "t4_blank" ["baseurl"]=> string(0) "" ["params"]=> object(Joomla\Registry\Registry)#1109 (3) { ["data":protected]=> object(stdClass)#1117 (13) { ["tplhelper"]=> string(2) "{}" ["typelist-site"]=> string(7) "default" ["typelist-navigation"]=> string(7) "default" ["typelist-theme"]=> string(7) "default" ["typelist-layout"]=> string(7) "default" ["sub-layout"]=> string(7) "default" ["system_optimizecss_exclude"]=> string(0) "" ["system_optimizejs_exclude"]=> string(0) "" ["system_advancedC

I've execute the following SQL queries on your site, can you give it a check again for the new user sign up via Google?

ALTER TABLE `#__social_oauth` MODIFY `permissions` text NULL;

Here is the new message for the new user sign up via Google
SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting

thank u

Here is the new message for the new user sign up via Google
SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting

thank u

It seems like I can't replicate the error, you can watch my attached video.

By the way, I noticed that your cronjob secure key is not configured correctly, you should just add your secure key without the path.

May I know do you have set up a cronjob on your server?

I don’t know that my Server has cron Job or not? Could you check or correct my server sir..
thank u

Okay, it seems like you don't have set up cronjob on your server, I already help you added a new cronjob on your server now.

Can you try and see whether you still manage to replicate this error "SMTP connect() failed"?

1. I don’t see any message appear when new user sign up with Google.
2. How is the Facebook whenever new user sign in with Facebook, is it ok or not?
Could you confirm because I don’t have any Facebook account to test now.
thank

Yes, look good to me.

Okay, it seems like you don't have set up cronjob on your server, I already help you added a new cronjob on your server now.

Can you try and see whether you still manage to replicate this error "SMTP connect() failed"?

Dear Wong,
Could you help me to check my cronjob again. I changed the server because my preview server that I use before is Webuzo, it doesn’t support PHP8. My server provider recommend me to change the server from Webozu to Directadmin because Directadmin support any php version. Now I am using new server and I think the cronjob was lost also.

Could you install cronjob in new server? I updated Additional Information so you can use those information to fix it.

thank u

Dear Wong,
Could you help me to check my cronjob again. I changed the server because my preview server that I use before is Webuzo, it doesn’t support PHP8. My server provider recommend me to change the server from Webozu to Directadmin because Directadmin support any php version. Now I am using new server and I think the cronjob was lost also.

Could you install cronjob in new server? I updated Additional Information so you can use those information to fix it.

Perhaps you can start a new thread on our forum and provide us with your DirectAdmin login access so that we can help you set up cronjob on your server again.

And guide me on how to access the cronjob configuration page as well.