UddeiM is impressive

UddeiM is impressive but the help/how to/Readme files just confuse me

Will you be adding a auto-updater to help the Beginners like me :blush: ??


Cheers

Hi,

an auto updater is not that easy to implement. Since uddeIM is open source a hacker may modify the update function which loads malicious code from a different server and spread this version. An auto updater will only be trustworthy when the package has been loaded from my server. Sure I could provide a hash to validate the package but how many users will really use it?

Hi
I know that you don't do support via the forum BUT I am at my wits end here

All of my site has been upgraded and as you can see I am still on
uddeIM 2.0rc/2009-12-24/dev because I have to upgrade from Joomla 1.0 to 1.5 and a friend was helping me and he just added that.
Now I need to get to 2.4: so that programs like Kunena will link to UddeiM and I can have a great site

I have read your UPGRADE READ ME so many times, downloaded jos_uddeim database files and can not see just what to change..!!
When you upgrade 2.0 to 2.4:
============================
ALTER TABLE `jos_uddeim` ADD `systemflag` INT( 1 ) NOT NULL DEFAULT '0' ;
ALTER TABLE `jos_uddeim` ADD INDEX ( `systemflag` ) ;
UPDATE `jos_uddeim` SET `systemflag` = 1 WHERE `systemmessage` != '' OR `systemmessage` IS NOT NULL ;
UPDATE `jos_uddeim` SET `systemflag` = 2 WHERE `fromid` = `toid` ;
ALTER TABLE `jos_uddeim` ADD `delayed` INT( 1 ) NOT NULL DEFAULT '0' ;
ALTER TABLE `jos_uddeim` ADD INDEX ( `delayed` ) ;
ALTER TABLE `jos_uddeim_emn` ADD `moderated` INT( 1 ) NOT NULL DEFAULT '0' ;


BUT JUST WHERE DOES THAT GO IN.................
CREATE TABLE `jos_uddeim` (
`id` int(10) unsigned NOT NULL auto_increment,
`replyid` int(11) NOT NULL default '0',
`fromid` int(11) NOT NULL default '0',
`toid` int(11) NOT NULL default '0',
`message` text NOT NULL,
`datum` int(11) default NULL,
`toread` int(1) NOT NULL default '0',
`totrash` int(1) NOT NULL default '0',
`totrashdate` int(11) default NULL,
`totrashoutbox` int(1) NOT NULL default '0',
`totrashdateoutbox` int(11) default NULL,
`expires` int(11) NOT NULL default '0',
`disablereply` int(1) NOT NULL default '0',
`systemmessage` varchar(60) default NULL,
`archived` int(1) NOT NULL default '0',
`cryptmode` int(1) NOT NULL default '0',
`flagged` int(1) NOT NULL default '0',
`crypthash` varchar(32) default NULL,
`publicname` text,
`publicemail` text,
PRIMARY KEY (`id`),
KEY `toid_toread` (`toid`,`toread`),
KEY `fromid` (`fromid`),
KEY `replyid` (`replyid`),
KEY `datum` (`datum`),
KEY `totrashdate` (`totrashdate`),
KEY `totrashdateoutbox_datum` (`totrashdateoutbox`,`datum`),
KEY `toread_totrash_datum` (`toread`,`totrash`,`datum`),
KEY `totrash_totrashdate` (`totrash`,`totrashdate`),
KEY `archived_totrash_toid_datum` (`archived`,`totrash`,`toid`,`datum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30255 ;

--
-- Dumping data for table `jos_uddeim`



Sorry but I really want to upgrade but I have NO IDEA how


Cheers

Open phpMyAdmin and copy and paste the code from the README file into the SQL box so it is executed.

The FAQ explains this step by step.

My God
First Your answer came back so quick

Second WHY did I not know that ?? :blush:

I have been going around and around for months to do a 30 second job

I must learn the lingo, as i DID read your tutorial

Thank you

Back again
I have done as you said BUT
after coping and pasting the code from the README file into the SQL box it came back with

Error
SQL query:
ALTER TABLE `jos_uddeim_emn` ADD `moderated` INT( 1 ) NOT NULL DEFAULT '0';
MySQL said: Documentation
#1060 - Duplicate column name 'moderated'

the data is on the site so emails are working

In the "uddeIM Administration" when I run "Database maintenance" check it just returns a blank page, as I say its working but are these two connected ??

I am on Version 1.5.23 and am moving from 2.0rc/2009-12-24/dev to 2.4:

cheers