Dutch_Boy
07-27-2009, 10:40 PM
Hello,
I installd the new update of vBexperience (https://vborg.vbsupport.ru/showthread.php?t=199556&highlight=vBExperience) mod. After he new update my forum gose crazy. Its saying there is a problem with the thanks (https://vborg.vbsupport.ru/showthread.php?t=165673&page=112&highlight=[AJAX]+Thank) 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.
I installd the new update of vBexperience (https://vborg.vbsupport.ru/showthread.php?t=199556&highlight=vBExperience) mod. After he new update my forum gose crazy. Its saying there is a problem with the thanks (https://vborg.vbsupport.ru/showthread.php?t=165673&page=112&highlight=[AJAX]+Thank) 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.