6.0.0-beta1
11/27/25

[#9710] DB schema is out of date
Summary DB schema is out of date
Queue IMP
Queue Version Git master
Type Bug
State Duplicate
Priority 1. Low
Owners
Requester horde (at) heskia (dot) net
Created 03/24/2011 (5362 days ago)
Due
Updated 09/29/2011 (5173 days ago)
Assigned 03/25/2011 (5361 days ago)
Resolved 04/21/2011 (5334 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
09/29/2011 01:03:00 PM macristo (at) gmx (dot) net Comment #13 Reply to this comment
BTW: some more info:

root@vm03:/var/www/horde/scripts/upgrades# php -v
PHP 5.3.3-7+squeeze3 with Suhosin-Patch (cli) (built: Jun 28 2011 13:13:26)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
     with Suhosin v0.9.32.1, Copyright (c) 2007-2010, by SektionEins GmbH
root@vm03:/var/www/horde/scripts/upgrades# mysql --version
mysql  Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (i486) using 
readline 6.1

and using mysql or mysqli doesn't solve the problem that the last 
login time isn't updated.
09/29/2011 12:51:29 PM macristo (at) gmx (dot) net Comment #12 Reply to this comment

[Show Quoted Text - 14 lines]
I had the same problem too, I resolved it by adding 1 dummy record in 
the imp_schema_info table, after that I clicked again on the link: DB 
Schema is out of date, and after that it said that all db Schema's are 
ready...

But I see a new problem: If I use DB storage for session handling, 
then the last login time isn't updated between sessions.
I will open a ticket for that.
04/22/2011 01:41:04 PM Michael Rubinsky Comment #11 Reply to this comment
Sorry, didn't you say the db error goes away when the port setting was 
removed? Is that no longer the case then? What db errors are you 
getting now?
04/22/2011 07:38:22 AM horde (at) heskia (dot) net Comment #10 Reply to this comment
MySQL is setup to use mysqli in Horde configuration
when I turn it to "MySQL" only then I got an error stating that the
port should not be mention in the conf.php. If I remove the line
$conf['sql']['port'] = 3306;
This sounds like duplicate of Bug: 9738
I don't think so... I have setup socket connection to mysql :
   $conf['sql']['username'] = 'horde';
   $conf['sql']['password'] = '********';
   $conf['sql']['socket'] = '/var/run/mysqld/mysqld.sock';
   $conf['sql']['protocol'] = 'unix';
   $conf['sql']['database'] = 'horde';
   $conf['sql']['charset'] = 'utf-8';
   $conf['sql']['splitread'] = false;
   $conf['sql']['ssl'] = false;
   $conf['sql']['phptype'] = 'mysqli';

I have been able to investigate a bit more in this issue and it 
happens only if I set MySQL as the sessionhandler backend. If I let 
the PHP default (file) choice then access to the DB is working fine.
Why this was working in H3/IMP4 and no more in H5/IMP4 ?
04/21/2011 02:18:36 PM Michael Rubinsky Comment #9
Version ⇒ Git master
State ⇒ Duplicate
Reply to this comment
MySQL is setup to use mysqli in Horde configuration
when I turn it to "MySQL" only then I got an error stating that the 
port should not be mention in the conf.php. If I remove the line
$conf['sql']['port'] = 3306;
This sounds like duplicate of Bug: 9738
in my conf.php file then horde is working again but IMP complains 
that it cannot access the IMAP server...
Sounds like a configuration issue.

Please use the mailing list to ask for additional support.

http://www.horde.org/mail/ contains a list of all available mailing lists.
03/29/2011 09:08:59 AM horde (at) heskia (dot) net Comment #8 Reply to this comment
Hi again,

I made several test and now I can confirm that any update on any table 
is not working except:
horde_cache
horde_sessionshandlers
It seems that I am facing an issue with some mysql connections.
MySQL is setup to use mysqli in Horde configuration
when I turn it to "MySQL" only then I got an error stating that the 
port should not be mention in the conf.php. If I remove the line
$conf['sql']['port'] = 3306;
in my conf.php file then horde is working again but IMP complains that 
it cannot access the IMAP server...
I don't understand what happens here...
the Horde3/IMP4 used to work pretty well on this server (until I 
upgraded to php 5.3.5)...

03/28/2011 03:43:41 PM horde (at) heskia (dot) net Comment #7
New Attachment: conf_log.zip Download
Reply to this comment
The attachment has not been saved correctly... Here it is

Also, I have noted lot of PHP ERROR in the log file.
Is Horde compliant with php5.3.5 ?
I am also running MySQL 5.1.51
03/28/2011 03:37:54 PM horde (at) heskia (dot) net Comment #6 Reply to this comment
I do not see erro in MySQL especially at all !

I have attached a dump of my horde and imp conf.php files in the 
ticket. As you can see MySQL is correctly setup (and we can see access 
in the log files i have joined to my previous message).

any idea ?
03/28/2011 01:36:58 PM Michael Rubinsky Comment #5 Reply to this comment
weird. This works fine for me here.

Any errors in the mysql log? Are you 100% sure the database horde is 
set to use is the same that you are dumping?
03/28/2011 01:21:51 PM horde (at) heskia (dot) net Comment #4
New Attachment: horde.zip Download
Reply to this comment
Hi Michael,

Sorry for this late answer...

So yes the conf.php file is set to use SQL.
In the ZIP attachment there are 2 files
horde.sql: SQL export ==> you will see the export for my 
imp_schema_info table has been created but is empty.
horde_updateDBSchema.log: extract of the log file ==> You will see the 
following line nr 1689:
2011-03-28T14:44:48+02:00 DEBUG: HORDE [horde] SQL  (0,0001s)
        UPDATE imp_schema_info SET version = 1 [pid 20838 on line 773 of 
"/usr/share/php/Horde/Db/Adapter/Base.php"]
But the database has not been updated !

What happens ?

Thanks for your support,
Antoine.
03/25/2011 06:28:01 PM Michael Rubinsky Comment #3
State ⇒ Feedback
Reply to this comment
What is the content of imp's schema table?

Have you verified that the horde config is still setup to use the sql 
prefs backend? Any errors in the log(s)?
03/24/2011 06:34:39 PM horde (at) heskia (dot) net Comment #2 Reply to this comment
Hi Again,

I do not know if this is linked to this bug, but since I installed 
IMP, the user preferences are no longer stored in the horde_pref table.
for instance, the "last login" entry is no more updated for existing 
users nor created for new users !
My environment:
gentoo linux
php 5.3.5
mysql 5.1.51
03/24/2011 05:39:43 PM horde (at) heskia (dot) net Comment #1
Priority ⇒ 1. Low
State ⇒ Unconfirmed
Patch ⇒ No
Milestone ⇒
Queue ⇒ IMP
Summary ⇒ DB schema is out of date
Type ⇒ Bug
Reply to this comment
I have just installed Horde4/IMP5 RC1
The horde DB has been created from the Horde configuration browser window.
I have now installed IMP and configured it.
The configuration window mentions that DB Schema is out of date and so 
I have the "Update DB" button.
If I click on it, evreything is going fine (I can see the to imp 
tables in my horde DB : imp_schema_info and imp_sentmail), but the 
configuration window still complains that the DB schema is out of date.

How to solve this bug ?

Thanks for your support,
Antoine

Saved Queries