Upgrade from 0.7 -> Beta1 is failing

Having trouble installing serendipity?
Post Reply
PilotSpike

Upgrade from 0.7 -> Beta1 is failing

Post by PilotSpike »

I tried to upgrade from 0.7 to Beta 1 today and it puked pretty badly.

During installation I got quite a bit of warnings regarding depricated sql calls and once it was done trying to bring up the front page the scripts error out with warnings of full table scans and of a missing table.

Am I trying to do to big of a jump in versions or something ? :roll:
Top
hemotox
Regular
Posts: 27
Joined: Thu Mar 31, 2005 2:06 am

Worse Problems...it worked and corrupted

Post by hemotox »

I had no trouble going from .91 to 1.00 beta, but... the end product is that I have a non-working blog.

The plugins are erroring out.

The formatting is truly a mess.

I tried (foolish) to go back to .91...could not do so.

Garvin...any words of wisdom?

ADDENDUM: When upgrading to 1.00, it corrupted one plug-in. The corruption caused an error message that spread across the page and changed formatting. Removing that plug-in permitted the correct formatting to return. But I am not certain which plug-in failed. In either case, I have the blog running (Serendipity rocks!).
Top
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:
Contact garvinhicking

Re: Worse Problems...it worked and corrupted

Post by garvinhicking »

I want to help all people, but please remember this:

I cannot help you at all if you just say "I got a lot of error messages". Think if you were me, and want to help. Your first question would be: "Well, WHAT is the error message saying"? :-)

So, everything can be fixed once you tell me those error messages. Also the FAQ on www.s9y.org helps on some common upgrading issues. :-)

Best regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Top
Guest

Post by Guest »

Sorry about that Garvin. Truth be told Im a software engineer and know better, it was just a long day yesterday. Anyway, when trying to upgrade from 0.7 to Beta 1, I unpack on top of serendipity as instructed.

Then when I go to the main page I get this:

Code: Select all

Warning: mysql_query(): Your query requires a full tablescan (table serendipity_config, 53 rows affected). Use EXPLAIN to optimize your query. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Serendipity has detected that your currently installed Serendipity version is 0.7. It seems you are attempting to upgrade to version 1.0-beta1, so you need to click here to continue the upgrade process.
Clicking on the link to go to the next step produces this:

Code: Select all

Warning: mysql_query(): Your query requires a full tablescan (table serendipity_config, 53 rows affected). Use EXPLAIN to optimize your query. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 200

Warning: mysql_query(): Your query requires a full tablescan (table serendipity_plugins, 16 rows affected). Use EXPLAIN to optimize your query. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Your query requires a full tablescan (table serendipity_config, 53 rows affected). Use EXPLAIN to optimize your query. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80
after which I get the pretty HTML telling me what needs to be done (an extensive list). I click on "Yes Please Do"

Which results in this:

Code: Select all

Warning: mysql_query(): Your query requires a full tablescan (table serendipity_config, 53 rows affected). Use EXPLAIN to optimize your query. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 200

Warning: mysql_query(): Your query requires a full tablescan (table serendipity_plugins, 16 rows affected). Use EXPLAIN to optimize your query. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Your query requires a full tablescan (table serendipity_config, 53 rows affected). Use EXPLAIN to optimize your query. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

.....



Serendipity Installation

Warning: mysql_query(): Table 'serendipity_entryproperties' already exists in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'prop_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'entrypropid_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Table 'serendipity_permalinks' already exists in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'pl_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'ple_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'plt_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'plcomb_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Table 'serendipity_groups' already exists in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Table 'serendipity_groupconfig' already exists in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'groupid_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'groupprop_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Table 'serendipity_authorgroups' already exists in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'authorgroup_idxA' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'authorgroup_idxB' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Table 'serendipity_plugincategories' already exists in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'plugincat_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Table 'serendipity_pluginlist' already exists in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'pluginlist_f_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'pluginlist_cn_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'pluginlist_pt_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'pluginlist_pl_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Table 'serendipity_access' already exists in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'accessgroup_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'accessgroupT_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_query(): Duplicate key name 'accessforeign_idx' in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80
Calling serendipity_removeFiles ...
Calling serendipity_removeFiles ...
Calling serendipity_installFiles ...
Calling serendipity_removeObsoleteVars ...
Calling serendipity_plugin_api::create_plugin_instance ...

Warning: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 200

Warning: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 200
Calling serendipity_installFiles ...
Calling serendipity_installFiles ...
Calling serendipity_fixPlugins ...

Warning: mysql_query(): Your query requires a full tablescan (table serendipity_config, 53 rows affected). Use EXPLAIN to optimize your query. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80
Calling serendipity_smarty_purge ...
Calling serendipity_buildPermalinks ...

Warning: mysql_query(): Your query requires a full tablescan (table serendipity_entries, 80 rows affected). Use EXPLAIN to optimize your query. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80

Warning: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 200

Warning: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 200

Warning: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 200

Warning: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 200

...


...


...


...



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_permalinks (
    permalink varchar(255) not null default '',
    entry_id int(10) unsigned not null default '0',
    type varchar(200) not null default '',
    data text
);

/ Table 'serendipity_permalinks' already exists

CREATE INDEX pl_idx ON serendipity_permalinks (permalink);

/ Duplicate key name 'pl_idx'

CREATE INDEX ple_idx ON serendipity_permalinks (entry_id);

/ Duplicate key name 'ple_idx'

CREATE INDEX plt_idx ON serendipity_permalinks (type);

/ Duplicate key name 'plt_idx'

CREATE INDEX plcomb_idx ON serendipity_permalinks (permalink, type);

/ Duplicate key name 'plcomb_idx'

create table serendipity_groups (
  id int(11) not null auto_increment primary key,
  name varchar(64) default null
);

/ Table 'serendipity_groups' already exists

create table serendipity_groupconfig (
  id int(10) unsigned not null default '0',
  property varchar(64) default null,
  value varchar(128) default null
);

/ Table 'serendipity_groupconfig' already exists

CREATE INDEX groupid_idx ON serendipity_groupconfig (id);

/ Duplicate key name 'groupid_idx'

CREATE INDEX groupprop_idx ON serendipity_groupconfig (id, property);

/ Duplicate key name 'groupprop_idx'

create table serendipity_authorgroups (
  groupid int(10) unsigned not null default '0',
  authorid int(10) unsigned not null default '0'
);

/ Table 'serendipity_authorgroups' already exists

CREATE INDEX authorgroup_idxA ON serendipity_authorgroups (groupid);

/ Duplicate key name 'authorgroup_idxA'

CREATE INDEX authorgroup_idxB ON serendipity_authorgroups (authorid);

/ Duplicate key name 'authorgroup_idxB'

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'

create table serendipity_access (
  groupid int(10) unsigned not null default '0',
  artifact_id int(10) unsigned not null default '0',
  artifact_type varchar(64) NOT NULL default '',
  artifact_mode varchar(64) NOT NULL default '',
  artifact_index varchar(64) NOT NULL default ''
);

/ Table 'serendipity_access' already exists

CREATE INDEX accessgroup_idx ON serendipity_access(groupid);

/ Duplicate key name 'accessgroup_idx'

CREATE INDEX accessgroupT_idx ON serendipity_access(artifact_id,artifact_type,artifact_mode);

/ Duplicate key name 'accessgroupT_idx'

CREATE INDEX accessforeign_idx ON serendipity_access(artifact_id);

/ Duplicate key name 'accessforeign_idx'
Cannot write to file /home/patti/public_html/cyphergirl/cgi-php/serendipity/templates/default/layout.php.


Your Serendipity installation is now upgraded to version 1.0-beta1

You can return to your blog by clicking here

Lots of stuff to read, sorry about that. Anyway, now when I go to the main page I get tons of warnings on the pages like those listed above. You can see them on the page itself at:

www.spikesplace.org/cgi-php/serendipity

It almost looks like its puking on the tables of 0.7 and I have not touched them that I know of.

PHP: 4.3.11
MySql: 3.23.58

-- John
Top
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:
Contact garvinhicking

Post by garvinhicking »

Hi!

Many thanks for posting your error messages! Actually, those messages are all redundant. How is your PHP/MySQL configured?

Especially this:

Code: Select all

Warning: mysql_query(): Your query requires a full tablescan (table serendipity_config, 53 rows affected). Use EXPLAIN to optimize your query. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80
should now show up. We NEED a full tablescan there, so it's pretty stupid that mysql_query emits this warning. My PHP/MySQL doesn't do that. Do you have enabled some ultra-verbose error reporting in your MySQL/PHP?

Because we cannot change the query; selecting all values is required.

The other error:

Code: Select all

Warning: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 200
This info should actually also not be emitted in usual PHP environments. But it is right, the function call is deprecated. I've just committed a change for the upcoming release so that we use mysql_real_escape_string.
Many thanks for pointing this out!

Lastly,

Code: Select all

Warning: mysql_query(): Table 'serendipity_entryproperties' already exists in /home/patti/public_html/cyphergirl/cgi-php/serendipity/include/db/mysql.inc.php on line 80
This stems from the fact that you already had the "new" tables installed in your second test, so those message should not have come in first place.

About your page:

Code: Select all

www.spikesplace.org/cgi-php/serendipity
This is basically pukung because of your ultra verbose mysqwl reporting; you'll need to find a way to switch this off. The mysql_escape_string thing can be done with this patch I committed:

http://svn.berlios.de/viewcvs/serendipi ... 861&r2=871

Best regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Top
Pilot Spike

Post by Pilot Spike »

Thanx!! A few tweaks to php.ini and everything seems to be A O K. Now, I just have to learn how to drive this new version!! :)

-- John
Top
Post Reply

Return to “Installation”