News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Voter Visibility

Started by Ray Cardillo, May 02, 2012, 12:25:01 PM

Previous topic - Next topic

SMiFFER

Oh, yes, that may actually be.

It is a very old theme that I like sooo very much: DarkModern by Crip
I doubt there are any updates to his themes anymore... for obvious reasons. He was a great guy!
Quote of the day: A troll is an obstinate bloke who only hungers for your attention. If you feed him, he will puke all over you!

lemur21

Question:

At one time, you were able to sort the votes by any number of columns (example: I could sort by the poll choice results or by the voter).

Now, it appears that's no longer available. I'm presuming that is/was a function of this mod; but, somewhere in the upgrades that simple functionality went missing?

KittyGalore

When you go to download it says Database error. Please contact the administrator.

https://custom.simplemachines.org/index.php?action=download;mod=3373;attach=245311
SMF Curve 2.0x

Shades.

Quote from: KittyGalore on October 18, 2021, 10:51:21 AMWhen you go to download it says Database error. Please contact the administrator.

https://custom.simplemachines.org/index.php?action=download;mod=3373;attach=245311
Hmm...I just tried it and it worked for me! ???
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

KittyGalore

Quote from: Shades. on October 18, 2021, 10:58:24 AM
Quote from: KittyGalore on October 18, 2021, 10:51:21 AMWhen you go to download it says Database error. Please contact the administrator.

https://custom.simplemachines.org/index.php?action=download;mod=3373;attach=245311
Hmm...I just tried it and it worked for me! ???
I have tried other browsers and it works but doesn't for Chrome.
SMF Curve 2.0x

Shades.

Ok hmm wierd! I just tried it in FF, Opera, Chrome & Edge and the download worked for all of those browsers. May have to clear out your cookies or update your browser maybe? Maybe somebody will chime in here in a minute that knows how to help! ;)
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

FrizzleFried

...any way this mod could be updated for 2.1.1?  I doubt the original author will be doing it though since his last post was from 5 years ago.


Like many features that we got used to in the 2.0.x version of our forum (thanks to mods!),  this functionality we find we miss (at least the ability to see who voted).

FrizzleFried

Checking back...  Even my management team is lamenting the lack of ability to see who voted or to make comments...

@rjen

Mod author last posted here in August 2017. I would not hold my breath waiting for an update...
Running SMF 2.1 with latest TinyPortal at www.fjr-club.nl

FrizzleFried

Hoping someone else would perhaps mimic/improve on the mod for 2.1.1... it's quite a nice addition for forums who use the poll option often.

bsmither

Here is an attempt to modify this package to work on SMF2.1.1.

I have not extensively tested it, as I have no experience with how this package is supposed to work.

Those who had/have this package on SMF20x, please try this adaptation for SMF211.

(Make a backup of your site, of course.)

FrizzleFried

#111
OK... first off... AWESOME!  Thank you for attempting this!

I followed the instructions...

The GOOD:

Everything about setting the poll up with the additional options appears to be there.

You can select whether to require a comment or allow a comment, etc.  All good.


The BAD:

When the poll displays... it displays as stock... there should be a VIEW VOTES button that allows you to see the additional fields (comment and who voted) etc... from my recollection.


FrizzleFried

OK I did notice that I failed to delete the .js file from the package.  So I did.  I then uninstalled the prior package... deleted... then attempted to install the updated package with the .js file removed.

I got this error:

Database Error
Invalid default value for 'timestamp'
File: /home/ahaforum/public_html/testsite/Packages/temp/database.php
Line: 44

bsmither

You made mention of the "VIEW VOTES button" issue in post #6. I can try to troubleshoot (from the original package) why you don't have permission to see this button.

The package file 'database.php' is unchanged (from the original package).

Please examine your database directly, at the table log_polls, and determine the schema details for the column 'timestamp'.

FrizzleFried

It seems that table is the COMMENTS table that is generated when you add a comment...

It includes the two comments I made.

You cannot view this attachment.

As you can see... timestamp is just a series of numbers. 

bsmither

There is a change between SMF20 and SMF21 in how a package's 'database.php' file gets parsed.

One change I discovered is in the $column parameter array. Of particular note, the parameter 'null' is no longer recognized. It must now be
'not_null' => true-like, // the database engine defaults NULL
I'll work on the package adaptation, but you may want to compare your database schema with the column parameters in the package file 'database.php'.

FrizzleFried

I'm none-too-skilled at this stuff.  Just enough to get myself in to trouble.

This is a test site.  It may be simpler to just re-install.

:)

FrizzleFried

Something to keep in mind however is that my site was updated from 2.0.x where I had this mod installed.  That means that the current database that I am running has tables for this mod already established ...

...as to whether or not that is going to be a problem,  I have no idea.  I just figured I better put it out there.

:)

bsmither

#118
Here is a slightly changed adaptation. (Cannot edit my previous post to detach the file.)

Having these columns already present -- I see no worries as the SMF code handles that scenario.

FrizzleFried

Will I need to re-install SMF to test or will these changes allow me to install with the current database?

FWIW I won't be able to test for a couple hours regardless as dinner is coming up and I we have a guest coming over.

Based on your response when I return I'll either make the necessary changes and install or remove the current SMF test site I have and install a new one THEN install the new version of the mod.

:)

Thank you again for tackling this...

Advertisement: