MyBB Community Forums

Hello, I've been trying to use my facebook connect but I'm resulting to a sql error

Quote:SQL Error:1064 - 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 ')' at line 1Query:ALTER TABLE mybb_users ADD ()

The same error occurred on mytwitter connect.

*I have plugin library installed
*I upgraded from 1609
* My phpinfo() PHP Version 5.3.29,,, mysqli 5.6.27



I please need help so I can use this functionality

Thank you for spotting this issue. For a temporary patch, delete all the columns beginning with "fb" from your mybb_users table in the database, and reinstall the plugin. This happens if you perform the installation process twice without actually completing it.

Solved!

Used this sql in phpmyadmin to delete the said columns

ALTER TABLE mybb_users
  DROP COLUMN fbavatar,
  DROP COLUMN fbsex,
....
...;

Thank you.

Glad you solved it. A patch has been pushed to GitHub and will be available in the next release. Nothing to worry about since you've solved it by yourself.

Thank you for contributing! Also, if you want to boost your site's integration, don't miss Flyover