Unable To convert Query to SQL after switched to MariaDB

If you think that something doesn't work in Aware IM post your message here
Post Reply
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Unable To convert Query to SQL after switched to MariaDB

Post by weblike »

Hi all,

Just switched to MariaDB from MySQL 5.6 and I have a problem with this type of query:
Selection_089.png
Selection_089.png (6.1 KiB) Viewed 9368 times
Selection_090.png
Selection_090.png (8.16 KiB) Viewed 9368 times
Selection_091.png
Selection_091.png (11.03 KiB) Viewed 9368 times
Anyone is using MariaDB and had faced this issues?

thx,
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
customaware
Posts: 2403
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Unable To convert Query to SQL after switched to MariaDB

Post by customaware »

Maria DB failed for a number of my existing Queries.....

Dropped it like a hot cake.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Re: Unable To convert Query to SQL after switched to MariaDB

Post by weblike »

:(
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
intra
Posts: 279
Joined: Thu Oct 11, 2012 1:30 pm
Location: Australia

Re: Unable To convert Query to SQL after switched to MariaDB

Post by intra »

Loved the idea of using MariaDB, however there wasn't any rock solid support for it so i backed out of that idea.
Avid Linux user....
customaware
Posts: 2403
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Unable To convert Query to SQL after switched to MariaDB

Post by customaware »

I was very interested also Pete.

I am not sure but suspect it "may" have been that I originally developed in MS-SQL and then deployed in Maria DB.

Have not had the time or inclination to develop solely in Maria DB, so that may have been the problem.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Re: Unable To convert Query to SQL after switched to MariaDB

Post by weblike »

eagles9999 wrote:I was very interested also Pete.

I am not sure but suspect it "may" have been that I originally developed in MS-SQL and then deployed in Maria DB.

Have not had the time or inclination to develop solely in Maria DB, so that may have been the problem.
I have developed in MySQL and after that deployed in MariaDB, but some queries gave the errors above.

MariaDB is gaining popularity and would be very nice to be supported by Aware.
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
Post Reply