vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Members Choice voting hack - V2 with usergroup permissions (https://vborg.vbsupport.ru/showthread.php?t=74183)

osariase 05-31-2005 12:55 AM

Hi all,
I am getting this error message when installing this hack is anybody out there that can help me correct this? you will find attached picture of the error message below thanks for your help

Marco van Herwaarden 05-31-2005 12:31 PM

@osariase

This hack is conflicting with another hack you already have installed. They try both to use the same phrasetypeid.

osariase 05-31-2005 05:51 PM

Thanks Marco for your response and help,
so what do I do and how do i know which hack is conflicting with it and how do I rectify this please help thanks. Since you are the only one that is answering

osariase 06-01-2005 03:16 AM

Hi MR-2ZZ ,
thanks for your support. I just wanted you to know that I followed the instructions u gave and for the first time I didnt get any error message during the install. but I do have a problem after the install when i go to nominate a member I get an error message, attached is a picture of what I get hope you can help me with solving this problem thanks man


Quote:

Originally Posted by MR-2ZZ
Follow the install guide I posted a page or two back, and it will solve everything.


Marco van Herwaarden 06-01-2005 07:27 AM

You could try to find out which other hack is conflicting by running the following query:
[sql]SELECT * from nwvb3phrasetype where phrasetypeid = 887;[/sql]

osariase 06-01-2005 02:11 PM

Thanks Marco,
I did what u said and it only showed me the members_choice. But I am not even getting that error message anymore, what I have now is restriction error message when go to nominate a member what do you think might be the issue here? look above this reply, I have a picture of the error message

See what you can do for me thanks man I appreciate your help

Marco van Herwaarden 06-01-2005 02:51 PM

Sorry but i really don't know what can be causing this. I don't have this hack installed, so i can't test.

osariase 06-01-2005 09:10 PM

Thanks for your help marcoH
I happened check usergroup permissions and I found that you have to give group permission to be able to vote or nominate even admin. so I did it and guess what it worked right now i'm testing it so far so good. Also, thanks to
MR-2ZZ he his edited work helped too thanks man

bgtking 06-05-2005 02:57 PM

I'm getting this error when installing:
Code:

Database error in vBulletin 3.0.7:

Invalid SQL: ALTER TABLE " . TABLE_PREFIX . "usergroup
                                ADD mcpollingbooth INT( 12 ) NOT NULL
)
mysql error: You have an error in your SQL syntax near '" . TABLE_PREFIX . "usergroup
                                ADD mcpollingbooth INT( 12 ) NOT NULL
)' at line 1

mysql error number: 1064


liaison 06-15-2005 09:21 PM

hay guys, has anyone installed this one on vb 3.0.7 ? and if they have is there any errors i am to watch out for.... looks like the perfect hack for my site :)

tomshawk 06-16-2005 09:16 PM

Quote:

Originally Posted by bgtking
I'm getting this error when installing:
Code:

Database error in vBulletin 3.0.7:

Invalid SQL: ALTER TABLE " . TABLE_PREFIX . "usergroup
                                ADD mcpollingbooth INT( 12 ) NOT NULL
)
mysql error: You have an error in your SQL syntax near '" . TABLE_PREFIX . "usergroup
                                ADD mcpollingbooth INT( 12 ) NOT NULL
)' at line 1

mysql error number: 1064


I got the same problem.

Seems something got changed in 3.0.7, What, Thats another question :(

I tryed the manual install pointed out here and it didn't work either

tomshawk 06-18-2005 12:33 PM

Is there no support for this hack anymore?

Just asking, I realize you may be busy.

Marco van Herwaarden 06-18-2005 09:53 PM

In your './install/hacks/Members Choice/2/queries.php' file, find:
PHP Code:

$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 

Replace :
PHP Code:

$query['new'][] = 'ALTER TABLE ' TABLE_PREFIX 'usergroup 


tomshawk 06-19-2005 01:04 AM

Quote:

Originally Posted by MarcoH64
In your './install/hacks/Members Choice/2/queries.php' file, find:
PHP Code:

$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 

Replace :
PHP Code:

$query['new'][] = 'ALTER TABLE ' TABLE_PREFIX 'usergroup 


Thank you

Now I get this

Invalid SQL: ALTER TABLE language ADD `phrasegroup_members_choice` MEDIUMTEXT NOT NULL
mysql error: Duplicate column name 'phrasegroup_members_choice'

mysql error number: 1060

Warning: halt(./includes/functions_log_error.php): failed to open stream: No such file or directory in /home/techunit/public_html/forums/includes/db_mysql.php on line 387

Warning: halt(): Failed opening './includes/functions_log_error.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/techunit/public_html/forums/includes/db_mysql.php on line 387

Thoughts?

Marco van Herwaarden 06-19-2005 06:26 AM

This is probably because some of the queries already have run. Sorry i don't have time today to have a look how to fix this. If nobody else helps you today, i will try to have a look tomorrow.

tomshawk 06-19-2005 02:43 PM

Quote:

Originally Posted by MarcoH64
This is probably because some of the queries already have run. Sorry i don't have time today to have a look how to fix this. If nobody else helps you today, i will try to have a look tomorrow.

But I went through the uninstall so I couls start over with your changes and it did not uninstall

Hopefully I'll hear from you tomorrow, Thank you ;)

Marco van Herwaarden 06-19-2005 09:37 PM

Please send me a PM about this or i will forget.

Marco van Herwaarden 06-21-2005 08:50 AM

Ok, run the following queries, ignoring any errors you might get to really uninstall all database changes. Then install again, using the modified queries.php. If you are using a table_prefix, you should manually add this in front of all table names.

[sql]ALTER TABLE language DROP COLUMN phrasegroup_members_choice;
DELETE FROM phrasetype WHERE phrasetypeid = 887 AND fieldname = 'members_choice';
DROP TABLE mc_nominee;
DROP TABLE mc_pollbooth;
DROP TABLE mc_whovoted;
ALTER TABLE usergroup DROP COLUMN mcpollingbooth;
DELETE FROM setting WHERE grouptitle = 'mc_polling';
[/sql]
That should do the trick i think.

tomshawk 06-21-2005 08:27 PM

Thank you for the assistance MarcoH64

This let me attempt to reinstall again, but I got the same error

Code:

Database error in vBulletin 3.0.7:

Invalid SQL: ALTER TABLE " . TABLE_PREFIX . "usergroup
                                ADD mcpollingbooth INT( 12 ) NOT NULL
)
mysql error: You have an error in your SQL syntax near '" . TABLE_PREFIX . "usergroup
                                ADD mcpollingbooth INT( 12 ) NOT NULL
)' at line 1

mysql error number: 1064


Marco van Herwaarden 06-22-2005 04:06 AM

Then you have used the original queries.php, and not the modified one (the first fix i gave you). Like i posted you should run the modified one, or you will have the same problems again.

tomshawk 06-22-2005 05:02 AM

Quote:

Originally Posted by MarcoH64
Then you have used the original queries.php, and not the modified one (the first fix i gave you). Like i posted you should run the modified one, or you will have the same problems again.

It's not the original queries.php, but for giggles I re-uploaded it to try again.

Same thing again

I dunno, maybe I should just give up on this one

Marco van Herwaarden 06-22-2005 05:13 AM

I am sorry, but you are getting the error again that we fixed in post #293, so it seems you are trying without that fix.

tomshawk 06-22-2005 05:29 AM

Quote:

Originally Posted by MarcoH64
I am sorry, but you are getting the error again that we fixed in post #293, so it seems you are trying without that fix.

Got me, but I just did a quick search and found this

https://vborg.vbsupport.ru/showpost....&postcount=217

This worked, dont know why I missed it last time.

Anyway, it works now. http://www.tech-unity.com/forums/mc_pollbooth.php

Thank you for the assistance and dealing with me MarcoH

Marco van Herwaarden 06-22-2005 05:52 AM

No problem, glad you got it fixed.

mcyates 07-15-2005 06:57 PM

What is the code i should put in my postbit to make people able to nominate other members from within their posts.

Thanks in advance.

Kihon Kata 07-18-2005 03:00 AM

Hello PEEPS,

Question, how can I keep my moderators or super mods from being nominated? :tired:

Thanks in advance

mayzan 07-22-2005 01:11 PM

trafix, all your scripts (Hack Installer System) will not run on VBulletin 3.0.7.

When I try to run the hack_installer.php file, the warning is always:

Warning: chdir(): No such file or directory (errno 2) in /home/guitars/public_html/forum/install/his_files/hack_install_b3.php on line 30

Warning: main(./global.php): failed to open stream: No such file or directory in /home/guitars/public_html/forum/install/his_files/hack_install_b3.php on line 31

Fatal error: main(): Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/guitars/public_html/forum/install/his_files/hack_install_b3.php on line 31

Marco van Herwaarden 07-22-2005 01:31 PM

You will probably not only have problems with hacks by trafix then, but with all HIS hacks. Did you rename your admincp directory by any chance? If yes, have a look at the ./install/his_files/hack_config_default.php

mayzan 07-22-2005 03:06 PM

Oh.. how stupid I was :p ok, I will try it now..... thanks Marco!!

Marco van Herwaarden 07-22-2005 03:15 PM

Once you have renamed that config file, and edited it, you can just leave it there. If you later install another HIS hack, it will not overwrite the renamed config file, so you only need to make this edit once.

Qwest 07-27-2005 08:20 PM

I dont understand the manual install........... https://vborg.vbsupport.ru/showthread.php?t=76050

The thread you point to has install for vb_jukebox not the members choice hack. I dont want to use HIS so how do you install it manually?

esology 08-24-2005 12:13 AM

Quote:

Originally Posted by TonysDesigns
Hello PEEPS,

Question, how can I keep my moderators or super mods from being nominated? :tired:

Thanks in advance

I really like this hack. I too want to know how to prevent Moderators from being nominated. I see Admins can be excluded but what about Mods?

esology 08-24-2005 12:53 PM

Quote:

if ($vboptions[mc_can_nom_admin] == "0")
{

if ($member[usergroupid] == "6")
{
eval(print_standard_error('mc_nominate_admin'));
}

}
In the mc_nominate.php file I see this line of code. Can I just add usergroup 7 to the 3rd line like this

Quote:

if ($member[usergroupid] == "6,7")
to also exclude the Moderators.

TRR 08-25-2005 08:33 PM

This is a great hack.

I saw the question asked a few times before the last release, however nothing was ever done about it: this hack could be greatly improved if there were a spot to fill in the date that voting would begin, rather than trying to fill in "X" amount of nominees. That way, for instance: nominations could start at say, the beginning of the month, candidates could make their speeches, and voting wouldn't begin until a specified date towards the end of the month (and this wouldn't matter how many candidates there were... voting would be allowed once the specified date arrived)

I never know how many nominees I am going to have, so right off the bat users are able to start voting because of the settings I have chosen. Then, a better candidate comes along later in the month...

Kihon Kata 09-15-2005 02:44 PM

Is Trafix NOT supporting this anymore? He hasn't been on vb.org since June 6th! WTF. :( Anyhow, I wanna the ability to PM instead of the emailing...

hbalagh1 09-26-2005 11:12 PM

Quote:

Originally Posted by tomshawk
Got me, but I just did a quick search and found this

https://vborg.vbsupport.ru/showpost....&postcount=217

This worked, dont know why I missed it last time.

Anyway, it works now. http://www.tech-unity.com/forums/mc_pollbooth.php

Thank you for the assistance and dealing with me MarcoH

I had the same exact problem tomshawk, but after reading all the post between you and MarchoH, was able to get it going doing :)

Hades-1 10-10-2005 09:10 PM

ok i need help, this hack was not working for me so i fully uninstalled it, but when on my WOL page it still says people are looking at 'unknown location' mc_nominate.php

why?

Hades-1 10-12-2005 02:43 PM

$10 to anyone who installs this hack for me

Hades-1 10-13-2005 12:08 AM

its pretty much my database that doesnt work, how i can i manuall install all the databases?

SaltedSlug 10-31-2005 02:43 PM

Nice hack. How might I make it so that only one usergroup can be nominated? For the others it would say "sorry, this user is not eligible for this poll" or something, if you tried to nominate them.


All times are GMT. The time now is 06:05 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.01510 seconds
  • Memory Usage 1,836KB
  • 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
  • (3)bbcode_code_printable
  • (4)bbcode_php_printable
  • (10)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