[horde] Fresh Install following the Horde Project install Page

[Jan Schneider]

Zitat von L. D. James <ljames at apollo3.com>:

> On 08/11/2014 03:28 AM, L. D. James wrote:
>> I'm trying to install Horde using the Pear/Quick Install.  I can't  
>> get past step 8 under Quick Install.
>>
>> I click on database, fill out the access information.  Every thing  
>> appears to work.  But the next time I click on something I get a  
>> text screen that gives the errors posted below.
>>
>> It's obvious that the needed tables for the database are missing.  
>> However, I can't figure out how to get them in.  The instructions  
>> says "Click Update All DB Schemas."
>>
>> However I can't figure out how to get to that option.  After I get  
>> past inputing the database information, the next click gives the  
>> error.
>>
>> Is there a script somewhere that I can manually run that will  
>> create the table?
>>
>> Thanks in advance for any help.
>>
>> Error message when clicking the horde link:
>> A fatal error has occurred
>>
>> SQLSTATE[42S02]: Base table or view not found: 1146 Table  
>> 'horde.horde_prefs' doesn't exist
>>
>> 1. Horde_Themes_Image::tag()  
>> /usr/share/php/www/horde/admin/config/index.php:142
>> 2. Horde_Themes_Image::base64ImgData()  
>> /usr/share/php/Horde/Themes/Image.php:99
>> 3. Horde_Themes_Image->__get() /usr/share/php/Horde/Themes/Image.php:137
>> 4. Horde_Themes_Element->__get() /usr/share/php/Horde/Themes/Image.php:44
>> 5. Horde_Prefs->getValue() /usr/share/php/Horde/Themes/Element.php:122
>> 6. Horde_Prefs->_getScope() /usr/share/php/Horde/Prefs.php:253
>> 7. Horde_Prefs->_loadScope() /usr/share/php/Horde/Prefs.php:346
>> 8. Horde_Prefs_Storage_Sql->get() /usr/share/php/Horde/Prefs.php:416
>> 9. Horde_Themes_Image::tag()  
>> /usr/share/php/www/horde/admin/config/index.php:142
>> 10. Horde_Themes_Image::base64ImgData()  
>> /usr/share/php/Horde/Themes/Image.php:99
>> 11. Horde_Themes_Image->__get() /usr/share/php/Horde/Themes/Image.php:137
>> 12. Horde_Themes_Element->__get() /usr/share/php/Horde/Themes/Image.php:44
>> 13. Horde_Prefs->getValue() /usr/share/php/Horde/Themes/Element.php:122
>> 14. Horde_Prefs->_getScope() /usr/share/php/Horde/Prefs.php:253
>> 15. Horde_Prefs->_loadScope() /usr/share/php/Horde/Prefs.php:346
>> 16. Horde_Prefs_Storage_Sql->get() /usr/share/php/Horde/Prefs.php:416
>> 17. Horde_Db_Adapter_Pdo_Base->selectAll()  
>> /usr/share/php/Horde/Prefs/Storage/Sql.php:74
>> 18. Horde_Db_Adapter_Pdo_Base->execute()  
>> /usr/share/php/Horde/Db/Adapter/Pdo/Base.php:109
>> 19. Horde_Themes_Image::tag()  
>> /usr/share/php/www/horde/admin/config/index.php:142
>> 20. Horde_Themes_Image::base64ImgData()  
>> /usr/share/php/Horde/Themes/Image.php:99
>> 21. Horde_Themes_Image->__get() /usr/share/php/Horde/Themes/Image.php:137
>> 22. Horde_Themes_Element->__get() /usr/share/php/Horde/Themes/Image.php:44
>> 23. Horde_Prefs->getValue() /usr/share/php/Horde/Themes/Element.php:122
>> 24. Horde_Prefs->_getScope() /usr/share/php/Horde/Prefs.php:253
>> 25. Horde_Prefs->_loadScope() /usr/share/php/Horde/Prefs.php:346
>> 26. Horde_Prefs_Storage_Sql->get() /usr/share/php/Horde/Prefs.php:416
>> 27. Horde_Db_Adapter_Pdo_Base->selectAll()  
>> /usr/share/php/Horde/Prefs/Storage/Sql.php:74
>> 28. Horde_Db_Adapter_Pdo_Base->execute()  
>> /usr/share/php/Horde/Db/Adapter/Pdo/Base.php:109
>> 29. PDO->query() /usr/share/php/Horde/Db/Adapter/Pdo/Base.php:201
>>
>> -- L. James
>>
> I'm wondering if the fact that the system is looking for a table  
> named "horde.horde_prefs" instead of "horde_prefs" is making a  
> difference.  Checking my horde database I see the following tables:
>
> Database changed
> mysql> show tables;
> --------------------------------------------------------------------
> +----------------------------------+
> | Tables_in_horde                  |
> +----------------------------------+
> | horde_activesync_schema_info     |
> | horde_alarm_schema_info          |
> | horde_auth_schema_info           |
> | horde_cache_schema_info          |
> | horde_core_schema_info           |
> | horde_dav_schema_info            |
> | horde_group_schema_info          |
> | horde_history_schema_info        |
> | horde_imap_client_schema_info    |
> | horde_lock_schema_info           |
> | horde_perms_schema_info          |
> | horde_prefs_schema_info          |
> | horde_queue_schema_info          |
> | horde_sessionhandler_schema_info |
> | horde_syncml_schema_info         |
> | horde_token_schema_info          |
> | horde_vfs_schema_info            |
> +----------------------------------+
> 17 rows in set (0.00 sec)
>
> mysql> describe horde_prefs_schema_info;
> +---------+---------+------+-----+---------+-------+
> | Field   | Type    | Null | Key | Default | Extra |
> +---------+---------+------+-----+---------+-------+
> | version | int(11) | YES  |     | NULL    |       |
> +---------+---------+------+-----+---------+-------+
> 1 row in set (0.00 sec)
>
> mysql>
>
> ----------------------------------------------------------------------
>
> Is there a way to configure horde so that it will look for the  
> tables the way they are actually configured by the default install?
>
> -- L. James
>
> -- 
> L. D. James
> ljames at apollo3.com
> www.apollo3.com/~ljames

Don't use the quick install, if it doesn't work for you.

-- 
Jan Schneider
The Horde Project
http://www.horde.org/
https://www.facebook.com/hordeproject