Originally Posted by Jdm Ej1 Coupe View Post
I installed this on my site when I go to the usercp to Edit vBGarage I get this

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT year,make,model,text FROM vbgarage_users WHERE userid = 2;

MySQL Error : 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 'make,model,text FROM vbgarage_users WHERE userid = 2' at line 1
Error Number : 1064
Date : Saturday, October 20th 2007 @ 02:26:05 PM
Script : http://www.jdmcoupecouncil.com/forum...?do=editgarage
Referrer : http://www.jdmcoupecouncil.com/forum/usercp.php
IP Address : 24.63.66.223
Username : EJWone Dina
Classname : vB_Database


Can anyone help me with this? What did I do wrong?

I've attachted the garage fix for 3.6.8. Just drag and drop. Your current database should remain without any issues. This fixes the problem where only the first page of a multiple page garage shows up.

My site (lincolnstreetscene.com soon to be starcityracing.com) and Mx6.com are using this file with success on 3.6.8.

enjoy.

Don't know if that was directed toward me but I did copy the attached file and paste it in the vbgarage.php in my file manager and still I get this error. Some one please help me as I would like to have this for my members.

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT year,make,model,text FROM vbgarage_users WHERE userid = 2;

MySQL Error : 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
'make,model,text FROM vbgarage_users WHERE userid = 2' at line 1
Error Number : 1064
Date : Tuesday, October 30th 2007 @ 08:08:42 PM
Script : http://www.jdmcoupecouncil.com/forum...?do=editgarage
Referrer : http://www.jdmcoupecouncil.com/forum/usercp.php
IP Address :
Username : EJWone Dina
Classname : vB_Database

weird... what version did you generate the error on??

Anyone ever figure out a way to have more than one vehicle per member?

So with a few edits, people are getting this to work with 3.6.8?

SVT

I think, this "Error" is just by using vB3.6.8 ("or higher")!


The garage runs by me with vB3.6.8!
http://www.zafira-forum.de/vbgarage.php?do=list

What, if anything, did you have to do to get it to work ok?

SVT

nothing!
I just updatet from 3.6.0 => and evrything was ok ... even the little bug postet by me here -> POST 428

Maybe it's because of your style?
did you tried it by using the standard-style?

I got it working fine on 3.8 as well. http://www.moddedmustangs.com/forums/garage/

Just installed the mod with this php file.

PS - also do the fix a few pages back where it fixes the garage numbering so that they don't all start back out at 1 when you change pages. Plus there's another bit of code a couple pages before that that allows you to track the garage activity in who's online. So do those two things in addition to using the file above.