Mango Blog Forums : Mango Forums : General : install error w/railo

Forums home | Profile | Search | Login | RSS

Thread: install error w/railo

Created on: 02/25/09 05:31 PM

New topic Reply

Page: 1

Replies: 23

jamwerx

Joined: 02/08/09
Posts: 17
02/25/09 5:31 PM

Just installed new version...
deleted all old files off server, deleted database and uploaded new files and did the setup again.
Also rebooted server & chanded app name & changed the config file to take out the prettyurls for tomcat and this is on a mac server running latest leopard.

The install went good and can log into admin and do all that.. and btw~ file manager works out of the gate now.

but when going to home page I get this message

Error:
Can't cast String [] to a value of type [Array] Java type of the object is java.lang.String

Link | Top | Bottom

Laura
Wizard

Joined: 01/29/05
Posts: 1236
02/25/09 5:36 PM

Can you check if the table link_category has the column blog_id?

Link | Top | Bottom

jamwerx

Joined: 02/08/09
Posts: 17
02/25/09 5:40 PM

yes and an entry of "default"

Link | Top | Bottom

Laura
Wizard

Joined: 01/29/05
Posts: 1236
02/25/09 5:43 PM

I don't know then. When you go to the Links section in the admin, do you see them (or is it blank)?
If all that is ok, please remove the onError function in application.cfc to see more of the problem.

Link | Top | Bottom

jamwerx

Joined: 02/08/09
Posts: 17
02/25/09 5:48 PM

The links page is blanks.

It says to update as well but won't do it.. might be a permission issue though for that.

Link | Top | Bottom

jamwerx

Joined: 02/08/09
Posts: 17
02/26/09 5:29 AM

So I ripped all that out again and uploaded 1.24 and it works ok.

Link | Top | Bottom

Clarkee21

Joined: 08/16/08
Posts: 13
03/08/09 5:57 PM

I'm getting this error as well.

It's a fresh install of 1.3.1 on Railo 3 / mySQL 5.1 / Window XP.

It is related to links from what I see but I'm seeing two errors:

1) "Can't cast String [] to a value of type [Array] Java type of the object is java.lang.String"

coming from this line in /mango/tags/mangoextras/LinkCategories.cfm :

<cfset to = arraylen(linkCategories) />

The issue is the linkCategories is returning an empty string.

I fixed this with a simple check for len on it but I don't know if there is an further issues related to this.

2) In the Admin > Links > Add Category if I try and submit a category I get an error similar to this:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '6C0C1959-D1CC-40DB-A9675491FBE69849'', ''xxxx'', ''xxxx'', ''de' at line 4

I need to look into this a bit more but hopefully this helps in putting some light on this one :-).

Cheers,
James

Link | Top | Bottom

Laura
Wizard

Joined: 01/29/05
Posts: 1236
03/08/09 6:10 PM

James,
Make sure you go to the web admin for Datasources, and uncheck
Preserve single quotes.

Link | Top | Bottom

Clarkee21

Joined: 08/16/08
Posts: 13
03/08/09 6:11 PM

Sorry my mistake in point one where I said I added a check for len I actually added this at the top of the tag:

<cfif thisTag.executionMode EQ "start">
<cfset to = 0 />

So there is always a default value.

Link | Top | Bottom

Clarkee21

Joined: 08/16/08
Posts: 13
03/08/09 6:12 PM

Thanks Laura,

Which Web admin are you referring to?

Link | Top | Bottom

Laura
Wizard

Joined: 01/29/05
Posts: 1236
03/08/09 6:49 PM

I am referring to Railo's administration.

Link | Top | Bottom

Clarkee21

Joined: 08/16/08
Posts: 13
03/09/09 2:18 PM

Thanks a lot Laura, that fixed it.

I'm a bit unsure of this approach though as its a global setting so it'll affects all my server's datasources.

It's in there for now though :-).

Thanks again,
James

Link | Top | Bottom

Clarkee21

Joined: 08/16/08
Posts: 13
03/09/09 2:18 PM

Thanks a lot Laura, that fixed it.

I'm a bit unsure of this approach though as its a global setting so it'll affects all my server's datasources.

It's in there for now though :-).

Thanks again,
James

Link | Top | Bottom

Clarkee21

Joined: 08/16/08
Posts: 13
03/09/09 2:28 PM

Thanks a lot Laura, that fixed it.

I'm a bit unsure of this approach though as its a global setting so it'll affects all my server's datasources.

It's in there for now though :-).

Thanks again,
James

Link | Top | Bottom

djkenod

Joined: 08/07/08
Posts: 7
03/11/09 2:45 PM

Just to clarify
unchecking Preserve single quotes in Railo administrator won't fix this issue alone.

I had to do the following:

<cfif linkCategories IS "">
<cfset linkCategories = arrayNew(1)>
</cfif>

Just before the line:
<cfset to = arraylen(linkCategories) />

I wouldn't say this is a Mango Blog problem though, its more of an issue with Railo dealing with things differently to cf (i think)

Link | Top | Bottom

Clarkee21

Joined: 08/16/08
Posts: 13
03/11/09 2:55 PM

Going by Jamwerx final comment above downgrading to 1.24 works on Railo yet 1.3.1 is having problems. So an issue has been introduced at the Mango side.

The Mango Blog site does also say it works on Railo :-)

I had a chat with Gert @ Railo about this global setting of PSQ and they're going to look at the possibility of making it datasource specific. That would be huge help as I'm not sure (yet) if unchecking this has messed up anything else on my server.

Not a short term fix I know but at least they're now aware of it anyway.

Cheers,
James

Link | Top | Bottom

jamwerx

Joined: 02/08/09
Posts: 17
03/11/09 3:17 PM

yes it worked for me.
Which admin are you unchecking it from?
It seems like you are doing it in the server admin and not the web admin.

Link | Top | Bottom

Clarkee21

Joined: 08/16/08
Posts: 13
03/11/09 3:20 PM

I've done it in the web admin.

I'm running the community edition which doesn't have any datasource options available in the server.

Link | Top | Bottom

jamwerx

Joined: 02/08/09
Posts: 17
03/11/09 3:24 PM

Im running community as well but if you don't put in a sn in server admin it shows the options so was thinking that was it.

If I remember correctly I removed everything from 1.3.1 install and put 1.24 back in, unchecked the box and then ran the update and everything worked fine after that even the file manager which didn't work before.

Link | Top | Bottom

Laura
Wizard

Joined: 01/29/05
Posts: 1236
03/12/09 12:40 AM

I highly recommend you to use version 1.3 instead of reverting to 1.2.4 if possible.
In any case, I think I will have a fix for this with a recommendation given by Andrea Campolonghi. I just need to make sure it will work for CF too.
I actually find this issue to be more of an incompatibility than anything, since the default behavior for CF is the opposite.

Link | Top | Bottom

Clarkee21

Joined: 08/16/08
Posts: 13
03/12/09 2:51 AM

Thought it best throw this in as well incase anyone needs more help:

http://blog.ciqala.com/2009/03/minor-railo-3-mysql-mango-blog-gotcha.html

Cheers,
James

Link | Top | Bottom

andyjarrett

Joined: 12/22/08
Posts: 1
04/21/09 1:21 AM

Hi

I've tried to put in the fixed mention here but I am still getting the following error:

Can't cast String [] to a value of type [Array] Java type of the object is java.lang.String

Anyone have any more idea?

Link | Top | Bottom

Laura
Wizard

Joined: 01/29/05
Posts: 1236
05/06/09 8:55 PM

Hi Andy,
Sorry for the late reply. I am pretty sure it should work with that fix. Make sure you do that in both Railo's admins.

Link | Top | Bottom

frinky

Joined: 06/28/09
Posts: 30
06/28/09 6:22 PM

Thanks for the conversation here! Just installed mangoblog on www.coldfusiondeveloper.nl, and ran into this same problem.
Now just to be sure, I wanted to check if these issues with "Preserve single quotes" and the fact that you have to uncheck it in both admins, are already told to railo themselves?
It seems kind of strange for Railo to be incompatible with CF on this matter, since it is about securing sql statements which could otherwise be compromised by sql injection (page.cfm?id=0;delete from users; select * from users where id=)
- - Freelance Coldfusion developer from The Netherlands!

Link | Top | Bottom

New Post

Please login to post a response.

Replies: 23
jamwerx Joined: 02/08/09 Posts: 17	02/25/09 5:31 PM Just installed new version... deleted all old files off server, deleted database and uploaded new files and did the setup again. Also rebooted server & chanded app name & changed the config file to take out the prettyurls for tomcat and this is on a mac server running latest leopard. The install went good and can log into admin and do all that.. and btw~ file manager works out of the gate now. but when going to home page I get this message Error: Can't cast String [] to a value of type [Array] Java type of the object is java.lang.String
	Link \| Top \| Bottom
Laura Wizard Joined: 01/29/05 Posts: 1236	02/25/09 5:36 PM Can you check if the table link_category has the column blog_id?
	Link \| Top \| Bottom
jamwerx Joined: 02/08/09 Posts: 17	02/25/09 5:40 PM yes and an entry of "default"
	Link \| Top \| Bottom
Laura Wizard Joined: 01/29/05 Posts: 1236	02/25/09 5:43 PM I don't know then. When you go to the Links section in the admin, do you see them (or is it blank)? If all that is ok, please remove the onError function in application.cfc to see more of the problem.
	Link \| Top \| Bottom
jamwerx Joined: 02/08/09 Posts: 17	02/25/09 5:48 PM The links page is blanks. It says to update as well but won't do it.. might be a permission issue though for that.
	Link \| Top \| Bottom
jamwerx Joined: 02/08/09 Posts: 17	02/26/09 5:29 AM So I ripped all that out again and uploaded 1.24 and it works ok.
	Link \| Top \| Bottom
Clarkee21 Joined: 08/16/08 Posts: 13	03/08/09 5:57 PM I'm getting this error as well. It's a fresh install of 1.3.1 on Railo 3 / mySQL 5.1 / Window XP. It is related to links from what I see but I'm seeing two errors: 1) "Can't cast String [] to a value of type [Array] Java type of the object is java.lang.String" coming from this line in /mango/tags/mangoextras/LinkCategories.cfm : <cfset to = arraylen(linkCategories) /> The issue is the linkCategories is returning an empty string. I fixed this with a simple check for len on it but I don't know if there is an further issues related to this. 2) In the Admin > Links > Add Category if I try and submit a category I get an error similar to this: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '6C0C1959-D1CC-40DB-A9675491FBE69849'', ''xxxx'', ''xxxx'', ''de' at line 4 I need to look into this a bit more but hopefully this helps in putting some light on this one :-). Cheers, James
	Link \| Top \| Bottom
Laura Wizard Joined: 01/29/05 Posts: 1236	03/08/09 6:10 PM James, Make sure you go to the web admin for Datasources, and uncheck Preserve single quotes.
	Link \| Top \| Bottom
Clarkee21 Joined: 08/16/08 Posts: 13	03/08/09 6:11 PM Sorry my mistake in point one where I said I added a check for len I actually added this at the top of the tag: <cfif thisTag.executionMode EQ "start"> <cfset to = 0 /> So there is always a default value.
	Link \| Top \| Bottom
Clarkee21 Joined: 08/16/08 Posts: 13	03/08/09 6:12 PM Thanks Laura, Which Web admin are you referring to?
	Link \| Top \| Bottom
Laura Wizard Joined: 01/29/05 Posts: 1236	03/08/09 6:49 PM I am referring to Railo's administration.
	Link \| Top \| Bottom
Clarkee21 Joined: 08/16/08 Posts: 13	03/09/09 2:18 PM Thanks a lot Laura, that fixed it. I'm a bit unsure of this approach though as its a global setting so it'll affects all my server's datasources. It's in there for now though :-). Thanks again, James
	Link \| Top \| Bottom
Clarkee21 Joined: 08/16/08 Posts: 13	03/09/09 2:18 PM Thanks a lot Laura, that fixed it. I'm a bit unsure of this approach though as its a global setting so it'll affects all my server's datasources. It's in there for now though :-). Thanks again, James
	Link \| Top \| Bottom
Clarkee21 Joined: 08/16/08 Posts: 13	03/09/09 2:28 PM Thanks a lot Laura, that fixed it. I'm a bit unsure of this approach though as its a global setting so it'll affects all my server's datasources. It's in there for now though :-). Thanks again, James
	Link \| Top \| Bottom
djkenod Joined: 08/07/08 Posts: 7	03/11/09 2:45 PM Just to clarify unchecking Preserve single quotes in Railo administrator won't fix this issue alone. I had to do the following: <cfif linkCategories IS ""> <cfset linkCategories = arrayNew(1)> </cfif> Just before the line: <cfset to = arraylen(linkCategories) /> I wouldn't say this is a Mango Blog problem though, its more of an issue with Railo dealing with things differently to cf (i think)
	Link \| Top \| Bottom
Clarkee21 Joined: 08/16/08 Posts: 13	03/11/09 2:55 PM Going by Jamwerx final comment above downgrading to 1.24 works on Railo yet 1.3.1 is having problems. So an issue has been introduced at the Mango side. The Mango Blog site does also say it works on Railo :-) I had a chat with Gert @ Railo about this global setting of PSQ and they're going to look at the possibility of making it datasource specific. That would be huge help as I'm not sure (yet) if unchecking this has messed up anything else on my server. Not a short term fix I know but at least they're now aware of it anyway. Cheers, James
	Link \| Top \| Bottom
jamwerx Joined: 02/08/09 Posts: 17	03/11/09 3:17 PM yes it worked for me. Which admin are you unchecking it from? It seems like you are doing it in the server admin and not the web admin.
	Link \| Top \| Bottom
Clarkee21 Joined: 08/16/08 Posts: 13	03/11/09 3:20 PM I've done it in the web admin. I'm running the community edition which doesn't have any datasource options available in the server.
	Link \| Top \| Bottom
jamwerx Joined: 02/08/09 Posts: 17	03/11/09 3:24 PM Im running community as well but if you don't put in a sn in server admin it shows the options so was thinking that was it. If I remember correctly I removed everything from 1.3.1 install and put 1.24 back in, unchecked the box and then ran the update and everything worked fine after that even the file manager which didn't work before.
	Link \| Top \| Bottom
Laura Wizard Joined: 01/29/05 Posts: 1236	03/12/09 12:40 AM I highly recommend you to use version 1.3 instead of reverting to 1.2.4 if possible. In any case, I think I will have a fix for this with a recommendation given by Andrea Campolonghi. I just need to make sure it will work for CF too. I actually find this issue to be more of an incompatibility than anything, since the default behavior for CF is the opposite.
	Link \| Top \| Bottom
Clarkee21 Joined: 08/16/08 Posts: 13	03/12/09 2:51 AM Thought it best throw this in as well incase anyone needs more help: http://blog.ciqala.com/2009/03/minor-railo-3-mysql-mango-blog-gotcha.html Cheers, James
	Link \| Top \| Bottom
andyjarrett Joined: 12/22/08 Posts: 1	04/21/09 1:21 AM Hi I've tried to put in the fixed mention here but I am still getting the following error: Can't cast String [] to a value of type [Array] Java type of the object is java.lang.String Anyone have any more idea?
	Link \| Top \| Bottom
Laura Wizard Joined: 01/29/05 Posts: 1236	05/06/09 8:55 PM Hi Andy, Sorry for the late reply. I am pretty sure it should work with that fix. Make sure you do that in both Railo's admins.
	Link \| Top \| Bottom
frinky Joined: 06/28/09 Posts: 30	06/28/09 6:22 PM Thanks for the conversation here! Just installed mangoblog on www.coldfusiondeveloper.nl, and ran into this same problem. Now just to be sure, I wanted to check if these issues with "Preserve single quotes" and the fact that you have to uncheck it in both admins, are already told to railo themselves? It seems kind of strange for Railo to be incompatible with CF on this matter, since it is about securing sql statements which could otherwise be compromised by sql injection (page.cfm?id=0;delete from users; select * from users where id=) - - Freelance Coldfusion developer from The Netherlands!
	Link \| Top \| Bottom