New Datalayer - SQL Server and MySQL support (Happy new year!) Options
PeterD
Posted: Tuesday, January 08, 2008 6:49:34 PM

Rank: Fanatic

Joined: 7/20/2006
Posts: 486
Location: NL
So, we can get access to the source-code, BUT:
can someone also make a binary set out of it?
I'm curious and want to do some testing with it :dribble:

PeterD

Working on an events-calendar with recursion. Post requests on my blog!
Ruben
Posted: Tuesday, January 08, 2008 6:51:50 PM

Rank: Aficionado

Joined: 12/21/2007
Posts: 169
Location: Belgium
Working on some parts of Umbraco right now... when it compiles, I'll try to remember making a binary.

Ruben Verborgh | Umbraco Core Team Developer | Working on: Data layer table utility. | LinkedIn
hoehler
Posted: Wednesday, January 09, 2008 4:05:07 PM

Rank: Addict

Joined: 7/19/2006
Posts: 597
Location: Bad Homburg, Germany
I am really deeply impressed...

I will test it with my mySQL webs...

Thomas

• 2007/2008 MVP • www.thoehler.com • Bad Homburg, Germany
Ruben
Posted: Thursday, January 10, 2008 5:05:03 PM

Rank: Aficionado

Joined: 12/21/2007
Posts: 169
Location: Belgium
A compiled version of change set 29543 can be found here.
Don't forget to change the database configuration string in Web.config. (I filled out the values for MySql.)

Ruben Verborgh | Umbraco Core Team Developer | Working on: Data layer table utility. | LinkedIn
Ruben
Posted: Thursday, January 10, 2008 5:07:06 PM

Rank: Aficionado

Joined: 12/21/2007
Posts: 169
Location: Belgium
Don't forget to use the modified version of the Creative Website Wizard if you're planning to use that one. (Don't know about the compatibility of the other packages.)

Ruben Verborgh | Umbraco Core Team Developer | Working on: Data layer table utility. | LinkedIn
PeterD
Posted: Thursday, January 10, 2008 5:32:31 PM

Rank: Fanatic

Joined: 7/20/2006
Posts: 486
Location: NL
Awesome! :thumbup:

Working on an events-calendar with recursion. Post requests on my blog!
PeterD
Posted: Thursday, January 10, 2008 9:48:12 PM

Rank: Fanatic

Joined: 7/20/2006
Posts: 486
Location: NL
First impression is good m8!!

I did encounter some things though.

First install didnt go smooth, I got a few NullReference errors. As well in installing database as in importing package.
Second try went a lot smoother and gave NO errors at all. So, not sure what went wrong first attempt. Perhaphs after some more tests I can get a finger on what happened maybe.

After second try, I got a sample-site running. However, I cant seem to edit macros.
Error I get is: Exception Details: MySql.Data.MySqlClient.MySqlException: Unknown column 'macroReader' in 'where clause'


So far so good, I'll keep on testing more :dribble:

Cheers,
PeterD

Working on an events-calendar with recursion. Post requests on my blog!
Ruben
Posted: Thursday, January 10, 2008 10:13:31 PM

Rank: Aficionado

Joined: 12/21/2007
Posts: 169
Location: Belgium
Thanks for testing!

About the macro errors: it was a problem with the last version, which I only noticed a few minutes after posting my message here. But now it is fixed, together with some XSLT-related bugs. You can find the binaries here.

The null references: this bothers me... can you reproduce it? Never had it, ran through several installations.

Ruben Verborgh | Umbraco Core Team Developer | Working on: Data layer table utility. | LinkedIn
PeterD
Posted: Thursday, January 10, 2008 11:31:46 PM

Rank: Fanatic

Joined: 7/20/2006
Posts: 486
Location: NL
Yes, I can reproduce.
I have a server 2003 running.
I took these steps:
-created database in mysql
-cretaed folder and copied all files in it
-modified web.config to fit my needs
-created new application pool
-created new website

Now, as soon as I open the website, I see in the event-log of the server this error (note, no error is shown in browser):

Exception: System.NullReferenceException
Message: Object reference not set to an instance of an object.
StackTrace: at umbraco.DataLayer.RecordsReaderAdapter`1.Dispose()
at umbraco.DataLayer.RecordsReaderAdapter`1.Finalize()

Now, when I click through, I get this error in the browser (first time I click to install database which was succesfull identified as none):
Exception Details: MySql.Data.MySqlClient.MySqlException: FUNCTION ConvertGuid already exists

After some fiddling, I managed to get it running

Then, importing the package, this error occurs:
Exception Details: MySql.Data.MySqlClient.MySqlException: There is already an open DataReader associated with this Connection which must be closed first.

Hope this is of some help for you.

Cheers,
PeterD

Working on an events-calendar with recursion. Post requests on my blog!
Ruben
Posted: Thursday, January 10, 2008 11:38:37 PM

Rank: Aficionado

Joined: 12/21/2007
Posts: 169
Location: Belgium
I just got an idea... did you remove the line in the config file that says version 3.0.3? Just underneath the database configuration. (Shouldn't be there, since there's no version installed in the beginning.) I hope it was still there... then this behavior is "normal".

Forgot to remove it in the package... I'm sorry!

Ruben Verborgh | Umbraco Core Team Developer | Working on: Data layer table utility. | LinkedIn
PeterD
Posted: Thursday, January 10, 2008 11:40:31 PM

Rank: Fanatic

Joined: 7/20/2006
Posts: 486
Location: NL
Forgot to mention that, I did not remove the whole line, just removed the value 3.0.3


Working on an events-calendar with recursion. Post requests on my blog!
Ruben
Posted: Thursday, January 10, 2008 11:43:42 PM

Rank: Aficionado

Joined: 12/21/2007
Posts: 169
Location: Belgium
Mmm... I'm not sure if that makes a difference, that part of the code was written way before I arrived here.

If you have some time, could you please try it that way? I tried the exact same steps, but I get no error here.

The ConvertGuid exception is normal, happens when the database is created a second time because the function gets created twice.

Ruben Verborgh | Umbraco Core Team Developer | Working on: Data layer table utility. | LinkedIn
PeterD
Posted: Thursday, January 10, 2008 11:45:15 PM

Rank: Fanatic

Joined: 7/20/2006
Posts: 486
Location: NL
Trying now with that line removed, so far no improvement, still same behaviour as described above

Working on an events-calendar with recursion. Post requests on my blog!
Ruben
Posted: Thursday, January 10, 2008 11:47:07 PM

Rank: Aficionado

Joined: 12/21/2007
Posts: 169
Location: Belgium
Thank you very much. I don't understand it at all. I'll try to dig into it tomorrow or the day after.

Ruben Verborgh | Umbraco Core Team Developer | Working on: Data layer table utility. | LinkedIn
Ruben
Posted: Friday, January 11, 2008 12:08:38 AM

Rank: Aficionado

Joined: 12/21/2007
Posts: 169
Location: Belgium
Aha, I got a NullPointerException! But now I'm going to sleep...

Ruben Verborgh | Umbraco Core Team Developer | Working on: Data layer table utility. | LinkedIn
PeterD
Posted: Friday, January 11, 2008 10:12:52 AM

Rank: Fanatic

Joined: 7/20/2006
Posts: 486
Location: NL
Good thing you found something, I thought I was doing something out of the ordinary.
Later today I'll try set it up on my XP machine, see if it behaves the same way.

BTW: does it matter which mySQL version is used?


Working on an events-calendar with recursion. Post requests on my blog!
Ruben
Posted: Friday, January 11, 2008 10:14:00 AM

Rank: Aficionado

Joined: 12/21/2007
Posts: 169
Location: Belgium
The MySql version should not make a difference, since you've got it working the second time. I suppose you have version >= 5?

Ruben Verborgh | Umbraco Core Team Developer | Working on: Data layer table utility. | LinkedIn
PeterD
Posted: Friday, January 11, 2008 10:22:53 AM

Rank: Fanatic

Joined: 7/20/2006
Posts: 486
Location: NL
Yes, I tried yesterday on >5
But, I also have a machine standing which has version 4. If it doesnt make a difference, I could try on that machine tonight. If you say it needs version 5 or higher, I dont have to go through all the trouble ;)

Working on an events-calendar with recursion. Post requests on my blog!
Ruben
Posted: Friday, January 11, 2008 10:24:59 AM

Rank: Aficionado

Joined: 12/21/2007
Posts: 169
Location: Belgium
You'll need version 5. But maybe you can connect the machine to other that has version 5? That could help you out, and it shouldn't make a difference on what machine the database server is running.

Ruben Verborgh | Umbraco Core Team Developer | Working on: Data layer table utility. | LinkedIn
PeterD
Posted: Friday, January 11, 2008 11:09:55 AM

Rank: Fanatic

Joined: 7/20/2006
Posts: 486
Location: NL
That's an option if I place the server within the same network ;)
I'll just install version 5 instead I guess. :whistle:

Working on an events-calendar with recursion. Post requests on my blog!
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.