[prev in list] [next in list] [prev in thread] [next in thread]
List: openmrs-dev
Subject: Re: Error executing SQL DELETE FROM `concept_word` WHERE concept_name_id = 0: Table 'openmrs.concept
From: Kaweesi Joseph <kaweesi.joseph2012 () gmail ! com>
Date: 2015-03-26 18:19:55
Message-ID: CAMXdmPzR+0=QMHUKV3KdZUyW=vg8Rhv0YOh6WfZg_YP77kPmWg () mail ! gmail ! com
[Download RAW message or body]
Daniel had to make a commit that skips some changesets
<https://github.com/openmrs/openmrs-standalone/commit/e4e7d927239a45294672bf8a9f4d5e8d30d7cb0c>:
so i was successful in compiling the standalone, however am still
investigating the big change in its size when compared with 1.11.0
- k-joseph
What we most need now is *NOT** legal religion* *BUT* *true and genuine
conversion* through *Christ our righteousness*
On Thu, Mar 26, 2015 at 7:55 PM, Wyclif Luyima <wyclif@openmrs.org> wrote:
> Did you resolve this Joseph? If yes, what was the problem?
>
> Wyclif
>
> On Wed, Mar 25, 2015 at 11:30 AM, Kaweesi Joseph <
> kaweesi.joseph2012@gmail.com> wrote:
>
> > Yes Darius, however the table is still created in our code by
> > https://github.com/openmrs/openmrs-core/blob/1.11.x/api/src/main/resources/liquibase-schema-only.xml#L449
> > but it is still supposed to be later on after being created be deleted by
> > https://github.com/openmrs/openmrs-core/blob/1.11.x/api/src/main/resources/liquibase-update-to-latest.xml#L771
> >
> >
> > It looks like the first changeset is not run, so when the compiler gets
> > to the second, it finds no table created called concept_word
> >
> >
> > - k-joseph
> >
> > What we most need now is *NOT** legal religion* *BUT* *true and genuine
> > conversion* through *Christ our righteousness*
> >
> > On Wed, Mar 25, 2015 at 6:25 PM, k-joseph <kaweesi.joseph2012@gmail.com>
> > wrote:
> >
> > > the shell > option gets part of the logs and gets the rest on to command
> > > line, so i have yet been able to establish whether the changeset that
> > > should have created the table failed
> > >
> > > On Wednesday, March 25, 2015 at 8:25:07 AM UTC+3, k-joseph wrote:
> > >
> > > > Am compiling the 1.11.1 standalone and experiencing some non expected
> > > > liquibase changeset failure:
> > > >
> > > > [ERROR] Failed to execute goal \
> > > > org.liquibase:liquibase-maven-plugin:2.0.1:update (empty-db-update-to-latest) \
> > > > on project standalone: Error setting up or running Liquibase: Migration \
> > > > failed for change set liquibase-update-to-latest.xml::200905150814::bwolfe:
> > > > [ERROR] Reason: liquibase.exception.DatabaseException: Error executing
> > > > SQL DELETE FROM `concept_word` WHERE concept_name_id = 0: Table
> > > > 'openmrs.concept_word' doesn't exist:
> > > > [ERROR] Caused By: Error executing SQL DELETE FROM `concept_word`
> > > > WHERE concept_name_id = 0: Table 'openmrs.concept_word' doesn't exist:
> > > > [ERROR] Caused By: Table 'openmrs.concept_word' doesn't exist
> > > > [ERROR] -> [Help 1]
> > > > [ERROR]
> > > > [ERROR] To see the full stack trace of the errors, re-run Maven with
> > > > the -e switch.
> > > > [ERROR] Re-run Maven using the -X switch to enable full debug logging.
> > > > [ERROR]
> > > > [ERROR] For more information about the errors and possible solutions,
> > > > please read the following articles:
> > > > [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/
> > > > MojoExecutionException
> > > > This is strange since i expected the table to have been created after
> > > > running liquibase-schema-only.xml which has the changeset that should
> > > > have created the table. This comes after i already tagged 1.11.1,
> > > >
> > > > May be the command is not looking to the right source of the war file:
> > > > here is the command am running:
> > > > mvn clean package -Dopenmrs.version=1.11.1 -Dopenmrs.war.path=/media/
> > > > KJoseph/Projects/openMRS/openmrs-core-master/openmrs-
> > > > core/webapp/target/openmrs.war
> > > >
> > > > Can someone try this out on his/her machine, let me upload the war file
> > > > to source-forge to share it
> > > >
> > > > - k-joseph
> > > >
> > > > What we most need now is *NOT** legal religion* *BUT* *true and
> > > > genuine conversion* through *Christ our righteousness*
> > > >
> > > --
> > > OpenMRS Developers: http://om.rs/dev
> > > Post: dev@openmrs.org | Unsubscribe: dev+unsubscribe@openmrs.org
> > > Manage your OpenMRS subscriptions: http://om.rs/id
> > >
> > > Visit OpenMRS Talk at http://om.rs/talk for chat and discussions!
> > >
> > > To unsubscribe from this group and stop receiving emails from it, send
> > > an email to dev+unsubscribe@openmrs.org.
> > >
> >
> > --
> > OpenMRS Developers: http://om.rs/dev
> > Post: dev@openmrs.org | Unsubscribe: dev+unsubscribe@openmrs.org
> > Manage your OpenMRS subscriptions: http://om.rs/id
> >
> > Visit OpenMRS Talk at http://om.rs/talk for chat and discussions!
> >
>
>
>
> --
> Wyclif Luyima
> Regenstrief Institute Inc.
>
> Confidentiality Notice: The contents of this message and any files
> transmitted with it may contain confidential and/or privileged information
> and are intended solely for the use of the named addressee(s).
> Additionally, the information contained herein may have been disclosed to
> you from medical records with confidentiality protected by federal and
> state laws. Federal regulations and State laws prohibit you from making
> further disclosure of such information without the specific written consent
> of the person to whom the information pertains or as otherwise permitted by
> such regulations. A general authorization for the release of medical or
> other information is not sufficient for this purpose.
>
> If you have received this message in error, please notify the sender by
> return e-mail and delete the original message. Any retention, disclosure,
> copying, distribution or use of this information by anyone other than the
> intended recipient is strictly prohibited.
>
> --
> OpenMRS Developers: http://om.rs/dev
> Post: dev@openmrs.org | Unsubscribe: dev+unsubscribe@openmrs.org
> Manage your OpenMRS subscriptions: http://om.rs/id
>
> *** THIS GROUP IS MOVING to OpenMRS Talk effective 10 April 2015 at 19:00
> UTC. Please visit
> https://talk.openmrs.org/t/openmrs-developers-group-changes-2015-04-10/1508
> for details and to make necessary changes.
>
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dev+unsubscribe@openmrs.org.
>
--
OpenMRS Developers: http://om.rs/dev
Post: dev@openmrs.org | Unsubscribe: dev+unsubscribe@openmrs.org
Manage your OpenMRS subscriptions: http://om.rs/id
*** THIS GROUP IS MOVING to OpenMRS Talk effective 10 April 2015 at 19:00 UTC. Please \
visit https://talk.openmrs.org/t/openmrs-developers-group-changes-2015-04-10/1508 for \
details and to make necessary changes.
To unsubscribe from this group and stop receiving emails from it, send an email to \
dev+unsubscribe@openmrs.org.
[Attachment #3 (text/html)]
<div dir="ltr">Daniel had to make a <a \
href="https://github.com/openmrs/openmrs-standalone/commit/e4e7d927239a45294672bf8a9f4d5e8d30d7cb0c">commit \
that skips some changesets</a>: so i was successful in compiling the standalone, \
however am still investigating the big change in its size when compared with \
1.11.0</div><div class="gmail_extra"><br clear="all"><div><div \
class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div \
dir="ltr"><div><br></div><div>- k-joseph</div></div><div dir="ltr">
<p style="margin-bottom:0in;background-repeat:initial initial"><font face="Arial \
Narrow, sans-serif"><font \
style="font-size:6pt;background-color:rgb(204,204,204)"><font color="#222222"><font \
face="comic sans ms, sans-serif">What we most need now is </font></font><font \
color="#222222"><font face="comic sans ms, \
sans-serif"><u><b>NOT</b></u></font></font><font color="#222222"><font face="comic \
sans ms, sans-serif"><b> legal religion</b></font></font><font color="#222222"> \
</font><font color="#222222"><font face="comic sans ms, \
sans-serif"><u>BUT</u></font></font><font color="#222222"> </font><font \
color="#222222"><font face="comic sans ms, sans-serif"><b>true and genuine \
conversion</b></font></font><font color="#222222"> </font><font \
color="#222222"><font face="comic sans ms, sans-serif">through </font></font><font \
color="#222222"><font face="comic sans ms, sans-serif"><b>Christ our \
righteousness</b></font></font></font></font></p></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On Thu, Mar 26, 2015 at 7:55 PM, Wyclif Luyima <span \
dir="ltr"><<a href="mailto:wyclif@openmrs.org" \
target="_blank">wyclif@openmrs.org</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><div>Did you resolve this Joseph? If yes, what \
was the problem?<br><br></div>Wyclif<br></div><div class="gmail_extra"><div><div \
class="h5"><br><div class="gmail_quote">On Wed, Mar 25, 2015 at 11:30 AM, Kaweesi \
Joseph <span dir="ltr"><<a href="mailto:kaweesi.joseph2012@gmail.com" \
target="_blank">kaweesi.joseph2012@gmail.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr">Yes Darius, however the table is still created \
in our code by <a href="https://github.com/openmrs/openmrs-core/blob/1.11.x/api/src/main/resources/liquibase-schema-only.xml#L449" \
target="_blank">https://github.com/openmrs/openmrs-core/blob/1.11.x/api/src/main/resources/liquibase-schema-only.xml#L449</a> \
but it is still supposed to be later on after being created be deleted by <a \
href="https://github.com/openmrs/openmrs-core/blob/1.11.x/api/src/main/resources/liquibase-update-to-latest.xml#L771" \
target="_blank">https://github.com/openmrs/openmrs-core/blob/1.11.x/api/src/main/resources/liquibase-update-to-latest.xml#L771</a> \
<div><br></div><div>It looks like the first changeset is not run, so when the \
compiler gets to the second, it finds no table created called \
concept_word</div></div><div class="gmail_extra"><span><br clear="all"><div><div><div \
dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><br></div><div>- \
k-joseph</div></div><div dir="ltr">
<p style="margin-bottom:0in;background-repeat:initial initial"><font face="Arial \
Narrow, sans-serif"><font \
style="font-size:6pt;background-color:rgb(204,204,204)"><font color="#222222"><font \
face="comic sans ms, sans-serif">What we most need now is </font></font><font \
color="#222222"><font face="comic sans ms, \
sans-serif"><u><b>NOT</b></u></font></font><font color="#222222"><font face="comic \
sans ms, sans-serif"><b> legal religion</b></font></font><font color="#222222"> \
</font><font color="#222222"><font face="comic sans ms, \
sans-serif"><u>BUT</u></font></font><font color="#222222"> </font><font \
color="#222222"><font face="comic sans ms, sans-serif"><b>true and genuine \
conversion</b></font></font><font color="#222222"> </font><font \
color="#222222"><font face="comic sans ms, sans-serif">through </font></font><font \
color="#222222"><font face="comic sans ms, sans-serif"><b>Christ our \
righteousness</b></font></font></font></font></p></div></div></div></div></div></div></div>
<br></span><div class="gmail_quote"><div><div>On Wed, Mar 25, 2015 at 6:25 PM, \
k-joseph <span dir="ltr"><<a href="mailto:kaweesi.joseph2012@gmail.com" \
target="_blank">kaweesi.joseph2012@gmail.com</a>></span> \
wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr">the shell \
> option gets part of the logs and gets the rest on to command line, so i have yet \
been able to establish whether the changeset that should have created the table \
failed<span><br><br>On Wednesday, March 25, 2015 at 8:25:07 AM UTC+3, k-joseph \
wrote:</span><div><div><blockquote class="gmail_quote" \
style="margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex"><div \
dir="ltr">Am compiling the 1.11.1 standalone and experiencing some non expected \
liquibase changeset failure:<div><br><div><div>[ERROR] Failed to execute goal \
org.liquibase:liquibase-maven-<u></u>plugin:2.0.1:update (empty-db-update-to-latest) \
on project standalone: Error setting up or running Liquibase: Migration failed for \
change set liquibase-update-to-latest.<u></u>xml::200905150814::bwolfe:</div><div>[ERROR] \
Reason: liquibase.exception.<u></u>DatabaseException: Error executing SQL DELETE FROM \
`concept_word` WHERE concept_name_id = 0: Table 'openmrs.concept_word' \
doesn't exist:</div><div>[ERROR] Caused By: Error executing SQL DELETE FROM \
`concept_word` WHERE concept_name_id = 0: Table 'openmrs.concept_word' \
doesn't exist:</div><div>[ERROR] Caused By: Table 'openmrs.concept_word' \
doesn't exist</div><div>[ERROR] -> [Help 1]</div><div>[ERROR] \
</div><div>[ERROR] To see the full stack trace of the errors, re-run Maven with the \
-e switch.</div><div>[ERROR] Re-run Maven using the -X switch to enable full debug \
logging.</div><div>[ERROR] </div><div>[ERROR] For more information about the errors \
and possible solutions, please read the following articles:</div><div>[ERROR] [Help \
1] <a href="http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException" \
rel="nofollow" target="_blank">http://cwiki.apache.org/<u></u>confluence/display/MAVEN/<u></u>MojoExecutionException</a></div><div>This \
is strange since i expected the table to have been created after running \
liquibase-schema-<u></u>only.xml which has the changeset that should have created the \
table. This comes after i already tagged 1.11.1,</div><div><br></div><div>May be the \
command is not looking to the right source of the war file: here is the command am \
running: </div><div>mvn clean package -Dopenmrs.version=1.11.1 \
-Dopenmrs.war.path=/media/<u></u>KJoseph/Projects/openMRS/<u></u>openmrs-core-master/openmrs-<u></u>core/webapp/target/openmrs.war<br></div><div><br></div><div>Can \
someone try this out on his/her machine, let me upload the war file to source-forge \
to share it </div><div><div><div dir="ltr"><div><div dir="ltr"><div><div \
dir="ltr"><div><br></div><div>- k-joseph</div></div><div dir="ltr">
<p style="margin-bottom:0in"><font face="Arial Narrow, sans-serif"><font \
style="font-size:6pt;background-color:rgb(204,204,204)"><font color="#222222"><font \
face="comic sans ms, sans-serif">What we most need now is </font></font><font \
color="#222222"><font face="comic sans ms, \
sans-serif"><u><b>NOT</b></u></font></font><font color="#222222"><font face="comic \
sans ms, sans-serif"><b> legal religion</b></font></font><font color="#222222"> \
</font><font color="#222222"><font face="comic sans ms, \
sans-serif"><u>BUT</u></font></font><font color="#222222"> </font><font \
color="#222222"><font face="comic sans ms, sans-serif"><b>true and genuine \
conversion</b></font></font><font color="#222222"> </font><font \
color="#222222"><font face="comic sans ms, sans-serif">through </font></font><font \
color="#222222"><font face="comic sans ms, sans-serif"><b>Christ our \
righteousness</b></font></font></font></font></p></div></div></div></div></div></div></div>
</div></div></div>
</blockquote></div></div></div>
<p></p>
-- <br></div></div><div><div><div><div>
OpenMRS Developers: <a href="http://om.rs/dev" \
target="_blank">http://om.rs/dev</a><br>
Post: <a href="mailto:dev@openmrs.org" target="_blank">dev@openmrs.org</a> | \
Unsubscribe: <a href="mailto:dev%2Bunsubscribe@openmrs.org" \
target="_blank">dev+unsubscribe@openmrs.org</a><br> Manage your OpenMRS \
subscriptions: <a href="http://om.rs/id" target="_blank">http://om.rs/id</a><br> \
<br> Visit OpenMRS Talk at <a href="http://om.rs/talk" \
target="_blank">http://om.rs/talk</a> for chat and discussions!<br>
<p></p></div></div>
To unsubscribe from this group and stop receiving emails from it, send an email to <a \
href="mailto:dev+unsubscribe@openmrs.org" \
target="_blank">dev+unsubscribe@openmrs.org</a>.<br> \
</div></div></blockquote></div><br></div><div><div>
<p></p>
-- <br>
OpenMRS Developers: <a href="http://om.rs/dev" \
target="_blank">http://om.rs/dev</a><br>
Post: <a href="mailto:dev@openmrs.org" target="_blank">dev@openmrs.org</a> | \
Unsubscribe: <a href="mailto:dev%2Bunsubscribe@openmrs.org" \
target="_blank">dev+unsubscribe@openmrs.org</a><br> Manage your OpenMRS \
subscriptions: <a href="http://om.rs/id" target="_blank">http://om.rs/id</a><br> \
<br> Visit OpenMRS Talk at <a href="http://om.rs/talk" \
target="_blank">http://om.rs/talk</a> for chat and discussions!<br> \
</div></div></blockquote></div><br><br clear="all"><br></div></div><span class="">-- \
<br><div><span style="background-color:rgb(51,102,255)"><span \
style="color:rgb(255,102,102)"><span \
style="font-size:7.5pt;font-family:"Arial","sans-serif""><span \
style="background-color:rgb(255,255,255)"><span style="color:rgb(51,102,255)">Wyclif \
Luyima<br>Regenstrief Institute Inc.<br><br> </span></span></span><span \
style="color:rgb(204,0,0)"><span \
style="font-size:7.5pt;font-family:"Arial","sans-serif""><span \
style="background-color:rgb(255,255,255)"><span \
style="color:rgb(51,102,255)">Confidentiality Notice: The contents of this message \
and any files transmitted with it may contain confidential and/or privileged \
information and are intended solely for the
use of the named addressee(s). Additionally, the information contained
herein may have been disclosed to you from medical records with
confidentiality protected by federal and state laws. Federal regulations
and State laws prohibit you from making further
disclosure of such information without the specific written consent of
the person to whom the information pertains or as otherwise permitted by
such regulations. A general authorization for the release of medical or
other information is not sufficient for
this purpose.<br>
<br>
If you have received this message in error, please notify the sender by
return e-mail and delete the original message. Any retention,
disclosure, copying, distribution or use of this information by anyone
other than the intended recipient is strictly prohibited.
</span><span></span></span></span></span></span></span></div>
</span></div>
<p></p>
-- <br><span class="">
OpenMRS Developers: <a href="http://om.rs/dev" \
target="_blank">http://om.rs/dev</a><br>
Post: <a href="mailto:dev@openmrs.org" target="_blank">dev@openmrs.org</a> | \
Unsubscribe: <a href="mailto:dev%2Bunsubscribe@openmrs.org" \
target="_blank">dev+unsubscribe@openmrs.org</a><br> Manage your OpenMRS \
subscriptions: <a href="http://om.rs/id" target="_blank">http://om.rs/id</a><br> \
<br></span>
*** THIS GROUP IS MOVING to OpenMRS Talk effective 10 April 2015 at 19:00 UTC. Please \
visit <a href="https://talk.openmrs.org/t/openmrs-developers-group-changes-2015-04-10/1508" \
target="_blank">https://talk.openmrs.org/t/openmrs-developers-group-changes-2015-04-10/1508</a> \
for details and to make necessary changes.<div class="HOEnZb"><div class="h5"><br>
<p></p>
To unsubscribe from this group and stop receiving emails from it, send an email to <a \
href="mailto:dev+unsubscribe@openmrs.org" \
target="_blank">dev+unsubscribe@openmrs.org</a>.<br> \
</div></div></blockquote></div><br></div>
<p></p>
-- <br />
OpenMRS Developers: <a href="http://om.rs/dev">http://om.rs/dev</a><br />
Post: dev@openmrs.org | Unsubscribe: dev+unsubscribe@openmrs.org<br />
Manage your OpenMRS subscriptions: <a href="http://om.rs/id">http://om.rs/id</a><br \
/> <br />
*** THIS GROUP IS MOVING to OpenMRS Talk effective 10 April 2015 at 19:00 UTC. Please \
visit <a href="https://talk.openmrs.org/t/openmrs-developers-group-changes-2015-04-10/ \
1508">https://talk.openmrs.org/t/openmrs-developers-group-changes-2015-04-10/1508</a> \
for details and to make necessary changes.<br />
<p></p>
To unsubscribe from this group and stop receiving emails from it, send an email to <a \
href="mailto:dev+unsubscribe@openmrs.org">dev+unsubscribe@openmrs.org</a>.<br />
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic