vb.org Archive - Major Additions - Yet Another Awards System

Page 5 of 190

« First

105

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Major Additions - Yet Another Awards System (https://vborg.vbsupport.ru/showthread.php?t=232684)

absy	01-11-2010 12:44 PM

Quote:

Is this on a brand new fresh install, or upgrade?

Its a fresh install, on a test version of my forum, the error is the same on the default skin and my custom skin

Googled the error, dont know if this helps:

Quote:

#

If the ONLY_FULL_GROUP_BY SQL mode is enabled, an error occurs:

mysql> SET sql_mode = 'ONLY_FULL_GROUP_BY';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT owner, COUNT(*) FROM pet;
ERROR 1140 (42000): Mixing of GROUP columns (MIN(),MAX(),COUNT()...)
with no GROUP columns is illegal if there is no GROUP BY clause

#

If ONLY_FULL_GROUP_BY is not enabled, the query is processed by treating all rows as a single group, but the value selected for each named column is indeterminate. The server is free to select the value from any row:

CypherSTL

01-11-2010 12:54 PM

Bart, I did notice another error on your site, particularly with the Profile Tab. I left out a conditional statement in the output code for that.

For those who downloaded the BETA2 Zip file before this post, please re-download and import the XML.

CypherSTL

01-11-2010 12:55 PM

Quote:

Originally Posted by absy (Post 1952700)

Its a fresh install, on a test version of my forum, the error is the same on the default skin and my custom skin

Googled the error, dont know if this helps:

Trying to see if I can duplicate it.

--
There is a SUM statement, which adds up the total amount of points. That could be where it is erroring out on. Did you make that setting custom on your database, or what?

absy	01-11-2010 01:02 PM

not that I know, i disabled the points system and it works fine, so I am not worrired since I do not want to use the points, but it may be others might, thank you so much for working on this, itsa great part of our forum

CypherSTL

01-11-2010 01:07 PM

@absy: I've tried it so far with fresh installed on VB 4.0PL1 using the normal mysql extension, and the mysqli extension. I myself cannot duplicate this. Anyone else running into this?

absy	01-11-2010 01:11 PM

As I said, I am quite happy not to have a points system, if you would like to go on my test site and re enable the points and investigate there please do. If its just a quirk with my sql i wouldnt worry its an awesome mod

pm me if you want to go on my forum

CypherSTL

01-11-2010 01:17 PM

I sent you a PM absy with a link to an XML. See if it's fixed in that if you don't mind.

CypherSTL

01-11-2010 01:26 PM

Is anyone else having this problem with the points system being enabled and getting the SQL Error? I have a possible fix that I'm wanting to test before I update the actual .zip package.

I'm unable to duplicate the error on my test machines.

DigitalDark

01-11-2010 01:28 PM

I use beta 2 and I've found a little bug in the private messages. I've seen the changes... very good work in beta 2

Image of the bug:
With moderators and admins ocurrs but with standard users not..
https://vborg.vbsupport.ru/external/2010/01/98.jpg

Image disabling the mod:

https://vborg.vbsupport.ru/external/2010/01/99.jpg

Another thing is the medal description in profile...

https://vborg.vbsupport.ru/external/2010/01/100.jpg

I think that there is a issue with the css nothing more... Thanks for your help!

PD: I don't have this sql error. I use ucash and I think that everithing is right despite of this details.

CypherSTL

01-11-2010 01:36 PM

Digital. I did catch the Profile Tab bug and a few template's wern't caching. Those have been fixed in the current Beta2 Zip file. Try to redownload it and reimport the XML from that and see what it does.

Also, what postbit location are you using?

All times are GMT. The time now is 05:09 PM.

Page 5 of 190

« First

105

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01952 seconds Memory Usage 1,741KB 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 (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)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
Messages: