vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Profile Enhancements - e-steki Karma version 2.2 (https://vborg.vbsupport.ru/showthread.php?t=154264)

Lea Verou 08-06-2007 05:18 AM

Quote:

Originally Posted by nosherwan9 (Post 1310363)
Hello,
I am trying to uninstall but cant , getting this error now .

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE user DROP karmatotal;

MySQL Error : Can't DROP 'karmatotal'; check that column/key exists
Error Number : 1091
Date : Sunday, August 5th 2007 @ 10:15:29 AM
Script : http://www.domine.com/Forums/admincp...do=productkill
Referrer : http://www.domine.com/Forums/admincp...=userrating&s=
IP Address : xyz
Username : user
Classname : vb_database


Please helo.
How can uninstall ??
Thanks

Was it the first time that you tried to uninstall that you got that error?

Lea Verou 08-06-2007 05:25 AM

Added "is in beta stage" till the issues get resolved :(
And they WILL be resolved, this is a promise.

TheBlackPoet 08-06-2007 05:47 AM

a woman on a mission... gotta love it!!

0tolerance 08-06-2007 06:00 AM

I will install this on my Dev board and tell you of any errors i run into along the way, i think this is a massively awesome asset.. it will keep my users from ranting at each other on the forum and making each other look like fools

Lea Verou 08-06-2007 07:21 AM

These problems were caused because I was working on a backup of my actual board, so it had over 2000 members, a lot banned etc. I hadn't tested on a smaller board, and that's what caused most problems, for instance I hadn't taken into account that there might be no banned users, I took for granted that some existed.
lasto provided me access to his test forum, so I performed some tests and changes to my code and the issues seem to be resolved. I'm now going to cache some templates I had forgotten to cache, transfer the plugin changes to my product and then I will update the zip on the first post :)

You will be informed when the zip is updated with a new post. :)

Lea Verou 08-06-2007 08:26 AM

Zip updated.
Please tell me if it works so that I can send an update email. :)

[high]* Lea Verou prays it works (atheists are not supposed to pray, so you can understand how much anxiety I have atm :p)[/high]

cynthetiq 08-06-2007 09:31 AM

thanks for the update. I just installed it.

I don't get that error that everyone else has any longer, but now get this one:
Code:

Warning: implode() [function.implode]: Bad arguments. in /member.php(838) : eval()'d code on line 201
Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT karma FROM vb_user WHERE (userid=1 OR userid=1) AND karma=1 AND userid NOT IN () AND usergroupid NOT IN (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 ') AND usergroupid NOT IN (0)' at line 1
Error Number : 1064
Date        : Monday, August 6th 2007 @ 03:25:31 AM
Script      : http://myforum.com/forum/member.php?u=1
Referrer    :
IP Address  :
Username    : Iorek
Classname    : vB_Database


Lea Verou 08-06-2007 09:34 AM

WTF? I thought I had fixed that! I'll have a look now :S

Lea Verou 08-06-2007 09:45 AM

Try this product file instead... (although I'm not so sure it will be fixed, I found a small thing I missed that could be causing that)
Do you get any errors in karma.php?
Do you have any banned users?
Any karma banned users?
Which are the restricted usergroups? The 0 I saw in the query? Guests are usergroup 1 btw, not 0. ;)

Khalid-B 08-06-2007 10:13 AM

Quote:

Originally Posted by Michelle (Post 1310887)
Was it the first time that you tried to uninstall that you got that error?


Hello,
Yes this is first time iam uninstalling but cannt.
I installed but its not work got DB error as i told you before so decided to uninstall ang again DB error as i told you .
Please help me thanks

Lea Verou 08-06-2007 10:18 AM

Quote:

Originally Posted by nosherwan9 (Post 1311054)
Hello,
Yes this is first time iam uninstalling but cannt.
I installed but its not work got DB error as i told you before so decided to uninstall ang again DB error as i told you .
Please help me thanks

Try to install the current product I uploaded.
Then probably you will be able to uninstall it (if you wish so)
If you still have issues, inform me.

Khalid-B 08-06-2007 10:20 AM

zip is updated so lemme try again, wait
Thanks

Khalid-B 08-06-2007 10:32 AM

hello,
I tried with again but still the same error , if you want i can give u my testid so you can check better.
Thanks

Harley77 08-06-2007 11:08 AM

Is there a way to have a pop-up box that will allow you to rate an individual? The reason I ask is I currently use zoints local and do not use the built-in members profile page. So being able to rate an individual outside the vb member profile page would be awesome.

cynthetiq 08-06-2007 12:13 PM

Quote:

Originally Posted by Michelle (Post 1311041)
Try this product file instead... (although I'm not so sure it will be fixed, I found a small thing I missed that could be causing that)
Do you get any errors in karma.php?
Do you have any banned users?
Any karma banned users?
Which are the restricted usergroups? The 0 I saw in the query? Guests are usergroup 1 btw, not 0. ;)

Acutally that is leftover from the other attempts that you suggested to other people.

I reset it back to:
Quote:

Usergroups that are not permitted to use the Karma system
1,3,4
and will try the new XML

Lea Verou 08-06-2007 12:39 PM

Quote:

Originally Posted by cynthetiq (Post 1311113)
Acutally that is leftover from the other attempts that you suggested to other people.

I reset it back to:

and will try the new XML

I didn't tell them to put the zero there but in the disallowed userids. ;)

Harley77, it would be really easy to put the rating "form" in a popup, but not at all to display the extra info that shows in the profile(last rate date, votes, controversy and whether or not the user viewing it has rated and with what), as that would mean some queries PER POST, which would be too heavy for the server. The average rating is displayed without any extra query, and this is why its "cached" in the user table. But to display the other info, that would need queries.

Lea Verou 08-06-2007 12:44 PM

Quote:

Originally Posted by nosherwan9 (Post 1311063)
hello,
I tried with again but still the same error , if you want i can give u my testid so you can check better.
Thanks

Then go to the product's uninstall code and delete this line, since obviously, it already has been executed:
PHP Code:

$db->query_write("ALTER TABLE " TABLE_PREFIX "user DROP karmatotal"); 

Then uninstall again.
If you get another error, delete the whole version 2.0 uninstall code and try again.

Harley77 08-06-2007 01:04 PM

Quote:

Originally Posted by Michelle (Post 1311134)
Harley77, it would be really easy to put the rating "form" in a popup, but not at all to display the extra info that shows in the profile(last rate date, votes, controversy and whether or not the user viewing it has rated and with what), as that would mean some queries PER POST, which would be too heavy for the server. The average rating is displayed without any extra query, and this is why its "cached" in the user table. But to display the other info, that would need queries.

Well, for the detailed information, It could be on a seperate page. Just for example, "www.mywebsite.com/forums/karma.php?userid=123". This would keep any extra queries contained to a separate page. I know this may be beyond the scope of what your idea/goal of this mod is, but It's worth considering I think to make it a bit more flexible for a variety of situations.

Lea Verou 08-06-2007 01:08 PM

Quote:

Originally Posted by Harley77 (Post 1311150)
Well, for the detailed information, It could be on a seperate page. Just for example, "www.mywebsite.com/forums/karma.php?userid=123". This would keep any extra queries contained to a separate page. I know this may be beyond the scope of what your idea/goal of this mod is, but It's worth considering I think to make it a bit more flexible for a variety of situations.

A separate page is too much for so little information. A popup pehaps, now that I think of it, would be a nice idea :)
However you will have to make this, as its too much work (not hard, just too much) for something I don't need (I'm planning to add a popup menu rating in the postbit for the next version however).

cynthetiq 08-06-2007 01:43 PM

I just realized that I don't see the karma icon on my postbit. I only have one account on the system right now, just the admin.

Lea Verou 08-06-2007 09:34 PM

Quote:

Originally Posted by cynthetiq (Post 1311167)
I just realized that I don't see the karma icon on my postbit. I only have one account on the system right now, just the admin.

There is no icon on the postbit, just "Karma: " (which links to the user's profile at the place where the karma table is) and the user's karma.

cynthetiq 08-06-2007 10:25 PM

Quote:

Originally Posted by Michelle (Post 1311457)
There is no icon on the postbit, just "Karma: " (which links to the user's profile at the place where the karma table is) and the user's karma.

Okay. I don't see that either. Did I miss a step with the installation and need to edit the postbit template?

The only template edit I did was for MEMBERINFO

Lea Verou 08-06-2007 10:32 PM

No, it doesn't need an edit, its done via template hooks. I chose not to do the same with MEMBERINFO to give the admin more freedom in the placement of the karma table.
Ensure that:
1. You have the "Show karma on postbit" option set to yes
2. You have vbulletin 3.6.8 (otherwise you will need to manually add the hook, I'm not sure it exists on older versions)
3. The user that you are looking at his postbit is not banned or otherwise restricted from the karma and has it set to on.
4. Your postbit template has all the new hooks added (if you are manually changing it on each update then probably you don't have the hooks, as Jelsoft never gives that extensive template upgrading info)

Btw is everything else working ok?

cynthetiq 08-06-2007 10:42 PM

Yes. I made a test account, and cannot see the karma in the postbit at all.

1. Yes.

2. yes.

3. yes.

btw, everything else seems to be fine.

Lea Verou 08-06-2007 10:45 PM

Quote:

Originally Posted by cynthetiq (Post 1311496)
Yes. I made a test account, and cannot see the karma in the postbit at all.

1. Yes.

2. yes.

3. yes.

btw, everything else seems to be fine.

What about 4? I edited my post.

Lea Verou 08-06-2007 10:45 PM

To cut a long story short, ensure that you have $template_hook[postbit_userinfo_right_after_posts] in the postbit template that you use.

RTFA 08-06-2007 11:11 PM

Looks like a really nice hack. Looks like a lot of DB problems now though, waiting for a few good installs. :erm:

Lea Verou 08-06-2007 11:47 PM

Quote:

Originally Posted by RTFA (Post 1311514)
Looks like a really nice hack. Looks like a lot of DB problems now though, waiting for a few good installs. :erm:

You can help out on that by installing it on your test board and give me feedback on what happened ;)

Lea Verou 08-07-2007 12:24 AM

cynthetiq what happened with your issue?

cynthetiq 08-07-2007 01:48 AM

sorry went out for dinner :)

i'm trying to add "$template_hook[postbit_userinfo_right_after_posts]" into postbit and postbit legacy.

Lea Verou 08-07-2007 01:51 AM

Only add it if its not already present.
Take a look at the original vb3.6.8 postbit template and put it where its located there.
You'll perhaps have the same issue with the modifyoptions template, if you have customized it in a previous version.

cynthetiq 08-07-2007 01:55 AM

It existed already in the file in both postbit and postbit legacy.

I just looked and I no longer see the karma check box in the user options. It has disappeared for some reason. Karma settings in vbulletin options is set to yes.

I also checked my MEMBERINFO template and inserted the comment:
Quote:

<!-- / main info - avatar, profilepic etc. -->
<!--end rating-->
I'm not very good at the vbulletin stuff but did lots of manual edits for phpbb. Please bear with me since I'm not 100% up to speed on vbulletin. Thank you for your patience and please also be as detailed as you can in your explanations. thank you.

Lea Verou 08-07-2007 03:41 AM

Version 2.1
------------------
Bugfixes
Cached templates (I had forgotten a lot)
New feature: Option to have a popup menu rating form in the postbit, so that users can rate from there.

Lea Verou 08-07-2007 03:55 AM

Quote:

Originally Posted by Harley77 (Post 1311075)
Is there a way to have a pop-up box that will allow you to rate an individual? The reason I ask is I currently use zoints local and do not use the built-in members profile page. So being able to rate an individual outside the vb member profile page would be awesome.

I think you'll like the update ;)

TheBlackPoet 08-07-2007 04:30 AM

okay... i finally was able to find the damn karma & other error source in my dbase.. they were in the USER table... (for those who dont know....).... i deleted them and ftp'd the files... imported the product and it installed no problem... i was looking for a drop down in my acp, but there was none.. so i went into my options and saw three options... and one in the maintenance area.... but nothing in my front end....... so.... help a brother out michelle!!!!

Lea Verou 08-07-2007 04:33 AM

Quote:

Originally Posted by TheBlackPoet (Post 1311638)
okay... i finally was able to find the damn karma & other error source in my dbase.. they were in the USER table... (for those who dont know....).... i deleted them and ftp'd the files... imported the product and it installed no problem... i was looking for a drop down in my acp, but there was none.. so i went into my options and saw three options... and one in the maintenance area.... but nothing in my front end....... so.... help a brother out michelle!!!!

Btw you could know from the db error you were getting that they were in the user table, lol. I thought you already knew that!
About the frontend: Go to a member's profile (that is not banned, karma banned, restricted, and has the karma set to active (its active by default). You should see the karma table there, with links to other karma pages (if you have performed the template edit for memberinfo). Also, you should notice the karma option added in Edit options and karma in the postbit (for users that are not banned etc).

TheBlackPoet 08-07-2007 04:38 AM

oh!!!!! no..... i see it.... it was there..... in a neat looking drop down!!! oh yeah baby!!! it looks really good....

it tried to rate someone.... and got this error...

Quote:

Sorry, we were unable to process your vote. This might be caused by one of the following reasons:

The appropriate time between rating two different users has not passed yet
You tried to rate yourself.
You tried to rate someone that is banned or has chosen not to participate in the karma system
You tried to rate someone that does not have the permission to participate in the karma system
You have chosen not to participate in the karma system
You are banned
You are not allowed to participate in the karma system

Lea Verou 08-07-2007 04:41 AM

Glad you like the postbit addition :D
Is any of these reasons true?
Have you rated any user before?

TheBlackPoet 08-07-2007 04:45 AM

okay.... i saw the tables in the edit options... in two places... the checkboxes are there... but no text.... i figure i didnt load something right.... do you know which one???

i could click them all but i dont know what im clicking....

Lea Verou 08-07-2007 04:47 AM

CheckboxES? There should be only one!
Also, the text is on phrases, search your phrases, perhaps something's missing there.

Btw I have to go to the super market, so I will be away for 1-2 hours.


All times are GMT. The time now is 10:03 PM.

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.01443 seconds
  • Memory Usage 1,842KB
  • 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
  • (1)bbcode_php_printable
  • (17)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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