Error in Page manager, version 2.9

[pieter]

Below the error report when I try to edit a page in the Page manager.
It is a fresh installation of SyndeoCMS 2.9.00.
What could be wrong?

Another question: there are two editors installed: fckeditor and sn_plain.
In earlier release I could choose the preferred editor. Is this not possible anymore?

Pieter

mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 20
Url: http://www.XXX.nl/cms/starnet/index.php?option=pagemanager&suboption=editpage&page=1§ion=1&site=
Backtrace:
#0: myErrHandler(())
#1: mysql_result(/home/zomerschool/public_html/cms/starnet/core/pagemanager.inc.php(164))
#2: include(/home/zomerschool/public_html/cms/starnet/index.php(176))

include(editors/) [function.include]: failed to open stream: No such file or directory
Url: http://www.XXX.nl/cms/starnet/index.php?option=pagemanager&suboption=editpage&page=1§ion=1&site=
Backtrace:
#0: myErrHandler(())
#1: include(/home/zomerschool/public_html/cms/starnet/core/pagemanager.inc.php(168))
#2: include(/home/zomerschool/public_html/cms/starnet/index.php(176))


include() [function.include]: Failed opening 'editors/' for inclusion (include_path='.:/usr/share/pear:/usr/share/php')
Url: http://www.XXX.nl/cms/starnet/index.php?option=pagemanager&suboption=editpage&page=1§ion=1&site=
Backtrace:
#0: myErrHandler(())
#1: include(/home/zomerschool/public_html/cms/starnet/core/pagemanager.inc.php(168))
#2: include(/home/zomerschool/public_html/cms/starnet/index.php(176))

[Fred Stuurman]

Pieter,
Do you have a table syn_editors? It looks like this table was not created or empty?

The editor choice has been removed accidently, I have to put it back.

[pieter]

Yes, this table syn_editors exists.

These are the two records:
1     FCKEditor     fckeditor/editor.php     
2    Plain text Editor    sn_plain/editor.php
(id, name, location, description)

[pieter]

Hi Fred,

The error occurs in core/pagemanager.inc.php. Check these lines:

  $query = "SELECT location FROM $table_editors WHERE id = '".$_SESSION['editor']."'";
  $result = mysql_query($query) or trigger_error(mysql_error().'"<br>Query : "' . $query . '".',E_USER_WARNING);
  $editor_loc = mysql_result($result, 0);

In my situation:
$query = "SELECT location FROM syn_editors WHERE id = '0' ".

This query searchs in record 0 in the table syn_editors. But the first record is number 1.
This value zero is the result of the variabe $_SESSION['editor'];

Where is $_SESSION['editor'] changed and should this value be 1 ?

One more thing:
the version number is 2.8 and not 2.9 in starnet/index.php, syndeo_check, ....

Pieter

[Fred Stuurman]

Pieter,
I think the editor value is wrong in the users record in syn_users.
Try this zip and then you can change the editor for the user again.
Save it once and I think it should work again.

[pieter]

Fred,

This is correct. This invalid value in the table syn_users is adjusted.
And now everything works fine.
Thank you!