[horde] Huge problems on fresh install of Horde Groupware.

[maillist]

We've had an older version of Horde for a long time, and when it became
necessary to upgrade, upgrading became impossible thanks to having to
skip over too many major versions. 

So I created a whole new space for Horde 5, and followed the
instructions for installing it through PEAR, found at
http://www.horde.org/apps/horde/docs/INSTALL 

The problems started when I came to this step:

Creating databases 

Once you created the database configuration in the previous step, you
can create all database tables by hitting the Update all DB schemas
button in the configuration screen. 

The database "horde5" had already been created, along with the user and
the password. Apparently, creating the database failed somewhere during
the process, and now I get the error at the end of my post.

Dropping the database and starting anew has done nothing to solve this
problem. Neither has re-creating the username and password, or scrubbing
the Horde config file and starting over. I would *like* to be able to
set up the database schema manually through MySQL, but I can't find any
way of doing that, or database tables for MySQL anywhere in the
installed code.

QUERY FAILED: TABLE 'HORDE5.HORDE_PREFS' DOESN'T EXIST SELECT PREF_NAME,
PREF_VALUE FROM HORDE_PREFS WHERE PREF_UID = 'ADMINISTRATOR' AND
PREF_SCOPE = 'HORDE'

 1. Horde_Registry::appInit()
/home/webmail.lightspeed.ca/public_html/horde5/index.php:20
 2. Horde_Registry->pushApp() /usr/share/php/Horde/Registry.php:290
 3. Horde_Registry->setLanguageEnvironment()
/usr/share/php/Horde/Registry.php:1577
 4. Horde_Registry->setLanguage() /usr/share/php/Horde/Registry.php:2829
 5. Horde_Registry->preferredLang()
/usr/share/php/Horde/Registry.php:2781
 6. Horde_Prefs->getValue() /usr/share/php/Horde/Registry.php:2713
 7. Horde_Prefs->_getScope() /usr/share/php/Horde/Prefs.php:253
 8. Horde_Prefs->_loadScope() /usr/share/php/Horde/Prefs.php:346
 9. Horde_Prefs_Storage_Sql->get() /usr/share/php/Horde/Prefs.php:416
10. Horde_Registry::appInit()
/home/webmail.lightspeed.ca/public_html/horde5/index.php:20
11. Horde_Registry->pushApp() /usr/share/php/Horde/Registry.php:290
12. Horde_Registry->setLanguageEnvironment()
/usr/share/php/Horde/Registry.php:1577
13. Horde_Registry->setLanguage() /usr/share/php/Horde/Registry.php:2829
14. Horde_Registry->preferredLang()
/usr/share/php/Horde/Registry.php:2781
15. Horde_Prefs->getValue() /usr/share/php/Horde/Registry.php:2713
16. Horde_Prefs->_getScope() /usr/share/php/Horde/Prefs.php:253
17. Horde_Prefs->_loadScope() /usr/share/php/Horde/Prefs.php:346
18. Horde_Prefs_Storage_Sql->get() /usr/share/php/Horde/Prefs.php:416
19. Horde_Db_Adapter_Mysqli->selectAll()
/usr/share/php/Horde/Prefs/Storage/Sql.php:74
20. Horde_Db_Adapter_Mysqli->execute()
/usr/share/php/Horde/Db/Adapter/Mysqli.php:220

DETAILS

THE FULL ERROR MESSAGE IS LOGGED IN HORDE'S LOG FILE, AND IS SHOWN BELOW
ONLY TO ADMINISTRATORS. NON-ADMINISTRATIVE USERS WILL NOT SEE ERROR
DETAILS.

Horde_Prefs_Exception Object
(
 [details] => 
 [logged] => 1
 [_logLevel:protected] => 0
 [message:protected] => QUERY FAILED: Table 'horde5.horde_prefs' doesn't
exist

SELECT pref_name, pref_value FROM horde_prefs WHERE pref_uid =
'Administrator' AND pref_scope = 'horde'
 [string:Exception:private] => 
 [code:protected] => 1146
 [file:protected] => /usr/share/php/Horde/Prefs/Storage/Sql.php
 [line:protected] => 77
 [trace:Exception:private] => Array
 (
 [0] => Array
 (
 [file] => /usr/share/php/Horde/Prefs.php
 [line] => 416
 [function] => get
 [class] => Horde_Prefs_Storage_Sql
 [type] => ->
 [args] => Array
 (
 [0] => Horde_Prefs_Scope Object
 (
 [init] => 1
 [scope] => horde
 [_dirty:protected] => Array
 (
 )

 [_prefs:protected] => Array
 (
 [id] => 
 [fullname] => 
 [from_addr] => 
 [location] => 
 [default_identity] => 0
 [identities] => a:0:{}
 [confirm_email] => a:0:{}
 [security_question] => 
 [security_answer] => 
 [alternate_email] => 
 [language] => 
 [sending_charset] => Array
 (
 [v] => UTF-8
 [l] => 1
 )

 [timezone] => 
 [twentyFour] => 
 [date_format] => %x
 [date_format_mini] => %x
 [time_format] => %X
 [first_week_day] => 0
 [categories] => 
 [category_colors] => 
 [initial_application] => horde
 [show_last_login] => 1
 [last_login] => a:0:{}
 [theme] => default
 [summary_refresh_time] => 300
 [sidebar_width] => 210
 [menu_refresh_time] => 300
 [widget_accesskey] => 1
 [portal_layout] => a:0:{}
 [facebook] => a:0:{}
 [twitter] => a:0:{}
 [imsp_auth_user] => 
 [imsp_auth_pass] => 
 [activesync_replyposition] => bottom
 [last_logintasks] => a:0:{}
 [upgrade_tasks] => a:0:{}
 )

 )

 )

 )

 [1] => Array
 (
 [file] => /usr/share/php/Horde/Prefs.php
 [line] => 346
 [function] => _loadScope
 [class] => Horde_Prefs
 [type] => ->
 [args] => Array
 (
 [0] => horde
 )

 )

 [2] => Array
 (
 [file] => /usr/share/php/Horde/Prefs.php
 [line] => 253
 [function] => _getScope
 [class] => Horde_Prefs
 [type] => ->
 [args] => Array
 (
 [0] => language
 )

 )

 [3] => Array
 (
 [file] => /usr/share/php/Horde/Registry.php
 [line] => 2713
 [function] => getValue
 [class] => Horde_Prefs
 [type] => ->
 [args] => Array
 (
 [0] => language
 )

 )

 [4] => Array
 (
 [file] => /usr/share/php/Horde/Registry.php
 [line] => 2781
 [function] => preferredLang
 [class] => Horde_Registry
 [type] => ->
 [args] => Array
 (
 )

 )

 [5] => Array
 (
 [file] => /usr/share/php/Horde/Registry.php
 [line] => 2829
 [function] => setLanguage
 [class] => Horde_Registry
 [type] => ->
 [args] => Array
 (
 [0] => 
 )

 )

 [6] => Array
 (
 [file] => /usr/share/php/Horde/Registry.php
 [line] => 1577
 [function] => setLanguageEnvironment
 [class] => Horde_Registry
 [type] => ->
 [args] => Array
 (
 [0] => 
 [1] => horde
 )

 )

 [7] => Array
 (
 [file] => /usr/share/php/Horde/Registry.php
 [line] => 290
 [function] => pushApp
 [class] => Horde_Registry
 [type] => ->
 [args] => Array
 (
 [0] => horde
 [1] => Array
 (
 [check_perms] => 
 [logintasks] => 
 [notransparent] => 
 )

 )

 )

 [8] => Array
 (
 [file] => /home/webmail.lightspeed.ca/public_html/horde5/index.php
 [line] => 20
 [function] => appInit
 [class] => Horde_Registry
 [type] => ::
 [args] => Array
 (
 [0] => horde
 [1] => Array
 (
 [authentication] => none
 [nologintasks] => 1
 )

 )

 )

 )

 [previous:Exception:private] => Horde_Db_Exception Object
 (
 [details] => 
 [logged] => 
 [_logLevel:protected] => 0
 [message:protected] => QUERY FAILED: Table 'horde5.horde_prefs' doesn't
exist

SELECT pref_name, pref_value FROM horde_prefs WHERE pref_uid =
'Administrator' AND pref_scope = 'horde'
 [string:Exception:private] => 
 [code:protected] => 1146
 [file:protected] => /usr/share/php/Horde/Db/Adapter/Mysqli.php
 [line:protected] => 316
 [trace:Exception:private] => Array
 (
 [0] => Array
 (
 [file] => /usr/share/php/Horde/Db/Adapter/Mysqli.php
 [line] => 220
 [function] => execute
 [class] => Horde_Db_Adapter_Mysqli
 [type] => ->
 [args] => Array
 (
 [0] => SELECT pref_name, pref_value FROM horde_prefs WHERE pref_uid = ?
AND pref_scope = ?
 [1] => Array
 (
 [0] => Administrator
 [1] => horde
 )

 [2] => 
 )

 )

 [1] => Array
 (
 [file] => /usr/share/php/Horde/Prefs/Storage/Sql.php
 [line] => 74
 [function] => selectAll
 [class] => Horde_Db_Adapter_Mysqli
 [type] => ->
 [args] => Array
 (
 [0] => SELECT pref_name, pref_value FROM horde_prefs WHERE pref_uid = ?
AND pref_scope = ?
 [1] => Array
 (
 [0] => Administrator
 [1] => horde
 )

 )

 )

 [2] => Array
 (
 [file] => /usr/share/php/Horde/Prefs.php
 [line] => 416
 [function] => get
 [class] => Horde_Prefs_Storage_Sql
 [type] => ->
 [args] => Array
 (
 [0] => Horde_Prefs_Scope Object
 (
 [init] => 1
 [scope] => horde
 [_dirty:protected] => Array
 (
 )

 [_prefs:protected] => Array
 (
 [id] => 
 [fullname] => 
 [from_addr] => 
 [location] => 
 [default_identity] => 0
 [identities] => a:0:{}
 [confirm_email] => a:0:{}
 [security_question] => 
 [security_answer] => 
 [alternate_email] => 
 [language] => 
 [sending_charset] => Array
 (
 [v] => UTF-8
 [l] => 1
 )

 [timezone] => 
 [twentyFour] => 
 [date_format] => %x
 [date_format_mini] => %x
 [time_format] => %X
 [first_week_day] => 0
 [categories] => 
 [category_colors] => 
 [initial_application] => horde
 [show_last_login] => 1
 [last_login] => a:0:{}
 [theme] => default
 [summary_refresh_time] => 300
 [sidebar_width] => 210
 [menu_refresh_time] => 300
 [widget_accesskey] => 1
 [portal_layout] => a:0:{}
 [facebook] => a:0:{}
 [twitter] => a:0:{}
 [imsp_auth_user] => 
 [imsp_auth_pass] => 
 [activesync_replyposition] => bottom
 [last_logintasks] => a:0:{}
 [upgrade_tasks] => a:0:{}
 )

 )

 )

 )

 [3] => Array
 (
 [file] => /usr/share/php/Horde/Prefs.php
 [line] => 346
 [function] => _loadScope
 [class] => Horde_Prefs
 [type] => ->
 [args] => Array
 (
 [0] => horde
 )

 )

 [4] => Array
 (
 [file] => /usr/share/php/Horde/Prefs.php
 [line] => 253
 [function] => _getScope
 [class] => Horde_Prefs
 [type] => ->
 [args] => Array
 (
 [0] => language
 )

 )

 [5] => Array
 (
 [file] => /usr/share/php/Horde/Registry.php
 [line] => 2713
 [function] => getValue
 [class] => Horde_Prefs
 [type] => ->
 [args] => Array
 (
 [0] => language
 )

 )

 [6] => Array
 (
 [file] => /usr/share/php/Horde/Registry.php
 [line] => 2781
 [function] => preferredLang
 [class] => Horde_Registry
 [type] => ->
 [args] => Array
 (
 )

 )

 [7] => Array
 (
 [file] => /usr/share/php/Horde/Registry.php
 [line] => 2829
 [function] => setLanguage
 [class] => Horde_Registry
 [type] => ->
 [args] => Array
 (
 [0] => 
 )

 )

 [8] => Array
 (
 [file] => /usr/share/php/Horde/Registry.php
 [line] => 1577
 [function] => setLanguageEnvironment
 [class] => Horde_Registry
 [type] => ->
 [args] => Array
 (
 [0] => 
 [1] => horde
 )

 )

 [9] => Array
 (
 [file] => /usr/share/php/Horde/Registry.php
 [line] => 290
 [function] => pushApp
 [class] => Horde_Registry
 [type] => ->
 [args] => Array
 (
 [0] => horde
 [1] => Array
 (
 [check_perms] => 
 [logintasks] => 
 [notransparent] => 
 )

 )

 )

 [10] => Array
 (
 [file] => /home/webmail.lightspeed.ca/public_html/horde5/index.php
 [line] => 20
 [function] => appInit
 [class] => Horde_Registry
 [type] => ::
 [args] => Array
 (
 [0] => horde
 [1] => Array
 (
 [authentication] => none
 [nologintasks] => 1
 )

 )

 )

 )

 [previous:Exception:private] => 
 )

)