Reply to thread

Message

<blockquote data-quote="Pablik" data-source="post: 1299579" data-attributes="member: 106554">Hi,in v1.33 there is a database upgrade by adding 'symbolRateMultiplier' column to the table name 'card' of the 'mptvdb' database.It seems, that under certain condition the upgrade somehow doesn't alter the table. I couldn't reproduce this behaviour by myself.Please, try to install MySQL Workbench 8.0 (mysql-workbench-community-8.0.34-winx64.msi). This is a MySQL GUI database manager. After installing:<ul>
<li data-xf-list-type="ul">stop the service 'TVservice' if running</li>
<li data-xf-list-type="ul">connect to the local database from MySQL Workbench</li>
<li data-xf-list-type="ul">under schemas there will be 'mptvdb'</li>
<li data-xf-list-type="ul">check the table 'card' for columns and for presence of 'symbolRateMultiplier' (int(11))</li>
<li data-xf-list-type="ul">if the column is missing, then check the table 'version': right click and select 'Select Rows - Limit 1000'</li>
<li data-xf-list-type="ul">in the result window there will be one row with value 'versionNumber' set to 62</li>
<li data-xf-list-type="ul">you have to modify the value back to 61: this will trigger the database upgrade to 62 again when you start the TVSetup</li>
</ul>PS: if you have trouble with running the Workbench by missing 'api-ms-win-core-path-l1-1-0.dll', you can use the dll from the attached file</blockquote>

[QUOTE="Pablik, post: 1299579, member: 106554"] Hi, in v1.33 there is a database upgrade by adding 'symbolRateMultiplier' column to the table name 'card' of the 'mptvdb' database. It seems, that under certain condition the upgrade somehow doesn't alter the table. I couldn't reproduce this behaviour by myself. Please, try to install MySQL Workbench 8.0 (mysql-workbench-community-8.0.34-winx64.msi). This is a MySQL GUI database manager. After installing: [LIST] [*]stop the service 'TVservice' if running [*]connect to the local database from MySQL Workbench [*]under schemas there will be 'mptvdb' [*]check the table 'card' for columns and for presence of 'symbolRateMultiplier' (int(11)) [*]if the column is missing, then check the table 'version': right click and select 'Select Rows - Limit 1000' [*]in the result window there will be one row with value 'versionNumber' set to 62 [*]you have to modify the value back to 61: this will trigger the database upgrade to 62 again when you start the TVSetup [/LIST] PS: if you have trouble with running the Workbench by missing 'api-ms-win-core-path-l1-1-0.dll', you can use the dll from the attached file [/QUOTE]

Verification