Hello all,
Firstly - Thank you for creating and maintaining such a fine example of open source software. Your efforts are appreciated, and help us out greatly. But, to get to the reason for my being here today..
We are currently running Owl 0.94 on a SLES 10 server. I'd like to migrate that to a SLES 11 server and upgrade to 1.0. So far, I've ran into several issues.
I saw in a post a week ago about how there might be some tables and columns missing from the database when using the mysql-from-0.90.sql. I was curious if I could get a fix for that? Or at least some details? :)
Thus far, even migrating the same exact DB with all key, table, and field values to the new server, and attempting to run owl .94 on there has issues. Doing that, I get an issue where after the first login, we get this:
| Code: |
: Invalid SQL: INSERT into owl_log (userid, filename, action, parent, details, logdate, ip, agent, type) values ('1', '0', '1', '0', 'Username: admin', '2010-02-25 10:06:55', 'XXX.XXX.XXX.XXX', 'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2)
Gecko/20100115 Firefox/3.6', 'LOGIN')
: 1062 (Duplicate entry '0' for key 1)
Session halted.
|
If I remove the entry in the owl_log table with id 0, then you are allowed to login, again. However, logging out or another login, you are right back in the same position.
So, basically, I have the two scenarios. Moving from one server to another, both using MySQL, issues with going from .94 to .94.. OR, and the preferable path, is to take .94 to 1.0.
Any help is appreciated.
