Conference : Galleon Forums : Use this conference to discuss Galleon the product. http://www.raymondcamden.com/forums Did you import the DB script? The error says it can't find galleon_conferences. Ensure the table was created. http://www.raymondcamden.com/forumsmessages.cfm?threadid=A75BB784-EDF5-4E7F-8106508B41E14303&r=1 2013-04-26T09:56:17-04:00 The cursor was not declared sure, here we go, this is my settings.ini.cfm: [settings] dsn=galleon2 perpage=10 fromAddress=admin@webprojects.ch rootURL=http://www.bbq24.ch/forum/ sendonpost=admin@webprojects.ch dbtype=sqlserver tableprefix=galleon_ version=2.6.2 requireconfirmation=true title=BBQ24.CH fullemails=true encryptpasswords=true allowavatars=true safeExtensions=zip,tar,jpg,gif,png,wpd,doc,pdf,xls,ppt,txt,odt bbcode_editor=true mailserver= mailusername= mailpassword= allowpms=true tempdir= preheaderlinkstext= preheaderlinksurl= http://www.raymondcamden.com/forumsmessages.cfm?threadid=A75BB784-EDF5-4E7F-8106508B41E14303&r=2 2013-04-26T07:23:43-04:00 The cursor was not declared Hmm. In your settings.ini.cfm, id you specify the dbtype correctly? Also, where did you specify BBQ24? You may want to just share the entire ini file with me. http://www.raymondcamden.com/forumsmessages.cfm?threadid=A75BB784-EDF5-4E7F-8106508B41E14303&r=3 2013-04-26T07:15:59-04:00 The cursor was not declared hi, i just tried to install this great forum at hostek: - ms sql db 2012 - cf version 10,0,9,284568 after uploading and running i am getting this error: http://www.bbq24.ch/forum/ any idea what i am doing wrong? all setting in the settings.ini.cfm file should be correct, but what i dont understand is, that the forum name (should be BBQ24) is still "Galleon Forums". dsn=galleon2 rootURL=http://www.bbq24.ch/forum/ dbtype=sqlserver title=BBQ24.CH maybe some variables are stored in cache? any way to reset them and reinstall? any help would be appreciated. sascha http://www.raymondcamden.com/forumsmessages.cfm?threadid=A75BB784-EDF5-4E7F-8106508B41E14303&r=4 2013-04-25T21:22:56-04:00 The cursor was not declared FYI, it looks like this may be more serious then thought. Please ensure you are patched up completely. http://www.raymondcamden.com/forumsmessages.cfm?threadid=C60102CA-9221-2FD6-A3CEDCAA37CDBF73&r=5 2013-04-17T07:32:37-04:00 Can not decode string "-1'= It is a bug with cflogin. I've seen this too. You can ignore it. It appears to be someone trying to hack via SQL Injection and cflogin throws an error on it. http://www.raymondcamden.com/forumsmessages.cfm?threadid=C60102CA-9221-2FD6-A3CEDCAA37CDBF73&r=6 2013-03-11T14:00:28-04:00 Can not decode string "-1'= Additional info: The line referred to in the error is 124 125 <cflogin> http://www.raymondcamden.com/forumsmessages.cfm?threadid=C60102CA-9221-2FD6-A3CEDCAA37CDBF73&r=7 2013-03-11T12:49:56-04:00 Can not decode string "-1'= I have been seeing a lot of "Can not decode string "-1'=" errors in the last few days. Possibly a hack attempt? Anybody have any ideas? Message attached below: Error Occured: Date: 2/25/13 5:17 PM Script Name: /booktalk/messages.cfm?threadid=C88D62E0-5056-A34B-625F9B9B1D48BDD6 Browser: Mozilla/4.0 (compatible; Synapse) Referer: Message: '' Can not decode string "-1'=". Type: coldfusion.runtime.CfErrorWrapper Root Cause: struct Detail The input string is not base64-encoded. ErrorContext [empty string] Message '' Can not decode string "-1'=". StackTrace coldfusion.wddx.Base64Encoder$InvalidEncodedStringException: '' Can not decode string "-1'=". at coldfusion.wddx.Base64Encoder.decode(Base64Encoder.java:131) at coldfusion.tagext.security.AuthenticateTag.decodeBase64(AuthenticateTag.java:374) at coldfusion.tagext.security.AuthenticateTag.doStartTag(AuthenticateTag.java:229) at cfApplication2ecfm926529069.runPage(\booktalk\Application.cfm:125) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) 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.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:201) 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$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) TagContext array 1 struct COLUMN 0 ID CFAUTHENTICATE LINE 125 RAW_TRACE at cfApplication2ecfm926529069.runPage(\booktalk\Application.cfm:125) TEMPLATE \booktalk\Application.cfm TYPE CFML Type Application detailMessage [empty string] errorContext [empty string] input -1'= Tag Context: array 1 struct COLUMN 0 ID CFAUTHENTICATE LINE 125 RAW_TRACE at cfApplication2ecfm926529069.runPage(\booktalk\Application.cfm:125) TEMPLATE \booktalk\Application.cfm TYPE CFML [i]* Last updated by: paulmw on 2/25/2013 @ 7:02 PM *[/i] http://www.raymondcamden.com/forumsmessages.cfm?threadid=C60102CA-9221-2FD6-A3CEDCAA37CDBF73&r=8 2013-02-25T19:00:28-04:00 Can not decode string "-1'= No, all posts must come from a signed in user. You could mod Galleon of course. http://www.raymondcamden.com/forumsmessages.cfm?threadid=47AC60A9-BF4C-9A82-05675F6B53C89797&r=9 2013-01-14T14:01:30-04:00 Public Posting Is there a way to let any public visitor post a thread? I see that I can set a conference and then a forum underneath of that to the security "Everyone" but regular visitors can't post a thread still. Is this something that Galleon is capable of (anonymous posting) or do I just have a setting wrong? http://www.raymondcamden.com/forumsmessages.cfm?threadid=47AC60A9-BF4C-9A82-05675F6B53C89797&r=10 2013-01-14T13:41:47-04:00 Public Posting no problem and thank you. http://www.raymondcamden.com/forumsmessages.cfm?threadid=286D1A5A-EF0A-DC2A-3155D990998C1638&r=11 2012-11-15T09:53:58-04:00 Single Sign On Sorry for not responding - was on the road. http://www.raymondcamden.com/forumsmessages.cfm?threadid=286D1A5A-EF0A-DC2A-3155D990998C1638&r=12 2012-11-10T11:59:15-04:00 Single Sign On I guess I found it and now it's working. It was the Web server authentication problem. http://www.raymondcamden.com/forumsmessages.cfm?threadid=286D1A5A-EF0A-DC2A-3155D990998C1638&r=13 2012-11-06T13:00:11-04:00 Single Sign On Hello Raymond, I am trying to login to your Galleon forum using our login system (SSO). The way we would like to show the forum is as an iframe. I passed the userID through the URL (which I know is not secure, but this is the way I have been asked to do), Now the problem is the program is not able to get the cached userinfo. If I login to the system and i go back to our own system , it works properly. But if i login using our own login system it does not work. Could you please help me on this? I would sincerely appreciate your help. http://www.raymondcamden.com/forumsmessages.cfm?threadid=286D1A5A-EF0A-DC2A-3155D990998C1638&r=14 2012-11-05T08:53:09-04:00 Single Sign On You will have to delete the messages manually. http://www.raymondcamden.com/forumsmessages.cfm?threadid=6A4ABF1C-99C5-C619-AB4BA2825E9AE378&r=15 2012-10-28T13:15:53-04:00 How do I re-index threads and messages? We've had quite a bit of spam from users in China. I've deleted the user accounts, which removes the spam messages, but the messages are still in the search index. How do I re-index the forum threads/messages? Thanks. -bg http://www.raymondcamden.com/forumsmessages.cfm?threadid=6A4ABF1C-99C5-C619-AB4BA2825E9AE378&r=16 2012-10-27T17:57:19-04:00 How do I re-index threads and messages? If you are using the cached copy, it's, well, cached, you need to refresh the application cache using the URL hook described in the Application.cfm file. http://www.raymondcamden.com/forumsmessages.cfm?threadid=E52FF6FE-0643-0DD9-FFD0E5A4AC5CAC13&r=17 2012-09-21T11:12:54-04:00 rss feeds to use forums not conferences Changed the call to the function to use cfinvoke. Then had issues with getting the dsn so went back to the original call and seems to have fixed things.... But I modified the sql to retrieve all rows but it still only retrieves 20... and yes there are more than 20 rows.. select #variables.tableprefix#messages.title, #variables.tableprefix#threads.name as thread, #variables.tableprefix#messages.posted, #variables.tableprefix#users.username, #variables.tableprefix#messages.threadi dfk as threadid, #variables.tableprefix#messages.body, #variables.tableprefix#threads.forumidf k, #variables.tableprefix#forums.conferenc eidfk from #variables.tableprefix#messages, #variables.tableprefix#threads, #variables.tableprefix#users, #variables.tableprefix#forums where #variables.tableprefix#messages.threadidfk = #variables.tableprefix#threads.id and #variables.tableprefix#messages.useridfk = #variables.tableprefix#users.id and #variables.tableprefix#threads.forumidfk = <cfqueryparam value="#arguments.forumid#" cfsqltype="CF_SQL_VARCHAR" maxlength="35"> and #variables.tableprefix#forums.conferenceidfk = #variables.tableprefix#conferences.id order by #variables.tableprefix#messages.posted desc http://www.raymondcamden.com/forumsmessages.cfm?threadid=E52FF6FE-0643-0DD9-FFD0E5A4AC5CAC13&r=18 2012-09-21T10:22:47-04:00 rss feeds to use forums not conferences That is odd. If you cfdump application.forum, do you see that method in the dump? http://www.raymondcamden.com/forumsmessages.cfm?threadid=E52FF6FE-0643-0DD9-FFD0E5A4AC5CAC13&r=19 2012-09-21T08:08:33-04:00 rss feeds to use forums not conferences Cant work out why I am getting this error The method getLatestThreads was not found in component forum.cfc. Calling it from rss.cfm <cfset data = application.forum.getLatestThreads(forumid=url.forumid)> forum.cfc <cffunction name="getLatestThreads" access="public" returnType="query" output="false" hint="Retrieve the last 20 posts to any threads in forums in this forum."> <cfargument name="forumid" type="uuid" required="true"> <cfset var qLatestThreads = ""> <cfquery name="qLatestThreads" datasource="#variables.dsn#"> <cfif variables.dbtype is "oracle"> select * from ( </cfif> select <cfif not listFindNoCase("mysql,oracle",variables.dbtype)> top 20 </cfif> #variables.tableprefix#messages.title, #variables.tableprefix#threads.name as thread, #variables.tableprefix#messages.posted, #variables.tableprefix#users.username, #variables.tableprefix#messages.threadidfk as threadid, #variables.tableprefix#messages.body, #variables.tableprefix#threads.forumidfk, #variables.tableprefix#forums.conferenceidfk from #variables.tableprefix#messages, #variables.tableprefix#threads, #variables.tableprefix#users, #variables.tableprefix#forums where #variables.tableprefix#messages.threadidfk = #variables.tableprefix#threads.id and #variables.tableprefix#messages.useridfk = #variables.tableprefix#users.id and #variables.tableprefix#threads.forumidfk = <cfqueryparam value="#arguments.forumid#" cfsqltype="CF_SQL_VARCHAR" maxlength="35"> and #variables.tableprefix#forums.conferenceidfk = #variables.tableprefix#conferences.id order by #variables.tableprefix#messages.posted desc <cfif variables.dbtype is "mysql"> limit 20 <cfelseif variables.dbtype is "oracle"> ) where rownum <= 20 </cfif> </cfquery> <cfreturn qLatestThreads> </cffunction> http://www.raymondcamden.com/forumsmessages.cfm?threadid=E52FF6FE-0643-0DD9-FFD0E5A4AC5CAC13&r=20 2012-09-20T17:05:40-04:00 rss feeds to use forums not conferences