News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Karma Description Mod

Started by Grek.Kamchatka, September 11, 2005, 11:48:26 PM

Previous topic - Next topic

spaceman

Quote from: Massyboy on October 02, 2006, 10:14:13 AM
Quote from: Grek_Kamchatka on October 02, 2006, 12:02:42 AM
I'm asking for you, have you 'Description' field in your database, but you didn't answer. You haven't this field, so KDM installation was failure. Upload new release and install it again. Advice to upload vanilla source files.

Sorry, the picture was meant to show you what fields I had.  It doesn't have it there and I have again tried to install the new versio but am having the same problem.  Can I add the field manually?

I've the same problem where 'lk.description' column is not found in 'field list' error whenever Viewkarma.php is loaded. And 'Description' column is not found in 'field list' error whenever Karma.php is loaded.

Might be database problem? As I'm sure I got the columns in my MySql by default.


Grek.Kamchatka

Quote from: Massyboy on October 02, 2006, 10:14:13 AM
Sorry, the picture was meant to show you what fields I had.  It doesn't have it there and I have again tried to install the new versio but am having the same problem.  Can I add the field manually?
Open your database in phpMyAdmin and enjoy this query

ALTER TABLE `your_prefix_log_karma`
        ADD `Description` TINYTEXT NOT NULL,
        ADD `link` TEXT NOT NULL

Where 'your_prefix_' is your smf base prefix.

Then this one

ALTER TABLE `your_prefix_log_karma`
        DROP PRIMARY KEY
That's all

Massyboy

#443
Great thanks.  all is working now-brilliant

However when I try to applaud/smite people I now get:

Parse error: parse error, unexpected $ in /home/content/m/a/s/massyboy/html/clan/smf/Sources/Karma.php on line 1893

*Update*

Ok, I've copied over the karma.php file from a new download of smf and replaced the old one (72kb in size) with the new one (only 8kb in size).  Just curious as to why the file sizes are so different.  Hopefully I won't run into any problems

Grek.Kamchatka

Oh man, you use older version of Karma Description Mod.

SleePy

Quote from: Massyboy on October 01, 2006, 11:05:31 PM
Quote from: Grek_Kamchatka on September 30, 2006, 10:43:05 PM

I think you use older version of viewkarma.php file. Please post it here or send me email with it. And look at your database. Have you 'Description' field in _log_karma table.
My database looks like:



Do I need to add something and if so, what/where?

Thanks a lot

In Your Image... Why Does it say

"Your SQL query has been executed successfully

ALTER TABLE `smf_log_karma` DROP `Description`"

To me it looks like you deleted the Description field.. Why?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Grek.Kamchatka

Quote from: SleePy on October 02, 2006, 09:49:02 PM
To me it looks like you deleted the Description field.. Why?
SleePy, Wow, what a beautiful attention.

Massyboy, can you answer?

n1kki6

Quote from: Grek_Kamchatka on October 01, 2006, 05:56:58 PM
Quote from: n1kki6 on October 01, 2006, 02:05:38 PM
Right now it seems it they want to recieve it they need to set it themselves in their preferences
Yep, you are right. By default it is disabled. You can open your database (ie by phpMyAdmin) and set 'karmanotifier' variable by default = 2 in _members table.

That worked, but make it a pop up, should it be a number 3 for a Personal message?

Grek.Kamchatka

Quote from: n1kki6 on October 02, 2006, 11:39:52 PM
That worked, but make it a pop up, should it be a number 3 for a Personal message?
Nope, try = 1

n1kki6

Actually neither worked.  I had mine already site for my profile but logging in as a normal user it didnt do a pop up or pm.  oh well know big deal.

Grek.Kamchatka

Whoops, it's not a _members table. It is a _setting table, i forget it. So it is a dynamical table, and it can't consist default value. You only can edit Profile.template.php lines with Karma Description Mod to set default value = 2

Massyboy

I attempted to add the Description field manually but didn't know what to set it as (ie text, tinytext etc) soI deleted it again as it didn't work.  the field just wasn't created for some reason.  And I have only been using the latest versions of karma description mod so it most certaintly wasn't an old version.  Only been using the version 2 builds.  all seems to be working now though

markd

I dont have the notifications turned on, so it seems that the karmanotifier variable is unset, thus filling my error logs with:

8: Undefined index: karmanotifier
File: /var/www/vhosts/mydomain.com/httpdocs/Sources/Karma.php
Line: 175

the error gets logged whenever someone modifies karma. i dont think this should be done by default if the karma notifications are turned off, so did you miss a global variable assignment somewhere in the code?

other than that, the rest works like a champ!

-mark

Grek.Kamchatka

Quote from: markd on October 04, 2006, 09:08:22 PM
I dont have the notifications turned on, so it seems that the karmanotifier variable is unset, thus filling my error logs with:

8: Undefined index: karmanotifier
File: /var/www/vhosts/mydomain.com/httpdocs/Sources/Karma.php
Line: 175

the error gets logged whenever someone modifies karma. i dont think this should be done by default if the karma notifications are turned off, so did you miss a global variable assignment somewhere in the code?

other than that, the rest works like a champ!

-mark

What version of Karma Description Mod?

rockinaway

I can't seem to execute this command

ALTER TABLE `smf_log_karma`
        DROP PRIMARY KEY


When I try doing any in SMF it says that it failed, so I went manual and this one doesn't work.. I get this error:

#1091 - Can't DROP 'PRIMARY'; check that column/key exists
Have I helped you? Then please join AdminFuel - The forum for forum administrators.

If you need help managing your forum, or maybe launching it, then visit us and view the quality articles, downloads and posts.

Grek.Kamchatka

Quote from: rockinaway on October 07, 2006, 04:57:44 PM
I can't seem to execute this command

ALTER TABLE `smf_log_karma`
        DROP PRIMARY KEY


When I try doing any in SMF it says that it failed, so I went manual and this one doesn't work.. I get this error:

#1091 - Can't DROP 'PRIMARY'; check that column/key exists
I think it's already dropped. #1091 - Can't DROP 'PRIMARY'; check that column/key exists

rockinaway

Well if it gave the error that DB hadn't been done when I was installing.... oh well!
Have I helped you? Then please join AdminFuel - The forum for forum administrators.

If you need help managing your forum, or maybe launching it, then visit us and view the quality articles, downloads and posts.

Grek.Kamchatka

Quote from: rockinaway on October 08, 2006, 05:24:05 AM
Well if it gave the error that DB hadn't been done when I was installing.... oh well!
You recieved this error, because your database already contain Description field and dropped primary key. Read this topic again.

rockinaway

Yes, but it didn't have the last one.

Can you look at this though, it is a bigger problem..

http://www.simplemachines.org/community/index.php?topic=118854.0
Have I helped you? Then please join AdminFuel - The forum for forum administrators.

If you need help managing your forum, or maybe launching it, then visit us and view the quality articles, downloads and posts.

Grek.Kamchatka

Quote from: rockinaway on October 09, 2006, 11:44:58 AM
Yes, but it didn't have the last one.

Can you look at this though, it is a bigger problem..

http://www.simplemachines.org/community/index.php?topic=118854.0
What do you want? I don't understand you. You tried to install or uninstall my mod?

Advertisement: