Error in OSCAR12.1

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

Error in OSCAR12.1

Tom Le

Hi All,

Does anyone know what this error in OSCAR 12.1 is?


java.sql.SQLException: Syntax error or access violation,  message from server: "'oscar12.formBCHP.demographic_no' isn't in GROUP BY"



--
Tom Le

mpeer networks inc.
Suite 720 - 999 W. Broadway
Vancouver, BC, V5Z 1K5
Work # : (604) 235-1689
Cell # : (604) 612-6617
Fax # : (604) 435-7153
http://www.mpeer.net

==========
Confidential: This message (including any attachments) is CONFIDENTIAL and maybe PRIVILEGED. If you are not an intended recipient you are hereby notified that any distribution, copying or use by you of this information is strictly prohibited. If you have received this message in error please immediately notify the sender by phone at 604-612-6617 or by return email and delete all copies of this information from your system. Thank you for you cooperation
==========

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: Error in OSCAR12.1

Thom Luxford-4
Where is the rest of the error?
Have you checked the definition of the table formBCHP?


Thom Luxford
Director
bCMDit Services Ltd.
(866) 922-6348, ext 101

On Mar 5, 2018, at 11:10, Tom Le <[hidden email]> wrote:

Hi All,

Does anyone know what this error in OSCAR 12.1 is?


java.sql.SQLException: Syntax error or access violation,  message from server: "'oscar12.formBCHP.demographic_no' isn't in GROUP BY"



--
Tom Le

mpeer networks inc.
Suite 720 - 999 W. Broadway
Vancouver, BC, V5Z 1K5
Work # : (604) 235-1689
Cell # : (604) 612-6617
Fax # : (604) 435-7153
http://www.mpeer.net

==========
Confidential: This message (including any attachments) is CONFIDENTIAL and maybe PRIVILEGED. If you are not an intended recipient you are hereby notified that any distribution, copying or use by you of this information is strictly prohibited. If you have received this message in error please immediately notify the sender by phone at 604-612-6617 or by return email and delete all copies of this information from your system. Thank you for you cooperation
==========
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: Error in OSCAR12.1

Colcamex Resources Inc.
In reply to this post by Tom Le
That’s a SQL syntax error. 

That particular error is common with MS SQL when ALL columns are not added to GROUP BY 

- OR - 

Only in MySQL when it’s set in “Strict Mode”.

If you send the rest of the trace we may be able to help you track down if this is due to a syntax error - or - if your MySQL settings are too strict. 

Dennis Warren, Manager
Colcamex Resources Inc.
[hidden email] | colcamex.com | 778.386.9264



On Mar 5, 2018, at 11:10 AM, Tom Le <[hidden email]> wrote:

isn't in GROUP BY


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: [OSCAR-advanced-users] Error in OSCAR12.1

Tom Le

Mysql 5.6 default setting for sql_mode is strict.

Thanks


On 2018-03-05 02:02 PM, Colcamex Resources Inc. wrote:
That’s a SQL syntax error. 

That particular error is common with MS SQL when ALL columns are not added to GROUP BY 

- OR - 

Only in MySQL when it’s set in “Strict Mode”.

If you send the rest of the trace we may be able to help you track down if this is due to a syntax error - or - if your MySQL settings are too strict. 

Dennis Warren, Manager
Colcamex Resources Inc.
[hidden email] | colcamex.com | 778.386.9264



On Mar 5, 2018, at 11:10 AM, Tom Le <[hidden email]> wrote:

isn't in GROUP BY



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users

--
Tom Le

mpeer networks inc.
Suite 720 - 999 W. Broadway
Vancouver, BC, V5Z 1K5
Work # : (604) 235-1689
Cell # : (604) 612-6617
Fax # : (604) 435-7153
http://www.mpeer.net

==========
Confidential: This message (including any attachments) is CONFIDENTIAL and maybe PRIVILEGED. If you are not an intended recipient you are hereby notified that any distribution, copying or use by you of this information is strictly prohibited. If you have received this message in error please immediately notify the sender by phone at 604-612-6617 or by return email and delete all copies of this information from your system. Thank you for you cooperation
==========

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: [OSCAR-advanced-users] Error in OSCAR12.1

Peter Hutten-Czapski-2

MySQL now defaults to strict
MariaDB defaults to not strict

================
Peter Hutten-Czapski
Haileybury Ontario

"The attitude that ‘if rural people want these services they’ll have to come to the city to get them’ is simply not acceptable…” (Newbery, 1999)

Before printing, think about the environment. Avant d' imprimer, pensez à l'environnement.

On 7 March 2018 at 13:45, Tom Le <[hidden email]> wrote:

Mysql 5.6 default setting for sql_mode is strict.

Thanks


On 2018-03-05 02:02 PM, Colcamex Resources Inc. wrote:
That’s a SQL syntax error. 

That particular error is common with MS SQL when ALL columns are not added to GROUP BY 

- OR - 

Only in MySQL when it’s set in “Strict Mode”.

If you send the rest of the trace we may be able to help you track down if this is due to a syntax error - or - if your MySQL settings are too strict. 

Dennis Warren, Manager
Colcamex Resources Inc.
[hidden email] | colcamex.com | <a href="tel:(778)%20386-9264" value="+17783869264" target="_blank">778.386.9264



On Mar 5, 2018, at 11:10 AM, Tom Le <[hidden email]> wrote:

isn't in GROUP BY



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users

--
Tom Le

mpeer networks inc.
Suite 720 - 999 W. Broadway
Vancouver, BC, V5Z 1K5
Work # : <a href="tel:(604)%20235-1689" value="+16042351689" target="_blank">(604) 235-1689
Cell # : <a href="tel:(604)%20612-6617" value="+16046126617" target="_blank">(604) 612-6617
Fax # : <a href="tel:(604)%20435-7153" value="+16044357153" target="_blank">(604) 435-7153
http://www.mpeer.net

==========
Confidential: This message (including any attachments) is CONFIDENTIAL and maybe PRIVILEGED. If you are not an intended recipient you are hereby notified that any distribution, copying or use by you of this information is strictly prohibited. If you have received this message in error please immediately notify the sender by phone at <a href="tel:(604)%20612-6617" value="+16046126617" target="_blank">604-612-6617 or by return email and delete all copies of this information from your system. Thank you for you cooperation
==========



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot



_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users






------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: [OSCAR-advanced-users] Error in OSCAR12.1

Colcamex Resources Inc.
Thank you Peter.

Personally I’ve only seen a syntax error like that using MS SQL Server.

Tom;

Can you provide a little more information so that we can help you without guessing?  

Or - at the very least - how to replicate the error.


Dennis Warren, Manager
Colcamex Resources Inc.
[hidden email] | colcamex.com | 778.386.9264



On Mar 7, 2018, at 11:18 AM, Peter Hutten-Czapski <[hidden email]> wrote:


MySQL now defaults to strict
MariaDB defaults to not strict

================
Peter Hutten-Czapski
Haileybury Ontario

"The attitude that ‘if rural people want these services they’ll have to come to the city to get them’ is simply not acceptable…” (Newbery, 1999)

Before printing, think about the environment. Avant d' imprimer, pensez à l'environnement.

On 7 March 2018 at 13:45, Tom Le <[hidden email]> wrote:

Mysql 5.6 default setting for sql_mode is strict.

Thanks


On 2018-03-05 02:02 PM, Colcamex Resources Inc. wrote:
That’s a SQL syntax error. 

That particular error is common with MS SQL when ALL columns are not added to GROUP BY 

- OR - 

Only in MySQL when it’s set in “Strict Mode”.

If you send the rest of the trace we may be able to help you track down if this is due to a syntax error - or - if your MySQL settings are too strict. 

Dennis Warren, Manager
Colcamex Resources Inc.
[hidden email] | colcamex.com | <a href="tel:(778)%20386-9264" value="+17783869264" target="_blank" class="">778.386.9264



On Mar 5, 2018, at 11:10 AM, Tom Le <[hidden email]> wrote:

isn't in GROUP BY



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users

--
Tom Le

mpeer networks inc.
Suite 720 - 999 W. Broadway
Vancouver, BC, V5Z 1K5
Work # : <a href="tel:(604)%20235-1689" value="+16042351689" target="_blank" class="">(604) 235-1689
Cell # : <a href="tel:(604)%20612-6617" value="+16046126617" target="_blank" class="">(604) 612-6617
Fax # : <a href="tel:(604)%20435-7153" value="+16044357153" target="_blank" class="">(604) 435-7153
http://www.mpeer.net

==========
Confidential: This message (including any attachments) is CONFIDENTIAL and maybe PRIVILEGED. If you are not an intended recipient you are hereby notified that any distribution, copying or use by you of this information is strictly prohibited. If you have received this message in error please immediately notify the sender by phone at <a href="tel:(604)%20612-6617" value="+16046126617" target="_blank" class="">604-612-6617 or by return email and delete all copies of this information from your system. Thank you for you cooperation
==========



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot



_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users







------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: [OSCAR-advanced-users] Error in OSCAR12.1

Colcamex Resources Inc.
In reply to this post by Peter Hutten-Czapski-2
Strict mode is defaulted only in MySQL 5.7. - this version is confirmed as not compatible with Oscar. 

Strict mode should be disabled (by default) in MySQL 5.6.  

Oscar works best with MySQL 5.5 - but I have had very few issues with 5.6


Dennis Warren, Manager
Colcamex Resources Inc.
[hidden email] | colcamex.com | 778.386.9264



On Mar 7, 2018, at 11:18 AM, Peter Hutten-Czapski <[hidden email]> wrote:


MySQL now defaults to strict
MariaDB defaults to not strict

================
Peter Hutten-Czapski
Haileybury Ontario

"The attitude that ‘if rural people want these services they’ll have to come to the city to get them’ is simply not acceptable…” (Newbery, 1999)

Before printing, think about the environment. Avant d' imprimer, pensez à l'environnement.

On 7 March 2018 at 13:45, Tom Le <[hidden email]> wrote:

Mysql 5.6 default setting for sql_mode is strict.

Thanks


On 2018-03-05 02:02 PM, Colcamex Resources Inc. wrote:
That’s a SQL syntax error. 

That particular error is common with MS SQL when ALL columns are not added to GROUP BY 

- OR - 

Only in MySQL when it’s set in “Strict Mode”.

If you send the rest of the trace we may be able to help you track down if this is due to a syntax error - or - if your MySQL settings are too strict. 

Dennis Warren, Manager
Colcamex Resources Inc.
[hidden email] | colcamex.com | <a href="tel:(778)%20386-9264" value="+17783869264" target="_blank" class="">778.386.9264



On Mar 5, 2018, at 11:10 AM, Tom Le <[hidden email]> wrote:

isn't in GROUP BY



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users

--
Tom Le

mpeer networks inc.
Suite 720 - 999 W. Broadway
Vancouver, BC, V5Z 1K5
Work # : <a href="tel:(604)%20235-1689" value="+16042351689" target="_blank" class="">(604) 235-1689
Cell # : <a href="tel:(604)%20612-6617" value="+16046126617" target="_blank" class="">(604) 612-6617
Fax # : <a href="tel:(604)%20435-7153" value="+16044357153" target="_blank" class="">(604) 435-7153
http://www.mpeer.net

==========
Confidential: This message (including any attachments) is CONFIDENTIAL and maybe PRIVILEGED. If you are not an intended recipient you are hereby notified that any distribution, copying or use by you of this information is strictly prohibited. If you have received this message in error please immediately notify the sender by phone at <a href="tel:(604)%20612-6617" value="+16046126617" target="_blank" class="">604-612-6617 or by return email and delete all copies of this information from your system. Thank you for you cooperation
==========



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot



_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users







------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: [OSCAR-advanced-users] Error in OSCAR12.1

Peter Hutten-Czapski
You are right on Dennis
no need to switch to MariaDB if you have something that works!

In Ubuntu 16.04 only MySQL 5.7 is available
and
MySQL 5.5 and Ubuntu 12.04 is no longer supported by either Canonical or Oracle

The OSCAR-EMR suggested upgrade is MySQL 5.5 -> MariaDB 5.5 and only then Ubuntu Upgrade which will get you to 16.04 Ubuntu and MariaDB 10, which work without issue after testing by OSCAR-EMR over a few months

Other paths might work, just not tested for insitu upgrades.  (You may need to mysqldump the schema and load it anew into MariaDB 10)
 

================
Peter Hutten-Czapski
Haileybury Ontario

"The attitude that ‘if rural people want these services they’ll have to come to the city to get them’ is simply not acceptable…” (Newbery, 1999)

Before printing, think about the environment. Avant d' imprimer, pensez à l'environnement.

On 7 March 2018 at 15:15, Colcamex Resources Inc. <[hidden email]> wrote:
Strict mode is defaulted only in MySQL 5.7. - this version is confirmed as not compatible with Oscar. 

Strict mode should be disabled (by default) in MySQL 5.6.  

Oscar works best with MySQL 5.5 - but I have had very few issues with 5.6


Dennis Warren, Manager
Colcamex Resources Inc.
[hidden email] | colcamex.com | <a href="tel:(778)%20386-9264" value="+17783869264" target="_blank">778.386.9264



On Mar 7, 2018, at 11:18 AM, Peter Hutten-Czapski <[hidden email]> wrote:


MySQL now defaults to strict
MariaDB defaults to not strict

================
Peter Hutten-Czapski
Haileybury Ontario

"The attitude that ‘if rural people want these services they’ll have to come to the city to get them’ is simply not acceptable…” (Newbery, 1999)

Before printing, think about the environment. Avant d' imprimer, pensez à l'environnement.

On 7 March 2018 at 13:45, Tom Le <[hidden email]> wrote:

Mysql 5.6 default setting for sql_mode is strict.

Thanks


On 2018-03-05 02:02 PM, Colcamex Resources Inc. wrote:
That’s a SQL syntax error. 

That particular error is common with MS SQL when ALL columns are not added to GROUP BY 

- OR - 

Only in MySQL when it’s set in “Strict Mode”.

If you send the rest of the trace we may be able to help you track down if this is due to a syntax error - or - if your MySQL settings are too strict. 

Dennis Warren, Manager
Colcamex Resources Inc.
[hidden email] | colcamex.com | <a href="tel:(778)%20386-9264" value="+17783869264" target="_blank">778.386.9264



On Mar 5, 2018, at 11:10 AM, Tom Le <[hidden email]> wrote:

isn't in GROUP BY



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users

--
Tom Le

mpeer networks inc.
Suite 720 - 999 W. Broadway
Vancouver, BC, V5Z 1K5
Work # : <a href="tel:(604)%20235-1689" value="+16042351689" target="_blank">(604) 235-1689
Cell # : <a href="tel:(604)%20612-6617" value="+16046126617" target="_blank">(604) 612-6617
Fax # : <a href="tel:(604)%20435-7153" value="+16044357153" target="_blank">(604) 435-7153
http://www.mpeer.net

==========
Confidential: This message (including any attachments) is CONFIDENTIAL and maybe PRIVILEGED. If you are not an intended recipient you are hereby notified that any distribution, copying or use by you of this information is strictly prohibited. If you have received this message in error please immediately notify the sender by phone at <a href="tel:(604)%20612-6617" value="+16046126617" target="_blank">604-612-6617 or by return email and delete all copies of this information from your system. Thank you for you cooperation
==========



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot



_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users










------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel