rszrama, I do again need your help.

I installed Drupal vB and my vb users started to re-register themselve in drupal. They get a error-message "duplicate user" - but everything works fine after that.

The problem occurs when new users register in drupal. The corresponding module-created vb user account does not work correctly. It is not possible to answer PMs nor to find the user in the admin module. I'm using vb 3.5.4.

I guess it is just a small thing - but I do not have the capabilities to analyse the Drupal Vb module to fix it. Do you have an idea?

CommentFileSizeAuthor
#4 drupalvb.inc.php.txt10.64 KBtassoman
#3 drupalvb.module30.74 KBtassoman

Comments

Transaxle’s picture

Transaxle commented

Here is what I get if I try to send a drupal created vb user a private message:

Datenbankfehler in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO pm (pmtextid, userid) VALUES (2021, );

MySQL-Fehler : 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 1
Fehler-Nr.   : 1064
Datum        : Wednesday, July 5th 2006 @ 07:12:15 PM
Skript       : http://www.transaxle-sportwagen.de/forum/private.php
Referrer     : http://www.transaxle-sportwagen.de/forum/private.php?do=newpm&u=957
IP-Adresse   : 84.160.232.102
Benutzername : Transaxle
Klassenname  : vb_database

I don't know why the userid is lost... It only happens with drupal created vb accounts. Maybe it helps...

Transaxle’s picture

Transaxle commented

OK - i give up...

I'll make the step back from 4.7 to 4.6 to give the vbDrupal approach a chance. Both - drupal and vb - are great software, but integration is a mess...

tassoman’s picture

tassoman commented
StatusFileSize
new drupalvb.module30.74 KB

I've edited the module file to support prefix in tables. Moreover it's possible also to have forums on different 3d level domain.

Still a problem with cookies. If i login into drupal, i can't get logged into vb.

this code must be checked

tassoman’s picture

tassoman commented
StatusFileSize
new drupalvb.inc.php.txt10.64 KB

Here attached there is also the modified drupalvb.inc.php

Before install edit the constants in top of script file.

The .module file is attached in the precedent message.

Transaxle’s picture

Transaxle commented

As I said, I made the step back from 4.7 to 4.6 to use vbDrupal instead of the Drupalvb module.

Everything is now very well integrated. It also offers a vb-Theme to create a perfect integrated look out of the box. The only issue was that the 4.6 stuff is not strict mode compatible in mysql 5.0.

If you love both - drupal and vb - that seems to be the way to go.

I just miss all the new things I've already seen in 4.7 ;-(

rszrama’s picture

rszrama commented

I recently began testing/rewriting much of the module... as you all found out, it was crap. Anyways, it turns out there was a constant that needs to be set per installation for the cookies to work properly -> your vBulletin license number is used as the cookie salt. I'm going to look through the other changes you made and hopefully apply them as well and get this module in working condition.

Sorry it's been so long.

valcker’s picture

valcker commented

Hello. I have a problem with users password in vbulletin. drupalvb creates vbulletin account but with wrong password. As I understand it just copies md5_hash from drupal to vbulletin database. So when I'm trying to login using created account I'm getting 'wrong password' message. Is there any solution of this problem?

Thank you.

rszrama’s picture

rszrama commented

I'm curious if you're using the latest CVS version. The module got a
total overhaul with the CVS release, and the one marked here as 4.7 is
outdated. Also, vBulletin actually uses an md5 of an md5 + a salt
string. Make sure your password salt string was setup correctly...
although with the latest I don't believe you need to fool with it at
all.

-Ryan

Andrew Thomas’s picture

Andrew Thomas commented

im getting this error

after i enable my blocks

Warning: mysql_real_escape_string(): 6 is not a valid MySQL-Link resource in /home/sbs/public_html/includes/database.mysql.inc on line 349

Warning: mysql_query(): 6 is not a valid MySQL-Link resource in /home/sbs/public_html/includes/database.mysql.inc on line 101

Warning: mysql_errno(): 6 is not a valid MySQL-Link resource in /home/sbs/public_html/includes/database.mysql.inc on line 116

rszrama’s picture

rszrama commented
Status: Active » Closed (fixed)

House cleaning... tassoman's patches are unfortunately obsolete after the major overhaul I did last month. : (