[CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Discuss the universal connector for forums and other applications. (including vBridge )
Locked
arian
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Sun Nov 27, 2005 9:54 am

[CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Post by arian » Tue Mar 21, 2006 6:46 pm

-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:

Code: Select all

DB function failed with error number 1064
You have an error in your SQL syntax near '' at line 3 SQL=UPDATE jos_users SET connector_cookies = 'a:0:{}' WHERE id =
SQL =

UPDATE jos_users
 SET connector_cookies = 'a:0:{}'
 WHERE id =
Last edited by arian on Tue Mar 21, 2006 6:57 pm, edited 1 time in total.

Slimper
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu Mar 09, 2006 5:47 pm

Re: [CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Post by Slimper » Tue Mar 21, 2006 8:46 pm

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 :-\

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: [CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Post by leonsio » Wed Mar 22, 2006 12:10 am

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 )
Last edited by leonsio on Wed Mar 22, 2006 12:11 am, edited 1 time in total.

arian
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Sun Nov 27, 2005 9:54 am

Re: [CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Post by arian » Wed Mar 22, 2006 12:17 am

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)

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: [CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Post by leonsio » Wed Mar 22, 2006 12:23 am

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 )

arian
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Sun Nov 27, 2005 9:54 am

Re: [CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Post by arian » Wed Mar 22, 2006 12:45 am

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.

BrianB
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 152
Joined: Thu Sep 08, 2005 2:26 am

Re: [CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Post by BrianB » Wed Mar 22, 2006 1:54 am

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

arian
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Sun Nov 27, 2005 9:54 am

Re: [CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Post by arian » Wed Mar 22, 2006 3:17 am

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

Code: Select all

DB function failed with error number 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 3 SQL=UPDATE jos_users SET connector_cookies = 'a:0:{}' WHERE id =
SQL =

UPDATE jos_users
 SET connector_cookies = 'a:0:{}'
 WHERE id =
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.

arian
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Sun Nov 27, 2005 9:54 am

Re: [CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Post by arian » Wed Mar 22, 2006 3:35 am

Progress report:

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

The problem was in joomla.php file:

Code: Select all

  // Save cookies into the Database ( needed for logout an other calls by soap modules )
                               
 //taken out by Arian on March 21st
/*
				$query = "UPDATE #__users"
                                . "\n SET connector_cookies = '".serialize($cookies)."'"
                                . "\n WHERE id = $row->id"
                                ;
                                $this->_db->setQuery($query);
                                if (!$this->_db->query()) {
                                        die($this->_db->stderr(true));
                                }
*/

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

Any ideas?

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: [CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Post by leonsio » Wed Mar 22, 2006 9:48 am

dont remove any code from joomla.php

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

User avatar
Takster
Joomla! Apprentice
Joomla! Apprentice
Posts: 24
Joined: Fri Feb 10, 2006 10:37 am

Re: [CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Post by Takster » Wed Mar 22, 2006 5:40 pm

arian wrote: 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

Code: Select all

DB function failed with error number 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 3 SQL=UPDATE jos_users SET connector_cookies = 'a:0:{}' WHERE id =
SQL =

UPDATE jos_users
 SET connector_cookies = 'a:0:{}'
 WHERE id =
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.

I can confirm from a fresh install  j!-108 and vb3.5.4 same error for incorrect login.
DB function failed with error number 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 3 SQL=UPDATE jos_users SET connector_cookies = 'a:0:{}' WHERE id =
SQL =

UPDATE jos_users
SET connector_cookies = 'a:0:{}'
WHERE id =
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.

arian
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Sun Nov 27, 2005 9:54 am

Re: [CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Post by arian » Sat Mar 25, 2006 3:20 am

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

berlin
Joomla! Intern
Joomla! Intern
Posts: 76
Joined: Thu Sep 01, 2005 5:41 am

Re: [CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Post by berlin » Tue Apr 25, 2006 10:18 am

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?
Last edited by berlin on Tue Apr 25, 2006 10:32 am, edited 1 time in total.
The man who speaks to you of sacrifice speaks of slaves and masters. And intends to be the master. --Ayn Rand

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: [CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Post by leonsio » Wed Apr 26, 2006 3:34 pm

berlin wrote: 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

xKillswitchx
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 215
Joined: Sun Mar 26, 2006 7:55 pm

Re: [CC] Joomla login won't login to vBulletin, and SQL error on incorrect login

Post by xKillswitchx » Sun Apr 30, 2006 7:36 pm

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?


Locked

Return to “com_connector - Multi Joomla Bridge”