[ZBX-10364] schema.inc.php doesn't correspond to a source schema.sql Created: 2016 Feb 09 Updated: 2017 May 30 Resolved: 2016 Feb 09 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | API (A), Frontend (F) |
| Affects Version/s: | 1.8.22 |
| Fix Version/s: | 1.8.23rc1 |
| Type: | Incident report | Priority: | Trivial |
| Reporter: | Alexander Vladishev | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | dm, installation | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Description |
|
Table definition in schema.sql: TABLE|user_history|userhistoryid|0 FIELD |userhistoryid |t_id |'0' |NOT NULL |0 FIELD |userid |t_id |'0' |NOT NULL |0 |users ... Table definition in schema.inc.php: 'user_history' => array( 'type' => DB::TABLE_TYPE_CONFIG, 'key' => 'userhistoryid', 'fields' => array( The flag DB::TABLE_TYPE_CONFIG must be replaced by DB::TABLE_TYPE_HISTORY in schema.inc.php. --- frontends/php/include/schema.inc.php +++ schema.inc.php (generated from schema.sql) @@ -4624,7 +4624,7 @@ ), ), 'user_history' => array( - 'type' => DB::TABLE_TYPE_CONFIG, + 'type' => DB::TABLE_TYPE_HISTORY, 'key' => 'userhistoryid', 'fields' => array( 'userhistoryid' => array( @@ -4791,4 +4791,4 @@ ), ), ); -?> +?> \ No newline at end of file |
| Comments |
| Comment by Alexander Vladishev [ 2016 Feb 09 ] |
|
Broken by: ------------------------------------------------------------------------ r24770 | sasha | 2012-01-13 18:49:53 +0200 (Pk, 13 jan 2012) | 1 line ........S. [ZBX-4511] removed the user_history table from the list of synchronized tables between nodes ------------------------------------------------------------------------ |
| Comment by Alexander Vladishev [ 2016 Feb 09 ] |
|
It does not affect Zabbix work. Must be fixed for consistency of code. |
| Comment by Alexander Vladishev [ 2016 Feb 09 ] |
|
Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-10364 |
| Comment by Alexander Vladishev [ 2016 Feb 09 ] |
|
Fixed in pre-1.8.23 r58335. |
| Comment by richlv [ 2016 Sep 24 ] |
|
(1) typo in the changelog entry - "inconsistences" sasha RESOLVED directly in branches/1.8 r62760. CLOSED |
| Comment by richlv [ 2016 Sep 24 ] |
|
given that this is one of two already fixed issues for 1.8.23, it is probably worth doing the "goodbye" release for the 1.8 branch the other is |