vb.org Archive
Page 22 of 37 « First 122021 22 232432 Last »
Show 40 post(s) from this thread on one page

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)

shadiguy1 02-18-2005 03:36 PM
i keep getting this error when i try and install it right after it says it changed all my stykes and i click done i get thsi error ill post a pic

shadiguy1 02-20-2005 02:25 PM
Bump

MR-2ZZ 02-22-2005 06:58 AM
I too get the same error

Marco van Herwaarden 02-22-2005 07:33 AM
In file install/hacks/Members Choice/2/queries.php change
PHP Code:
$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 
                ADD mcpollingbooth INT( 12 ) NOT NULL
)'; 
into (remove the closing ")"):
PHP Code:
$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 
                ADD mcpollingbooth INT( 12 ) NOT NULL
'; 

MR-2ZZ 02-22-2005 09:26 AM
Great now I cant update any of my usergroups :(

MR-2ZZ 02-22-2005 09:29 AM
Quote:
Originally Posted by MarcoH64
In file install/hacks/Members Choice/2/queries.php change
PHP Code:
$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 
                ADD mcpollingbooth INT( 12 ) NOT NULL
)'; 
into (remove the closing ")"):
PHP Code:
$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 
                ADD mcpollingbooth INT( 12 ) NOT NULL
'; 
same error occured

MR-2ZZ 02-22-2005 06:47 PM
Ok here is what I did, I removed from the queries the first 2 and the last query, and removed all mc_xxx from my db. Install went through, I then manually enterered this:

Code:
ALTER TABLE `usergroup` ADD `mcpollingbooth` INT( 12 ) UNSIGNED NOT NULL ;
and now everything is back working on my site. I can give user group permissions and what not. I added a booth and it went fine, but nothing else seems to work. I am also going to have to figure out why there is no title for the drop down in the admincp.

MR-2ZZ 02-22-2005 09:27 PM
It appears that it is working as normal after I did the above.

shadiguy1 02-23-2005 08:10 PM
trying everything damn thing will not install i keep getting the database error

MR-2ZZ 02-23-2005 08:47 PM
Do This...

* Make necessary changes per Readme
* Go into your DB and drop all mc_ tables
* Find the /Members choice v2/upload/install/hacks/Members Choice/2/quieries.sql, and change it to the below form.

PHP Code:
<?php

$query['new'][] = 'CREATE TABLE '. TABLE_PREFIX .'mc_nominee (
`mc_nomineeid` int(11) unsigned NOT NULL auto_increment,
`boothid` int( 11 ) NOT NULL default \'0\',
`userid` int( 11 ) NOT NULL default \'0\',
`username` varchar( 225 ) default \'0\',
`nominatorid` smallint( 5 ) default \'0\',
`nominatorname` varchar( 50 ) NOT NULL default \'\',
`votes` smallint( 6 ) default \'0\',
`nomreason` mediumtext NOT NULL ,
`acceptspeach` mediumtext NOT NULL ,
`datestamp` int( 10 ) NOT NULL default \'0\',
PRIMARY KEY ( `mc_nomineeid` ) 
) TYPE = MYISAM ;';

$query['new'][] = 'CREATE TABLE '. TABLE_PREFIX .'mc_pollbooth (
  `mc_pollboothid` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default \'\',
  `status` smallint(2) default \'0\',
  `statusreason` varchar(255) NOT NULL default \'\',
  `startdate` int(11) unsigned NOT NULL default \'0\',
  `enddate` int(11) unsigned NOT NULL default \'0\',
  `qty_nominees` smallint(3) default \'0\',
  `qty_votes` int(11) NOT NULL default \'0\',
  PRIMARY KEY  (`mc_pollboothid`))';

$query['new'][] = 'CREATE TABLE '. TABLE_PREFIX .'mc_whovoted (
  `mc_whovotedid` int(11) unsigned NOT NULL auto_increment,
  `boothid` int(11) NOT NULL default \'0\',
  `nomuserid` int(11) default \'0\',
  `nomusername` varchar(255) NOT NULL default \'\',
  `voteruserid` int(11) default \'0\',
  `votername` varchar(255) NOT NULL default \'\',
  `votereason` mediumtext NOT NULL,
  `votedate` int(10) unsigned NOT NULL default \'0\',
  PRIMARY KEY  (`mc_whovotedid`)
)';

?>
* Re-Run the Install script.
* Manuall enter this code into your DB

Code:
ALTER TABLE `usergroup` ADD `mcpollingbooth` INT( 12 ) UNSIGNED NOT NULL ;
* Next goto AdminCP, goto Languages and Phrases, select any phrase (edit) and save without changing anything.

* That should work now


All times are GMT. The time now is 11:29 PM.
Page 22 of 37 « First 122021 22 232432 Last »
Show 40 post(s) from this thread on one page

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.01318 seconds
  • Memory Usage 1,754KB
  • 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
  • (2)bbcode_code_printable
  • (5)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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