Camping TCS "Le Petit Bois"
The campsite of Morges profits from a excellent situation on the shores of Lake Geneva between the port Petit Bois and the swimming pool. There is also the possibility to rent a bungalow.
On the campsite Petit Bois there is a grocery, a restaurant, a laundry, a carnotzet, sanitary facilities (handicapped accessible), a big playground, a pétanque track, a kitchen (open to the guests), internet access and wireless LAN. The guests of the campsite are allowed to use the swimming pool for free.
There is the possibility to rent a bungalow (handicapped accessible).
In the port there are landing places for the boats of the visitors.
Ideal place for families. Animations and activities are regularly organized.
Address
Camping TCS "Le Petit-Bois"
Promenade du Petit Bois 15
1110 Morges
Promenade du Petit Bois 15
1110 Morges
Phone +41 (0)21 801 12 70
Fax +41 (0)21 803 38 69
Fax +41 (0)21 803 38 69
An unexpected error occurred.
Please provide the following information to technical support:
Error Event:
Error details:
| struct | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cause |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DataSource | web | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Detail | Column 'sortorder' in order clause is ambiguous | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ErrorCode | 23000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Message | Error Executing Database Query. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| NativeErrorCode | 1052 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| RootCause |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| SQLState | 23000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sql | select SQL_NO_CACHE distinct P.PAGE_ID as pageId, N.NODE_ID as nodeId, NR.sortorder as nodeOrder, IFNULL(PD.VISIBLE,0) as visibleLang ,P.sortorder IS NULL AS isnull ,IFNULL(PD.title_offe,PDDFLT.title_offe) as title ,IFNULL(PD.navcode,PDDFLT.navcode) as navcode from G_NODES N join G_NODES_REL NR on (NR.NODE_ID=N.NODE_ID) join G_PAGES P on ( P.PAGE_ID=N.PAGE_ID and P.DELETED= (param 1) and P.VISIBLE= (param 2) ) join G_NODES_SITES_REL NSR on (NSR.NODE_ID=N.NODE_ID and NSR.SITE_ID= (param 3) ) left outer join G_PAGES_DETAILS PD on (PD.PAGE_ID=N.PAGE_ID and PD.DELETED= (param 4) and PD.VISIBLE= (param 5) and PD.LANGUAGE = (param 6) ) left outer join G_PAGES_DETAILS PDDFLT on (PDDFLT.PAGE_ID=N.PAGE_ID and PDDFLT.DELETED= (param 7) and PDDFLT.VISIBLE= (param 8) and PDDFLT.LANGUAGE=P.DEFAULT_LANG) where N.DELETED= (param 9) and NR.PARENT_NODE_ID = ( select N2.NODE_ID from G_NODES N2 join G_NODES_SITES_REL NSR2 on (NSR2.NODE_ID=N2.NODE_ID and NSR2.SITE_ID= (param 10) ) join G_PAGES_DETAILS PD2 on (PD2.PAGE_ID=N2.PAGE_ID and PD2.DELETED= (param 11) and PD2.VISIBLE= (param 12) ) join G_PAGES P2 on (P2.PAGE_ID=PD2.PAGE_ID and P2.DELETED= (param 13) ) where N2.DELETED= (param 14) and PD2.NAVCODE= (param 15) limit 1) and ((P.online_from <= '2012-05-21 18:55:03' and P.online_to >= '2012-05-21 18:55:03') OR (P.online_from IS NULL and P.online_to >= '2012-05-21 18:55:03') OR (P.online_from <= '2012-05-21 18:55:03' and P.online_to IS NULL) OR (P.online_from IS NULL and P.online_to IS NULL)) order by sortorder | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| StackTrace | coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:583) at cfoutput2ecfc587473406$funcGETNODELIST.runFunction(/mnt/gadmin4/cfc/output.cfc:509) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222) at cf8005_22509_en2ecfm456794143._factor13(/mnt/pages/119/en/8005_22509_en.cfm:294) at cf8005_22509_en2ecfm456794143._factor15(/mnt/pages/119/en/8005_22509_en.cfm:285) at cf8005_22509_en2ecfm456794143.runPage(/mnt/pages/119/en/8005_22509_en.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at cfpage2ecfm2041460619.runPage(/mnt/webroot/sites/otv_morges/html/page.cfm:17) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column 'sortorder' in order clause is ambiguous at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715) at com.mysql.jdbc.Connection.execSQL(Connection.java:3249) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:843) at coldfusion.sql.Executive.executeQuery(Executive.java:1249) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) ... 46 more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| TagContext |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Type | Database | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| queryError | Column 'sortorder' in order clause is ambiguous | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| where | (param 1) = [type='IN', class='java.math.BigDecimal', value='0', sqltype='cf_sql_numeric', scale='0'] , (param 2) = [type='IN', class='java.math.BigDecimal', value='1', sqltype='cf_sql_numeric', scale='0'] , (param 3) = [type='IN', class='java.math.BigDecimal', value='119', sqltype='cf_sql_numeric', scale='0'] , (param 4) = [type='IN', class='java.math.BigDecimal', value='0', sqltype='cf_sql_numeric', scale='0'] , (param 5) = [type='IN', class='java.math.BigDecimal', value='1', sqltype='cf_sql_numeric', scale='0'] , (param 6) = [type='IN', class='java.lang.String', value='en', sqltype='cf_sql_varchar'] , (param 7) = [type='IN', class='java.math.BigDecimal', value='0', sqltype='cf_sql_numeric', scale='0'] , (param 8) = [type='IN', class='java.math.BigDecimal', value='1', sqltype='cf_sql_numeric', scale='0'] , (param 9) = [type='IN', class='java.math.BigDecimal', value='0', sqltype='cf_sql_numeric', scale='0'] , (param 10) = [type='IN', class='java.math.BigDecimal', value='119', sqltype='cf_sql_numeric', scale='0'] , (param 11) = [type='IN', class='java.math.BigDecimal', value='0', sqltype='cf_sql_numeric', scale='0'] , (param 12) = [type='IN', class='java.math.BigDecimal', value='1', sqltype='cf_sql_numeric', scale='0'] , (param 13) = [type='IN', class='java.math.BigDecimal', value='0', sqltype='cf_sql_numeric', scale='0'] , (param 14) = [type='IN', class='java.math.BigDecimal', value='0', sqltype='cf_sql_numeric', scale='0'] , (param 15) = [type='IN', class='java.lang.String', value='campsites', sqltype='cf_sql_varchar'] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||







