vb.org Archive - Un-Activated User Management

Page 19 of 21

« First

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)

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

Kaishi

04-22-2005 03:38 PM

marcho your code got me this error, did i copy something wrong?

PHP Code:


		
			
Database error in vBulletin 3.0.7:



Invalid SQL: 

        SELECT username,user.userid,email,joindate,activationid

            FROM useractivation AS useractivation

            LEFT JOIN user AS user ON(user.userid=useractivation.userid)

            WHERE dateline =

                (select MAX(dateline) FROM useractivation AS ua2 WHERE ua2.userid = useractivation.userid)

            AND user.usergroupid=3 AND user.posts = 0    

mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select MAX(dateline) FROM useractivation AS ua2 WHERE ua2.useri



mysql error number: 1064

Marco van Herwaarden

04-22-2005 04:03 PM

What MySQL version are you using?

Kaishi

04-22-2005 04:06 PM

Quote:

Originally Posted by MarcoH64

What MySQL version are you using?

4.0.22-standard

Marco van Herwaarden

04-22-2005 06:41 PM

Hmm not sure, will look if there are any clauses used that where not allowed in 4.0 a litle bit later.

Marco van Herwaarden

04-22-2005 07:51 PM

Just checked this subquery is not allowed in MySQL 4.0. :(

Will have to rewrite it using LEFT JOINs. Will be a tough one. Will try if i can have a look this weekend.

Kaishi

04-23-2005 03:07 AM

Quote:

Originally Posted by MarcoH64

Just checked this subquery is not allowed in MySQL 4.0. :(

Will have to rewrite it using LEFT JOINs. Will be a tough one. Will try if i can have a look this weekend.

i really appreciate it! thanks alot in advance. i love this vb.org community, i couldn't get help with stuff anywhere else for some reason.

Kaishi

04-28-2005 04:39 PM

i hope you guys didn't forget about me :(

Marco van Herwaarden

04-28-2005 07:28 PM

Quote:

Originally Posted by Kaishi

i hope you guys didn't forget about me :(

Actually i did. :(

Is a bit hectic these days and i can't spend as much time as i would like on vB. Will try to find some time to have a look at your problem in the next days i hope.

Kaishi

04-28-2005 07:33 PM

:D ok

Kaishi

05-05-2005 04:24 AM

another problem kinda. sometimes it would send a 3/5/8 day reminder to someone, then the next day it would send the same reminder again. for example, today user x got a 3 day reminder, tomorrow, he gets a 3 day reminder again.

All times are GMT. The time now is 07:39 AM.

Page 19 of 21

« First

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

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