Shoreline Properties, Inc.
Navigation
Rentals
Weekly Condo Rental Search
Mini-Week Condo Rental Search
Search by Building
Policies
Flexible arrival Rental Search
Condo Rental Specials
Sunset Island Search
Any Bayside Rentals
Three and More Bedrooms
Oceanfront Rentals
Guest Services
List with Us
Guest Login
Book with Confidence
Guest Testimonials
Guest Benefits
Exclusive Services
Benefits of Renting a Condo
Benefits of Booking Direct
Policies
Members
Owner Login
Owner Benefits
Owner Testimonials
Your Property's Value
About Ocean City
Ocean City Dining
City Ordinances
Events
Other Important City Ordinances to Note
Things To Do In Ocean City
Resources
Restaurants in Ocean City
Intro to Ocean City
News
Sales
Sales Agents
Ocean City Sales
List With Us
Contact
(800) 492-5832
BrightMLS-Maryland MLS Advanced Search
Login
or
Create an Account
Advanced Search
Listing Company
All Listings
Shoreline Properties, Inc. Listings
MLS Area
BrightMLS-Maryland
BrightMLS-Delaware
MLS Number
Street Address
Subdivision
Waterview / Front
All
N
Y
Search Details
Property Type
All Types
Residential
Land
Commercial
Sort By
Price (Low to High)
Price (High to Low)
Bedrooms
Bathrooms
Listing Date (New to Old)
Listing Date (Old to New)
Stipulations
Foreclosures
Short Sales
Basic Criteria
Minimum Price
No Min
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
$450,000
$500,000
$550,000
$600,000
$650,000
$700,000
$750,000
$800,000
$850,000
$900,000
$950,000
$1,000,000
$1,500,000
$1,600,000
$1,700,000
$1,800,000
$1,900,000
$2,000,000
$2,100,000
$2,200,000
$2,300,000
$2,400,000
$2,500,000
$2,600,000
$2,700,000
$2,800,000
$2,900,000
$3,000,000
$3,100,000
$3,200,000
$3,300,000
$3,400,000
$3,500,000
$3,600,000
$3,700,000
$3,800,000
$3,900,000
$4,000,000
$4,100,000
$4,200,000
$4,300,000
$4,400,000
$4,500,000
$4,600,000
$4,700,000
$4,800,000
$4,900,000
$5,000,000
$5,100,000
$5,200,000
$5,300,000
$5,400,000
$5,500,000
$5,600,000
$5,700,000
$5,800,000
$5,900,000
$6,000,000
$6,100,000
$6,200,000
$6,300,000
$6,400,000
$6,500,000
$6,600,000
$6,700,000
$6,800,000
$6,900,000
$7,000,000
$7,100,000
$7,200,000
$7,300,000
$7,400,000
$7,500,000
$7,600,000
$7,700,000
$7,800,000
$7,900,000
$8,000,000
$8,100,000
$8,200,000
$8,300,000
$8,400,000
$8,500,000
$8,600,000
$8,700,000
$8,800,000
$8,900,000
$9,000,000
$9,100,000
$9,200,000
$9,300,000
$9,400,000
$9,500,000
$9,600,000
$9,700,000
$9,800,000
$9,900,000
$10,000,000
Maximum Price
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
$450,000
$500,000
$550,000
$600,000
$650,000
$700,000
$750,000
$800,000
$850,000
$900,000
$950,000
$1,000,000
$1,500,000
$1,600,000
$1,700,000
$1,800,000
$1,900,000
$2,000,000
$2,100,000
$2,200,000
$2,300,000
$2,400,000
$2,500,000
$2,600,000
$2,700,000
$2,800,000
$2,900,000
$3,000,000
$3,100,000
$3,200,000
$3,300,000
$3,400,000
$3,500,000
$3,600,000
$3,700,000
$3,800,000
$3,900,000
$4,000,000
$4,100,000
$4,200,000
$4,300,000
$4,400,000
$4,500,000
$4,600,000
$4,700,000
$4,800,000
$4,900,000
$5,000,000
$5,100,000
$5,200,000
$5,300,000
$5,400,000
$5,500,000
$5,600,000
$5,700,000
$5,800,000
$5,900,000
$6,000,000
$6,100,000
$6,200,000
$6,300,000
$6,400,000
$6,500,000
$6,600,000
$6,700,000
$6,800,000
$6,900,000
$7,000,000
$7,100,000
$7,200,000
$7,300,000
$7,400,000
$7,500,000
$7,600,000
$7,700,000
$7,800,000
$7,900,000
$8,000,000
$8,100,000
$8,200,000
$8,300,000
$8,400,000
$8,500,000
$8,600,000
$8,700,000
$8,800,000
$8,900,000
$9,000,000
$9,100,000
$9,200,000
$9,300,000
$9,400,000
$9,500,000
$9,600,000
$9,700,000
$9,800,000
$9,900,000
$10,000,000
No Max
Bedrooms
No Preference
1+ Bedrooms
1 Bedrooms
2+ Bedrooms
2 Bedrooms
3+ Bedrooms
3 Bedrooms
4+ Bedrooms
4 Bedrooms
5+ Bedrooms
5 Bedrooms
6+ Bedrooms
6 Bedrooms
7+ Bedrooms
7 Bedrooms
8+ Bedrooms
8 Bedrooms
9+ Bedrooms
9 Bedrooms
10+ Bedrooms
10 Bedrooms
Bathrooms
No Preference
1+ Bathrooms
2+ Bathrooms
3+ Bathrooms
4+ Bathrooms
5+ Bathrooms
Days On Market
All Days
1 Day
7 Days
14 Days
30 Days
Kind
Any
Sq. Footage Min.
Min
500
1000
1500
2000
2500
3000
3500
4000
4500
5000
5000+
Sq. Footage Max.
Max
500
1000
1500
2000
2500
3000
3500
4000
4500
5000
5000+
Central Air
Any
Yes
No
Gas Heat
Any
Yes
No
Garage
Any
Yes
No
Pool
Any
Yes
No
Fence
Any
Yes
No
Boat Slip
Any
Yes
No
Water Views
Any
Yes
No
Fireplace
Any
Yes
No
Patio
Any
Yes
No
New Construction
Any
Yes
No
Select An Area
Area
Worcester East of Rt
Worcester Ocean Pines
Worcester West of Rt
City
struct
Cause
struct
ErrorCode
1055
Message
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mlsv30master.fields_cities.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQLState
42000
StackTrace
java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mlsv30master.fields_cities.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975) at com.mysql.cj.jdbc.ClientPreparedStatement.$fr$execute(ClientPreparedStatement.java:392) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1501) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cffields2ecfc1722901080$funcGETSEARCHCITIES.runFunction(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\fields.cfc:258) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfindex2ecfm475651297._factor2(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm:624) at cfindex2ecfm475651297.runPage(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at sun.reflect.GeneratedMethodAccessor134.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:809) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at sun.reflect.GeneratedMethodAccessor97.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
258
RAW_TRACE
at cffields2ecfc1722901080$funcGETSEARCHCITIES.runFunction(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\fields.cfc:258)
TEMPLATE
E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\fields.cfc
TYPE
CFML
2
struct
COLUMN
0
ID
CF_TEMPLATEPROXY
LINE
624
RAW_TRACE
at cfindex2ecfm475651297._factor2(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm:624)
TEMPLATE
E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_INDEX
LINE
1
RAW_TRACE
at cfindex2ecfm475651297.runPage(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm:1)
TEMPLATE
E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm
TYPE
CFML
Type
java.sql.SQLSyntaxErrorException
DataSource
mlsv30master
Detail
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mlsv30master.fields_cities.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
ErrorCode
42000
Exceptions
array
1
struct
class
java.sql.SQLSyntaxErrorException
message
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mlsv30master.fields_cities.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Message
Error Executing Database Query.
NativeErrorCode
1055
RootCause
struct
ErrorCode
1055
Message
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mlsv30master.fields_cities.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQLState
42000
StackTrace
java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mlsv30master.fields_cities.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975) at com.mysql.cj.jdbc.ClientPreparedStatement.$fr$execute(ClientPreparedStatement.java:392) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1501) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cffields2ecfc1722901080$funcGETSEARCHCITIES.runFunction(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\fields.cfc:258) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfindex2ecfm475651297._factor2(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm:624) at cfindex2ecfm475651297.runPage(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at sun.reflect.GeneratedMethodAccessor134.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:809) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at sun.reflect.GeneratedMethodAccessor97.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
258
RAW_TRACE
at cffields2ecfc1722901080$funcGETSEARCHCITIES.runFunction(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\fields.cfc:258)
TEMPLATE
E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\fields.cfc
TYPE
CFML
2
struct
COLUMN
0
ID
CF_TEMPLATEPROXY
LINE
624
RAW_TRACE
at cfindex2ecfm475651297._factor2(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm:624)
TEMPLATE
E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_INDEX
LINE
1
RAW_TRACE
at cfindex2ecfm475651297.runPage(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm:1)
TEMPLATE
E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm
TYPE
CFML
Type
java.sql.SQLSyntaxErrorException
SQLState
42000
Sql
select id, city, city as areashidden, fields_cities.display_on_advanced, fields_cities.display_on_refine, fields_cities.display_on_quick from fields_cities where siteid= (param 1) and mlsid IN( (param 2) , (param 3) ) and city in ( select distinct(mastertable.city) from mlsv30master.mastertable where mastertable.mlsid IN( (param 4) ) ) and city IN('Berlin','Ocean City','Ocean Pines') group by city order by city
StackTrace
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:867) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cffields2ecfc1722901080$funcGETSEARCHCITIES.runFunction(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\fields.cfc:258) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfindex2ecfm475651297._factor2(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm:624) at cfindex2ecfm475651297.runPage(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at sun.reflect.GeneratedMethodAccessor134.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:809) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at sun.reflect.GeneratedMethodAccessor97.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mlsv30master.fields_cities.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975) at com.mysql.cj.jdbc.ClientPreparedStatement.$fr$execute(ClientPreparedStatement.java:392) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1501) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) ... 70 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
258
RAW_TRACE
at cffields2ecfc1722901080$funcGETSEARCHCITIES.runFunction(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\fields.cfc:258)
TEMPLATE
E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\fields.cfc
TYPE
CFML
2
struct
COLUMN
0
ID
CF_TEMPLATEPROXY
LINE
624
RAW_TRACE
at cfindex2ecfm475651297._factor2(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm:624)
TEMPLATE
E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm
TYPE
CFML
3
struct
COLUMN
0
ID
CF_INDEX
LINE
1
RAW_TRACE
at cfindex2ecfm475651297.runPage(E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm:1)
TEMPLATE
E:\inetpub\wwwroot\domains\shorepro.com\htdocs\mls\index.cfm
TYPE
CFML
Type
Database
queryError
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mlsv30master.fields_cities.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
where
(param 1) = [type='IN', class='java.lang.Integer', value='24', sqltype='cf_sql_integer'] , (param 2) = [type='IN', class='java.lang.Integer', value='28', sqltype='CF_SQL_INTEGER'] , (param 3) = [type='IN', class='java.lang.Integer', value='29', sqltype='CF_SQL_INTEGER'] , (param 4) = [type='IN', class='java.lang.Integer', value='28', sqltype='CF_SQL_INTEGER']
