vb.org Archive - Members Choice voting hack - V2 with usergroup permissions

Page 30 of 37

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)

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.

All times are GMT. The time now is 08:59 AM.

Page 30 of 37

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01239 seconds Memory Usage 1,750KB 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 (4)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)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
Messages: