Unable to upgrade database (1 Viewer)

[porky996t]

Forgive my ignorance, but I have script downloaded, how do I run it?

I can design buildings, but I do struggle with code



M

 

[mm1352000]

A very fair question! I thought you were executing the queries as I provided them (but I guess not?).

First, I notice just now that I forgot to remove the first line - use %TvLibrary%; - in the script. Please do that (you can edit the file with any text editor). After that, it should just be a matter of opening the file in Workbench and executing it - there would be a function for this somewhere I'm sure. In the Query Browser I have an Open Script item in the file menu and an Execute item in the Script menu.

mm

 

[porky996t]

I'd worked out how to import it into Workbench...using the "Import Script" icon... but there was a syntax issue with the %TVLibrary% and thus didn't work. I'll remove that in a text editor and re-import.

EDIT: Just my luck.... it threw this back at me....

"Error Code: 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 '"SoftwareEncoder" (
"idEncoder" int(11) NOT NULL auto_increment,
"priority" ' at line 1"

EDIT:I have just manually added a table and I'm just manually populating it with the data from the script. I'll keep you posted.

Whey hey - I can open TV Server config settings!!

mm1352000 you really are a star -


I couldn't have done it without your help... I'm going to grab me'self a cool tinny now.

 

[spiderwheels]

I have just had the same issue.

I have MySql 5.1.38 (installed by MediaPortal way back when..)

The problem is that this version of MySql doesn't like the strings to be identity strings to be quoted e.g. where it says "SoftwareEncoder" or "idEncoder" should just be SoftwareEncoder and idEncoder.

I have updated the script for any other people that are having the same problem.

If you can't figure out which menu in Workbench to use to open the script then just open it in notepad and copy and paste the entire text in to the query window.

 

[porky996t]

Nice one spider wheels... should certainly be quicker than my manual job... (ooo,eer missus!)

Your version of MySQL is the same as yours.



M

 

[mm1352000]

Hi spiderwheels

I did wonder about that, but I'm not so sure since that seems to be the only update that failed. Other updates succeeded. Of course attempting to execute the SQL (ie. copy + paste) in GUI tools also fails for me unless I remove the quotes.

mm

 

[infinite.loop]

I have just had the same issue.

I have MySql 5.1.38 (installed by MediaPortal way back when..)

The problem is that this version of MySql doesn't like the strings to be identity strings to be quoted e.g. where it says "SoftwareEncoder" or "idEncoder" should just be SoftwareEncoder and idEncoder.

I am sorry but this can not be the case.

I use the very same MySQl Server Version 5.1.38 on my TV-Server, and the upgrade works just nicely.
So it can not be a general problem with that specific MySQL version. Otherwise why do I and others not encounter it?

*edit*
5.1.38 is still installed by 1.2.0 on a clean install.
So if it would be a general issue in this MySQl version, everyone would suffer from it.

 

[jameson_uk]

Is very odd as MySQL allows for quoted identifiers in 5.1. You need to set ANSI_QUOTES mode on
http://dev.mysql.com/doc/refman/5.1/en/identifiers.html

Question is why is this mode on for most users (else I guess we would have more bug reports) but off for others?

 

[infinite.loop]

Question is why is this mode on for most users (else I guess we would have more bug reports) but off for others?

Guess this is again (like the one we had with users running MySQL on some Linux box) an issue for users who installed MySQL on their own?

 

[mm1352000]

I installed MySQL by myself and I couldn't execute the query, but that was in the MySQL tool itself not via the installer. One would think that there shouldn't be a difference. Another thing to check when I get home.