Syntax error while upgrading Liferay 6.0.5 to 6.1.0 -


i trying upgrading liferay 6.0.5 6.1.0. follow steps in sites https://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/upgrading-lifer-5. during upgradation process got following error. 

 10:48:21,489 info  [dialectdetector:80] determine dialect postgresql 9 10:48:21,522 info  [dialectdetector:145] found dialect org.hibernate.dialect.postgresqldialect starting liferay portal community edition 6.1.0 ce (paton / build 6100 / january 6, 2012) 10:48:44,349 info  [basedb:406] database supports case sensitive queries 10:48:44,530 info  [upgradeprocess:205] upgrading com.liferay.portal.upgrade.upgradeprocess_6_0_6 10:48:44,532 info  [upgradeprocess:205] upgrading com.liferay.portal.upgrade.v6_0_6.upgradeschema 10:48:44,599 info  [upgradeprocess:205] upgrading com.liferay.portal.upgrade.v6_0_6.upgraderss 10:48:45,006 info  [upgradeprocess:205] upgrading com.liferay.portal.upgrade.upgradeprocess_6_1_0 10:48:45,007 info  [upgradeprocess:205] upgrading com.liferay.portal.upgrade.v6_1_0.upgradeschema 10:49:07,783 info  [upgradeprocess:205] upgrading com.liferay.portal.upgrade.v6_1_0.upgradeusername 10:49:08,272 info  [upgradeprocess:205] upgrading com.liferay.portal.upgrade.v6_1_0.upgradeadminportlets 10:49:21,512 info  [upgradeprocess:205] upgrading com.liferay.portal.upgrade.v6_1_0.upgradeblogs 10:49:21,529 info  [upgradeprocess:205] upgrading com.liferay.portal.upgrade.v6_1_0.upgradecamelcaseportletpreferences 10:53:16,032 info  [upgradeprocess:205] upgrading com.liferay.portal.upgrade.v6_1_0.upgradecountry 10:53:16,264 info  [upgradeprocess:205] upgrading com.liferay.portal.upgrade.v6_1_0.upgradedocumentlibrary 11:00:46,866 info  [upgradeprocess:205] upgrading com.liferay.portal.upgrade.v6_1_0.upgradeexpando 11:00:46,872 info  [upgradeprocess:205] upgrading com.liferay.portal.upgrade.v6_1_0.upgradegroup 11:00:51,024 error [mainservlet:198] com.liferay.portal.kernel.events.actionexception: com.liferay.portal.kernel.upgrade.upgradeexception: com.liferay.portal.kernel.upgrade.upgradeexception: org.postgresql.util.psqlexception: error: syntax error @ or near "s"   position: 81 com.liferay.portal.kernel.events.actionexception: com.liferay.portal.kernel.upgrade.upgradeexception: com.liferay.portal.kernel.upgrade.upgradeexception: org.postgresql.util.psqlexception: error: syntax error @ or near "s"   position: 81     @ com.liferay.portal.events.startupaction.run(startupaction.java:58)     @ com.liferay.portal.servlet.mainservlet.processstartupevents(mainservlet.java:1267)     @ com.liferay.portal.servlet.mainservlet.init(mainservlet.java:195)     @ javax.servlet.genericservlet.init(genericservlet.java:160)     @ org.apache.catalina.core.standardwrapper.initservlet(standardwrapper.java:1266)     @ org.apache.catalina.core.standardwrapper.loadservlet(standardwrapper.java:1185)     @ org.apache.catalina.core.standardwrapper.load(standardwrapper.java:1080)     @ org.apache.catalina.core.standardcontext.loadonstartup(standardcontext.java:5001)     @ org.apache.catalina.core.standardcontext.startinternal(standardcontext.java:5289)     @ org.apache.catalina.util.lifecyclebase.start(lifecyclebase.java:150)     @ org.apache.catalina.core.containerbase.addchildinternal(containerbase.java:866)     @ org.apache.catalina.core.containerbase.addchild(containerbase.java:842)     @ org.apache.catalina.core.standardhost.addchild(standardhost.java:615)     @ org.apache.catalina.startup.hostconfig.deploydescriptor(hostconfig.java:649)     @ org.apache.catalina.startup.hostconfig$deploydescriptor.run(hostconfig.java:1581)     @ java.util.concurrent.executors$runnableadapter.call(executors.java:471)     @ java.util.concurrent.futuretask$sync.innerrun(futuretask.java:334)     @ java.util.concurrent.futuretask.run(futuretask.java:166)     @ java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor.java:1146)     @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:615)     @ java.lang.thread.run(thread.java:679) caused by: com.liferay.portal.kernel.upgrade.upgradeexception: com.liferay.portal.kernel.upgrade.upgradeexception: org.postgresql.util.psqlexception: error: syntax error @ or near "s"   position: 81     @ com.liferay.portal.kernel.upgrade.upgradeprocess.upgrade(upgradeprocess.java:211)     @ com.liferay.portal.upgrade.upgradeprocessutil._upgradeprocess(upgradeprocessutil.java:93)     @ com.liferay.portal.upgrade.upgradeprocessutil.upgradeprocess(upgradeprocessutil.java:46)     @ com.liferay.portal.events.startuphelper.upgradeprocess(startuphelper.java:81)     @ com.liferay.portal.events.startuphelperutil.upgradeprocess(startuphelperutil.java:40)     @ com.liferay.portal.tools.dbupgrader.upgrade(dbupgrader.java:119)     @ com.liferay.portal.events.startupaction.dorun(startupaction.java:144)     @ com.liferay.portal.events.startupaction.run(startupaction.java:52)     ... 20 more caused by: com.liferay.portal.kernel.upgrade.upgradeexception: org.postgresql.util.psqlexception: error: syntax error @ or near "s"   position: 81     @ com.liferay.portal.kernel.upgrade.upgradeprocess.upgrade(upgradeprocess.java:211)     @ com.liferay.portal.kernel.upgrade.upgradeprocess.upgrade(upgradeprocess.java:225)     @ com.liferay.portal.upgrade.upgradeprocess_6_1_0.doupgrade(upgradeprocess_6_1_0.java:66)     @ com.liferay.portal.kernel.upgrade.upgradeprocess.upgrade(upgradeprocess.java:208)     ... 27 more caused by: org.postgresql.util.psqlexception: error: syntax error @ or near "s"   position: 81     @ org.postgresql.core.v3.queryexecutorimpl.receiveerrorresponse(queryexecutorimpl.java:2103)     @ org.postgresql.core.v3.queryexecutorimpl.processresults(queryexecutorimpl.java:1836)     @ org.postgresql.core.v3.queryexecutorimpl.execute(queryexecutorimpl.java:257)     @ org.postgresql.jdbc2.abstractjdbc2statement.execute(abstractjdbc2statement.java:512)     @ org.postgresql.jdbc2.abstractjdbc2statement.executewithflags(abstractjdbc2statement.java:374)     @ org.postgresql.jdbc2.abstractjdbc2statement.executeupdate(abstractjdbc2statement.java:302)     @ com.mchange.v2.c3p0.impl.newproxystatement.executeupdate(newproxystatement.java:64)     @ com.liferay.portal.dao.db.basedb.runsql(basedb.java:237)     @ com.liferay.portal.dao.db.basedb.runsql(basedb.java:204)     @ com.liferay.portal.dao.db.basedb.runsql(basedb.java:191)     @ com.liferay.portal.kernel.upgrade.upgradeprocess.runsql(upgradeprocess.java:115)     @ com.liferay.portal.upgrade.v6_1_0.upgradegroup.updatename(upgradegroup.java:86)     @ com.liferay.portal.upgrade.v6_1_0.upgradegroup.doupgrade(upgradegroup.java:51)     @ com.liferay.portal.kernel.upgrade.upgradeprocess.upgrade(upgradeprocess.java:208)     ... 30 more
using postgres 9.4 , error shown syntax error . unable resolve error. please me.

upgrade routines fixed newer minor releases, same this: please try last available 6.1 update release (which, way, won't receive future upgrades - recommendation continue update 6.2 ga4).

if problem still persists when upgrading 6.1.2, might want try direct update 6.2 without stopping @ 6.1.x , see if update process fixes problem.


Comments

Post a Comment

Popular posts from this blog

php - failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request -

this code i'm using find latitude , longitude of place: function coords($address){ echo $url="http://maps.googleapis.com/maps/api/geocode/json?address=".$address; $json = file_get_contents(urlencode($url)); $data = json_decode($json, true); print_r($data['results'][0]['geometry']['location']['lat']); print_r($data['results'][0]['geometry']['location']['lng']); } however returns warning: failed open stream: http request failed! http/1.0 400 bad request if use above code in simple procedure works fine not in function. note: have tried curl_init()... method produced same result? instead of encoding whole url encode address part. following code work fine $add='jamshoro phase 2'; $url="http://maps.googleapis.com/maps/api/geocode/json?address=".urlencode($add); $json = file_get_contents($url); $data = json_decode($json, true); print_r($data['r
Read more

java - How to filter a backspace keyboard input -

i have code gives message when key number pressed: txtvalueofclause.addeventfilter(keyevent.key_typed, new eventhandler<keyevent>() { @override public void handle(keyevent t) { char ar[] = t.getcharacter().tochararray(); char ch = ar[t.getcharacter().tochararray().length - 1]; if (!(ch >= '0' && ch <= '9')) { system.out.println("the char entered not number"); t.consume(); } } }); now if press on wrong button , press backspace remove it, error message. how can add backspace input if statement? i have found answer: txtvalueofclause.addeventfilter(keyevent.key_typed, new eventhandler<keyevent>() { @override public void handle(keyevent t) { char ar[] = t.getcharacter().tochararray(); char ch = ar[t.getcharacter().tochar
Read more

java - Show Soft Keyboard when EditText Appears -

i have code in android app, alert dialog , keyboard, , when dialog shown want keyboard appear. not , not sure why? here code: final alertdialog.builder alert = new alertdialog.builder(this); alert.settitle("title"); alert.setmessage("message"); final edittext input = new edittext(this); input.setinputtype(inputtype.type_class_number); alert.setview(input); input.setonfocuschangelistener(new view.onfocuschangelistener() { @override public void onfocuschange(view v, boolean hasfocus) { if (hasfocus) { log.i(tag, "in focus"); inputmethodmanager inputmethodmanager = (inputmethodmanager) getsystemservice(context.input_method_service); inputmethodmanager.showsoftinput(input, inputmethodmanager.show_implicit); } } }); but keyboard not appear though edit text in focus, , tell appear why, doesn't come up? thanks in advance.
Read more