internal SQL error when installing and activating Oneall Social login on MyBB

Dave_Murphy

MyBB Version 1.8.38
PHP Version 8.2.28
SQL Engine PostgreSQL 15.12 (Debian 15.12-0+deb12u2)

This is the SQL errror.

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
0 - ERROR: syntax error at or near "(" LINE 2: id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, ^
Query:
CREATE TABLE mybb_oa_social_login_user_token( id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, uid INT(10) NOT NULL, user_token CHAR(36) NOT NULL, date_creation INT(10) ) > ENGINE=MyISAM;

`

I also end up with multiple setting groups for Oneall Social Login if I click on install and activate again - presumably because the process didn't complete.

Let me know if you need any more information to help figure this out.

Dave_Murphy

I figured this out and submitted a PR at https://github.com/oneall/social-login-mybb/pull/7