Dolphin V5.2 Vbulletin Module Bug

bond2u · 10-01-2006

I have installed DOLPHIN v5.2, runs fine.
Then I installed Vbulletin v3.6.0, runs fine.
Then I installed Boonex's/Dolphin's vbull module to connect the two together.
After adding my first user to Dolphin, I pressed "FORUM" and this is what returned:

"Fatal error: Erroneous or empty query result: SELECT userid, usergroupid, membergroupids, username, password, salt FROM vbull_user WHERE username = 'bond2u'"

I believe this to be a "bug" in the Dolphin -> Vbulletin module.

As per Smoge, I am looking into the inc/modules.inc.php file (line 153)
$$ModuleFunction = create_function($ParametersDeclaration, $ArrModule[$FuncName]);

1. I "wish" (like this was magic) that the module was just written to post registration information to the appropriate location in the DB, so it could be recalled and the member could just go to the forum

2. I have no idea what I'm doing

3. I want to do my own work...I have time, I just don't know how many files have to be changed. I'm sitting in a pile of printed out code trying to match all this together! hahahaha

4. I think that I'd have to set up my own unix server at home (I'll do it, I have the computers) to use this PhpED program I have to troubleshoot this issue myself. It seems like many people could benefit from this.

5. HELP!!!!! Any suggestions from those of you who know and don't have the time to build this mod the way it should have been built? Tell me how to go about it and I'll do it and give it back!!

10. (forget 6-9) DON'T USE BOONEX FORUM FOR HELP ON THIS - THEY DON'T ANSWER = THEY DON'T CARE!

**Smoge** · 10-01-2006

Run:

Code:

SELECT userid, usergroupid, membergroupids, username, password, salt FROM vbull_user WHERE username = 'bond2u'"

in the phpmyadmin SQL box (after selecting your database) - and see what happens there.

Does it run? Any results? Does phpmyadmin report an error?

Smoge

**Smoge** · 10-01-2006

this has been split into a new thread (the one you are looking at now).

Smoge

bond2u · 10-01-2006

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 sec)
SQL query: SELECT userid, usergroupid, membergroupids, username,
PASSWORD , salt
FROM vbull_user
WHERE username = 'bond2u'
LIMIT 0 , 30

1. I have only one user = bond2u that was registered into Dolphin.
2. I see "bond2u" in the "PROFILE" listing in my DB
3. There is NOTHING in the Vbull_user listing of my DB

4. I just checked my e-mail = bug report and this showed up:
synchronizeProfiles(): exec(/usr/local/bin/php -f refresh.php 1 admin ) returned 255

**Smoge** · 10-01-2006

Originally Posted by bond2u

4. I just checked my e-mail = bug report and this showed up:
synchronizeProfiles(): exec(/usr/local/bin/php -f refresh.php 1 admin ) returned 255

Yes - look into this before you do anything else.

Smoge

bond2u · 10-01-2006

Here's something I found interesting.

When I am logged into Dolphin as administrator, then open another browser window and log into my "bond2u" user account and select Vbulletin (forum), I am redirected (as I should be) to Vbulletin.....TO BE LOGGED IN AS ADMINISTRATOR

??

So I guess that's a cookies setting or IP address.

Luckily I have four computers in the house...so I tested that on the computer 2 feet away from me (hahahaha) and it returned my previously posted error i.e.,

Fatal error: Erroneous or empty query result: SELECT userid, usergroupid, membergroupids, username, password, salt FROM vbull_user WHERE username = 'bond2u'
**the browser page url showing is: http://www.mysite.com/forum/vblogin.php (mysite substituted for real name)

So it's not an IP issue...but cookies.

Still not any closer to the original problem of vBulletin integration.

Tomorrow I go to Walmart to buy a Nic for another computer to put a Unix server Clone on it so I can troubleshoot this issue at home.

bond2u · 10-01-2006

Quote:
Originally Posted by bond2u
4. I just checked my e-mail = bug report and this showed up:
synchronizeProfiles(): exec(/usr/local/bin/php -f refresh.php 1 admin ) returned 255

Originally Posted by Smoge

Yes - look into this before you do anything else.

Smoge

It was because I emptied my profile table yesterday in frustration with this, at the same time I was in Dolphin Admin and did the refresh, and received that e-mail. Hasn't happened again after a refresh. Whew!

**Smoge** · 10-01-2006

So it's not an IP issue...but cookies.

I thought you did a query on the vbull_user table, and your username was not found - so I think it is the "add" or "modify" code in the vbulletin aedating module.

You need to fix this problem first perhaps:

Code:

synchronizeProfiles(): exec(/usr/local/bin/php -f refresh.php 1 admin ) returned 255

Smoge

Thread: Dolphin V5.2 Vbulletin Module Bug

LinkBack

Thread Tools

Display