vb.org Archive - Un-Activated User Management 3

Page 12 of 14

« First

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

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

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

- - Un-Activated User Management 3 (https://vborg.vbsupport.ru/showthread.php?t=99509)

sabret00the

08-05-2006 02:25 PM

what's the error for 3.6?

jluerken

08-05-2006 06:49 PM

Quote:

Originally Posted by sabret00the

what's the error for 3.6?

If I run this with 3.6 everything seems to run normally

RS_Jelle

08-06-2006 10:48 PM

When I run it manually, the first part works good:

Quote:

Un-Activated User Management
Sent 8 Day email to xxx
Sent 8 Day email to xxx

But then, there's the error:

Quote:

Database error in vBulletin 3.6.0:

Invalid SQL:

INSERT INTO useractivation
VALUES
(NULL , 13188, 1154907330, 84391481, 0, 2);

MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Monday, August 7th 2006 @ 01:35:30 AM
Script : http://www.ivanhoejupiler.be/admincp...cron&cronid=24
Referrer : http://www.ivanhoejupiler.be/admincp....php?do=modify
IP Address : xx.xxx.xx.xxx
Username : Jelle
Classname : vb_database

Also check this bug report. So I think there's a missing 0 at the end of the INSERT query for vBulletin 3.6.0 :)

sabret00the

08-06-2006 10:54 PM

Quote:

Originally Posted by RS_Jelle

When I run it manually, the first part works good:

But then, there's the error:

Also check this bug report. So I think there's a missing 0 at the end of the INSERT query for vBulletin 3.6.0 :)

thank you very much, i'll post a 3.6 complient version in the morning.

bongwater

08-17-2006 01:48 PM

the time specified -- is it the administrator's local time specified in the control panel, or is it the time on the host server?

-bongwater

sabret00the

08-20-2006 09:34 PM

Quote:

Originally Posted by sabret00the

thank you very much, i'll post a 3.6 complient version in the morning.

oops totally forgot about this. tomorrow morning for sure. i'll sleep with this page on my monitor.

crxrocks

08-21-2006 11:06 PM

Thanks! This is one of my favorite hacks!

crxrocks

08-21-2006 11:15 PM

Whoops. It looks like I am having a problem. I uploaded the include .php file to the cron directory and imported the new product, overwriting the existing one. Here is the error

Code:

Prune Users Awaiting Confirmation

ActivationID created to xxxxx



Fatal error: Call to a member function on a non-object in /home/thezcres/public_html/forums/includes/cron/manageActivation.php on line 63

The line of code it is references is

Code:

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "post SET username = '" . $db->escape_string($user['username']) . "', userid = 0 WHERE userid = " . $user['userid']);

Any ideas?

I forgot to mention that this is a 3.6 install.

crxrocks

08-21-2006 11:19 PM

Nevermind. There are two copies of these files contained in the distribution a 3.6 version and a 3.6.0 version. I had originally uploaded the 3.6 version so I replaced it w/ the 3.6.0 version and it worked well.

Thanks!

Chris

dtdesign

08-22-2006 11:01 AM

Quote:

Originally Posted by crxrocks

Which is which ?

All times are GMT. The time now is 10:22 AM.

Page 12 of 14

« First

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

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