<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix"><tt>I don't remember skipping any
errors during make upgrade-database. Here are the table
descriptions you asked for. As you can see the Classes, Topics,
Articles tables do exist.<br>
<br>
Hopefully you will be able to tell what I need to do to my DB to
fix this...<br>
<br>
<br>
mysql> describe ACL;</tt><tt><br>
</tt><tt>+---------------+-------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| Field | Type | Null | Key | Default |
Extra |</tt><tt><br>
</tt><tt>+---------------+-------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| id | int(11) | NO | PRI | NULL |
auto_increment |</tt><tt><br>
</tt><tt>| PrincipalType | varchar(25) | NO | | NULL
| |</tt><tt><br>
</tt><tt>| PrincipalId | int(11) | NO | | NULL
| |</tt><tt><br>
</tt><tt>| RightName | varchar(25) | NO | MUL | NULL
| |</tt><tt><br>
</tt><tt>| ObjectType | varchar(25) | NO | | NULL
| |</tt><tt><br>
</tt><tt>| ObjectId | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Creator | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Created | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>| LastUpdatedBy | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| LastUpdated | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>+---------------+-------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>10 rows in set (0.00 sec)</tt><br>
<br>
<tt>mysql> describe Groups;</tt><tt><br>
</tt><tt>+---------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| Field | Type | Null | Key | Default |
Extra |</tt><tt><br>
</tt><tt>+---------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| id | int(11) | NO | PRI | NULL |
auto_increment |</tt><tt><br>
</tt><tt>| Name | varchar(200) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| Description | varchar(255) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| Domain | varchar(64) | YES | MUL | NULL
| |</tt><tt><br>
</tt><tt>| Type | varchar(64) | YES | MUL | NULL
| |</tt><tt><br>
</tt><tt>| Instance | int(11) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| Creator | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Created | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>| LastUpdatedBy | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| LastUpdated | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>+---------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>10 rows in set (0.00 sec)</tt><br>
<br>
<tt>mysql> describe GroupMembers;</tt><tt><br>
</tt><tt>+---------------+----------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| Field | Type | Null | Key | Default |
Extra |</tt><tt><br>
</tt><tt>+---------------+----------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| id | int(11) | NO | PRI | NULL |
auto_increment |</tt><tt><br>
</tt><tt>| GroupId | int(11) | NO | MUL | 0
| |</tt><tt><br>
</tt><tt>| MemberId | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Creator | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Created | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>| LastUpdatedBy | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| LastUpdated | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>+---------------+----------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>7 rows in set (0.00 sec)</tt><br>
<br>
<tt>mysql> describe CustomFieldValues;</tt><tt><br>
</tt><tt>+---------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| Field | Type | Null | Key | Default |
Extra |</tt><tt><br>
</tt><tt>+---------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| id | int(11) | NO | PRI | NULL |
auto_increment |</tt><tt><br>
</tt><tt>| CustomField | int(11) | NO | MUL | NULL
| |</tt><tt><br>
</tt><tt>| Name | varchar(200) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| Description | varchar(255) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| SortOrder | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Creator | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Created | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>| LastUpdatedBy | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| LastUpdated | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>| Category | varchar(255) | YES | | NULL
| |</tt><tt><br>
</tt><tt>+---------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>10 rows in set (0.00 sec)</tt><br>
<br>
<tt>mysql> describe Tickets;</tt><tt><br>
</tt><tt>+-----------------+--------------+------+-----+--------------+----------------+</tt><tt><br>
</tt><tt>| Field | Type | Null | Key |
Default | Extra |</tt><tt><br>
</tt><tt>+-----------------+--------------+------+-----+--------------+----------------+</tt><tt><br>
</tt><tt>| id | int(11) | NO | PRI |
NULL | auto_increment |</tt><tt><br>
</tt><tt>| EffectiveId | int(11) | NO | MUL |
0 | |</tt><tt><br>
</tt><tt>| Queue | int(11) | NO | MUL |
0 | |</tt><tt><br>
</tt><tt>| Type | varchar(16) | YES | |
NULL | |</tt><tt><br>
</tt><tt>| IssueStatement | int(11) | NO | |
0 | |</tt><tt><br>
</tt><tt>| Resolution | int(11) | NO | |
0 | |</tt><tt><br>
</tt><tt>| Owner | int(11) | NO | MUL |
0 | |</tt><tt><br>
</tt><tt>| Subject | varchar(200) | YES | | [no
subject] | |</tt><tt><br>
</tt><tt>| InitialPriority | int(11) | NO | |
0 | |</tt><tt><br>
</tt><tt>| FinalPriority | int(11) | NO | |
0 | |</tt><tt><br>
</tt><tt>| Priority | int(11) | NO | |
0 | |</tt><tt><br>
</tt><tt>| TimeEstimated | int(11) | NO | |
0 | |</tt><tt><br>
</tt><tt>| TimeWorked | int(11) | NO | |
0 | |</tt><tt><br>
</tt><tt>| Status | varchar(64) | YES | |
NULL | |</tt><tt><br>
</tt><tt>| TimeLeft | int(11) | NO | |
0 | |</tt><tt><br>
</tt><tt>| Told | datetime | YES | |
NULL | |</tt><tt><br>
</tt><tt>| Starts | datetime | YES | |
NULL | |</tt><tt><br>
</tt><tt>| Started | datetime | YES | |
NULL | |</tt><tt><br>
</tt><tt>| Due | datetime | YES | |
NULL | |</tt><tt><br>
</tt><tt>| Resolved | datetime | YES | |
NULL | |</tt><tt><br>
</tt><tt>| LastUpdatedBy | int(11) | NO | |
0 | |</tt><tt><br>
</tt><tt>| LastUpdated | datetime | YES | |
NULL | |</tt><tt><br>
</tt><tt>| Creator | int(11) | NO | |
0 | |</tt><tt><br>
</tt><tt>| Created | datetime | YES | |
NULL | |</tt><tt><br>
</tt><tt>| Disabled | smallint(6) | NO | |
0 | |</tt><tt><br>
</tt><tt>+-----------------+--------------+------+-----+--------------+----------------+</tt><tt><br>
</tt><tt>25 rows in set (0.00 sec)</tt><br>
<br>
<tt>mysql> describe CustomFields;</tt><tt><br>
</tt><tt>+---------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| Field | Type | Null | Key | Default |
Extra |</tt><tt><br>
</tt><tt>+---------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| id | int(11) | NO | PRI | NULL |
auto_increment |</tt><tt><br>
</tt><tt>| Name | varchar(200) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| Type | varchar(200) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| MaxValues | int(11) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| Pattern | text | YES | | NULL
| |</tt><tt><br>
</tt><tt>| Repeated | smallint(6) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Description | varchar(255) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| SortOrder | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| LookupType | varchar(255) | NO | | NULL
| |</tt><tt><br>
</tt><tt>| Creator | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Created | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>| LastUpdatedBy | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| LastUpdated | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>| Disabled | smallint(6) | NO | | 0
| |</tt><tt><br>
</tt><tt>| BasedOn | int(11) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| RenderType | varchar(64) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| ValuesClass | varchar(64) | YES | | NULL
| |</tt><tt><br>
</tt><tt>+---------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>17 rows in set (0.00 sec)</tt><br>
<br>
<tt>mysql> describe Queues;</tt><tt><br>
</tt><tt>+-------------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| Field | Type | Null | Key | Default
| Extra |</tt><tt><br>
</tt><tt>+-------------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| id | int(11) | NO | PRI | NULL
| auto_increment |</tt><tt><br>
</tt><tt>| Name | varchar(200) | NO | UNI | NULL
| |</tt><tt><br>
</tt><tt>| Description | varchar(255) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| CorrespondAddress | varchar(120) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| CommentAddress | varchar(120) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| InitialPriority | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| FinalPriority | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| DefaultDueIn | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Creator | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Created | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>| LastUpdatedBy | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| LastUpdated | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>| Disabled | smallint(6) | NO | MUL | 0
| |</tt><tt><br>
</tt><tt>| SubjectTag | varchar(120) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| Lifecycle | varchar(32) | YES | | NULL
| |</tt><tt><br>
</tt><tt>+-------------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>15 rows in set (0.00 sec)</tt><br>
<br>
<tt>mysql> show tables;</tt><tt><br>
</tt><tt>+-------------------------+</tt><tt><br>
</tt><tt>| Tables_in_rtdb |</tt><tt><br>
</tt><tt>+-------------------------+</tt><tt><br>
</tt><tt>| ACL |</tt><tt><br>
</tt><tt>| Articles |</tt><tt><br>
</tt><tt>| Attachments |</tt><tt><br>
</tt><tt>| Attributes |</tt><tt><br>
</tt><tt>| CachedGroupMembers |</tt><tt><br>
</tt><tt>| Classes |</tt><tt><br>
</tt><tt>| CustomFieldValues |</tt><tt><br>
</tt><tt>| CustomFields |</tt><tt><br>
</tt><tt>| GroupMembers |</tt><tt><br>
</tt><tt>| Groups |</tt><tt><br>
</tt><tt>| Links |</tt><tt><br>
</tt><tt>| ObjectClasses |</tt><tt><br>
</tt><tt>| ObjectCustomFieldValues |</tt><tt><br>
</tt><tt>| ObjectCustomFields |</tt><tt><br>
</tt><tt>| ObjectTopics |</tt><tt><br>
</tt><tt>| Principals |</tt><tt><br>
</tt><tt>| Queues |</tt><tt><br>
</tt><tt>| ScripActions |</tt><tt><br>
</tt><tt>| ScripConditions |</tt><tt><br>
</tt><tt>| Scrips |</tt><tt><br>
</tt><tt>| Templates |</tt><tt><br>
</tt><tt>| Tickets |</tt><tt><br>
</tt><tt>| Topics |</tt><tt><br>
</tt><tt>| Transactions |</tt><tt><br>
</tt><tt>| Users |</tt><tt><br>
</tt><tt>| sessions |</tt><tt><br>
</tt><tt>+-------------------------+</tt><tt><br>
</tt><tt>26 rows in set (0.00 sec)</tt><tt><br>
</tt><tt><br>
</tt><tt>mysql> describe Classes;</tt><tt><br>
</tt><tt>+---------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| Field | Type | Null | Key | Default |
Extra |</tt><tt><br>
</tt><tt>+---------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| id | int(11) | NO | PRI | NULL |
auto_increment |</tt><tt><br>
</tt><tt>| Name | varchar(255) | NO | |
| |</tt><tt><br>
</tt><tt>| Description | varchar(255) | NO | |
| |</tt><tt><br>
</tt><tt>| SortOrder | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Disabled | int(2) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Creator | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Created | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>| LastUpdatedBy | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| LastUpdated | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>| HotList | int(2) | NO | | 0
| |</tt><tt><br>
</tt><tt>+---------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>10 rows in set (0.00 sec)</tt><tt><br>
</tt><tt><br>
</tt><tt>mysql> describe Topics;</tt><tt><br>
</tt><tt>+-------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| Field | Type | Null | Key | Default |
Extra |</tt><tt><br>
</tt><tt>+-------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| id | int(11) | NO | PRI | NULL |
auto_increment |</tt><tt><br>
</tt><tt>| Parent | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Name | varchar(255) | NO | |
| |</tt><tt><br>
</tt><tt>| Description | varchar(255) | NO | |
| |</tt><tt><br>
</tt><tt>| ObjectType | varchar(64) | NO | |
| |</tt><tt><br>
</tt><tt>| ObjectId | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>+-------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>6 rows in set (0.01 sec)</tt><tt><br>
</tt><tt><br>
</tt><tt>mysql> describe Articles;</tt><tt><br>
</tt><tt>+---------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| Field | Type | Null | Key | Default |
Extra |</tt><tt><br>
</tt><tt>+---------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>| id | int(11) | NO | PRI | NULL |
auto_increment |</tt><tt><br>
</tt><tt>| Name | varchar(255) | NO | |
| |</tt><tt><br>
</tt><tt>| Summary | varchar(255) | NO | |
| |</tt><tt><br>
</tt><tt>| SortOrder | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Class | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Parent | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| URI | varchar(255) | YES | | NULL
| |</tt><tt><br>
</tt><tt>| Creator | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| Created | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>| LastUpdatedBy | int(11) | NO | | 0
| |</tt><tt><br>
</tt><tt>| LastUpdated | datetime | YES | | NULL
| |</tt><tt><br>
</tt><tt>+---------------+--------------+------+-----+---------+----------------+</tt><tt><br>
</tt><tt>11 rows in set (0.00 sec)</tt><tt><br>
</tt><tt><br>
</tt><br>
<div class="moz-signature">
<div style="font-family:Arial;font-size:12px">
<p><strong>Paul O’Rorke</strong><br>
Tracker Software Products<br>
<a href="mailto:paul.ororke@tracker-software.com">paul@tracker-software.com</a></p>
</div>
</div>
On 7/31/2013 5:15 PM, Kevin Falcone wrote:<br>
</div>
<blockquote cite="mid:20130801001554.GI22003@jibsheet.com"
type="cite">
<pre wrap="">On Wed, Jul 31, 2013 at 12:31:26PM -0700, Paul O'Rorke wrote:
</pre>
<blockquote type="cite">
<pre wrap=""> OK - I thought that make upgrade-database covered those - it suggested it was doing all those
incremental updates. It asked from which version I was update from/to and showed each step as
doing something. What is it's purpose then?
Do I have to still do each one manually from 3.8.4 then?
</pre>
</blockquote>
<pre wrap="">
make upgrade-database runs all of the steps.
The database you're showing clearly did not have at least one of the
steps run on it.
Did you skip past any errors?
You can also show the 'desc TABLE' for:
ACL
Groups
GroupMembers
CustomFieldValues
Tickets
CustomFields
Queues
and check for the existence of the Classes, Topics, Articles tables.
Your desc Users showed that at least one part of the Users table
upgrade (adding the AuthToken field) was run. Now the challenge is
figuring out what steps did not run.
-kevin
</pre>
<blockquote type="cite">
<pre wrap=""> Paul O'Rorke
On 07/31/2013 11:59 AM, Kevin Falcone wrote:
On Wed, Jul 31, 2013 at 10:24:29AM -0700, Paul O'Rorke wrote:
Password: !sha512!8MzDJesb8kr4UHIA!784B/mzwvLcUEEa
`Password` varbinary(40) DEFAULT NULL,
These are 3.8 versions of that table, not 4.0 versions.
Did you run all of the database upgrade steps? This was step 4.0.0rc4.
There are many other schema changes.
</pre>
</blockquote>
</blockquote>
<br>
</body>
</html>