SQL Error message

Hi,

Trying to install and get uddelIM 2.6 working on Joomla 2.5. It worked just file on Jooomla 1.7, but with 2.5 I have no admin menu, I can't find any entries for UDDEL IM in the data base, no entry in the pluggin manager but I do see it in the extentions manager. When I set up a menu item to go to the inbox I get the following error message:



SQL errorDB function failed with error number 1146
Table 'fsnavnet_joom987.jos_uddeim_emn' doesn't exist SQL=INSERT INTO jos_uddeim_emn (moderated, locked, status, popup, public, autoresponder, autoforward, autoforwardid, userid) VALUES (0, 0, 0, 0, 0, 0, 0, 0, 42)
SQL =
INSERT INTO #__uddeim_emn (moderated, locked, status, popup, public, autoresponder, autoforward, autoforwardid, userid) VALUES (0, 0, 0, 0, 0, 0, 0, 0, 42)



I really need to get this working soon. The site is due to go online in two days

Thanks!!

Please read

www.joomlapolis.com/forum/25-uddeim-plugin-and-component/74651-please-read-the-faq-inside-before-posting

and

www.joomlapolis.com/forum/25-uddeim-plugin-and-component/157512-solved-j16--17--25-non-created-admin-menus

before posting.

Ok, read them, tried them and I'm still getting errors. I installed uninstalled 7 times, repaired the DB and so forth. I added the code from the readme through mysql and it accepted:

CREATE TABLE IF NOT EXISTS `jos_uddeim_attachments` (
`id` int(10) unsigned NOT NULL auto_increment,
`mid` int(1) NOT NULL default '0',
`tempname` TEXT NOT NULL,
`filename` TEXT NOT NULL,
`fileid` varchar(32) NOT NULL,
`size` int(1) NOT NULL default '0',
`datum` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `mid` (`mid`),
KEY `fileid` (`fileid`),
KEY `datum` (`datum`)
) ENGINE=MyISAM;


But not:


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' ;

So you have several problems:

1. You have updated in the past and not corrected the database.
2. You have installed the wrong package.

(2) can be repaired using the description from the sticky.
(1) can be repaired when you check each field in uddeIMs tables and repair them.

The simplest way is to remove uddeIM. Delete (Drop) all uddeIM tables. Remove menu references as described in the sticky. Reinstall the correct(!) package.

For your information I did read prior before installing and still had the problem. I also restored the data base from an old install prior to installing the messagaing plugin. And if I installed the wrong package then it would be because the wrong files were included in the download package that the instructions said to install!!

uddeIM 2.6 is delivered in two packages: One package for Joomla 1.0/1.5 and one for Joomla 1.6+.

UddeIM 2.5 was delivered in one package, so a few people installed "com_uddeim" in Joomla 2.5 instead of the correct package "com_uddeim_j16" with the problems you have reported.

When the wrong package has been installed once, it is required to clean up the database entries (see sticky) in order to get a working installation. Without this preparation the problem will appear again and again.

This is not a problem with uddeIM, nor with the package, nor with the documentation. You can try a fresh Joomla 2.5 installation and see that everything is fine with the package.

I gave you all possible solutions for your problem in my previous post, so comply with them or not.