Solved 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 : [url]http://www.****.net/forum/admincp/eznl.php?do=send[/url]
Referrer : [url]http://www.****l.net/forum/admincp/eznl.php?do=process[/url]
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 [url]http://link[/url] and not the pic (but that can wait)..

Any idea's ???