Error - htmlspecialchars_decode()

[sofaman]

Hi,

I have the following error, have tried a few things but I'm probably missing something daft out!

Started with 1.0.1 had this error, have now upgraded to 1.0.3 and still have this error and a new error!

I set all the options for the NL, previews in html and text worked fine. Clicked on save for review.

Processing Data Skipped, already cached. Sending from page 1...

Review Email Before Sending to 1 Members.
HTML Review. Click here to Review the HTML EZ NewsLetter in a new window.
TEXT Review. Click here to Review the TEXT EZ NewsLetter in a new window.
When you click on either of the links you get the following error message...

Fatal error: Call to undefined function: htmlspecialchars_decode() in /home/*myurlinhere*/public_html/forum/admincp/eznlpreviewer.php on line 58

line 58 = $username = htmlspecialchars_decode($vbulletin->userinfo['username']);

then when I tried sending the email it came up with the same error but in a differn't file (can't rember which file).

So I turned debug on.. and

EZ NewsLetter Creator for vBulletin

Send Page: 1
Total Pages: 1
Total Members: 1
Members This Page: 1




SMTP DEBUG Mode In Effect!



and a message from my host....

Database error in vBulletin 3.6:

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

MySQL Error : Unknown column 'friendcount' in 'field list'
Error Number : 1054
Date : Monday, December 1st 2008 @ 08:14:36 PM
Script : http://www.****.net/forum/admincp/eznl.php?do=send
Referrer : http://www.****l.net/forum/admincp/eznl.php?do=process
IP Address : 90.***.***.***
Username : Admin
Classname : vb_database

and the thing that went wrong in 1.0.3 that worked in 1.0.1 was my logo is now a http://link and not the pic (but that can wait)..

Any idea's ???

[Greg]

Yeah, fields we want from the user table are not there in vB 3.5.x and 3.6.x. oops. :(

I will add some code to build the field list based on the version of vb. I went pretty extensive and only considered vB 3.7.4 where I am.

The header url stopped working because we changed the field from url to header code. This way you have more flexibility. So, wrap the url in an html image tag or copy the header out of your forum and paste it in the box.

Will that cover it?

I'll get in the version code now for that DB select that broke on vB 3.6.

Thank you for your help.

Note to early EZ NewsLetter Purchasers
All of the folks that endure testing will have their downloads extended to one year plus three months from when we squash the bugs. I will extend that offer on purchases through midnight EST Friday December 5, 2008.

[sofaman]

img tag around the header url works a treat.

Sorry to find a bug but at least you can iron it out :D

Thanks for the extended download time. Very kind of you :D

Off to bed now so I'll have a look for an update in the morning

[Greg]

EZ NewsLetter 1.0.4 should address the user table select issue and the htmlspecialchars_decode.

[sofaman]

Don't know if 1.0.4 cured it but 1.0.5 did :D Thank you

[Greg]

Nope, you are correct. 1.0.4 didn't solve this problem. I had used that function I think 3 times and only removed it once in 1.0.4.

[sofaman]

Nope, you are correct. 1.0.4 didn't solve this problem. I had used that function I think 3 times and only removed it once in 1.0.4.

Nice of you to own up lol.
Just to let you know, I have 1.0.6 installed and everything seems to be working just fine.

[Greg]

Nice of you to own up lol.
Just to let you know, I have 1.0.6 installed and everything seems to be working just fine.

That's really good news. I appreciate your help and for sticking with us through what I'm sure many are sitting back and saying, "no way, not a .0 version", to.

This is a big app, I'd be lying if I said I thought it would work perfect the first time for everyone. But this was, while a little tiring, not too bad to get done.

In the end, the hope is that we will be able to run EZ NewsLetter on a diverse set of servers and get the job done without ticking off hosts or bringing servers to their knees.

Getting bounces under control is a big part of that. We have a simple bounce management system built into EZ NewsLetter, but I'm working on a pop3 cron app that will run the mail queue and parse the messages. I really want to do the job without using a catch all email account and so far it looks possible.

When we catch a bounce, well, we'll do stuff with it. I'm not going to spell it out yet.