Author Topic: Database Setup Error  (Read 7088 times)

DJ Garybaldy

  • Global Moderator
  • Hero Member

  • Offline
  • *****
  • 4603
  • Personal Text
    Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: Database Setup Error
« Reply #15 on: June 25, 2014, 10:59:43 AM »
Quote
If it was only that simple....it's within an environment that can't be upgraded due to legacy conflicts. Every other part of RadioDJ is working and has been for months, so MySQL can't be the issue, surely?

I'm intrigued what exactly is the "legacy" bit all about? I think the version of MySQL  5.0.51 you are trying to work with was a beta with lots of known bugs.

Try this version it one of the 5.1 versions of SQL http://www.mediafire.com/download/sxvo8pceiycyjvf/mysql-essential-5.1.41-win32.msi

It may help with any problems you are experiencing  :bash:
Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com

How to Install RadioDJ: https://djgarybaldy.blogspot.com/2020/08/how-to-install-radiodj-free-radio.html

RadioDJ is my most FAVOURITE piece of software EVER

What I do with RadioDJ: http://goldradio.servemp3.com

HMC

  • Full Member

  • Offline
  • ***
  • 181
Re: Database Setup Error
« Reply #16 on: June 25, 2014, 11:50:23 AM »
BTW as an FYI, I used MariaDB 10.0.10 instead of Oracle MySQL and it's works great. Haven't had an issue that I know of yet.
Radio DJ 1.7.5 Update with MariaDB 10

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5718
    • Radio DJ
Re: Database Setup Error
« Reply #17 on: June 25, 2014, 12:14:12 PM »
@HMC, i forgot about that. I planned to test it a while ago, but i simply forgot.
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

nitram78

  • Jr. Member

  • Offline
  • **
  • 73
Re: Database Setup Error
« Reply #18 on: June 25, 2014, 12:20:50 PM »
I'm intrigued what exactly is the "legacy" bit all about? I think the version of MySQL  5.0.51 you are trying to work with was a beta with lots of known bugs.

Try this version it one of the 5.1 versions of SQL http://www.mediafire.com/download/sxvo8pceiycyjvf/mysql-essential-5.1.41-win32.msi

It may help with any problems you are experiencing  :bash:

Legacy in the fact we run other systems from the same database that can't be upgraded to a 5.1.* base. I am more than happy to explain in private what job I do, but rest assured I know my stuff ;)

I have no issue deploying a fresh database, but merely wanted clarity on the error before going hunting too deep. However, I rather deploy MySQL onto Debian than Windows ;)

SnowHow

  • Hero Member

  • Offline
  • *****
  • 911
  • Personal Text
    A-1 Radio - The Variety Channel
    • A-1 Radio - The Variety Channel
Re: Database Setup Error
« Reply #19 on: June 25, 2014, 05:34:26 PM »
BTW as an FYI, I used MariaDB 10.0.10 instead of Oracle MySQL and it's works great. Haven't had an issue that I know of yet.

Well that's interesting. I've never heard of MariaDB before. I will definitely have a look.


Legacy in the fact we run other systems from the same database that can't be upgraded to a 5.1.* base. I am more than happy to explain in private what job I do, but rest assured I know my stuff ;)

I have no issue deploying a fresh database, but merely wanted clarity on the error before going hunting too deep. However, I rather deploy MySQL onto Debian than Windows ;)

That's perfectly understandable - other systems are at play here....


I have a spare hard drive with Vista on it. It may be worthwhile to dig it out just to test 5.0.51 and see how RDJ behaves.


J-


HMC

  • Full Member

  • Offline
  • ***
  • 181
Re: Database Setup Error
« Reply #20 on: June 26, 2014, 01:48:36 AM »
Well that's interesting. I've never heard of MariaDB before. I will definitely have a look.


Yeah, it's a fork of MySQL by the original developers of MySQL. After Oracle bought MySQL they have become less and less cooperative with the community so the MariaDB fork was created and even has more enhanced features than MySQL. It's notable that even major players such as RedHat have replaced MySQL with MariaDB as the default DB in RHEL 7. Oracle MySQL isn't going to be used as much in the near future because they are not keeping it community driven as was before.

@HMC, i forgot about that. I planned to test it a while ago, but i simply forgot.

Cool, well so far it works for me. Hope you won't have to do much in terms of support. MariaDB is supposed to be a drop-in replacement so the point is not to have to make any changes.
Radio DJ 1.7.5 Update with MariaDB 10

starlite

  • Guest
Re: Database Setup Error
« Reply #21 on: June 26, 2014, 02:14:37 AM »
Talking about db versions.

Would that impact on my connecting to the db on my XP for the demo script which is on a shared server?

It looks like I have 5.5.25a.0 according to Properties on mysql.exe     7/2012 install.

oz

SnowHow

  • Hero Member

  • Offline
  • *****
  • 911
  • Personal Text
    A-1 Radio - The Variety Channel
    • A-1 Radio - The Variety Channel
Re: Database Setup Error
« Reply #22 on: June 26, 2014, 04:02:29 AM »

I have a spare hard drive with Vista on it. It may be worthwhile to dig it out just to test 5.0.51 and see how RDJ behaves.


I tried RDJ with MySQL 5.0.51 and it ran fine, events and all, so at this point I'm out of ideas... :(


J-

nitram78

  • Jr. Member

  • Offline
  • **
  • 73
Re: Database Setup Error
« Reply #23 on: June 26, 2014, 12:27:22 PM »
I tried RDJ with MySQL 5.0.51 and it ran fine, events and all, so at this point I'm out of ideas... :(


J-

Cheers SnowHow. In theory it should be working, even as far back as this version....I've got one of my db guys (former google employee) looking into it.

We have no problems at all with RadioDJ itself....everything works flawless, it's purely the database Setup/Updater .exe that seems to throw issues. If we manually populate the .xml file with the db info, then RadioDJ itself works fine.