[horde] Fresh Install following the Horde Project install Page

L. D. James ljames at apollo3.com
Mon Aug 11 09:19:11 UTC 2014


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


More information about the horde mailing list