figured it out --- shoulda ran the install script BEFORE making all those code modifications.... (good thing i kept backups of the originals, huh?)

Well there is no select query in the install script (teams2.0.2_install.php), so i doubt you are getting this error during the install script.

This error look like the install script was never run.

well, im having problems where i have people as a member of certain teams and they cant access the private forums for that team etc.

HELP ME!!!...

After the file modifications and as I attempted to enter my forum's main index page to edit the templates, I came upon this error message:

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT teams.*, teams.name AS username,

COUNT(user.userid) AS totalmembers,
sum(user.posts) AS posts,
sum(user.reputation) AS reputation
FROM vb3teams AS teams
LEFT JOIN vb3user ON(teams.teamid = user.teamid)
WHERE teams.teamid =1
GROUP BY teams.teamid


mysql error: Unknown table 'user' in field list

mysql error number: 1109

Date: Friday 11th of March 2005 12:37:55 AM


Can someone please help me here???

Sounds to me like you are using table prefix, and the hack didn't support that.

Try to find the file where you made the edit to this sql when installing this hack. You will probably see something like:
chnage it to:

I didn't do any mysql edits just main file edits...u know how to install this script? If so, can you look over my modified files and see what went wrong and if you see any thing messed up can you fix it? I mean can you help me out????

screw this hack! Is full of bugs and as I read this entire thread...I realize just like the rest of you...it was poorly coded and the creator is no where to be found to help us out when we need help...I hope someone else (who is more experinced in coding) pick this hack up and rewrite it and test it out...and may that coder be successful in it and we have another cool hack to add to our forums...as for the creator of this hack...you need to practice or learn more bout coding cuz this hack has great potentials but ya codin sux as there are so many bugs in it...is not even funny and it is freakin frustratin to try and sort it out...esp when ur not a techie like u!

PLEASE SOMEONE ELSE WITH MORE CODIN EXPERINCE REWRITE THIS HACK & I HOPE YOU HAVE BETTER LUCK WITH IT THAN IT'S ORIGINAL CREATOR!

And I do not mean to sound ungrateful here but seriously...too much bugs and is freakin frustratin to try and fix it and when u do fix something... more bugs pop up! It got great potential but the codin SUX big ass time

peeps like is the exscat reason i dont post the fix's and updates.
i had bugs on the table prefix cuse i simply dont use it

you say my coding sux so you have 2 options right now
or code for yourself, or simply dont use my code
if you want to use it take it as it is

thats all. if you want to see my real coding you can take a look on my site
there all of my hacks working 100 % perfectly.

sorry but im not going to support any qustions from you any more
thanx for the response have a good day and good bye.

Scerina no one is forcing you to use this mod, if you dont like it learn php and code it yourself. Here is a good link to start Learn PHP

Also remember that Miz is generous enough to share his mod with the community.. he has no obligation at all to be here or share his coded mods... he does it because he feels like it... if you dont like how he codes, as I said, learn php or pay some coder to create the pefect hack for you.

Have a great day.

P.S. Next time try to be nice and dont let frustration get to you.

ok, back on track now the hatred has been let out,lol

Anyone want to work on getting this to work correctly for us?