Integration with VB 3.6.4

[Jamie Edwards]

Did you update this one?

Line 41:
Add your prefix, as below:

 $_user = $dbLoginShare->queryFetch("SELECT * FROM `user` WHERE `vb1_username` = '". $dbCore->escape($username) ."';");

[gedsta07]

Hi Jamie

We have 2 databases

One for vB and one for Kayako

The settings I used in the LOGINSHARE were copied off the config.php from vB so I know they are right.

I have done exactly what Craig said above and it throws the same error.

This is the error - Table 'nameofdatabase_.user' so it is not putting the vb1_ before the nameofdatabase_.user, I would expect it to be vb1_nameofdatabase_.user if you get what I mean.

[gedsta07]

Originally Posted by Jamie Edwards

Did you update this one?

Line 41:
Add your prefix, as below:

 $_user = $dbLoginShare->queryFetch("SELECT * FROM `user` WHERE `vb1_username` = '". $dbCore->escape($username) ."';");

nope

$_user = $dbLoginShare->queryFetch("SELECT * FROM `user` WHERE `vb1_username` = '"

[gedsta07]

Sorry the error has now changed

Invalid SQL: SELECT * FROM 'user' WHERE 'vb1_username' = 'myemailaddress'; (Table 'mydatabasename_.user' doesn't exist)

[Jamie Edwards]

I made a mistake, it was meant to read:

 $_user = $dbLoginShare->queryFetch("SELECT * FROM `vb1_user` WHERE `username` = '". $dbCore->escape($username) ."';");

[gedsta07]

That's the baby

Logged in successfully

Cheers I owe you both a beer

Ged

[craigbrass]

Hey, your welcome. Didn't think about if you'd done the second one when I seen the error.