Joomla! Discussion Forums

-software versions
  a. PHP 4 / MySQL 4.1
  b. OS / Webserver: Linux
  c. Joomla: 1.0.8
  d. com_connector: 1.0.0
  e.  used module / version: vBulletin SQL (donno the version)
  f. connected application version: vBulletin 3.5.4

detailed description of the problem:

leonsio,

great work.

Although I have problems getting this to work.. I was wondering if you could help me out.

What I have done:

-installed a fresh copy of Joomla! 1.0.8
-unzipped files_to_replace.zip to the root of Joomla! installation in /portal/
-installed the com_connector via Joomla! admin panel
-created a directory in portal/components/com_connector/ called "modules"
-copied vbull_sql.class.php from the zip file that you provided in the other post in that new directory
-i went to the components->connector->new and filled in the appropriate info:
  --Title: Forum
  --Module: VBULLETIN SQL
  --URL: http://www.mysite.com/portal/forums
  --Add to user/app: YES
  --Display Mode: Wrapped
-In the next page, with the settings:
  --DB Host: localhost
  --DB User/Pass
  --DB Name
  --VBulletin prefix: vb3_
  --VBulletin Liscence Key
  --VBulletin Prefix: bb

-I click save, and publish the item.
-I make a new item menu using Connector Item under Misc category and I choose Forum as the item.


What happens

-I register with the site under a normal account.
-I activate the account
-I login, and it logs in to Joomla and NOT VBulletin!!!!!!!
-I look at the list of users in Vbulletin, and the new user isn't there.



I have done the above on 2 different servers, with different settings.
I have also tried Joomla! 1.0.7, and still no luck.

I'm going crazy here.

What do you think the problem is?





One more thing.. after all the above, now if I try to login with an incorrect username password, instead of a notification, I get this error:

i read what need something soap server for joomla and vbulletin? but i dont know what need to this work. Full normally instruction i dont find

you cann connect vbulletin and joomla with 2 different modules

vbulletin_soap and vbulletin_sql

the vbulletin_soap module is only for php5 with soap extension!!


for the UPDATE sql error just resplace joomla.php with this one

http://www.c4u.to/includes/joomla.zip


to your problem:
you have VB and joomla on 2 different servers, right?
if the domain is different you CAN NOT use common login

for user synchronisation: it should work allways
if not, you have added wrong connection data
or the user has no rights to access the vbulletin database from joomla side/server

synchronisation will only work if the user is excisting in vbulletin database with same username/password ( then it should loggin to, only if they arfe on same domain )
or it will be created if he does not exist ( and then login )

thanks for the reply leonsio..

But the thing is, I have setup vbull in the same database as Joomla, and they are on the same domain.

http://www.my-site.com/portal  (joomla)
http://www.my-site.com/portal/forums (vbulletin)

plz check the database connection settings

it can be that the connection data was not saved??

with this constelation it should work ( sync and common login )

what should I be checking in the connection settings?

You mean user/pass/dbname?

I'm 100% sure they are correct, since I used the exact same settings for installing Joomla! and it runs fine.

Is com_connector and vbulletin_sql working for Joomla 1.0.8 now??  I must have missed that post if it is working.

OK..

My problem is PARTIALLY solved.

I can now login to Joomla! and I get logged into vbulletin.
The problem was that Joomla and VBulletin were in the same database. They have to be in 2 separate databases.

BUT, I still have problems.

1- If I input an invalid user/id, I still get the same SQL error


2- Now another issue has been risen.
In VBulletin, in the stats, I get 0 MEMBERS, 0 ACTIVE MEMBERS... although I do get right number of threads and posts.

Progress report:

I have now removed the SQL error when invalid user/pass was provided.

The problem was in joomla.php file:




I still have to get the MEMBERS stat on vbulletin to work. It shows them as 0!

Any ideas?

dont remove any code from joomla.php

REPLACE joomla.php WITH THE FILE THAT I HAVE LINKED IN MY POST

I can confirm from a fresh install  j!-108 and vb3.5.4 same error for incorrect login.


Also statistics need to be fixed, you must go to the admin>Update counters>Update usernames; to reset it back to normal after every single registration made. Obviously it cant work like that.

I will give up for the moment, its getting ridiculous trying to find information in this mess of a forum. 

Someone confirm if we have a stable 108 release yet with vbulletin_sql and PHP4. Im going to bed now.

I have successfuly wrapped and connected vbulletin to joomla in SQL format (NOT SOAP)

you have to get rid of the code I mentioned above in the joomla.php file.

Also, instead of using the Connector Item for the menu, use The Wrapper. It fits in better.

Regarding members # stat in vBulletin, I just removed them, since I already have a module on Joomla that tells the latest + # of registered members

Edit: Got it to work 100%

my forum however is under a subdomain. i think this is the reason why I have to login twice to post. is there a work around with this one?

Also how can I sync 3,000 + users to joomla?

you can not sync all user at one time
the user will be synced automaticaly by first login

I am having the same problems.  I have all the corrrect information added into the module.  Database name, user, pass, cookie, etc I know if all correct.  I have them on two different databases.  Those already registered on my joomla site cannot login to Vbulletin.  I registered a test account to see if I could log into VBulletin and I couldnt.  Weird, I must have missed something but I followed each step listed perfectly.  I am on joomla 1.0.8, could this be the problem?