Horde - "Undefined index: ..." error.

[denisdekat09]

Hello,

I just moved an account from one server to another.

Horde is showing this error when the user logs in.:

A fatal error has occurred:

DB Error: connect failed

[line 108 of /usr/local/cpanel/base/horde/lib/Prefs/sql.php]

Details have been logged for the administrator.

Then in the inbox I see this one:

Notice: Undefined index: direct_access in /usr/local/cpanel/base/horde/imp/templates/menu/menu.inc on line 53

I found several threads on this subject:

http://forums.cpanel.net/showthread....ndefined+index
this one sugests I try

1) chown -R cpanel:cpanel horde/
2) look into your /home/usrname/etc folder and open all the files there in any editor fix the path to the home folders

http://forums.cpanel.net/showthread....ndefined+index
this one sugests I try

1) chown -R cpanel:cpanel horde/
2) /scripts/upcp --force

http://forums.cpanel.net/showthread....ndefined+index
this one sugests I try

1) chown -R cpanel:cpanel horde/
2) change versions then /scripts/upcp

http://forums.cpanel.net/showthread....ndefined+index
This one said
1) reboot

http://forums.cpanel.net/showthread....ndefined+index
This one said

1) exit IE and re-enter

I have tired all of these but rebooting with no succes yet. Several upcps, fixwebmail, rebuildhorde, fullhordereset...

Does anyone know if there is one official fix for this? So far it seems like loads of folks are suffering from this...

[denisdekat09]

got an answer form Cpanel:

Usually this is because the horde db doesn't exists. You can confirm this by doing the following from the command line:

[~]# mysql horde

If it does not exist, you will see:

ERROR 1049: Unknown database 'horde'


If this is the case, run the following:

[~]# mysqladmin create horde
[~]# /scripts/fullhordereset

It worked and fixed it for me

[Optical]

this resolved the issue for me thanks

[BLazeD]

OK I just tried that and it removed this error:

A fatal error has occurred:

DB Error: connect failed

[line 108 of /usr/local/cpanel/base/horde/lib/Prefs/sql.php]

Details have been logged for the administrator.

However, this one still remains:

Notice: Undefined index: direct_access in /usr/local/cpanel/base/horde/imp/templates/menu/menu.inc on line 53

Any ideas?

[snide]

I'm having this same issue as well. Fixed the DB errors, and now see the "Notice: Undefined index: direct_access in /usr/local/cpanel/base/horde/imp/templates/menu/menu.inc on line 53"

[c0bra]

Same here. Anyone got a fix?

[Optical]

would you like me to take a look any one? just contact me if so http://opticalnet.us/contact/

[Sash]

Same problem. Anyone have a fix?

Mike

[TySoft]

<-- Another with the problem. Some idea would be appreciated. I'm stumped. It's related to the logout function.

[internetfab]

1. Open WHM for the server
2. Click on Change a User or Database Password under mysql
3. Look up the horde database (if it's not there, do what denisdekat09 wrote in this thread)
4. Change password to the one you got from the /scripts/fullresethorde command
5. Log out of horde if you were logged in.

That should do it.

[mjost]

Setting

$conf['debug_level'] = E_ERROR;

in /usr/local/cpanel/base/horde/config/horde.php will prevent the error

Notice: Undefined index: direct_access in /usr/local/cpanel/base/horde/imp/templates/menu/menu.inc on line 53

to be displayed

[Sheldon]

I did that mysqladmin create horde then the full horde reset and that worked wonderfully.. no errors what so ever now..

Thanks people!
Sheldon

PS... I wonder why all of us had this problem at the same time!

[wizade]

Originally posted by mjost
Setting
in /usr/local/cpanel/base/horde/config/horde.php will prevent the error to be displayed

Hi gang,
mjost has the right idea. This error message is simply a notice from PHP. It comes from sloppy code in the file:
/usr/local/cpanel/base/horde/imp/templates/menu/menu.inc

The line in question (line 53 for me) looks like this:
if ($registry->getMethod('auth/logout') == 'imp' && !$imp['direct_access']) {

PHP is griping because $imp['direct_access'] isn't a valid array index and whoever coded this didn't think to test the variable first. You can safely test the variable to see if it exists using the isset() function. Simply alter the line to make it look like this:
if ($registry->getMethod('auth/logout') == 'imp' && !isset($imp['direct_access'])) {

Notice the only change I made was wrapping the $imp['direct_access']) in the !isset() function. Remember, before you mess with the code, make sure you have a backup in case you accidentally bork something up.

[jameshsi]

This thread really helps,tks.

[myusername]

Here is the quickest way to fix this without editing files.

# Fix the original issue with the database.

A fatal error has occurred:

DB Error: connect failed

[line 108 of /usr/local/cpanel/base/horde/lib/Prefs/sql.php]

Details have been logged for the administrator.

mysqladmin create horde
/scripts/fullhordereset

# Get rid of the error on the top of the pages

Notice: Undefined index: direct_access in /usr/local/cpanel/base/horde/imp/templates/menu/menu.inc on line 53

(Courtesy Kyle cPanel support)

cd /usr/local/cpanel
rm cpanel
/scripts/updatenow
/scripts/upcp

The above resyncs cPanel/WHM.

Good luck.