[mythtvnz] I killed MYSQL now what?

[Steve Hodge]

On Fri, Jun 1, 2012 at 9:10 PM, criggie <criggie at criggie.org.nz> wrote:

> On 01/06/12 21:00, Steve V wrote:
>
>> ERROR: 1064 You have an error in your SQL syntax; check the manual that
>> corresponds to your MySQL server version for the right syntax to use near
>> 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET
>> utf8 NOT ' at line 1
>>
> Something tried to change the table called user by adding a column called
> Show_view_priv but something's wrong with the command.
>
>
>
>  ERROR: 1050 Table 'plugin' already exists
>>
> Something's trying to create a table in the database called plugin, and it
> already exists.


Both "user" and "plugin" are mysql system tables. It looks like something
is trying to upgrade the mysql core schema and failing. The Show_view_priv
column was added in 5.0.1. The plugin table was added in 5.1. What version
do you have installed?

What is interesting is that from the log it looks like it's gone through a
couple of shutdown/startup cycles. And the second time it failed at a
different point in the upgrade script. Do you still get the same error now?

Cheers,
Steve
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ourshack.com/pipermail/mythtvnz/attachments/20120601/a8dbec0c/attachment.html>