Hi,
I’ve installed Gravity SMTP and configured it with a Google Address (specifically a Google workspace address, not a simple gmail one, I don’t know if that makes a difference), and have gotten through the process of creating the App on cloud console, the oAuth screen, obtained credentials and published the External App.
On adding the client id & secret, and clicking Sign in with Google, I am redirected to the google login and Auth page, all seems fine but then, after accepting the oAuth screen I am redirected back to Gravity SMTP get started modal as though I did nothing (as in, the img attached). I’m not getting any errors, not even from Google. Not sure what the problem is here… As much as we all hate errors, would be helpful to know what the problem is
Plugins with security, redirection, and caching/optimization features have been known to cause issues like this, preventing completion of the connection process to external services.
Try clearing the caches of any caching/optimization plugins, deactivating any plugins with the above features, clearing your browser cache and cookies, then connect again.
Seconding @richardw8k’s suggestion to clear your browser cookies. I’ve run into this same issue with auth redirects and clearing my cookies resolved the problem.
Update:
Seems related to this error, as each attempt generated this in the error log (domain and table names removed for privacy reasons).
Tried it on a fresh database, worked perfectly.
WordPress database error 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 'FULLTEXT(email, notes)' at line 1 for query ALTER TABLE ***_gravitysmtp_suppressed_emails ADD COLUMN FULLTEXT(email, notes) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, Gravity_Forms\\Gravity_SMTP\\Gravity_SMTP::Gravity_Forms\\Gravity_SMTP\\{closure}, Gravity_Forms\\Gravity_Tools\\Upgrades\\Upgrade_Routines->handle, call_user_func, Gravity_Forms\\Gravity_SMTP\\Gravity_SMTP::create_suppression_table, dbDelta, referer: https://******.com/wp-admin/upload.php
WordPress database error 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 'FOREIGN KEY (event_id) REFERENCES ***_gravitysmtp_events(id)' at line 1 for query ALTER TABLE ***_gravitysmtp_event_tracking ADD COLUMN FOREIGN KEY (event_id) REFERENCES ***_gravitysmtp_events(id) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, Gravity_Forms\\Gravity_SMTP\\Gravity_SMTP::Gravity_Forms\\Gravity_SMTP\\{closure}, Gravity_Forms\\Gravity_Tools\\Upgrades\\Upgrade_Routines->handle, call_user_func, Gravity_Forms\\Gravity_SMTP\\Gravity_SMTP::create_tracking_tables, dbDelta, referer: https://********.com/wp-admin/upload.php
