vb.org Archive
Page 5 of 68 « First 34 5 671555 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - Yet Another Awards System 2.1.4 (https://vborg.vbsupport.ru/showthread.php?t=142487)

masons 03-21-2007 09:03 AM
Can someone integrate this so it shows up in ZOINTS profiles too?

masons 03-21-2007 10:02 AM
Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT a.*, au.*, post.userid, post.postid
FROM post AS post
INNER JOIN award_user AS au ON (au.userid=post.userid)
INNER JOIN award AS a ON (a.award_id=au.award_id)
WHERE post.postid IN (0,5288,5244,5169,5161,5158,5154,5142,4651,4291,42 50) GROUP BY post.postid

GROUP BY au.issue_id
ORDER BY au.issue_time DESC;

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 'GROUP BY au.issue_id
ORDER BY au.issue_time DESC' at line 7
Error Number : 1064
Date : Wednesday, March 21st 2007 @ 05:53:15 AM
Script : http://www.novusordosaeculorum.com/s...34.html?p=5288
Referrer : http://www.novusordosaeculorum.com/
IP Address : 124.86.224.8
Username : Mike
Classname : vB_Database

Phooey 03-21-2007 11:09 AM
Quote:
Originally Posted by KristerSwe (Post 1207313)
Hello all

Sharing my PSD here for you to play with. the psd file is sliced so if you make changes
you can easy "save optimized as" and they are splitted and named .....

Hope you guys liked them enjoy ...

Regards Krister
You rock.

masons 03-21-2007 01:07 PM
The above error disappears when I turn off the POSTBIT function in the admin area!

Necrosaro420 03-21-2007 11:10 PM
Will this run on vb 3.6.4? Also, I use Postbit, (not legacy) will this work? Thanks!

toucan42 03-22-2007 03:13 AM
Quote:
Originally Posted by masons (Post 1208774)
The above error disappears when I turn off the POSTBIT function in the admin area!
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT a.*, au.*, post.userid, post.postid
FROM post AS post
INNER JOIN award_user AS au ON (au.userid=post.userid)
INNER JOIN award AS a ON (a.award_id=au.award_id)
WHERE post.postid IN (0,11332,11334,11336,11337,11338) GROUP BY post.postid

GROUP BY au.issue_id
ORDER BY au.issue_time DESC;

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 'GROUP BY au.issue_id
ORDER BY au.issue_time DESC' at line 7
Error Number : 1064
Date : Wednesday, March 21st 2007 @ 11:04:22 PM
Script : http://www.talkwhatever.com/showthread.php?p=11338
Referrer : http://www.talkwhatever.com/index.php
IP Address : 72.92.141.48
Username : admintw42
Classname : vb_database

For me this occurs when I turn ON postbit - assuming it is the double GROUP BY but not sure how to fix that in the product.

toucan42 03-22-2007 03:40 AM
On member.php there is a problem also where it shows the small awards showcase:

Awards Showcase
The Ladybug Award: For excellent posts

Congratulations!" border="0" />

Issue with quotes in the "Reason" field?

mtha 03-22-2007 03:43 AM
Quote:
Originally Posted by masons (Post 1208672)
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 'GROUP BY au.issue_id
ORDER BY au.issue_time DESC' at line 7
Quote:
Originally Posted by toucan42 (Post 1209342)
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT a.*, au.*, post.userid, post.postid
FROM post AS post
INNER JOIN award_user AS au ON (au.userid=post.userid)
INNER JOIN award AS a ON (a.award_id=au.award_id)
WHERE post.postid IN (0,11332,11334,11336,11337,11338) GROUP BY post.postid

GROUP BY au.issue_id
ORDER BY au.issue_time DESC;

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 'GROUP BY au.issue_id
ORDER BY au.issue_time DESC' at line 7
Error Number : 1064
Date : Wednesday, March 21st 2007 @ 11:04:22 PM
Script : http://www.talkwhatever.com/showthread.php?p=11338
Referrer : http://www.talkwhatever.com/index.php
IP Address : 72.92.141.48
Username : admintw42
Classname : vb_database

For me this occurs when I turn ON postbit - assuming it is the double GROUP BY but not sure how to fix that in the product.


Do you have some other hack that replace the $postids value and add a GROUP BY post.postid ?


please check what's other hacsk using this hook location: showthread_query

toucan42 03-22-2007 04:10 AM
I'm not sure but by simply removing the GROUP BY in the product XML and replacing with a comma I was able to get it working.

howard11 03-22-2007 12:24 PM
Great Mod really chuffed about it :):) Thanks


All times are GMT. The time now is 07:12 AM.
Page 5 of 68 « First 34 5 671555 Last »
Show 40 post(s) from this thread on one page

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.01594 seconds
  • Memory Usage 1,747KB
  • 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
  • (2)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