Strange category links and no WYSIWYG after upgrade

[Josh]

I did not any error messages, when I upgraded from 0.84 to 0.9 beta1, but two things are not working right after the upgrade:

a) The categories sidebar links to each category with this URL: http://atlanticreview.org/categories/PERM_CATEGORIES

b) There is no WYSIWYG editor, so I installed the TinyMCE. Relative path is: serendipity/plugins/serendipity_event_tinymce/tinymce/
I don't use imanager or any TinyMCE plugins.

I downloaded and extracted TinyMCE and copied all files in to this directory: serendipity/plugins/serendipity_event_tinymce/tinymce
This directory now includes the folders docs, examples, jscripts and the files changelog, lgpl.txt, readme, todo.

Nothing happened. No error message, but it does not work either. When I want to create a new entry, there is no WYSIWYG editor.

Then I went to Personal Settings, where "YES" is checked at the question "Use WYSIWYG editor". So just for the hack of it, I checked "NO", pressed save. I still did not work. Then I checked "YES" again and there was the error message "Warning: Invalid argument supplied for foreach() in /kunden/xxx/serendipity/include/functions_config.inc.php on line 683"

So I guess, something went wrong after all during the upgrade and caused the strange URL in the categories sidebar plugin and the trouble with WYSWYG/TinyMCE.

What shall I do now?

[garvinhicking]

It seems that your database upgrade failed and your installation does not contain any new required DB tables and the new usergroups.

Please describe how you upgraded exactly, and if you made sure that .htaccess and serendipity_config_local.inc.php were writable and if you executed the DB updates and if your DB user has ALTER/CREATE TABLE privileges.

Regards,
Garvin

[Josh]

Thank you Garvin,

Both files are writable for the owner.

My host (domainfactory) just confirmed that I have alter/create table privileges.

I upgraded by copying all files via FTP in the correct directory, then I opened my homepage and I was told that I am attempting to upgrade to 0.9 beta1.

I can't rember exactly what the screen said. (I should have made a screenshot, but in the past everything went so smoothly.) What I do know is that there was not a single error messages. The screen listed three things with a green "check" sign in front of it, indicating that everything is prepared and fine, I thought.
I just had to confirm that I want to upgrade. And, I think, I was told that the DB were going to be updated.

I am sorry, I really should have taken screenshots.


I got a feeling that my FTP program did not copy all the files. I did not get an error message, but I saw some lines of red text quickly flickering on the screen during the transfer. Perhaps these red lines said that the FTP program could not overwrite a specific file for some reason? (Because the existing file is newer?) It was all too fast to read.

Besides, I now realized that my FTP program had the option enabled "Don't transfer older or same files during directory transfers". Shall I disable this option and then transfer all the files again? Can I then open the upgrade script somehow again as well?

[garvinhicking]

Yes, you should try to copy those files again with overwriting every file.

Then edit your serendipity_config_local.inc.php file and set the versionInstalled variable to "0.8.4". If you cannot write to that file, execute this PHP script before:

Code: Select all

<?php
chmod('serendipity_config_local.inc.php', 0777);
?>

Then you can do the upgrade again. After the upgrade is done, please go to your s9y configuration screen and check the permalink options to see if they contain values? Maybe save the config once there.

Best regards,
Garvin

[Josh]

Thank you

After the upgrade is done, please go to your s9y configuration screen and check the permalink options to see if they contain values? Maybe save the config once there.

They do contain values and the categories plugin uses the correct URL for my categories.

Great!


However, there is still no WYSIWYG editor. Neither the standard one nor the TinyMCE. I have deleted the TinyMCE plugin and then installed it again. Didn't work either.

When using Internet Explorer to create a new entry, I get the following error notification:

Zeile: 376
Zeichen: 2
Fehler: 'tinyMCE' ist undefiniert
Code: 0


Update: I do not get an error notification in Firefox, but there is no WYSIWYG editor in Firefox either:

After the upgrade I recived the following error messages, but I assume they only concern the permalinks.

Calling serendipity_buildPermalinks ...
Calling serendipity_addDefaultGroups ...
We detected some errors while running some diagnostics on your entered information:

-

CREATE TABLE s9y_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 's9y_permalinks' already exists

CREATE INDEX pl_idx ON s9y_permalinks (permalink);

/ Duplicate key name 'pl_idx'

CREATE INDEX ple_idx ON s9y_permalinks (entry_id);

/ Duplicate key name 'ple_idx'

CREATE INDEX plt_idx ON s9y_permalinks (type);

/ Duplicate key name 'plt_idx'

CREATE INDEX plcomb_idx ON s9y_permalinks (permalink, type);

/ Duplicate key name 'plcomb_idx'

CREATE INDEX commentry_idx ON s9y_comments (entry_id);

/ Duplicate key name 'commentry_idx'

CREATE INDEX commpentry_idx ON s9y_comments (parent_id);

/ Duplicate key name 'commpentry_idx'

CREATE INDEX commtype_idx ON s9y_comments (type);

/ Duplicate key name 'commtype_idx'

CREATE INDEX commstat_idx ON s9y_comments (status);

/ Duplicate key name 'commstat_idx'

CREATE INDEX edraft_idx ON s9y_entries (isdraft);

/ Duplicate key name 'edraft_idx'

CREATE INDEX eauthor_idx ON s9y_entries (authorid);

/ Duplicate key name 'eauthor_idx'

CREATE INDEX refentry_idx ON s9y_references (entry_id);

/ Duplicate key name 'refentry_idx'

CREATE INDEX exits_idx ON s9y_exits (entry_id,day);

/ Duplicate key name 'exits_idx'

CREATE INDEX referrers_idx ON s9y_referrers (entry_id,day);

/ Duplicate key name 'referrers_idx'

CREATE INDEX urllast_idx on s9y_suppress (last);

/ Duplicate key name 'urllast_idx'

CREATE INDEX pluginplace_idx ON s9y_plugins (placement);

/ Duplicate key name 'pluginplace_idx'

CREATE INDEX categorya_idx ON s9y_category (authorid);

/ Duplicate key name 'categorya_idx'

CREATE INDEX categoryp_idx ON s9y_category (parentid);

/ Duplicate key name 'categoryp_idx'

CREATE INDEX categorylr_idx ON s9y_category (category_left, category_right);

/ Duplicate key name 'categorylr_idx'

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

/ Table 's9y_groups' already exists

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

/ Table 's9y_groupconfig' already exists

CREATE INDEX groupid_idx ON s9y_groupconfig (id);

/ Duplicate key name 'groupid_idx'

CREATE INDEX groupprop_idx ON s9y_groupconfig (id, property);

/ Duplicate key name 'groupprop_idx'

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

/ Table 's9y_authorgroups' already exists

CREATE INDEX authorgroup_idxA ON s9y_authorgroups (groupid);

/ Duplicate key name 'authorgroup_idxA'

CREATE INDEX authorgroup_idxB ON s9y_authorgroups (authorid);

/ Duplicate key name 'authorgroup_idxB'

create table s9y_plugincategories (
class_name varchar(250) default null,
category varchar(250) default null
);

/ Table 's9y_plugincategories' already exists

CREATE INDEX plugincat_idx ON s9y_plugincategories(class_name, category);

/ Duplicate key name 'plugincat_idx'

create table s9y_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 's9y_pluginlist' already exists

CREATE INDEX pluginlist_f_idx ON s9y_pluginlist(plugin_file);

/ Duplicate key name 'pluginlist_f_idx'

CREATE INDEX pluginlist_cn_idx ON s9y_pluginlist(class_name);

/ Duplicate key name 'pluginlist_cn_idx'

CREATE INDEX pluginlist_pt_idx ON s9y_pluginlist(plugintype);

/ Duplicate key name 'pluginlist_pt_idx'

CREATE INDEX pluginlist_pl_idx ON s9y_pluginlist(pluginlocation);

/ Duplicate key name 'pluginlist_pl_idx'

create table s9y_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 's9y_access' already exists

CREATE INDEX accessgroup_idx ON s9y_access(groupid);

/ Duplicate key name 'accessgroup_idx'

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

/ Duplicate key name 'accessgroupT_idx'

CREATE INDEX accessforeign_idx ON s9y_access(artifact_id);

/ Duplicate key name 'accessforeign_idx'

[garvinhicking]

Okay, the errors you get is just because of duplicate tables, you can safely ignore that.

The problem with the WYSIWYG editor is a bit harder. How did you configure the tinymce plugin? Did you take all steps described in the plugin to download tinyMCE and put it in your plugins directorY? And did you configure the plugin with the right path?

If you don't give the right path to the tinymce plugin (and pay attention to mod_Rewrite rules - you cannot link directly to the files when using mod_rewrite, but need to put the tinymce stuff into a directory outside the s9y directory or you need to put a .htaccess into your tinymce directory with a "rewriteEngine Off" content)...

Best regards,
Garvin

[Josh]

How did you configure the tinymce plugin? Did you take all steps described in the plugin to download tinyMCE and put it in your plugins directorY? And did you configure the plugin with the right path?

Yes, I downloaded and extracted TinyMCE and copied all files in the directory: serendipity/plugins/serendipity_event_tinymce/tinymce

The directory serendipity_event_tinymce contains the file
serendipity_event_tinymce.php and the directory tinymce.

And the directory tinymce contains the directories docs, examples, jscripts and the files changelog, lgpl.txt, readme, todo.

The relative path stated in configuration screen for the tinymce plugin was automatically set to
serendipity/plugins/serendipity_event_tinymce/tinymce/
Therefore I did not change that.

If you don't give the right path to the tinymce plugin (and pay attention to mod_Rewrite rules - you cannot link directly to the files when using mod_rewrite, but need to put the tinymce stuff into a directory outside the s9y directory or you need to put a .htaccess into your tinymce directory with a "rewriteEngine Off" content)...

Do you refer to the URL rewriting option in the main configuration? There I have enabled the option "use Apache mod rewrite." I guess you mean something else, but I don't know what.

[garvinhicking]

Okay, then please put this .htaccess inside your event_tinymce directory:

Code: Select all

RewriteEngine Off

And then please adjust (or check) the URL of the tinymce plugin. It seems to not fetch the right JS file.

If it doesn'T work please view the HTML source of your edit entries screen and search for the <script src=> tag where tinymce is loaded, and call exactly that URL via HTTP to see if it exists.

Regards,
Garvin