Ask Questions and Find Answers
Important:
Ask is now read-only. You can review any existing questions and answers, but not add anything new.
But - don't panic! While ask is no more, we've replaced it with discuss - the new Liferay Discussion Forum! Read more here here or just visit the site here:
discuss.liferay.com
RE: Liferay - Pages Import Export - Big Bug?
Hi,
I was playing with Community version of Liferay. Liferay has a cool feature of Import/Export of Layout. I was trying to import a page which had some categories out of which one category was having title of 20 chars
I tried to import the same in another environment and it got failed. Data truncation error.
I tried to import the same in my local environment and it worked successfully.
Identifying the problem
So there is some differenc between my environment and the env in which i got error. It was easy to identify it was Database. I had MySQL in my local and SQL server in the env where i got error.
Digging Deep
Once i identified it was db error, i jumped on debugging the source. After debugging i found that in SQL server data truncation was occuring coz datatype of title which stores internationalized values in xml was Varchar(2000) whereas datatype in MySQL was longtext!!!!!
Digging Deeper
Oh my god why this incosistency i knew liferay creates default tables on its own so both should either be Varchar(2000) or longtext(not sure what the correspondign value is in SQLServer)
Final Catch
portal-model-hints.xml - jeez now heres the weird thing. In portal-model-hints liferay specifies the size of the datatype and on runing subsequent build-service it would generate .sql file. Finally through code depending on the database it creates the Create script such taht for mysql it stores it longtext and for SQLServer as Varchar(2000).
Enterprise version
I checked the trial version of EE and same bug
Question
Is this expected or thats how liferay is inconsistent or is it a bug that someone has raised which i dont know
I was playing with Community version of Liferay. Liferay has a cool feature of Import/Export of Layout. I was trying to import a page which had some categories out of which one category was having title of 20 chars
I tried to import the same in another environment and it got failed. Data truncation error.
I tried to import the same in my local environment and it worked successfully.
Identifying the problem
So there is some differenc between my environment and the env in which i got error. It was easy to identify it was Database. I had MySQL in my local and SQL server in the env where i got error.
Digging Deep
Once i identified it was db error, i jumped on debugging the source. After debugging i found that in SQL server data truncation was occuring coz datatype of title which stores internationalized values in xml was Varchar(2000) whereas datatype in MySQL was longtext!!!!!
Digging Deeper
Oh my god why this incosistency i knew liferay creates default tables on its own so both should either be Varchar(2000) or longtext(not sure what the correspondign value is in SQLServer)
Final Catch
portal-model-hints.xml - jeez now heres the weird thing. In portal-model-hints liferay specifies the size of the datatype and on runing subsequent build-service it would generate .sql file. Finally through code depending on the database it creates the Create script such taht for mysql it stores it longtext and for SQLServer as Varchar(2000).
Enterprise version
I checked the trial version of EE and same bug
Question
Is this expected or thats how liferay is inconsistent or is it a bug that someone has raised which i dont know
It's an issue that's already been posted.
http://www.liferay.com/community/forums/-/message_boards/message/543004
http://www.liferay.com/community/forums/-/message_boards/message/543004
Hi Hitoshi,
No please that is completely different post. With all due respect please stop posting solutions that are not solutions at all. I have seen that 90 percent of your solutions are of no use at all and you dont look deep into the code, instead you post blank link. And genuine people stop posting on that thinking someone has already answered.
For example i was just seeing this post posted by Jitendra http://www.liferay.com/community/forums/-/message_boards/message/8363297
And you just gave a blunt solution. The real issue in that was Liferay uses getSession method to set the from email address so that it can connect to the Mail server using those credentials.
With again due respect please stop giving one liner links or post which has no relevance at all with the posts unless its a proper answer.
Regards,
Liferay Questions
No please that is completely different post. With all due respect please stop posting solutions that are not solutions at all. I have seen that 90 percent of your solutions are of no use at all and you dont look deep into the code, instead you post blank link. And genuine people stop posting on that thinking someone has already answered.
For example i was just seeing this post posted by Jitendra http://www.liferay.com/community/forums/-/message_boards/message/8363297
And you just gave a blunt solution. The real issue in that was Liferay uses getSession method to set the from email address so that it can connect to the Mail server using those credentials.
With again due respect please stop giving one liner links or post which has no relevance at all with the posts unless its a proper answer.
Regards,
Liferay Questions
And you just gave a blunt solution. The real issue in that was Liferay uses getSession method to set the from email address so that it can connect to the Mail server using those credentials
So, is this a bug or is this a specification? And how would you make it work?
And would you use your real name as everybody else in this forum is doing.
Liferay Question:
Hi Hitoshi,
No please that is completely different post. With all due respect please stop posting solutions that are not solutions at all. I have seen that 90 percent of your solutions are of no use at all and you dont look deep into the code, instead you post blank link. And genuine people stop posting on that thinking someone has already answered.
For example i was just seeing this post posted by Jitendra http://www.liferay.com/community/forums/-/message_boards/message/8363297
And you just gave a blunt solution.
The real issue in that was Liferay uses getSession method to set the from email address so that it can connect to the Mail server using those credentials.
With again due respect please stop giving one liner links or post which has no relevance at all with the posts unless its a proper answer.
Regards,
Liferay Questions
WTF! Please show a little respect with all people here in forums. Hitoshi always tries to solve people's problems, and almost all of them with great point of view and knowledge, so please don't come here to judge anybody that you don't really know at all.
Regarding your problem, first of all please post the error log and environment to identify your problem properly, if not you probably won't receive proper feedback and answers.
Then, you could test that in Liferay trunk version, there are many issues solved in there.
After that, you can search the forums if somebody had any problem with that, and/or search if there's an issue posted at Liferay JIRA (http://issues.liferay.com). If you didn't find anything related, perhaps it's time for you to post an issue in it with all steps to reproduce, environment and so on. If there are some issue already posted you could vote to agilize the fix for it (providing a patch could help).
Since you just joined and from your posts, it seems you've mistakenly taken this forum as Liferay support rather than a community forum - the truth is, you're not paying us and we're not getting paid to answer questions; this isn't Liferay support. We don't work for you.
As such, do YOUR own homework BEFORE posting - do your own search, check the jira to make sure it's not already being worked on, check the code on the svn trunk repository. Then, post your questions and make it concise - include the following information and if you have a viable solution, attach that.
When posting your question, please specify which version of Liferay you've encountered your problem with, your environment (including application server and it's version), how you've installed Liferay (whether you've used a bundle or a war), and error logs. And lastly, unless you pay us to go to your site and look at your Liferay, it's very difficult to solve a problem because there are so many factors - we can only help YOU solve your own problem - if you need somebody else to solve it for you, pay for Liferay support.
Additionally, most of us search for answers on this forum. If we keep answering the same questions over and over again in full sentences, our search result will keep showing posts linking to the same post. It's better to just link the URL so the posts won't be picked up by the search engine. This forum isn't to answer your question, it's to assist users answer their own questions.
http://www.liferay.com/community/forums/-/message_boards/message/572822
And I hope that you've read and understood the policy which you've consented when signing up for an Liferay account.
That said, it seems Liferay has some problems with SQL Server 2008. Liferay is working on it and other user are recommending not to use it in production yet. If you want to contribute a solution to a problem, please create an issue in jira and contribute a solution there - most of us will appreciate it.
As such, do YOUR own homework BEFORE posting - do your own search, check the jira to make sure it's not already being worked on, check the code on the svn trunk repository. Then, post your questions and make it concise - include the following information and if you have a viable solution, attach that.
When posting your question, please specify which version of Liferay you've encountered your problem with, your environment (including application server and it's version), how you've installed Liferay (whether you've used a bundle or a war), and error logs. And lastly, unless you pay us to go to your site and look at your Liferay, it's very difficult to solve a problem because there are so many factors - we can only help YOU solve your own problem - if you need somebody else to solve it for you, pay for Liferay support.
Additionally, most of us search for answers on this forum. If we keep answering the same questions over and over again in full sentences, our search result will keep showing posts linking to the same post. It's better to just link the URL so the posts won't be picked up by the search engine. This forum isn't to answer your question, it's to assist users answer their own questions.
http://www.liferay.com/community/forums/-/message_boards/message/572822
And I hope that you've read and understood the policy which you've consented when signing up for an Liferay account.
That said, it seems Liferay has some problems with SQL Server 2008. Liferay is working on it and other user are recommending not to use it in production yet. If you want to contribute a solution to a problem, please create an issue in jira and contribute a solution there - most of us will appreciate it.
Community
Company
Feedback