Integration with VB 3.6.4

gedsta07 · **Integration with VB 3.6.4 -** 05-08-2007, 05:58 PM

Hi all

First post so please go easy on me. We bought the leased version on Friday and have followed all the instructions to the best of my knowledge.

The issue we are having is using the LOGINSHARE with vbulletin. We have inputted the correct details:

localhost
username
password

However when we go to test it says:

Invalid SQL: SELECT * FROM 'user' WHERE 'username' = 'myname'; (Table 'myname_.user' doesn't exist)

Have I missed a step?

tia

craigbrass · 05-08-2007, 07:38 PM

Do you by any chance use a different table prefix to the one vBulletin defaultly uses?

gedsta07 · 05-08-2007, 07:42 PM

Yes - vb1

Is there a way I can change it in Kayako?

craigbrass · 05-08-2007, 07:48 PM

You can edit includes/LoginShare/vb.login.php in the two instances that say TABLE_PREFIX.

gedsta07 · 08:05 PM

Hi Craig, I can't edit it its encoded. So looks like I am stuffed

**Jamie Edwards** · 05-08-2007, 07:56 PM

Hi there,

Please e-mail me at my address in the signature and I will send it to you.

gedsta07 · 05-08-2007, 08:01 PM

Hi Jamie

Emailed

Sorry I just realised I called you Craig in the email

Thx for the excellent support on a Sunday night at 9pm

Ged

craigbrass · 05-08-2007, 08:12 PM

Yea, me and Jamie are a bit sad doing this at this time on a Sunday aren't we

gedsta07 · 05-08-2007, 08:19 PM

Can I post the table prefix thingy as I cannot get it work?

Glad you are working btw I have been on this for 24 hours and I need a beer

craigbrass · 05-08-2007, 08:30 PM

Just change the following :-

Code:

". TABLE_PREFIX ."

To :-

Code:

vb1_

and the same for the second instance later on in the code. Should do the trick.

Jamie: Two things. Can the LoginShare files be removed from the files getting encrypted? Also, can't the DB prefix be one of the admin entries like I have done in the LoginShares I created?

gedsta07 · 05-08-2007, 08:43 PM

so it should look like?

Code:

"UPDATE `vb1_users`

and

Code:

("SELECT `userid` FROM `vb1_useremails` WHERE

craigbrass · 05-08-2007, 08:43 PM

gedsta07 · 05-08-2007, 08:47 PM

Nope - don't work

same error

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

craigbrass · 05-08-2007, 08:50 PM

That is really odd then. I suggest you contact Kayako who will investigate the problem on your installation (http://members.kayako.net -> Get Support).

Edit: I wonder if VB has changed their database since the LoginShare was made. This would make sense why it isn't working.

**Jamie Edwards** · 05-08-2007, 08:52 PM

Hi there,

Are you sure that vBulletin has been installed into the database you are pointing the LoginShare module to?

This error suggests to me that there is another occurrence that needs updating with the table prefix. I will take a look.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
kayako, upgrade this forum to VB 3.6.4	ppc	Comments, Questions & Feedback	15	28-02-2007 12:00 AM
ModernBill Integration Beta	Jamie Edwards	News and Announcements	0	13-11-2006 12:00 PM
New integration method	jc11	Developers & Code	4	05-11-2005 05:22 PM

craigbrass Offline Senior Member Posts: 5,394 Join Date: Jun 2005 Location: Cumbria, UK	05-08-2007, 07:38 PM Do you by any chance use a different table prefix to the one vBulletin defaultly uses? Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

gedsta07 Offline Member Posts: 40 Join Date: Aug 2007	05-08-2007, 07:42 PM Yes - vb1 Is there a way I can change it in Kayako?

craigbrass Offline Senior Member Posts: 5,394 Join Date: Jun 2005 Location: Cumbria, UK	05-08-2007, 07:48 PM You can edit includes/LoginShare/vb.login.php in the two instances that say TABLE_PREFIX. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

gedsta07 Offline Member Posts: 40 Join Date: Aug 2007	05-08-2007, 07:52 PM Hi Craig, I can't edit it its encoded. So looks like I am stuffed Last edited by gedsta07; 05-08-2007 at 08:05 PM.

gedsta07 Offline Member Posts: 40 Join Date: Aug 2007	05-08-2007, 08:01 PM Hi Jamie Emailed Sorry I just realised I called you Craig in the email Thx for the excellent support on a Sunday night at 9pm Ged

craigbrass Offline Senior Member Posts: 5,394 Join Date: Jun 2005 Location: Cumbria, UK	05-08-2007, 08:12 PM Yea, me and Jamie are a bit sad doing this at this time on a Sunday aren't we Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

gedsta07 Offline Member Posts: 40 Join Date: Aug 2007	05-08-2007, 08:19 PM Can I post the table prefix thingy as I cannot get it work? Glad you are working btw I have been on this for 24 hours and I need a beer

gedsta07 Offline Member Posts: 40 Join Date: Aug 2007	05-08-2007, 08:43 PM so it should look like? Code: "UPDATE `vb1_users` and Code: ("SELECT `userid` FROM `vb1_useremails` WHERE

craigbrass Offline Senior Member Posts: 5,394 Join Date: Jun 2005 Location: Cumbria, UK	05-08-2007, 08:43 PM Ya. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

gedsta07 Offline Member Posts: 40 Join Date: Aug 2007	05-08-2007, 08:47 PM Nope - don't work same error Invalid SQL: SELECT * FROM 'user' WHERE 'username' = 'myemailaddress'; (Table 'nameofdatabase_.user' doesn't exist)