Have been running the integration between aMember and vBulletin for a while now and all's been fine however I've noticed over teh last week that not all members have been recreated on the vB database when they've been signed up. I tried to rebuild the database this evening to force them through which usually works a treat but got the following error: MYSQL 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 '' at line 2 in query: SELECT userid, username, amemberid FROM **removed_database_name**.vb_user WHERE amemberid= Thoughts?
Make sure that aMember product is still installed in vBulletin. === INSTALL a "product" into vBulletin for integration from vB side == 5. Click vBulletin3 AdminCP -> Plugins and Products -> Manage Products, click "Add/Import Product" link. In the "EITHER upload the XML file from your computer" field, choose file "product-amember.xml" contained in vBulletin3 aMember plugin ZIP file. Click "Import". 6. Go to vBulletin3 AdminCP -> vBulletin Options, there is a new settings group now: "aMember Pro Integration". Go to inside. Set aMember Root URL: {$config.root_url} aMember Signup URL: {$config.root_url}/signup.php Redirect All Registrations to aMember : YES (you can do that later when configuration finished).
I've followed all of the instructions for installing VB into amember. I keep getting: Vbulletin3 plugin error. Cannot select MySQL db: 'dbname' Now, I know that my dbase is correct, along with uname and pass. Any ideas?
Just to follow up. I did get the VBulletin plugin working fine. It was a weird error because I was switching to a subdomain. Anyway the VB plugin works great. I am upgrading from SMF and VB definitely seems spot on.
I'm having the same issue... PHP: vBulletin3 Db and Prefix - incorrect value. 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 ANyone have a clue? I have checked and re-checked database values - everything is right.
I submitted a ticket via help desk - but here is the full message ... Code: # vBulletin3 Db and Prefix - incorrect value. 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 '-mtb_moreMTBTEST.user LIMIT 1' at line 1