vb.org Archive - Major Additions

Just installed the 4.10 version - I am getting an SQL error when I try to run the awards counter and a database error when I click on "Insight Experience" - this is what I'm seeing:

Quote:

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT
COUNT(*) AS cnt_ach,
i.achievementid,
a.title,
a.description,
a.imagebig
FROM xperience_achievements_issues AS i
INNER JOIN xperience_achievements AS a ON a.achievementid=i.achievementid
GROUP BY achievementid
ORDER BY COUNT(*) DESC
LIMIT 1;

MySQL Error : Invalid use of group function
Error Number : 1111

I'm not really sure where to look for how to fix this... any advice?

Zadvantage

04-28-2013 11:14 PM

...and it has been brought to my attention that when new "Achievements" are given and someone clicks on the notification, it causes a database error...

Also when I have tried recounting I'm getting this:

Quote:

Database error in vBulletin 4.2.0:

Invalid SQL:
SHOW COLUMNS FROM xperience_stats WHERE Field='points_threads';

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 'WHERE Field='points_threads'' at line 1
Error Number : 1064
Request Date : Sunday, April 28th 2013 @ 05:08:50 PM
Error Date : Sunday, April 28th 2013 @ 05:08:52 PM
Script : http://www.myforum.com/admincp/xperi...t=47501&pp=500
Referrer : http://www.myforum.com/admincp/xperi...t=47001&pp=500
IP Address : *****
Username : ******
Classname : vB_Database
MySQL Version : 4.1.24-log

I'd really love to use this system because it makes a lot of things I have planned MUCH easier - but I don't have the first clue where to start to fix this. Any guidance would be great.

Cody1611

04-28-2013 11:59 PM

Why do I only have level 1 showing?

Zadvantage

04-29-2013 03:54 AM

Going back, I see that the developer doesn't support this anymore - is there anything similar out there?

qpurser

04-29-2013 04:56 PM

Quote:

Originally Posted by Cody1611 (Post 2419023)

Why do I only have level 1 showing?

Only 1 level will be visible but you can import a higher or lower level from your admin Cpanel.

Under Experience on the left just select the option to import another level.
Several levels are included in the package you downloaded.

sonic83

05-09-2013 06:44 AM

I have a problem. Accumulate achievements and not replaced one another:

http://www.tradingunited.es/borrar.png

but if I have set in admincp: "Replace this achievement"

http://www.tradingunited.es/borrar2.png

Thank you

M.C.	05-09-2013 05:17 PM

anyone made Achivements and Awards icons in postbit BIGGER?! They downsize to 16x16 but I can't find any place where that happend?! :(

UPD: Found it ;)

mohammadxxx

05-20-2013 12:16 AM

Hi

i want change bars location like this :

http://file4.all4persian.org/do.php?...4537333251.jpg

Sorry for my bad english !
thanks

RustyF

05-29-2013 12:50 AM

Quote:

Originally Posted by IndigoSociety (Post 2405707)

Does this mod still work as expected or is it kinda broken right now? Any alternatives?

It is working for me, as far as I can tell. Though I'm not sure the point market goes with it.

Do a search for activity and awards. I think you'll find something. I'm going to change to that.

K!nG	05-31-2013 04:47 AM

Just wants to check if this mod is still working properly for version 4.2.1 because when i ran suspect file versions in admincp, most of xperience files came up with errors, e.g.

xperience_admin.php File does not contain expected contents

Eventhough i just updated all the files before i ran it through admincp. Can anyone help why i get this "files does not contain expeced contents" error on most of the files ??

Thanks in advance.

All times are GMT. The time now is 08:06 PM.

Page 255 of 270

255

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04912 seconds Memory Usage 1,745KB 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 (4)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: