Serendipity Forums

Posted: **Sun Nov 13, 2005 1:31 am**

I downloaded the Serendipity version .9 today and installed it on my webserver. I got through the installation and thought everything was fine. The database tables said they were created. After the install, I got this error.

Query failed:
SELECT

e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.email

, e.body, e.extended

FROM
serendipity_entries AS e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid
LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 1
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid
)
WHERE isdraft = 'false' AND e.timestamp <= '1131838376' AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ Table 'xxxxxxx.serendipity_authorgroups' doesn't exist

Where xxxxxx is my database name.

Posted: **Sun Nov 13, 2005 1:12 pm**

It seems the table "authorgroups" was not created on your system!

Did you install serendipity 0.9 from scratch, or did you do an upgrade?

What is your database type and version? Did you get any errors when installing about missing tables?

Regards,
Garvin

Posted: **Sun Nov 13, 2005 2:17 pm**

I installed Sernedipity 0.9 from scratch. I didn't get any errors about missing tables. The database is MySQL.

Posted: **Sun Nov 13, 2005 11:55 pm**

Which MySQL version? And what is the size of your sql/db.sql file?

You can run this SQL query to create the missing talbe:

Code: Select all

CREATE TABLE `serendipity_authorgroups` (
  `groupid` int(10) unsigned NOT NULL default '0',
  `authorid` int(10) unsigned NOT NULL default '0',
  KEY `authorgroup_idxA` (`groupid`),
  KEY `authorgroup_idxB` (`authorid`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `serendipity_authorgroups`
-- 

INSERT INTO `serendipity_authorgroups` VALUES (2, 2);
INSERT INTO `serendipity_authorgroups` VALUES (2, 4);
INSERT INTO `serendipity_authorgroups` VALUES (2, 5);
INSERT INTO `serendipity_authorgroups` VALUES (3, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `serendipity_groupconfig`
-- 

CREATE TABLE `serendipity_groupconfig` (
  `id` int(10) unsigned NOT NULL default '0',
  `property` varchar(64) default NULL,
  `value` varchar(128) default NULL,
  KEY `groupid_idx` (`id`),
  KEY `groupprop_idx` (`id`,`property`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `serendipity_groupconfig`
-- 

INSERT INTO `serendipity_groupconfig` VALUES (1, 'userlevel', '0');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'personalConfiguration', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'personalConfigurationUserlevel', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'personalConfigurationNoCreate', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'personalConfigurationRightPublish', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'siteConfiguration', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'blogConfiguration', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminEntries', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminEntriesMaintainOthers', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminImport', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminCategories', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminCategoriesMaintainOthers', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminCategoriesDelete', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminUsers', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminUsersDelete', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminUsersEditUserlevel', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminUsersMaintainSame', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminUsersMaintainOthers', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminUsersCreateNew', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminUsersGroups', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminPlugins', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminPluginsMaintainOthers', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminImages', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminImagesDirectories', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminImagesAdd', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminImagesDelete', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminImagesMaintainOthers', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminImagesViewOthers', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminImagesView', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminImagesSync', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminComments', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (1, 'adminTemplates', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'userlevel', '1');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'personalConfiguration', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'personalConfigurationUserlevel', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'personalConfigurationNoCreate', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'personalConfigurationRightPublish', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'siteConfiguration', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'blogConfiguration', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminEntries', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminEntriesMaintainOthers', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminImport', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminCategories', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminCategoriesMaintainOthers', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminCategoriesDelete', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminUsers', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminUsersDelete', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminUsersEditUserlevel', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminUsersMaintainSame', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminUsersMaintainOthers', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminUsersCreateNew', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminUsersGroups', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminPlugins', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminPluginsMaintainOthers', 'false');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminImages', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminImagesDirectories', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminImagesAdd', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminImagesDelete', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminImagesMaintainOthers', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminImagesViewOthers', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminImagesView', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminImagesSync', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminComments', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (2, 'adminTemplates', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'userlevel', '255');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'personalConfiguration', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'personalConfigurationUserlevel', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'personalConfigurationNoCreate', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'personalConfigurationRightPublish', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'siteConfiguration', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'blogConfiguration', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminEntries', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminEntriesMaintainOthers', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminImport', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminCategories', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminCategoriesMaintainOthers', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminCategoriesDelete', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminUsers', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminUsersDelete', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminUsersEditUserlevel', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminUsersMaintainSame', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminUsersMaintainOthers', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminUsersCreateNew', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminUsersGroups', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminPlugins', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminPluginsMaintainOthers', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminImages', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminImagesDirectories', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminImagesAdd', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminImagesDelete', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminImagesMaintainOthers', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminImagesViewOthers', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminImagesView', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminImagesSync', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminComments', 'true');
INSERT INTO `serendipity_groupconfig` VALUES (3, 'adminTemplates', 'true');

-- --------------------------------------------------------

-- 
-- Table structure for table `serendipity_groups`
-- 

CREATE TABLE `serendipity_groups` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(64) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `serendipity_groups`
-- 

INSERT INTO `serendipity_groups` VALUES (1, 'Redakteur');
INSERT INTO `serendipity_groups` VALUES (2, 'Chef-Redakteur');
INSERT INTO `serendipity_groups` VALUES (3, 'Administrator');

Regards,
Garvin

Serendipity Forums

Query failed

Query failed

Re: Query failed

authorgroups

Re: authorgroups