vb.org Archive
Page 7 of 23 « First 56 7 8917 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   News & Email Community Bulletin Generator (https://vborg.vbsupport.ru/showthread.php?t=32517)

sccr410 01-29-2002 07:34 PM
How can I edit the register.php file so people can decide to subscribe to a newsletter when they register?

DJ FRESCO 02-11-2002 03:10 PM
What to do now??? Please advise

thanks,

dj fresco

Database error in vBulletin Control Panel: Invalid SQL: SELECT userid,username,birthday FROM user WHERE SUBSTRING(birthday,6)>='02-11' AND SUBSTRING(birthday,6)<='02-25' ORDER BY SUBSTRING(birthday,6) LIMIT 0,10
mysql error: You have an error in your SQL syntax near 'SUBSTRING(birthday,6) LIMIT 0,10' at line 1
mysql error number: 1064
Date: Monday 11th of February 2002 12:08:05 PM
Script: /forum/admin/commbull.php
Referer: http://www.djfresco.com/forum/admin/commbull.php

centris 02-11-2002 04:55 PM
Quote:
Originally posted by sccr410
How can I edit the register.php file so people can decide to subscribe to a newsletter when they register?
If you apply the script hacks "member.php and admin/index.php" and the modifyoptions template addition this option will be included in the member registration area by default and the Admin CP.

DJ FRESCO
Check member.php for script errors if you hacked this script.

DJ FRESCO 02-11-2002 06:40 PM
I made sure to check my hack code everything is okay... This is the error I get now:


Database error in vBulletin Control Panel 2.2.2:

Invalid SQL: SELECT userid,username,birthday FROM user WHERE SUBSTRING(birthday,6)>='02-11' AND SUBSTRING(birthday,6)<='02-25' ORDER BY SUBSTRING(birthday,6) LIMIT 0,10
mysql error: You have an error in your SQL syntax near 'SUBSTRING(birthday,6) LIMIT 0,10' at line 1

mysql error number: 1064

Date: Monday 11th of February 2002 03:28:57 PM
Script: http://www.djfresco.com/forum/forum/admin/commbull.php
Referer: http://www.djfresco.com/forum/admin/commbull.php

slideboxer 02-13-2002 03:32 AM
I keep getting the following databse error whenever I include the birthdays in the bulletin:

Quote:
Database error in vBulletin Control Panel 2.2.2:

Invalid SQL: SELECT * FROM user WHERE SUBSTRING(birthday,6)>='02-13' AND SUBSTRING(birthday,6)<='02-27' ORDER BY SUBSTRING(birthday,6) LIMIT 0,10
mysql error: You have an error in your SQL syntax near 'SUBSTRING(birthday,6) LIMIT 0,10' at line 1

mysql error number: 1064
Works fine and well when I set the birthdays/events stuff to 0, but otherwise I get the error. Ideas?

DJ FRESCO 02-13-2002 10:06 AM
That worked

over 02-13-2002 10:40 AM
seems a good hack :) gonna install it :D

Held der Nacht 02-13-2002 06:22 PM
hello,

i have a small problem.

When a User want get his Mail as text, then he get a E-Mail with a .txt file. How i can change it, that the Text is in the Mail without a .txt file ?

I hope anybody can me help.

Thx.

slideboxer 02-19-2002 03:44 AM
Quote:
Originally posted by slideboxer
I keep getting the following databse error whenever I include the birthdays in the bulletin:

Quote:
Database error in vBulletin Control Panel 2.2.2:

Invalid SQL: SELECT * FROM user WHERE SUBSTRING(birthday,6)>='02-13' AND SUBSTRING(birthday,6)<='02-27' ORDER BY SUBSTRING(birthday,6) LIMIT 0,10
mysql error: You have an error in your SQL syntax near 'SUBSTRING(birthday,6) LIMIT 0,10' at line 1

mysql error number: 1064
Works fine and well when I set the birthdays/events stuff to 0, but otherwise I get the error. Ideas?
*bump*

Also, receiving this error message while executing the mailings:
Quote:
Fatal error: Maximum execution time of 30 seconds exceeded in /home/www/abudokan/forums/admin/commbull.php on line 932
Is this simply from sending too many (300) mails at a time?

christec 02-19-2002 01:06 PM
Quote:
Is this simply from sending too many (300) mails at a time?
Yes


All times are GMT. The time now is 08:07 AM.
Page 7 of 23 « First 56 7 8917 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.01313 seconds
  • Memory Usage 1,739KB
  • 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
  • (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