Need help. Database errors.

[Dutch_Boy]

Hello,

I installd the new update of vBexperience mod. After he new update my forum gose crazy. Its saying there is a problem with the thanks en groan mod.

Here are some of the database error's i got:


Invalid SQL:
SELECT * FROM vb_post_groan AS post_groan INNER JOIN vb_user AS user USING (userid) WHERE post_groan.postid IN (0,15029,15030,15031,15034,15036,15037,15038,15046 ,15063,15108,15182,15254,15296,15317,15344,15554,1 5768) ORDER BY post_groan.username ASC;

MySQL Error : SELECT command denied to user 'iwsgamin_iwsvb'@'localhost' for column 'userid' in table 'post_groan'
Error Number : 1143

Invalid SQL:
SELECT * FROM vb_post_groan AS post_groan INNER JOIN vb_user AS user USING (userid) WHERE post_groan.postid IN (0,15963,15965,15966) ORDER BY post_groan.username ASC;

MySQL Error : SELECT command denied to user 'iwsgamin_iwsvb'@'localhost' for column 'userid' in table 'post_groan'
Error Number : 1143


Invalid SQL:
SELECT * FROM vb_post_thanks AS post_thanks INNER JOIN vb_user AS user USING (userid) WHERE post_thanks.postid IN (0,15963,15965,15966) ORDER BY post_thanks.username ASC;

MySQL Error : SELECT command denied to user 'iwsgamin_iwsvb'@'localhost' for column 'userid' in table 'post_thanks'
Error Number : 1143

Invalid SQL:
ALTER TABLE vb_xperience_stats DROP points_post_thanks_used BIGINT DEFAULT '0';

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 'BIGINT DEFAULT '0'' at line 1
Error Number : 1064
[/CODE]

I have no idea what to do :S Im with my back against the wall

Here what i allready tried:

• Turned of experience mod and all the addons that work with experience mod.
• Delete experience mod and all the addons.
• Delete thanks, groan mod and experience mod. A complete new install. Delete everthing on the server via FTP.
• Delete experience mod and try it only with thanks en groan mod. Still same error.

I get the database error when i try to open a topic.

Im running now the new experience mod (version 3.8.4) on my forum. And i still get database errors:

Invalid SQL:
SELECT
u.userid,
points_misc_v3arcadechamps
AS get_count
FROM vb_xperience_stats as s
LEFT JOIN vb_user as u ON u.userid = s.userid
WHERE 1 = 1 AND NOT (1=2 OR u.usergroupid = '6' OR FIND_IN_SET(6, u.membergroupids))
ORDER BY get_count DESC, points_xperience DESC
LIMIT 0,1;

MySQL Error : Unknown column 'points_misc_v3arcadechamps' in 'field list'
Error Number : 1054

The maker of experience knows that i got a problem. Check experience forum and go to page 52. He told me that experience mod cant be the problem, but it all hapens after installing the new update :S

So is there anyone who can tell me what the problem is?

Kind regards,

Dutch_Boy.