Website Redesign: A balancing act between functional and fancy.

A static website with no interactive elements and dull, unchanging content can give a lackluster impression of your brand. But a site with too many font styles, colors and photos vying for attention will confuse and frustrate your visitor. For a website to be successful, there needs to be a deliberate relationship between form and function.

It’s not about you. It’s about them.
We’ve spent hours drafting redesigns for sites appealing to opinions of CEOs, marketing directors and the like. No big deal, that’s our job.

When the site starts getting too specific to one person’s taste, though, it’s time to reel it back in. Often the needs of the consumer get ignored when redesigning the site to look “cool” or “pretty.” The addition of too many trendy features can disrupt the delicate balance between functional and fancy.

While making an impression with great visuals is important, you need to ensure users won’t get frustrated with fancy features and complex organization. If your site isn’t easily navigated, your content won’t easily be found, and visitors will go elsewhere.

Don’t frustrate your members.
Remember that the bulk of your site’s repeat visitors will be your members. The home page that wows them the first time with animation, taking several clicks to get to your content -- will quickly turn annoying to sit through while your page loads.

Visitors come to your site to fulfill a banking need, not to consume art. The quickest and easiest way to communicate that you can help is the best design for you. Accomplish this by putting yourself in their mind:

  • What do they need? What words would they use in a search for information about this?
  • How will you help them solve their problem?
  • What are other factors affecting their decision? For a new bank, on a loan product, on a mortgage?
  • How would they accomplish this task in one of your branches? For example, how would they transfer money between accounts? It should be easier to accomplish online!

If you approach your website redesign with usability as your first goal, you can’t lose. Get that right before adding in the visuals. Don’t introduce features just because they’re trendy, especially if they don’t enhance usability. If your users can complete their task with minimal questions and frustrations, your website is sure to impress visitors and increase conversions.

What more could you ask for?

Date/Time: 8/10/20 7:52 PM

Error: Error Executing Database Query.

Line No.: 1

Script: www.creditunionwebdesign.com/index.cfm?p=website-redesign-a-balancing-act-between-functional-and-fancy/

Referring Page:

User IP: 3.226.245.48

Error - struct
Cause
Error - struct
ErrorCode 1064
Message You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2020-08-10 18:52:52'}' OR c.start_date IS NULL) AND (c.start_date IS NULL OR ...' at line 1
SQLState 42000
StackTrace com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2020-08-10 18:52:52'}' OR c.start_date IS NULL) AND (c.start_date IS NULL OR ...' at line 1 at jdk.internal.reflect.GeneratedConstructorAccessor853.newInstance(Unknown Source) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449) at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:939) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cffunctions2ecfc1920561524$funcGET_PREV_POST.runFunction(C:\home\creditunionwebdesign.com\wwwroot\site_theme\functions.cfc:1) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:597) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3506) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3481) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4287) at cfnavigation_prev_next_post2ecfm1238164707.runPage(C:\home\creditunionwebdesign.com\wwwroot\site_theme\navigation\navigation_prev_next_post.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfpost2ecfm1665657854.runPage(C:\home\creditunionwebdesign.com\wwwroot\site_theme\post.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfindex2ecfm330623847.runPage(C:\home\creditunionwebdesign.com\wwwroot\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:557) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 1
RAW_TRACE at cffunctions2ecfc1920561524$funcGET_PREV_POST.runFunction(C:\home\creditunionwebdesign.com\wwwroot\site_theme\functions.cfc:1)
TEMPLATE C:\home\creditunionwebdesign.com\wwwroot\site_theme\functions.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 1
RAW_TRACE at cfnavigation_prev_next_post2ecfm1238164707.runPage(C:\home\creditunionwebdesign.com\wwwroot\site_theme\navigation\navigation_prev_next_post.cfm:1)
TEMPLATE C:\home\creditunionwebdesign.com\wwwroot\site_theme\navigation\navigation_prev_next_post.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1
RAW_TRACE at cfpost2ecfm1665657854.runPage(C:\home\creditunionwebdesign.com\wwwroot\site_theme\post.cfm:1)
TEMPLATE C:\home\creditunionwebdesign.com\wwwroot\site_theme\post.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1
RAW_TRACE at cfindex2ecfm330623847.runPage(C:\home\creditunionwebdesign.com\wwwroot\index.cfm:1)
TEMPLATE C:\home\creditunionwebdesign.com\wwwroot\index.cfm
TYPE CFML
Type com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
DataSource cuwebdesign
Detail You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2020-08-10 18:52:52'}' OR c.start_date IS NULL) AND (c.start_date IS NULL OR ...' at line 1
ErrorCode 42000
Exceptions
Error - array
1
Error - struct
class com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
message You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2020-08-10 18:52:52'}' OR c.start_date IS NULL) AND (c.start_date IS NULL OR ...' at line 1
Message Error Executing Database Query.
NativeErrorCode 1064
RootCause
Error - struct
ErrorCode 1064
Message You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2020-08-10 18:52:52'}' OR c.start_date IS NULL) AND (c.start_date IS NULL OR ...' at line 1
SQLState 42000
StackTrace com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2020-08-10 18:52:52'}' OR c.start_date IS NULL) AND (c.start_date IS NULL OR ...' at line 1 at jdk.internal.reflect.GeneratedConstructorAccessor853.newInstance(Unknown Source) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449) at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:939) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cffunctions2ecfc1920561524$funcGET_PREV_POST.runFunction(C:\home\creditunionwebdesign.com\wwwroot\site_theme\functions.cfc:1) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:597) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3506) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3481) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4287) at cfnavigation_prev_next_post2ecfm1238164707.runPage(C:\home\creditunionwebdesign.com\wwwroot\site_theme\navigation\navigation_prev_next_post.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfpost2ecfm1665657854.runPage(C:\home\creditunionwebdesign.com\wwwroot\site_theme\post.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfindex2ecfm330623847.runPage(C:\home\creditunionwebdesign.com\wwwroot\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:557) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 1
RAW_TRACE at cffunctions2ecfc1920561524$funcGET_PREV_POST.runFunction(C:\home\creditunionwebdesign.com\wwwroot\site_theme\functions.cfc:1)
TEMPLATE C:\home\creditunionwebdesign.com\wwwroot\site_theme\functions.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 1
RAW_TRACE at cfnavigation_prev_next_post2ecfm1238164707.runPage(C:\home\creditunionwebdesign.com\wwwroot\site_theme\navigation\navigation_prev_next_post.cfm:1)
TEMPLATE C:\home\creditunionwebdesign.com\wwwroot\site_theme\navigation\navigation_prev_next_post.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1
RAW_TRACE at cfpost2ecfm1665657854.runPage(C:\home\creditunionwebdesign.com\wwwroot\site_theme\post.cfm:1)
TEMPLATE C:\home\creditunionwebdesign.com\wwwroot\site_theme\post.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1
RAW_TRACE at cfindex2ecfm330623847.runPage(C:\home\creditunionwebdesign.com\wwwroot\index.cfm:1)
TEMPLATE C:\home\creditunionwebdesign.com\wwwroot\index.cfm
TYPE CFML
Type com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
SQLState 42000
Sql SELECT cc.alias,c.created_date,c.start_date,c.alias,c.content_url,c.title FROM cuwd_content c,cuwd_content_to_category ctc,cuwd_categories cc WHERE ctc.catid = 3 AND cc.catid = ctc.catid AND c.cid = ctc.cid AND c.created_date > {ts '2016-12-12 11:00:07'} AND c.cid != 64 AND c.post_type = 'linked' AND c.display = 'y' AND c.status = 'Published' AND (c.start_date <= '{ts '2020-08-10 18:52:52'}' OR c.start_date IS NULL) AND (c.start_date IS NULL OR {ts '2020-08-10 18:52:52'} >= c.start_date AND (c.start_date IS NULL OR {ts '2020-08-10 18:52:52'} >= c.start_date AND (c.expire_date IS NULL OR {ts '2020-08-10 18:52:52'} <= c.expire_date))) ORDER BY c.created_date LIMIT 1
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:894) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cffunctions2ecfc1920561524$funcGET_PREV_POST.runFunction(C:\home\creditunionwebdesign.com\wwwroot\site_theme\functions.cfc:1) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:597) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3506) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3481) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:472) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4287) at cfnavigation_prev_next_post2ecfm1238164707.runPage(C:\home\creditunionwebdesign.com\wwwroot\site_theme\navigation\navigation_prev_next_post.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfpost2ecfm1665657854.runPage(C:\home\creditunionwebdesign.com\wwwroot\site_theme\post.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286) at cfindex2ecfm330623847.runPage(C:\home\creditunionwebdesign.com\wwwroot\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:557) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2020-08-10 18:52:52'}' OR c.start_date IS NULL) AND (c.start_date IS NULL OR ...' at line 1 at jdk.internal.reflect.GeneratedConstructorAccessor853.newInstance(Unknown Source) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449) at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:939) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1567) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) ... 70 more
Suppressed
Error - array[empty]
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 1
RAW_TRACE at cffunctions2ecfc1920561524$funcGET_PREV_POST.runFunction(C:\home\creditunionwebdesign.com\wwwroot\site_theme\functions.cfc:1)
TEMPLATE C:\home\creditunionwebdesign.com\wwwroot\site_theme\functions.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 1
RAW_TRACE at cfnavigation_prev_next_post2ecfm1238164707.runPage(C:\home\creditunionwebdesign.com\wwwroot\site_theme\navigation\navigation_prev_next_post.cfm:1)
TEMPLATE C:\home\creditunionwebdesign.com\wwwroot\site_theme\navigation\navigation_prev_next_post.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1
RAW_TRACE at cfpost2ecfm1665657854.runPage(C:\home\creditunionwebdesign.com\wwwroot\site_theme\post.cfm:1)
TEMPLATE C:\home\creditunionwebdesign.com\wwwroot\site_theme\post.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1
RAW_TRACE at cfindex2ecfm330623847.runPage(C:\home\creditunionwebdesign.com\wwwroot\index.cfm:1)
TEMPLATE C:\home\creditunionwebdesign.com\wwwroot\index.cfm
TYPE CFML
Type Database
queryError You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2020-08-10 18:52:52'}' OR c.start_date IS NULL) AND (c.start_date IS NULL OR ...' at line 1
where [empty string]
FORM - struct [empty]
URL - struct
p website-redesign-a-balancing-act-between-functional-and-fancy/
SESSION - struct
sessionid A0F09F013E59EDB2755448DCCCD66F31.cfusion
time_zone MST
urltoken CFID=5228488&CFTOKEN=aaff849897818571-8E0E68EE-B9A0-599E-91D276BB7600BBA5&jsessionid=A0F09F013E59EDB2755448DCCCD66F31.cfusion