vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Add-On Releases - vBExperience 3.8 (https://vborg.vbsupport.ru/showthread.php?t=199556)

Dutch_Boy 07-27-2009 01:30 PM

Hey phalynx i think you did something wrong. After installing the new update i get this database error:

Database error in vBulletin 3.8.3:

Invalid SQL:
SELECT * FROM vb_post_thanks AS post_thanks INNER JOIN vb_user AS user USING (userid) WHERE post_thanks.postid IN (0,15946) 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
Request Date : Monday, July 27th 2009 @ 06:26:35 PM
Error Date : Monday, July 27th 2009 @ 06:26:35 PM

Im using the addon:

vBExperience - Post Thank You Hack Integration

When i turn the thanks an groan addon off it stops.

When i try to look at a topic it give the database error.

Phalynx 07-27-2009 02:02 PM

Dutch Boy I don't think I did something wrong. I cannot see that vBExperience is involved in that query you posted. vBExperience and also that post hack integration is not using such a query.

Dutch_Boy 07-27-2009 02:07 PM

Quote:

Originally Posted by Phalynx (Post 1856521)
Dutch Boy I don't think I did something wrong. I cannot see that vBExperience is involved in that query you posted. vBExperience and also that post hack integration is using such a query.

But the last thing i did on the forum is upload your beta mod :S Strange !

Phalynx 07-27-2009 02:15 PM

That error disappears when you do what ... ?

Dutch_Boy 07-27-2009 02:22 PM

When i try to uninstall "vBExperience - Post Thank You Hack Integration" i get this database error.

Database error in vBulletin 3.8.3:

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

Dutch_Boy 07-27-2009 02:24 PM

Quote:

Originally Posted by Phalynx (Post 1856529)
That error disappears when you do what ... ?

It disappears when i turn the mods offline. I need to turn them both offline or i still get the error.

But i just reinstallad them both. Removed them completle but that didnt work :(

Phalynx 07-27-2009 02:25 PM

Quote:

Originally Posted by Dutch_Boy (Post 1856536)
When i try to uninstall "vBExperience - Post Thank You Hack Integration" i get this database error.

That does not happen with the version included in vBExperience 3.8.4.
Please install the version delivered with 3.8.4 and uninstall it after that.

Dutch_Boy 07-27-2009 02:31 PM

Quote:

Originally Posted by Phalynx (Post 1856541)
That does not happen with the version included in vBExperience 3.8.4.
Please install the version delivered with 3.8.4 and uninstall it after that.

Yep your right. Installed the new version and i removed it. But i still got the same problem.

Ill remove the thanks mod again.

But first i have to do some other things. Back in a few hours. (Around 20:00 dutch time)

Dutch_Boy 07-27-2009 02:34 PM

Ow got another database error and experience got something to do with it.

Database error in vBulletin 3.8.3:

Invalid SQL:
SELECT
u.userid,
points_post_thanks_got_total
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_post_thanks_got_total' in 'field list'
Error Number : 1054

Phalynx 07-27-2009 02:47 PM

As you removed that post thanks integration, you need also to remove that fields manually from awards you created.


All times are GMT. The time now is 09:25 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02715 seconds
  • Memory Usage 1,743KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete