MySQL option (3 Viewers)

[Frodo]

sounds good!
please upload the modified/new sources here:
http://sourceforge.net/tracker/?group_id=107397&atid=647927

or mail them to e.beckers@gmail.com

 

[dunkstar]

I have the code at home, so i'll send it when I get home from work

 

[THDBASED]

I've already cahnged the SetupDatabaseForm so you can choose MySQL.
I have made it so the .net script converts the database.sql to a MySQL compatilble sql file, so when they update the MSSQL file, the script just converts it.
BUT they use some tables that MySQL dont support, and I cannot see where they are used.
Maybe we can just leave them out.

Anybody interested in seeing my work?

I would love to test this out, I will install this on my mini Epia Server...

 

[dunkstar]

Ok I can see some new things have been added in the new revision.
I'll just update my work and send you the code tomorrow.

 

[dunkstar]

OK there are several issues with the version 20 of the database.sql
Too long table names is the biggest issue.

For now i'll stop my coding until we find a universal solution.

Sorry...I know some of you hoped I could make an universal setup for MySQL...

 

[THDBASED]

Oh dammit too bad, I really thought this would be the ONE, Again, maybe one of the devs (Frodo ) could help out, maybe this can be solved very easy with the help of one of the devs...

 

[Frodo]

Too long table names is the biggest issue.

WTF ???
is mysql that bad that it dont even support a table name of 16 characters
(the table names 'CanceledSchedule' is the longest atm in the tvserver)

 

[THDBASED]

I also thought that was kind of strange, I am going to do some searching to see if this is true...

Well take a look at this page:

http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

I thought it was 64 and I was right, so the "too long table names" error isn't correct I guess...

 

[samposoft]

TVEngine on MySQL

I currently use TVEngine on MySQL 5.0.26 and it's works.

you can download my sql script to create db from
http://www.samposoft.it/database.zip

I have use MyIsam table for best performance.

I have made some modification to the TVLibraty project to add the latest reference to
Gentle-1.2.9 DLL because in SVN are 2 missing dll
Gentle.Provider.MySQL.dll
MySql.Data.dll

I have removed in all project reference to
Gentle.Provider.SQLServer.dll
because Gentle.Framework load dynmically these dll based on Gentle.config configuration.


http://www.samposoft.it/Gentle129Dll.zip

The only bug that i found in source code is in

TVLibrary\TVDatabase\Channel.cs
TVLibrary\TVDatabase\TvBusinessLayer\BusinessLayer.cs

that format bad datetime string in query "yyyyMMdd HH:mm:ss"
I've changed to "yyyy-MM-dd HH:mm:ss"
I think that SQLserver support this format (is more flexible).

I have also commented code in

TVLibrary\SetupTv\Startup.cs

      //SetupDatabaseForm dlg = new SetupDatabaseForm();
      //if (!dlg.TestConnection())
      //{
      //  dlg.ShowDialog();
      //}
      //if (dlg.ShouldDoUpgrade())
      //{
      //  dlg.CreateDatabase();
      //}

because the SetupDatabaseForm works only for SQLServer and use System.Data.SqlClient.

The next step is to create a new SetupDatabaseForm for support MySQL or SQLServer.
I think that is very simple...

 

[THDBASED]

Sweet I will try this, maybe you should send this code to Frodo, he was going to put this into the SVN if it worked....or maybe he can just download it from here

Thanks a lot for you work!

THDBASED