PDA

View Full Version : Getting EZ Newsletter setup...

Pages : 1 [2]
Greg
12-01-2008, 03:31 PM
ah ha. PHP4?

Sorry, that can go.

I will update.

if you would like to continue, edit eznl.php and on line 787 find...


$email_from_name = htmlspecialchars_decode($vbulletin->options['bbtitle']);


Change to:

$email_from_name = $vbulletin->options['bbtitle'];


Upload the file to the admincp folder.
kenfuzed
12-01-2008, 03:51 PM
Okay, that took me past that point but now I get the error below. Maybe its still related to my php version.

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT userid,username,email,posts,joindate,lastactivity, lastvisit,lastpost,friendcount,friendreqcount,prof ilevisits,socgroupinvitecount, socgroupreqcount,pmtotal,pmunread FROM user WHERE userid IN() ORDER by userid ASC;

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 ') ORDER by userid ASC' at line 1
Error Number : 1064
Date : Monday, December 1st 2008 @ 02:42:44 PM
Script : http://bike-talk.com/forum/admincp/eznl.php?do=send
Referrer : http://bike-talk.com/forum/admincp/eznl.php?do=process
IP Address : xxx.xxx.xxx.xxx
Username : kenfuzed
Classname : vb_database
Thanks for the help.
bigH2O
12-01-2008, 04:15 PM
I'm getting that same error... the IN() clause is not getting populated. It's as if you've specified no groups to send it to, but I do have groups specified... they're just not making it into the IN() clause.

In my case it's not in debug mode, and I'm running PHP 5.2.5

I started digging into the code last night to look for the problem myself, but was already too deep in a bottle of Jim Beam to get very far ;)
Greg
12-01-2008, 04:25 PM
What is the value of Review Email Before Sending to X Members. on the page before the send page?

I can't duplicate that.

If I can get into either system and have a look, pm me details. I will fix this right now.
bigH2O
12-01-2008, 04:30 PM
You got the details to my box Greg.
bigH2O
12-01-2008, 04:35 PM
Was wondering if this could be a problem with disabling phpinfo(). Does this hack call that function? If so, that may be the problem. I've got disable_functions = phpinfo in my php.ini file for security reasons. Shout if you don't see something quick and I'll lose that line and see if it fixes the issue.
Greg
12-01-2008, 04:38 PM
I think it has to do with the table update this version does. Not sure.

I will install it on riderinfo and that should duplicate your problem so I can debug it.
Greg
12-01-2008, 04:44 PM
Nope, can't duplicate this. I'm gonna need ftp and admin access to investigate.

Very odd.

You did upload and overwrite all files, correct?
Greg
12-01-2008, 04:48 PM
Wait a minute here. No one is opted in. That's the problem, it's not a bug.

You have opt in at least yourself.

I'll add that to the install so that the error is not thrown.
kenfuzed
12-01-2008, 04:50 PM
What is the value of Review Email Before Sending to X Members. on the page before the send page?

I can't duplicate that.

If I can get into either system and have a look, pm me details. I will fix this right now.Mine says "Review Email Before Sending to 7 Members." however I don't know where "7" is being calculated from. I have all usergroups selected.

I'll wait until you've diagnosed bigH2O's board before passing along login info to you.

Thanks Greg!
Greg
12-01-2008, 04:55 PM
I'm working it. To opt in more members, see this thread in the downloads forum. http://www.cpurigs.com/forums/showthread.php?t=5173
bigH2O
12-01-2008, 04:58 PM
Getting closer... now I get the following
1) FAILURE Sending to Member: 1 - bigwater UNEXPECTED_DATA_AFTER_ADDRESS .SYNTAX-ERROR.
Greg
12-01-2008, 05:49 PM
Getting closer... now I get the following
1) FAILURE Sending to Member: 1 - bigwater UNEXPECTED_DATA_AFTER_ADDRESS .SYNTAX-ERROR.

Yep. I'm logged into your acp. I opted me in.

But I need ftp access. I need to see your config.php.

I'm gonna call ya.
bigH2O
12-01-2008, 06:17 PM
Check your PM. Aleta's still on the phone, talking to her daughter, so it may be a while before I get back to you :)
Greg
12-01-2008, 07:43 PM
BigH2O is fixed. Apparently there was an upload problem.

Kenfuzed, please see this thread and opt in some members. http://www.cpurigs.com/forums/showthread.php?t=5173 and see if that fixes your issue.

Upon install, no members are opted into EZ News Letter. I have made it so that upon install, the installing admin gets opted in in the future.
Greg
12-01-2008, 08:18 PM
Please download and install EZ NewsLetter 1.0.3.

Thank you.