RC3 der Joomunity in 1.5.9: db error number 01142

Hallo liebe Joomla-Fans in der Schweiz.

habe eine frische Installation der 1.5.9 - In diese Installation habe ich die SOBI2 (neuester RC eingespielt) und dann versucht den RC3 der Joomunity zu installieren. Hier gibts allerdings dann erhebliche Probleme...

Bei mir scheints auf der DB zu hacken... Keine Ahnung was ich damit anfangen soll.

DB function failed with error number 01142
DROP command denied to user 'luser'@'localhost' for
table 'jos_joomm_albums' SQL=-- phpMyAdmin SQL Dump -- version 3.1.1
-- --ALTER LINK WURDE ENTFERNT-- -- -- Serveur:
localhost -- : Ven 09 Janvier 2009 01:03 - Version du serveur: 5.1.30 -- Version de PHP: 5.2.8 Base de donn?es:
`joomunity` -- --

---

-- -- Structure de la table `joom_albums` -- DROP TABLE IF EXISTS `jos_joomm_albums`

-

fällt euch hier was ein?

Freu mich über jeden Tipp. Falls ich das alles näher erklären soll dann schreibt bitte.

Gruß in die Schweiz

Dilbert

Hi,

scheint mir fast so als ob Du mit dem DB Benutzer nicht alle rechte hast Operationen auf der DB zu machen...

Gruess

Pete

hallo Pete,

Danke fürs Posten. Das scheint mir auch so. in der Tat ist das DB-Management auf dem Rootserver meines Freundes ziemlich strikt geloest. Ich werd da nochmals drüber nachdenken.

ghosty schrieb: Hi,

scheint mir fast so als ob Du mit dem DB Benutzer nicht alle rechte hast Operationen auf der DB zu machen...

Gruess

Pete

Hmm - die Jooomunity holt sich doch aber die Daten aus der Joomla 1.5.9. oder. ich denk dass sie die Daten aus der Config der joomla 1.5.9 holt. Hmmm - Dennoch. Du hast dennoch eine gute Idee. Ich werd mal drüber nachdenken.

gruss dilbert

Update:

Ein user der auf dem engl. Forum - von joomunity dieselben errors hatte meldete folgendes:

Okay, good. 5.0 is a good version and is probably the reason why you're having the same problems as me.

1. Unzip the Joomunity .zip component
2. open "sql.joomunity.txt"
3. There, you'll see

-- phpMyAdmin SQL Dump
-- version 3.1.1
-- --ALTER LINK WURDE ENTFERNT--
--
-- Serveur: localhost
-- Généré le : Ven 09 Janvier 2009 à 01:03
-- Version du serveur: 5.1.30
-- Version de PHP: 5.2.8
--
-- Base de données: `joomunity`
--

--

---

--
-- Structure de la table `joom_albums`
--
DROP TABLE IF EXISTS `#__joomm_albums`;
CREATE TABLE IF NOT EXISTS `#__joom_albums` (
`album_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`album_name` mediumtext NOT NULL,
`album_descr` text,
`album_published` int(5) NOT NULL DEFAULT '0',
`album_create_date` datetime NOT NULL COMMENT 'date the album was createdrn',
`album_ordering` int(11) DEFAULT NULL,
`album_views` int(11) NOT NULL DEFAULT '0',
`album_user_id` int(11) NOT NULL,
`album_permissions` varchar(20) NOT NULL,
`album_thumb` varchar(255) NOT NULL DEFAULT 'no_thumb.jpg',
`album_rating` int(11) NOT NULL DEFAULT '0',
`album_img_count` int(11) NOT NULL DEFAULT '0',
`album_votes` int(11) NOT NULL DEFAULT '0',
`album_comments` int(11) NOT NULL DEFAULT '0',
`album_params` varchar(255) DEFAULT NULL,
PRIMARY KEY (`album_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

--

---

--
-- Structure de la table `joom_albums_pics`
--
DROP TABLE IF EXISTS `#__joom_albums_pics`;
CREATE TABLE IF NOT EXISTS `#__joom_albums_pics` (
`pic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pic_name` text NOT NULL,
`pic_descr` text,
`pic_album_id` int(11) NOT NULL,
`pic_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`pic_user_id` int(11) NOT NULL,
`pic_title` text NOT NULL,
`pic_status` int(11) NOT NULL DEFAULT '0' COMMENT '0=unpublished, 1=published, 2=in moderation qeue',
`pic_views` int(11) NOT NULL DEFAULT '0',
`pic_rating` int(11) NOT NULL DEFAULT '0',
`pic_votes` int(11) NOT NULL DEFAULT '0',
`pic_comments` int(11) DEFAULT '0',
`pic_params` varchar(255) DEFAULT NULL,
PRIMARY KEY (`pic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

--

---

--
-- Structure de la table `joom_albums_pics_comments`
--
DROP TABLE IF EXISTS `#__joom_albums_pics_comments`;
CREATE TABLE IF NOT EXISTS `#__joom_albums_pics_comments` (
`cmt_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cmt_pic_id` int(11) NOT NULL,
`cmt_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`cmt_user_id` int(11) NOT NULL,
`cmt_status` int(11) NOT NULL DEFAULT '0' COMMENT '0=unpublished, 1=published, 2=in moderation qeue',
`cmt_body` text NOT NULL,
PRIMARY KEY (`cmt_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;


--

---

--

--

---

--
-- Structure de la table `joom_notifications`
--
DROP TABLE IF EXISTS `#__joom_notifications`;
CREATE TABLE IF NOT EXISTS `#__joom_notifications` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` text CHARACTER SET latin1 NOT NULL,
`body` text CHARACTER SET latin1,
`link` varchar(100) NOT NULL,
`application` varchar(50) NOT NULL DEFAULT 'Profile',
`status` enum('0','1','2') NOT NULL DEFAULT '0' COMMENT '0 = unread, 1= read , 2=solved if in moderation que',
`type` enum('0','1') NOT NULL DEFAULT '0' COMMENT '0= default, 1=moderation',
`userid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

--

---

--
-- Structure de la table `joom_params`
--
DROP TABLE IF EXISTS `#__joom_params`;
CREATE TABLE IF NOT EXISTS `#__joom_params` (
`album_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`album_name` mediumtext NOT NULL,
`album_descr` text,
`album_published` int(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`album_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `joom_params`
--


--

---

--
-- Structure de la table `joom_plg`
--
DROP TABLE IF EXISTS `#__joom_plg`;
CREATE TABLE IF NOT EXISTS `#__joom_plg` (
`plg_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`plg_name` varchar(200) NOT NULL,
`plg_title` varchar(200) NOT NULL,
`plg_icon` varchar(255) NOT NULL,
`plg_type` varchar(100) NOT NULL,
`plg_published` enum('0','1','2','3') NOT NULL DEFAULT '0',
`plg_author` varchar(100) NOT NULL DEFAULT 'Unknown',
`plg_date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`plg_params` varchar(255) DEFAULT NULL,
`plg_action` varchar(150) DEFAULT NULL,
`plg_actionlink` varchar(150) DEFAULT NULL,
PRIMARY KEY (`plg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

--
-- Contenu de la table `joom_plg`
--

--
-- Structure de la table `joom_rel`
--

DROP TABLE IF EXISTS `#__joom_rel`;
CREATE TABLE IF NOT EXISTS `#__joom_rel` (
`rel_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`rel_type` varchar(100) NOT NULL,
`rel_thisuser` int(20) NOT NULL,
`rel_thatuser` int(20) NOT NULL,
`rel_consent` enum('0','1') NOT NULL DEFAULT '0',
`rel_datereq` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`rel_dateaccept` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`rel_thatdescr` mediumtext CHARACTER SET latin1,
`rel_thisdescr` mediumint(9) DEFAULT NULL,
`rel_params` varchar(255) DEFAULT NULL,
PRIMARY KEY (`rel_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;

--

---

--
-- Structure de la table `joom_social`
--
DROP TABLE IF EXISTS `#__joom_social` ;
CREATE TABLE IF NOT EXISTS `#__joom_social` (
`social_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`social_perms` enum('0','1') NOT NULL DEFAULT '0' COMMENT '0=visible to all, 1=visible to friends',
`uc_main_occupation` varchar(150) DEFAULT '',
`uc_favorite_color` varchar(40) DEFAULT '',
PRIMARY KEY (`social_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

--

---

--
-- Structure de la table `joom_social_fields`
--
DROP TABLE IF EXISTS `#__joom_social_fields`;
CREATE TABLE IF NOT EXISTS `#__joom_social_fields` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`title` varchar(100) NOT NULL,
`descr` text CHARACTER SET latin1,
`type` varchar(100) NOT NULL,
`maxlength` int(11) DEFAULT NULL,
`size` varchar(20) DEFAULT NULL,
`required` enum('0','1') NOT NULL DEFAULT '0' COMMENT '0 = not required, 1 = required',
`ordering` int(11) NOT NULL,
`defaultvalue` varchar(255) DEFAULT NULL,
`visible` enum('0','1') NOT NULL DEFAULT '1' COMMENT '0 = no , 1 = yes',
`validation` text CHARACTER SET latin1,
`attributes` text CHARACTER SET latin1,
`indexed` enum('0','1') DEFAULT '1' COMMENT 'allow search 0 = no 1 = yes',
`linkfieldvalue` varchar(255) DEFAULT NULL COMMENT 'link the value of this field to some url?',
`tablename` varchar(90) DEFAULT NULL,
`options` text CHARACTER SET latin1,
`editable` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'Wether the filed is editable from the profile social settings tab',
PRIMARY KEY (`id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Contenu de la table `joom_social_fields`

--
-- Structure de la table `joom_users`
--
DROP TABLE IF EXISTS `#__joom_users`;
CREATE TABLE IF NOT EXISTS `#__joom_users` (
`user_id` int(10) NOT NULL,
`user_name` varchar(30) DEFAULT NULL,
`user_nickname` varchar(60) NOT NULL,
`user_firstname` text CHARACTER SET latin1 NOT NULL,
`user_lastname` text CHARACTER SET latin1 NOT NULL,
`user_initials` text CHARACTER SET latin1,
`user_email` varchar(200) DEFAULT NULL,
`user_reg_date` datetime NOT NULL,
`user_last_login` datetime NOT NULL,
`user_sex` int(11) NOT NULL DEFAULT '0',
`user_dob` date DEFAULT NULL,
`user_picture` varchar(40) NOT NULL DEFAULT 'nopicture.jpg',
`user_rating` float(9,3) NOT NULL DEFAULT '0.000',
`user_votes` int(11) NOT NULL DEFAULT '0',
`user_occupation` text CHARACTER SET latin1,
`user_descr` text CHARACTER SET latin1,
`user_last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`user_tag` text CHARACTER SET latin1,
`user_views` int(11) NOT NULL DEFAULT '0',
`user_groups` varchar(145) DEFAULT NULL,
`user_params` text,
`user_jid` int(11) NOT NULL,
`user_fbcid` int(10) unsigned NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

---

--
-- Structure de la table `joom_users_apps`
--
DROP TABLE IF EXISTS `#__joom_users_apps`;
CREATE TABLE IF NOT EXISTS `#__joom_users_apps` (
`record_id` int(10) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`app_id` int(11) NOT NULL,
`app_title` text CHARACTER SET latin1 NOT NULL,
`app_status` enum('0','1','2') NOT NULL DEFAULT '1',
`app_proposed_by` int(11) DEFAULT NULL,
`app_date_proposed` datetime DEFAULT '0000-00-00 00:00:00',
`app_date_added` datetime NOT NULL,
`app_user_settings` text,
`app_order` int(11) DEFAULT NULL,
PRIMARY KEY (`record_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0;



4. Take out anything that starts with "--"
5. Change anything that says "__joom" to "jos_joom"
6. Change anything that says "__joomm" to "jos_joom"
7. Change anything that says "#jos_joom" to "jos_joom"
8. Should look like this



DROP TABLE IF EXISTS `jos_joom_chat_members`;
CREATE TABLE IF NOT EXISTS `jos_joom_chat_members` (
`cmid` int(10) unsigned NOT NULL,
`crid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cmjointime` int(10) unsigned NOT NULL,
`cmpermission` enum('0','1','2') NOT NULL,
`cmlastmsgtime` int(10) unsigned NOT NULL,
`cmmsgcount` tinyint(3) unsigned NOT NULL,
`cmsesskey` varchar(120) NOT NULL,
`cmroomid` int(10) unsigned NOT NULL,
`cmusername` varchar(60) NOT NULL,
PRIMARY KEY (`crid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

DROP TABLE IF EXISTS `jos_joom_chat_message`;
CREATE TABLE IF NOT EXISTS `jos_joom_chat_message` (
`msgid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`msgcrid` varchar(45) NOT NULL,
`msguid` tinyint(3) unsigned NOT NULL,
`msguname` varchar(60) NOT NULL,
`msgbody` text,
`msgposttime` int(10) unsigned NOT NULL,
`msgstatus` varchar(45) NOT NULL,
PRIMARY KEY (`msgid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;


DROP TABLE IF EXISTS `jos_joom_contacts`;
CREATE TABLE IF NOT EXISTS `jos_joom_contacts` (
`contact_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`user_title` varchar(20) NOT NULL,
`user_suffix` varchar(20) DEFAULT NULL,
`user_home_address` varchar(155) DEFAULT NULL,
`user_city` text,
`user_region` text,
`user_postal_code` text,
`user_country` varchar(100) DEFAULT NULL,
`user_phone` varchar(60) DEFAULT NULL,
`user_mobile` varchar(60) DEFAULT NULL,
`user_fax` varchar(60) DEFAULT NULL,
`user_im` text,
`user_notes` text,
`user_jobtitle` text,
`user_department` text,
`user_profession` text,
`user_workaddress` text,
`user_website` varchar(100) DEFAULT NULL,
`user_ICQ` varchar(50) DEFAULT NULL,
`user_AIM` varchar(50) DEFAULT NULL,
`user_YIM` varchar(50) DEFAULT NULL,
`user_MSN` varchar(50) DEFAULT NULL,
`user_skype` varchar(50) DEFAULT NULL,
`user_GTALK` varchar(50) DEFAULT NULL,
`user_company` text,
PRIMARY KEY (`contact_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `jos_joom_params`;
CREATE TABLE IF NOT EXISTS `jos_joom_params` (
`album_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`album_name` mediumtext NOT NULL,
`album_descr` text,
`album_published` int(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`album_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `jos_joom_plg`;
CREATE TABLE IF NOT EXISTS `jos_joom_plg` (
`plg_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`plg_name` varchar(200) NOT NULL,
`plg_title` varchar(200) NOT NULL,
`plg_icon` varchar(255) NOT NULL,
`plg_type` varchar(100) NOT NULL,
`plg_published` enum('0','1','2','3') NOT NULL DEFAULT '0',
`plg_author` varchar(100) NOT NULL DEFAULT 'Unknown',
`plg_date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`plg_params` varchar(255) DEFAULT NULL,
`plg_action` varchar(150) DEFAULT NULL,
`plg_actionlink` varchar(150) DEFAULT NULL,
PRIMARY KEY (`plg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;



INSERT INTO `jos_joom_social_fields` (`id`, `name`, `title`, `descr`, `type`, `maxlength`, `size`, `required`, `ordering`, `defaultvalue`, `visible`, `validation`, `attributes`, `indexed`, `linkfieldvalue`, `tablename`, `options`, `editable`) VALUES
(1, 'user_nickname', 'Nick name', NULL, 'text', NULL, NULL, '0', 6, NULL, '1', NULL, 'style=width::100%;', '1', NULL, 'jos_joom_users', NULL, '0'),
(2, 'user_sex', 'Sex', NULL, 'text', NULL, NULL, '0', 7, NULL, '1', NULL, 'style=width::100%;', '1', NULL, 'jos_joom_users', NULL, '0'),
(3, 'user_dob', 'Date of Birth', NULL, 'date', NULL, NULL, '0', 8, NULL, '1', NULL, 'style=width::100%;', '1', NULL, 'jos_joom_users', NULL, '0'),
(4, 'user_descr', 'About Me', NULL, 'textarea', NULL, NULL, '0', 9, NULL, '1', NULL, 'style=width::100%;', '1', NULL, 'jos_joom_users', NULL, '0'),
(7, 'uc_main_occupation', 'Occupation', 'Users main occupation', 'text', 150, '', '0', 0, '', '1', NULL, NULL, '1', '', 'jos_joom_social', '', '1'),
(8, 'uc_favorite_color', 'Favorite Color', 'user favorite color field', 'text', 40, '', '0', 0, '', '1', NULL, NULL, '1', '', 'jos_joom_social', '', '1');


DROP TABLE IF EXISTS `jos_joom_users`;
CREATE TABLE IF NOT EXISTS `jos_joom_users` (
`user_id` int(10) NOT NULL,
`user_name` varchar(30) DEFAULT NULL,
`user_nickname` varchar(60) NOT NULL,
`user_firstname` text CHARACTER SET latin1 NOT NULL,
`user_lastname` text CHARACTER SET latin1 NOT NULL,
`user_initials` text CHARACTER SET latin1,
`user_email` varchar(200) DEFAULT NULL,
`user_reg_date` datetime NOT NULL,
`user_last_login` datetime NOT NULL,
`user_sex` int(11) NOT NULL DEFAULT '0',
`user_dob` date DEFAULT NULL,
`user_picture` varchar(40) NOT NULL DEFAULT 'nopicture.jpg',
`user_rating` float(9,3) NOT NULL DEFAULT '0.000',
`user_votes` int(11) NOT NULL DEFAULT '0',
`user_occupation` text CHARACTER SET latin1,
`user_descr` text CHARACTER SET latin1,
`user_last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`user_tag` text CHARACTER SET latin1,
`user_views` int(11) NOT NULL DEFAULT '0',
`user_groups` varchar(145) DEFAULT NULL,
`user_params` text,
`user_jid` int(11) NOT NULL,
`user_fbcid` int(10) unsigned NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `jos_joom_users_apps`;
CREATE TABLE IF NOT EXISTS `jos_joom_users_apps` (
`record_id` int(10) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`app_id` int(11) NOT NULL,
`app_title` text CHARACTER SET latin1 NOT NULL,
`app_status` enum('0','1','2') NOT NULL DEFAULT '1',
`app_proposed_by` int(11) DEFAULT NULL,
`app_date_proposed` datetime DEFAULT '0000-00-00 00:00:00',
`app_date_added` datetime NOT NULL,
`app_user_settings` text,
`app_order` int(11) DEFAULT NULL,
PRIMARY KEY (`record_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0;



9. zip the files back up with the original file name
10. Upload as normal.
11. If that doesn't work, upload the original .zip installer (without modifications), then go to your database and manually import that text file as a .sql file.

Let me know if this works, good luck!

Hab einige Daten rausgeschnitten - damit der beitrag nicht zu lang wird.... Pete, was meinst du denn!?
viele Grüße dilbert