(NO BUG) uddeim SQL error: Unknown column

Hello,

Thanks for your reply.
Yes i did as you said and pasted in this box this code with the code i found it in as is below:

SELECT * FROM `jos1_uddeim` WHERE 1ALTER TABLE `jos_uddeim` ADD `publicname` TEXT ;
ALTER TABLE `jos_uddeim` ADD `publicemail` TEXT ;
ALTER TABLE `jos_uddeim_emn` ADD `public` INT( 1 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `jos_uddeim_emn` ADD `lastsent` INT( 11 ) DEFAULT '0' NOT NULL ;
CREATE TABLE IF NOT EXISTS `jos_uddeim_userlists` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`name` varchar(40) NOT NULL default '',
`description` text NOT NULL,
`userids` text NOT NULL,
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) TYPE=MyISAM;

But i got this ERROR below:

Error
SQL query:

SELECT *
FROM `jos1_uddeim`
WHERE 1
ALTER TABLE `jos_uddeim` ADD `publicname` TEXT;



MySQL said:

#1064 - 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 'ALTER TABLE `jos_uddeim` ADD `publicname` TEXT' at line 2

Your help will be highly appreciated.

Thanks for your support.

Ronnie

After several hours of reading these forums, and the readme, I am still at a loss of what to do. Tried all kinds of weird alterations getting equally weird results.

I was wondering, if I could just un-install the current version, drop the jos_uddeim table, and install a fresh copy of the newest version?