serendipity_authorgroups table error when upgrading to 0.9

[selva]

Tried searching on the forum and no one seems to have had this problem. I am trying to upgrade from 0.8.5 to 0.9. The installer finishes fine. When I access the blog I get:
---------
Query failed:
....
/ Table 'blog.serendipity_authorgroups' doesn't exist
----------
The table does not exist. Do I create it myself? Or am I missing something about the installation?

I run MySQL 5.0.15. The s9y 0.8.5 works fine.

Thanks for the help.

[jhermanns]

it looks like the neccesary db changes for the 0.8 -> 0.9 transition have not been made. how exactly did you upgrade your blog? did you get any error messages?

[garvinhicking]

I must agree to Jannis - Selva, if you talk about the "Installer" then you did it wrong. The Installer may NEVER kick in on an upgrader; only the Upgrader should show up that performs DB upgrades. The authorgroups is created in such an update:

Code: Select all

create table {PREFIX}groups (
  id {AUTOINCREMENT} {PRIMARY},
  name varchar(64) default null
);

create table {PREFIX}groupconfig (
  id int(10) {UNSIGNED} not null default '0',
  property varchar(64) default null,
  value varchar(128) default null
);

CREATE INDEX groupid_idx ON {PREFIX}groupconfig (id);
CREATE INDEX groupprop_idx ON {PREFIX}groupconfig (id, property);

create table {PREFIX}authorgroups (
  groupid int(10) {UNSIGNED} not null default '0',
  authorid int(10) {UNSIGNED} not null default '0'
);

CREATE INDEX authorgroup_idxA ON {PREFIX}authorgroups (groupid);
CREATE INDEX authorgroup_idxB ON {PREFIX}authorgroups (authorid);

(Alpha2 -> Alpha3)

Regards,
Garvin

[selva]

>t looks like the neccesary db changes for the 0.8 -> 0.9 transition have not been made. how exactly did you upgrade your blog? did you get any error messages?

ouch. That gave me the clue to what I did wrong. Let me state it here so others would know.
1.I renamed my existing installation folder "blog" to "blog.85" (this where I went wrong).
2.I untarred 0.9 the release into a new folder and renamed it to "blog".
3.I then ran the installer (via the web browser) and gave the existing db details.
4.S9y installed but never ran the "upgrader" (thanks, garvin, for pointing that out).

The upgrade worked when I "copied over" the new release onto the existing folder.

I am not good yet. I see this after the upgrade:
"Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /Users/selva/Sites/blog/include/db/mysql.inc.php on line 156
DATABASE_ERROR"

Many thanks for the immediate reply. S9Y team is very cool.

[selva]

How could I be so stupid! oh, well.

I got it installed. I did give MySQL root login correctly and the upgrade went fine but I screwed with the s9y admin login and password in the upgrader. Fixed it and the blog works great.

[Guest]

I must agree to Jannis - Selva, if you talk about the "Installer" then you did it wrong. The Installer may NEVER kick in on an upgrader; only the Upgrader should show up that performs DB upgrades. The authorgroups is created in such an update:
Garvin

I tried to upgrade from 07.1 to 9. I recieved the same error message about authorgroup...and did not run the "installer". My current version was detected, the upgrade script did run and showed a list of the sql files to be run.

But again, authorgroups was never created.

[garvinhicking]

Guest, did you get any warning errors? What database type and version were/are you using? Did your SQL user have ALTER TABLE and CREATE TABLE privileges, were the SQL user permissions correctly entered?

Best regards,
Garvin

[Guest]

In fact, I recieved a syntax error in phpmyadmin when I tried to run the above queries manually (of course changing prefix to my actual prefix)

(sorry about "guest mode". I forgot to log in)

[garvinhicking]

If you get an error, we of course need to know that error, else we can't know what's happening. )

Regards,
Garvin

[Guest]

It doens't really tell me WHAT the error is:
-------------------
Error
SQL query:

CREATE TABLE serendipity_groups(

id{AUTOINCREMENT}{ PRIMARY },
name varchar( 64 ) default NULL
)
MySQL said:
-----------------------

(and that's it). I am running the lasted mysql, phpmyadmin, and php.

[garvinhicking]

The code above wasn't mean to be executed as SQL code! It contains the {} special syntax only used by Serendipity.

This is the SQL that would get through to MySQL:

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

Inserting this is taken from my install. Depending on your authors you might need other values in the serendipity_authorgroups table.

HOWEVER I think something else failed on your upgrade. The tables really must've been created by Serendipity. You might want to re-execute the upgrader by taking these steps: http://www.s9y.org/11.html#A13

Regards,
Garvin

[Guest]

Garvin,
I followed your steps to re-upgrade, and it...well it appeared to work,
although I received the following errors

We detected some errors while running some diagnostics on your entered information:

-
create table serendipity_entryproperties (
entryid int(11) not null,
property varchar(255) not null,
value text
);
/ Table 'serendipity_entryproperties' already exists

CREATE UNIQUE INDEX prop_idx ON serendipity_entryproperties (entryid, property);
/ Duplicate key name 'prop_idx'

CREATE INDEX entrypropid_idx ON serendipity_entryproperties (entryid);
/ Duplicate key name 'entrypropid_idx'

create table serendipity_plugincategories (
class_name varchar(250) default null,
category varchar(250) default null
);
/ Table 'serendipity_plugincategories' already exists

CREATE INDEX plugincat_idx ON serendipity_plugincategories(class_name, category);
/ Duplicate key name 'plugincat_idx'

create table serendipity_pluginlist (
plugin_file varchar(255) NOT NULL default '',
class_name varchar(255) NOT NULL default '',
plugin_class varchar(255) NOT NULL default '',
pluginPath varchar(255) NOT NULL default '',
name varchar(255) NOT NULL default '',
description text NOT NULL,
version varchar(12) NOT NULL default '',
upgrade_version varchar(12) NOT NULL default '',
plugintype varchar(255) NOT NULL default '',
pluginlocation varchar(255) NOT NULL default '',
stackable int(1) NOT NULL default '0',
author varchar(255) NOT NULL default '',
requirements text NOT NULL,
website varchar(255) NOT NULL default '',
last_modified int(11) NOT NULL default '0'
);
/ Table 'serendipity_pluginlist' already exists

CREATE INDEX pluginlist_f_idx ON serendipity_pluginlist(plugin_file);
/ Duplicate key name 'pluginlist_f_idx'

CREATE INDEX pluginlist_cn_idx ON serendipity_pluginlist(class_name);
/ Duplicate key name 'pluginlist_cn_idx'

CREATE INDEX pluginlist_pt_idx ON serendipity_pluginlist(plugintype);
/ Duplicate key name 'pluginlist_pt_idx'

CREATE INDEX pluginlist_pl_idx ON serendipity_pluginlist(pluginlocation);
/ Duplicate key name 'pluginlist_pl_idx'

Your Serendipity installation is now upgraded to version 0.9

I checked the site, and it looked fine. But 10 minutes later, the web site was just BLANK. I use a wrapper (blog.php) and I don't know if it had anything to do with that, or the new smarty templates...but nothing would load, so I have to revert back to 0.7.1

Any ideas why blank pages are loading?

[garvinhicking]

Hi!

The errors you got should be alright, they just report already existing tables from the previous upgrade run.

It is very strange that your site just appeared blank - usually this only happens when you have parse errors in one of your plugins, or the template methods fail. In that case you might want to try to use a non-embedded page and choose the default template. If that works, we could try to investigate what is causing the trouble in your embed solution?

Best regards,
Garvin

[Guest]

It was working until I changed my template from Newspaper to Blue.
Then I couldn't get my site back.

btw, it's www.cybermidi.com/default.php

You helped me set up the wrapper there, I gave you a free membership
(which you never use )

I guess I'll try again tomorrow