Previous Thread
Next Thread
Print Thread
Hop To
Anonymous
Unregistered
Anonymous
Unregistered
Rick,
This is Raven, Tom Light's server admin (I've spoken with you before via email).
Our subscriptions.pl form (we're now using the php version) is driving me nuts.

When started manually, the script doesn't seem to stop running. I finally killed it this morning after running for 115 minutes.

I went into subscriptions.pl and added a line so that it would echo sent emails to the screen.
At the very end of the script just before the closing brackets, my code now looks like so:
$mailer -> send( {to => $to, from => (etc etc)
print "subscription sent to $to.\n";
}

When running it manually after adding this line, it successfully printed each email address to the screen. After a few moments, I noticed that it was looping among the first 20 or so users and only sending email to them - over and over.
I had to kill it.

Do you have ANY clue? I don't believe it's the database; as we sucessfully imported from an old infopop board and have had many more subscribers sign up since then. I've updated the database as per the upgrade php scripts included with the latest version.

One note - some of our users have apostrophes in their usernames. While our board is set to allow special characters, the apostrophes seem to throw everything out of whack. It looks like some stripslashes coding is in order - the user shows up as \'88 or Grinnin\' Fool, for example, when shown in the user list or on posts.
Since that's a php issue and not a perl issue, it is probably not related; but who knows - since we're blending the php script with a cgi subscriptions script I thought it might be relevant.

Raven

Phog.net: Where the Jayhawks Hold Court!

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Hmm, can you run the following mysql command and then email me the results:

mysqldump databasename w3t_Subscribe > subscriptions.dump

I'm not real sure about the \' problem. That shouldn't cause any problems with the email's being sent out. How big is your users database? If it's not too large can you do the same as with your subsciptions and mail me the results:

mysqldump databasename w3t_Users > users.dump

-------------------
Rick Baker
UBBThreads developer


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Another error
by Baldeagle - 10/07/2024 9:08 PM
Is this a cookie issue?
by Baldeagle - 10/05/2024 2:01 PM
Search button not there
by ehill - 10/02/2024 2:56 PM
Change the Order of the buttons in a post
by Unixspot - 09/19/2024 10:04 PM
How do I get rid of this?
by Baldeagle - 09/12/2024 6:30 PM
Who's Online Now
1 members (1 invisible), 765 guests, and 64 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)