vb.org Archive - Countdown Timer for your users

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Countdown Timer for your users (https://vborg.vbsupport.ru/showthread.php?t=107596)

Ok, I need help on manually removing this plugin, my board is down currently. I've never had any problems like this with other plugins or my years of running phpbb forums and manually editting stuff.

Can anyone help me out? before viewthread died completely, I had 7 entries in the usercp for events. I know I haven't tried this 7 times, and I dug around in the templates and don't see multiple entries for anything related to this.

Here is my error:

Database error in vBulletin 3.5.3:

Invalid SQL:
SELECT field FROM vbuserfield WHERE userid='106';;

MySQL Error : Unknown column 'field' in 'field list'
Error Number : 1054
Date : Saturday, February 18th 2006 @ 02:26:28 PM
Script : http://www.x-h2o.com/showthread.php?t=750
Referrer : http://www.x-h2o.com/search.php?searchid=22848

Classname : vb_database

Quote:

Originally Posted by got1-2

Same problem here, if i set event, ans save, it wont show, and go back to edit options...there is no event???

im at a complete loss....

I'm having the same issue on my own live server.
I already tracked it down to some sort of misbehaviour of eval()'d code on some occasions.
I think I have soon at least a workaround for this....

Quote:

Originally Posted by SuperJETT

Uploaded the .php file to /includes/ then added new product with the .xml file and there is nothing anywhere and I've tried 3 different test accounts.

I also tried with uploading /xml/bitfield_hc_countdown.xml and no errors, but no options anywhere for countdown.

Did you edit the usergrouppermissions to allow usage of the timer?

Quote:

Originally Posted by SuperJETT

I've tried 2 different ways so far because the instructions don't mention the /xml/bitfield_hc_countdown.xml so I tried both with and without it.

Upload the contents of the "upload to ...." folder, the subfolder layou tin there is how it's supposed to be uploaded already....

Quote:

Originally Posted by mholtum

Great Idea, but I am a little lost.
I have followed your instructions and installed the mod, then I edited the user group properties.. But if you look at the image, I am not sure what to do.

That's weird :ermm:
Shouldn't look that way. Have to see and find what may cause this....

Quote:

Originally Posted by SuperJETT

Ok, I need help on manually removing this plugin, my board is down currently. I've never had any problems like this with other plugins or my years of running phpbb forums and manually editting stuff.

In the table "settings" delete all entries with "varname" = "countdownfield"
In table "profilefield" delete all entries with "title" = "User Countdown"
In table "userfield" drop all columns added by the countdown
SQL: DELETE FROM plugin WHERE product = 'hc_usercountdown';
In the product table delete the "hc_usercountdown" entry
Delete uploaded files

[EDIT]
OK, I did a few quick test, it seeme vB re-runns the install code even if it's already there. That shouldn't have happened....
That could be the cause for much troubles....

Quote:

Originally Posted by Hellcat

In the table "settings" delete all entries with "varname" = "countdownfield"
In table "profilefield" delete all entries with "title" = "User Countdown"
In table "userfield" drop all columns added by the countdown
SQL: DELETE FROM plugin WHERE product = 'hc_usercountdown';
In the product table delete the "hc_usercountdown" entry
Delete uploaded files

Just did that, showthread.php isn't working currently after removing everything from the db and the files from /includes.

Code:

Warning: Unknown(./includes/plugins_usercountd.php): failed to open stream: No such file or directory in /includes/class_postbit.php(279) : eval()'d code on line 3



Warning: Unknown(./includes/plugins_usercountd.php): failed to open stream: No such file or directory in /includes/class_postbit.php(279) : eval()'d code on line 3



Fatal error: (null)(): Failed opening required './includes/plugins_usercountd.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xh2ocomg/public_html/includes/class_postbit.php(279) : eval()'d code on line 3

After uploading the files again just to see if it works:

Code:

Database error in vBulletin 3.5.3:



Invalid SQL:

SELECT field17 FROM vbuserfield WHERE userid='290';;



MySQL Error  : Unknown column 'field17' in 'field list'

Error Number : 1054

Date         : Sunday, February 19th 2006 @ 03:39:46 AM

Script       : http://www.x-h2o.com/showthread.php?p=12134

Referrer     : http://www.x-h2o.com/index.php?

IP Address   : my ip

Username     : me

Classname    : vb_database

field 17 is gone of course, was one that I deleted from the db. Can you point out the code modifications I need to remove? I'm new to the .xml and can sort of understand it, but not completely.

It's a beautiful day in the neighborhood, a beautiful day for a neighbor....

BTW, I love the idea of this plugin, and will definitely install it once it's sorted completely.

EDIT: since I was down anyway, decided to see if reinstalling would at least get me functional since the database was corrected, and it did, for now. Counters are even working. Can I get verification that the plugin uninstall works properly?

Quote:

Originally Posted by SuperJETT

EDIT: since I was down anyway, decided to see if reinstalling would at least get me functional since the database was corrected, and it did, for now. Counters are even working. Can I get verification that the plugin uninstall works properly?

Weird that it still wanted to access the files when the plugins are deleted....
Did the product / the plugins still show up on the plugin manager?

I just installed, uninstalled and reinstalled it several times on a test installation - didn't encounter any problems :-/

Quote:

Originally Posted by Hellcat

Try installing, reinstall with overwrite, then uninstall and see where you end up. I think that's what got me.

That's the point: NO OVERWRITE
Besides, after unistalling the overwrite is somewhat meaningless, since there is nothing to overwrite.

I think that's what causing the problems. Reinstalling by overwriting the current one (without uninstalling it first), and vB also re-runs the installer code (wich it shouldn't) and that really messes things up.

I will enhance the installer somehow to prevent that!

very nice, I'm sure our users will like this, easy install.

BTW Hellcat, thanks, both for writing this, and for helping me get mine straightened out.

Anyone have this running on a large board? I am curious about performance. It sure does add a lot of queries.

Very nice hack though. :)

X vBulletin 3.8.12 by vBS Debug 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 (8)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01254 seconds Memory Usage 1,756KB 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 (8)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: