Query failed

[markhorwich]

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.

[garvinhicking]

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

[markhorwich]

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

[garvinhicking]

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