View Single Post
  #59  
Old 03-14-2006, 12:06 AM
SilentK SilentK is offline
 
Join Date: Nov 2004
Location: Maryland
Posts: 57
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Im running into a problem.

I have two joomla portals they are both on the same domain and server as the vbulletin installation. My problem is that one is working and the other is not.

Is it possible to run the connector on two joomla portals and one vbulletin installtion?

the reaosn i ask is the both have the identical information in the connector preferences and the one will not work.

Each installation is in a seperate database, so the joomla's are seperate and the vbulletin is by itself as well.

the error I get whenever I try to login is the following.
Quote:
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 = 'session information' WHERE id =
SQL =

UPDATE jos_users
SET connector_cookies = 'session information'
WHERE id =
I have the same exact connection details in my working portal though and it works so I don't think it's a problem with me specifying bad details on how to connect to the database.

By the way I get the above when trying to login into mambo with my vbulletin account.

An interesting tid bit though is that the vbulletin installation is getting updated with my joomla account from the portal that gives me the error so I know for sure it's not a connectoin issue with the vbulletin database.

Only difference between the two joomla installation is one is a sub domain. Vbulletin cookies settings are path / and domain blank however.

I have php 4 so I am using the vbulletin_sql.class
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01412 seconds
  • Memory Usage 1,765KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete