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.

[snakes1100]

1. You need to post in the thread related to said hacks for support for that hack.

2. It appears the user dont have SELECT priv's on the db, fix the user privs for the db.

3. Reinstall the hacks you removed as its stating some columns are unknown.