vb.org Archive - Major Additions

Database error in vBulletin 4.1.1:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_cprofilefield = 'a:18:{s:12:\"field10_desc\";s:60:\"Aici trebuie să ?ţi introduci numele tău real\";s:13:\"field10_title\";s:9:\"Nume Real\";s:11:\"field1_desc\";s:26:\"C?teva detalii despre tine\";s:12:\"field1_title\";s:12:\"Biografia Ta\";s:11:\"field2_desc\";s:19:\"Unde locuieşti\";s:12:\"field2_title\";s:24:\"Reşedinţă \";s:11:\"field3_desc\";s:20:\"Pasiunile tale,
.......................................ETC ETC.............................................
Activity\";s:15:\"xperience_stats\";s:10:\"Statist ics\";}' WHERE languageid = 3;

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Request Date : Wednesday, January 19th 2011 @ 11:43:56 PM
Error Date : Wednesday, January 19th 2011 @ 11:44:00 PM
Script : http://www.stormzone.ro/forum/adminc...=productimport
Referrer : http://www.stormzone.ro/forum/adminc...?do=productadd
IP Address : 79.117.100.135
Username : Lloyd
Classname : vB_Database
MySQL Version : 5.0.91-community-log

cant post you all the message. it has 1 mill characters:)). need help please. what is the problem. i think is related to language but can figure out what

Sunka

01-20-2011 11:17 PM

Database error every 10 minutes.

HTML Code:

Database error in vBulletin 4.1.0:



Invalid SQL:

SELECT 

        dbtech_thanks_likes,

        dbtech_thanks_liked,

        dbtech_thanks_thanks,

        dbtech_thanks_thanked

        FROM user

        WHERE userid = 1;



MySQL Error   : Unknown column 'dbtech_thanks_likes' in 'field list'

Error Number  : 1054

Request Date  : Friday, January 21st 2011 @ 01:30:11 AM

Error Date    : Friday, January 21st 2011 @ 01:30:12 AM

Script        : http://www.pijanitvor.com/cron.php?rand=1295569810

Referrer      : http://www.pijanitvor.com/showthread.php?t=8839&p=118840

IP Address    : ***********

Username      : Unregistered

Classname     : vB_Database

MySQL Version :

On DB Tech forum they say that is nothing they can do about this error => "This is a bug in vBExperience's integration with APTL."

Phalynx, could you help please?

Phalynx

01-22-2011 09:51 AM

I'm now back from vacation.

Quote:

Originally Posted by Dirks (Post 2146721)

Edit: Also, our EXP system starts at level 0. Is there anyway to modify the level XML to show that or not? I put in an input for (0,2000,2) but it doesn't seem to do anything.

There is no way for it.

Quote:

Originally Posted by wampforum (Post 2147718)

great mod - i wondered whether theres a possibility of add ons for wikis (via the mediawiki mod and links directory?
also maybe for voting in polls?

You can add some more calculation with the CDP Plugins.

Quote:

Originally Posted by wampforum (Post 2147718)

Also I asked ages ago about the ability to manually assign achievements to users and you were going to implement it - I cant seem to find it or has it not been done yet?

It seems your achievements are outdated. Please try to re-create them via AdminCP, Experience, Manage Achievements, Clear and create default

Quote:

Originally Posted by wampforum (Post 2147718)

I,m having problems with some post achievements - the awards are all set up correctly but the posting awards wont work correctly - for instance I have one award for having between 2500-5000 posts I set 2 conditions one saying Post more than 2499 and the other Posts less than 5000 I then clear achievements and logs and recount - problem is its only assigning this to half the users that have a post count between that number. It does these on the other awards too. I have tried changing all my posting awards conditions over to Points for Posts instead (1 point per post) but this doesnt work either.
Not sure what to do - I have deleted several of these achievements and re-created them - checked the conditions numerous times but its still not working correctly. I wondered if I'm assuming the Posts condition value wrong - I'm assuming Posts means actual posts made and nothing else? (I have 1 point awarded per post anyway so it cant be that!)

cheers

There are "Points for posts" and "Points for posts" - one is the sum of all posting relevant data, the other are the real thread postings.

Quote:

Originally Posted by RichieBoy67 (Post 2148326)

I just want to make sure I am doing this correctly for a client. What is the proper procedure for resetting Vb experience to 0? I would like to reset everything..

Thanks

Never mind--I believe the client wants to count new posts from a certain date... I am all set with the resetting. When you reset this will shjow users current count and not start at zero..I believe this is what the client wants..

Resetting is currently not possible.

Quote:

Originally Posted by segamarius (Post 2148672)

I have some problems .. see picture .... i'm using v4.08

It seems the images are missing. Please re-uplad the /xperience/ folder to the server.

Quote:

Originally Posted by sweetpotato (Post 2148798)

When I decrease points for all factors, user groups did not demote to the groups equal with the points. How can I solve this problem?

Demoting does not work at all, you need to create another promotion and move the user from higher to the lower group.

Phalynx

01-22-2011 10:00 AM

Quote:

Originally Posted by sweetpotato (Post 2148885)

I also find something wrong in this phrase but don't know how to fix it

Code:

<a href="member.php?u={1}">{2}</a> sent {3} {4} points to <a href="{5}">{6}</a>

Anyone please instruct me?
Thank you,

What's wrong with that phrase?

Quote:

Originally Posted by dearone (Post 2148953)

hello everyone where should i put plugin folder

Please click "Mark as Installed" to get further support.
You can install the XML files if you are having the products installed, to gather points from them.

Quote:

Originally Posted by robhole (Post 2149137)

Without needing to read all previous 115 pages... is this mod really worth installing? I'm debating on it but 1/4 posts I read people are having issues??

This is a major addition with much features. Most issues are related to users environment or installation errors like files that have not been transfered to server. Other "issues" are improvement requests.
At least this is a support thread where you get answers. And the installation count is speaking also a language....

Quote:

Originally Posted by DevinM (Post 2149674)

How does the vbookieplugin work? What I mean is when I set an achievement up and use "vbookie Bets" as my condition, what is it counting? Just my point value per bet?

It's counting won bets.

Quote:

Originally Posted by DevinM (Post 2149674)

I seem to have 4-5 users that almost no matter what I set it to they keep the achievement. Ive done reconts, re-installs, deleted/re-added the achievment.....all the same.

You must set it and take it away from all users.

Quote:

Originally Posted by DevinM (Post 2150083)

Nevermind this hack isnt counting right for pretty much anything. I added an achievment for days since registration (5 years).....4 users won it......which is odd since our forums wont be 5 years old til march. I tried using days and points as the calculation.

At closer glance there are many calculation errors so I just shut it off. Im going to have a coder look at my install.

Are you sure you set the required points for 5 years?!?

Q: My conditions don't work correctly on achievements and promotions.
A: Conditions in achievements and promotions are calculated in POINTS, not in count of items.
If you create an achievement for reaching the first 10 Days, you must enter the points needed for this. If you reward 2 points for every day, you have to set 2 points for every day since registering. Calculation: 10 days * 2 points = 20 as condition. So you will have to set 20 as the condition.

Phalynx

01-22-2011 10:04 AM

Quote:

Originally Posted by jamshed (Post 2150371)

"points required for next level: 0"

stays at 0.. i did create new thread, post etc.. but it doesn't level up :/ .

It does not recount immediatly, it does it only every 10 minutes. There is a cron running.

Quote:

Originally Posted by RK KINGKONG (Post 2150773)

can someone tell me , the plug in xml files in this zip , do i reinstall these even if i have some already and do i choose overwrite or not .??.. so for instance i have some of these mods , i want them to work with this mod ofcourse , do i upload the corresponding xml files to the mods i already have and re upload them & CHOOSE OVERWRITE OR JUST UPLOAD ?

The plugins are required to connect a MOD with vBExperience. It is not the mod itself. You should overwrite an existing.

Quote:

Originally Posted by horussjr (Post 2151629)

huge error from the database when tring to install...

cant post you all the message. it has 1 mill characters:)). need help please. what is the problem. i think is related to language but can figure out what

Increase the max_allowed_packet, search for it here at the forums, you are not the single one having this issue. It's only related to vBExperience.

Quote:

Originally Posted by Sunka (Post 2152172)

Database error every 10 minutes.

HTML Code:

Database error in vBulletin 4.1.0:



Invalid SQL:

SELECT 

        dbtech_thanks_likes,

        dbtech_thanks_liked,

        dbtech_thanks_thanks,

        dbtech_thanks_thanked

        FROM user

        WHERE userid = 1;



MySQL Error   : Unknown column 'dbtech_thanks_likes' in 'field list'

Error Number  : 1054

Request Date  : Friday, January 21st 2011 @ 01:30:11 AM

Error Date    : Friday, January 21st 2011 @ 01:30:12 AM

Script        : http://www.pijanitvor.com/cron.php?rand=1295569810

Referrer      : http://www.pijanitvor.com/showthread.php?t=8839&p=118840

IP Address    : ***********

Username      : Unregistered

Classname     : vB_Database

MySQL Version :

On DB Tech forum they say that is nothing they can do about this error => "This is a bug in vBExperience's integration with APTL."

Phalynx, could you help please?

It seems there is a new version of the DBTech Thanks/Like and a changed column definition, will take a closer look later.

sweetpotato

01-22-2011 01:46 PM

Quote:

What's wrong with that phrase?

I have fixed the problem successfully
The phrase:
<a href="member.php?u={1}">{2}</a> sent {3} {4} points to <a href="{5}">{6}</a>
should be:
<a href="member.php?u={1}">{2}</a> sent {3} {4} points to <a href="member.php?u={5}">{6}</a>

Phalynx

01-22-2011 03:54 PM

Quote:

Originally Posted by sweetpotato (Post 2152912)

You are right, didn't saw this. Thanks for pointing me to it. Fixed in next version.

Sunka

01-22-2011 11:51 PM

Phalynx, how to give some points to some usergroup?
Let say that I want to give 100 points to all users in VIP group, is that possible?
If not, could you set this in ACP in new version of this MOD, so then we could give bonus points to members of some group.

Untill then, could you tell me "Run SQL query" for that?
Another question, I can't put graphic bars in middle of my postbit (horizontal, not legacy), even if I use mannualy code in template, allways bars are broken. It is pity, because middle of postbit on my forum is empty....
And for the end, thank you for looking to fix database error DB Tech Thanks mod <==> vBExperience mod

MAdotcom

01-23-2011 12:08 AM

Crotan

01-23-2011 10:04 PM

For Plugins, does anything more have to be done after they are imported?

Also what are the vBExperience\extras\Levels xml files? Do I have to import them to get the additional levels to work?

Also seems to be a formatting issue with the featured window, the best group text covered the group photo.
https://vborg.vbsupport.ru/external/2011/01/9.png

From what I've seen so far this is pretty damn good! Thanks

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

Page 175 of 270

175

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03409 seconds Memory Usage 1,806KB 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 (1)bbcode_code_printable (2)bbcode_html_printable (20)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
Messages: