[horde] horde_prefs table doesn't exist...

[Arjen de Korte]

Citeren Michael Robinson <plug_1 at robinson-west.com>:

> On Wed, 2015-01-14 at 10:11 +0100, Arjen de Korte wrote:
>> Citeren Michael Robinson <plug_1 at robinson-west.com>:
>>
>> > A fatal error has occurred
>> > SQLSTATE[42S02]: Base table or view not found: 1146 Table
>> > 'horde.horde_prefs' doesn't exist
>> >
>> >  1. Horde_Prefs->getValue() /var/www/horde5/index.php:62
>> >  2. Horde_Prefs->_getScope() /usr/lib/php/Horde/Prefs.php:253
>> >  3. Horde_Prefs->_loadScope() /usr/lib/php/Horde/Prefs.php:346
>> >  4. Horde_Prefs_Storage_Sql->get() /usr/lib/php/Horde/Prefs.php:416
>> >  5. Horde_Prefs->getValue() /var/www/horde5/index.php:62
>> >  6. Horde_Prefs->_getScope() /usr/lib/php/Horde/Prefs.php:253
>> >  7. Horde_Prefs->_loadScope() /usr/lib/php/Horde/Prefs.php:346
>> >  8. Horde_Prefs_Storage_Sql->get() /usr/lib/php/Horde/Prefs.php:416
>> >  9. Horde_Db_Adapter_Pdo_Base->selectAll()
>> > /usr/lib/php/Horde/Prefs/Storage/Sql.php:74
>> > 10. Horde_Db_Adapter_Pdo_Base->execute()
>> > /usr/lib/php/Horde/Db/Adapter/Pdo/Base.php:109
>> > 11. Horde_Prefs->getValue() /var/www/horde5/index.php:62
>> > 12. Horde_Prefs->_getScope() /usr/lib/php/Horde/Prefs.php:253
>> > 13. Horde_Prefs->_loadScope() /usr/lib/php/Horde/Prefs.php:346
>> > 14. Horde_Prefs_Storage_Sql->get() /usr/lib/php/Horde/Prefs.php:416
>> > 15. Horde_Db_Adapter_Pdo_Base->selectAll()
>> > /usr/lib/php/Horde/Prefs/Storage/Sql.php:74
>> > 16. Horde_Db_Adapter_Pdo_Base->execute()
>> > /usr/lib/php/Horde/Db/Adapter/Pdo/Base.php:109
>> > 17. PDO->query() /usr/lib/php/Horde/Db/Adapter/Pdo/Base.php:201
>> >
>> > I have specifically attempted to set up mariadb just for the preferences
>> > not knowing how to get my postgresql database to store them.  Same
>> > problem, the table doesn't get created and the preferences aren't
>> > written out.  I have blown a whole day on this :-(
>>
>> Again, what does 'horde-db-migrate' report about the status of the
>> tables? If they don't exist, this will create them for you, provided
>> that (in your case) the 'horde' database exists and the user you
>> configured has sufficient rights on your database to do so.
>>
>> --
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
> The horde-db-migrate script tells me nothing.

Exactly *what* does it report?

> Is there a way to get
> more information about what happened afterwards?

After *what* event?

> I'm trying to figure
> out if I have the permission to create the table, but I'm not terribly
> familiar with MariaDB.

That's outside the scope of Horde. I suggest to read up on either  
PostgreSQL or MySQL/MariaDB to get familiar with creating databases  
and granting access permissions to database users.

-- 
This message was sent from a mailinglist subscription address.
For off-list replies, you must remove the address extension.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 11647 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/horde/attachments/20150114/c33017e6/attachment.bin>