What is the Shelf Life of Your Website?

Has Your Website’s “Freshness Date” Expired?

Updating your website with fresh content is the best way to ensure that your company is being found on the web. Google or any other search engine ranks the most relevant and interesting topics at the top so that consumer searches consistently yield the best results.

However, for many small businesses, the usefulness of their website isn’t top-of-mind, or they’re concerned re-design just isn’t in the budget.

Have you considered a re-write?

Now, I know that most services and products aren’t very electrifying to write about, or need constant updating, and I’m not suggesting you come up with 100 ways to write about your great customer service.

Instead, include other engaging and informative content – community events, helpful tips, industry articles – and you’ll position your company as a trusted source that is concerned about helping its customers.  Isn’t that what your website is for anyway?

In freshening up your website, here are some points to consider:

Always Be Original! Copy and pasting content from another source or using “generic copy” that doesn’t contain unique keywords can hurt your chances of being found by a customer. Using duplicate material across your site can harm your site’s ranking, as well.

A good benchmark is to strive for somewhere in the 60% unique content range to stay in good graces with the search engines. Be unusual!  Use your copy to talk about what sets your company apart!

Update Often

Now is the time to rewrite your old content. Updated pages tell the search engine crawlers to “check on me often” to see if there is fresh content. Updated pages maintain a higher placement in search engine results.

While we’re talking about updates, if nothing else, make sure that your product information is current!  Don’t give the impression to members that you are out of touch, and lose an opportunity to turn a shopper into a customer.

Archive Old Content

Archiving, or removing old irrelevant copy helps to reduce your website’s “page totals”, and increases your ratio of fresh-to-stale content.  Keeping older, irrelevant pages can offset your chances of being recognized for your fresh, informative copy.

Fresh content will keep members and prospects coming back and will position your business as a trusted source of quality information. Staying relevant is much easier if your website has a CMS (Customer Management System) to make updating your site as easy as typing a Word document.

Lastly, be sure there is someone at your company in charge of updating.  Too many times updates are ignored because it's assumed someone else has done it.

Date/Time: 8/10/20 4:30 PM

Error: Error Executing Database Query.

Line No.: 527

Script: www.skadv.com/index.cfm?p=what-is-the-shelf-life-of-your-website/

Referring Page:

User IP: 18.207.98.97

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 15:30:57'}' OR c.start_date IS NULL) ORDER BY c.created_date...' at line 3
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 15:30:57'}' OR c.start_date IS NULL) ORDER BY c.created_date...' at line 3 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 cffunctions2ecfc412872186$funcGET_PREV_POST.runFunction(C:\home\skadv.com\wwwroot\site_theme\functions.cfc:527) 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_post2ecfm247233177.runPage(C:\home\skadv.com\wwwroot\site_theme\template_parts\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 cfpost2ecfm65058832.runPage(C:\home\skadv.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 cfindex2ecfm741057451.runPage(C:\home\skadv.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 527
RAW_TRACE at cffunctions2ecfc412872186$funcGET_PREV_POST.runFunction(C:\home\skadv.com\wwwroot\site_theme\functions.cfc:527)
TEMPLATE C:\home\skadv.com\wwwroot\site_theme\functions.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 1
RAW_TRACE at cfnavigation_prev_next_post2ecfm247233177.runPage(C:\home\skadv.com\wwwroot\site_theme\template_parts\navigation_prev_next_post.cfm:1)
TEMPLATE C:\home\skadv.com\wwwroot\site_theme\template_parts\navigation_prev_next_post.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1
RAW_TRACE at cfpost2ecfm65058832.runPage(C:\home\skadv.com\wwwroot\site_theme\post.cfm:1)
TEMPLATE C:\home\skadv.com\wwwroot\site_theme\post.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1
RAW_TRACE at cfindex2ecfm741057451.runPage(C:\home\skadv.com\wwwroot\index.cfm:1)
TEMPLATE C:\home\skadv.com\wwwroot\index.cfm
TYPE CFML
Type com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
DataSource skadvdb1
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 15:30:57'}' OR c.start_date IS NULL) ORDER BY c.created_date...' at line 3
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 15:30:57'}' OR c.start_date IS NULL) ORDER BY c.created_date...' at line 3
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 15:30:57'}' OR c.start_date IS NULL) ORDER BY c.created_date...' at line 3
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 15:30:57'}' OR c.start_date IS NULL) ORDER BY c.created_date...' at line 3 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 cffunctions2ecfc412872186$funcGET_PREV_POST.runFunction(C:\home\skadv.com\wwwroot\site_theme\functions.cfc:527) 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_post2ecfm247233177.runPage(C:\home\skadv.com\wwwroot\site_theme\template_parts\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 cfpost2ecfm65058832.runPage(C:\home\skadv.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 cfindex2ecfm741057451.runPage(C:\home\skadv.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 527
RAW_TRACE at cffunctions2ecfc412872186$funcGET_PREV_POST.runFunction(C:\home\skadv.com\wwwroot\site_theme\functions.cfc:527)
TEMPLATE C:\home\skadv.com\wwwroot\site_theme\functions.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 1
RAW_TRACE at cfnavigation_prev_next_post2ecfm247233177.runPage(C:\home\skadv.com\wwwroot\site_theme\template_parts\navigation_prev_next_post.cfm:1)
TEMPLATE C:\home\skadv.com\wwwroot\site_theme\template_parts\navigation_prev_next_post.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1
RAW_TRACE at cfpost2ecfm65058832.runPage(C:\home\skadv.com\wwwroot\site_theme\post.cfm:1)
TEMPLATE C:\home\skadv.com\wwwroot\site_theme\post.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1
RAW_TRACE at cfindex2ecfm741057451.runPage(C:\home\skadv.com\wwwroot\index.cfm:1)
TEMPLATE C:\home\skadv.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 sk_content c,sk_content_to_category ctc,sk_categories cc WHERE ctc.catid = 9 AND cc.catid = ctc.catid AND c.cid = ctc.cid AND c.created_date > {ts '2014-01-04 15:49:00'} AND c.cid != 50 AND c.post_type = 'linked' AND c.display = 'y' AND c.status = 'Published' AND (c.start_date <= '{ts '2020-08-10 15:30:57'}' OR c.start_date IS NULL) 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 cffunctions2ecfc412872186$funcGET_PREV_POST.runFunction(C:\home\skadv.com\wwwroot\site_theme\functions.cfc:527) 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_post2ecfm247233177.runPage(C:\home\skadv.com\wwwroot\site_theme\template_parts\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 cfpost2ecfm65058832.runPage(C:\home\skadv.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 cfindex2ecfm741057451.runPage(C:\home\skadv.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 15:30:57'}' OR c.start_date IS NULL) ORDER BY c.created_date...' at line 3 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 527
RAW_TRACE at cffunctions2ecfc412872186$funcGET_PREV_POST.runFunction(C:\home\skadv.com\wwwroot\site_theme\functions.cfc:527)
TEMPLATE C:\home\skadv.com\wwwroot\site_theme\functions.cfc
TYPE CFML
2
Error - struct
COLUMN 0
ID CFINVOKE
LINE 1
RAW_TRACE at cfnavigation_prev_next_post2ecfm247233177.runPage(C:\home\skadv.com\wwwroot\site_theme\template_parts\navigation_prev_next_post.cfm:1)
TEMPLATE C:\home\skadv.com\wwwroot\site_theme\template_parts\navigation_prev_next_post.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1
RAW_TRACE at cfpost2ecfm65058832.runPage(C:\home\skadv.com\wwwroot\site_theme\post.cfm:1)
TEMPLATE C:\home\skadv.com\wwwroot\site_theme\post.cfm
TYPE CFML
4
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 1
RAW_TRACE at cfindex2ecfm741057451.runPage(C:\home\skadv.com\wwwroot\index.cfm:1)
TEMPLATE C:\home\skadv.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 15:30:57'}' OR c.start_date IS NULL) ORDER BY c.created_date...' at line 3
where [empty string]
FORM - struct [empty]
URL - struct
p what-is-the-shelf-life-of-your-website/
SESSION - struct
sessionid 545A2E441B5F8FD583807720F0711AB2.cfusion
time_zone MST
urltoken CFID=5222020&CFTOKEN=650e49096f994e73-86D5E4E8-C1A7-A8C0-15570F457627536C&jsessionid=545A2E441B5F8FD583807720F0711AB2.cfusion