problems with upgrade to version 0.5.4 (webapp) from version

Wow that's a big leap!
What was it you did precisely?

"Invalid store version number" means:

When upgrading Pixory looks in your current database to see which
version is being used and then upgrades the database structure (the
structure not the content) to the latest version. And then tags the
database that you use the new version (0.5.4 in your case). Invalid
Store version means that your database does not contain a version or
that your database is newer then your applicaton.

-1- I understand this checking and updating part. However I'm not sure
in which version that was introduced. I cannot check since the 0.5.x
versions are the first public source ones. I have used the 3 versions
and I think it is there.
So if we assume that works.

What I would do is restore your 3.13 version. And then when you see
that it works then update to the 0.5.4 STANDALONE version. Just by
overwriting the application. Safe your .pixory/ folder and your images
(as you did all ready before you do so, because they will be touched)
Just to see if Pixory will pick up your database.
If that works we can go the webapp route.

Lemme know

Ronald

Post by skidvd
I am trying to upgrade to version 0.5.4 (webapp) from version
beta-3.13 standalone.
I have copied my picture root as well as my .pixory/data/pixory
files/dirs to the new enviroment.
Whenever I deploy (or access via URL ) the 0.5.4 webapp, I
org.pixory.pxmodel.PXObjectStore Exception: Invalid store
version number
I'm sure I'm missing some key migration/upgrade step(s), but I
cannot seem to locate any docs on this migration.
I'd appreciate any and all help anyone can provide.
TIA!

c***@abilsoft.com

2007-08-31 02:21:41 UTC

Ronald,

Thanks for your response and suggestions. Running the standalone
0.5.4 seems to confirm your suspicions.

Here are some snips from the pixory.log

Most notably, see the pxmodel.PXObjectStoreVersion ensureCurrent]
- store version: null and

javax.servlet.ServletException:
org.pixory.pxmodel.PXObjectStoreException: Invalid store version
number

messages.

Where do I go from here?

TIA!

......

19:44:33,275 INFO (main) [cfg.SettingsFactory buildSettings] -
RDBMS: HSQL Database Engine, version: 1.7.3
19:44:33,277 INFO (main) [cfg.SettingsFactory buildSettings] -
JDBC driver: HSQL Database Engine Driver, version: 1.7.3
19:44:33,296 INFO (main) [dialect.Dialect <init>] - Using
dialect: org.hibernate.dialect.HSQLDialect
19:44:33,306 INFO (main) [transaction.TransactionFactoryFactory
buildTransactionFactory] - Transaction strategy:
org.hibernate.transaction.JDBCTransactionFactory
19:44:33,313 INFO (main)
[transaction.TransactionManagerLookupFactory
getTransactionManagerLookup] - No TransactionManagerLookup
configured (in JTA environment, use of read-write or
transactional second-level cache is not recommended)
19:44:33,315 INFO (main) [cfg.SettingsFactory buildSettings] -
Automatic flush during beforeCompletion(): disabled
19:44:33,316 INFO (main) [cfg.SettingsFactory buildSettings] -
Automatic session close at end of transaction: disabled
19:44:33,318 INFO (main) [cfg.SettingsFactory buildSettings] -
JDBC batch size: 15
19:44:33,319 INFO (main) [cfg.SettingsFactory buildSettings] -
JDBC batch updates for versioned data: disabled

.......

19:44:33,585 INFO (main) [cfg.SettingsFactory buildSettings] -
Default entity-mode: pojo
19:44:33,702 INFO (main) [impl.SessionFactoryImpl <init>] -
building session factory
19:44:33,728 WARN (main) [config.Configurator configure] - No
configuration found. Configuring ehcache from
ehcache-failsafe.xml found in the classpath:
jar:file:/home/jboss/bin/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
19:44:33,777 INFO (main) [impl.SessionFactoryObjectFactory
addInstance] - Not binding factory to JNDI, no JNDI name configured
19:44:34,054 WARN (main) [pxmodel.PXObjectStoreVersion
fetchStoreVersionNumber]
-
org.pixory.pxmodel.PXObjectStoreException: PXObjectStore contains
invalid number of System records
at
org.pixory.pxmodel.PXObjectStoreVersion.fetchStoreVersionNumber(PXObjectStoreVersion.java:437)
at
org.pixory.pxmodel.PXObjectStoreVersion.getDatabaseVersionNumber(PXObjectStoreVersion.java:333)
at
org.pixory.pxmodel.PXObjectStoreVersion.ensureCurrent(PXObjectStoreVersion.java:512)
at
org.pixory.pxmodel.PXObjectStore.setup(PXObjectStore.java:155)
at
org.pixory.pxapplication.PXApplication.init(PXApplication.java:140)
at
org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:361)
at
org.mortbay.jetty.servlet.ServletHolder.start(ServletHolder.java:240)
at
org.mortbay.jetty.servlet.ServletHandler.initializeServlets(ServletHandler.java:403)
at
org.mortbay.jetty.servlet.WebApplicationHandler.initializeServlets(WebApplicationHandler.java:288)
at
org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:445)
at org.mortbay.http.HttpServer.start(HttpServer.java:678)
at ServletContainer.startServer(ServletContainer.java:259)
at ServletContainer.main(ServletContainer.java:122)
19:44:34,071 INFO (main) [pxmodel.PXObjectStoreVersion
ensureCurrent] - store version: null
19:44:34,078 WARN (main) [pxmodel.PXObjectStore setup] -
org.pixory.pxmodel.PXObjectStoreException: Invalid store version
number
at
org.pixory.pxmodel.PXObjectStoreVersion.ensureCurrent(PXObjectStoreVersion.java:538)
at
org.pixory.pxmodel.PXObjectStore.setup(PXObjectStore.java:155)
at
org.pixory.pxapplication.PXApplication.init(PXApplication.java:140)
at
org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:361)
at
org.mortbay.jetty.servlet.ServletHolder.start(ServletHolder.java:240)
at
org.mortbay.jetty.servlet.ServletHandler.initializeServlets(ServletHandler.java:403)
at
org.mortbay.jetty.servlet.WebApplicationHandler.initializeServlets(WebApplicationHandler.java:288)
at
org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:445)
at org.mortbay.http.HttpServer.start(HttpServer.java:678)
at ServletContainer.startServer(ServletContainer.java:259)
at ServletContainer.main(ServletContainer.java:122)
19:44:34,469 INFO (main) [impl.SessionFactoryImpl close] - closing
19:44:34,470 INFO (main)
[connection.DriverManagerConnectionProvider close] - cleaning up
connection pool: jdbc:hsqldb:/home/jboss/.pixory/data/pixory
19:44:34,491 ERROR (main) [ServletContainer main] -
javax.servlet.ServletException:
org.pixory.pxmodel.PXObjectStoreException: Invalid store version
number
at
org.pixory.pxapplication.PXApplication.init(PXApplication.java:207)
at
org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:361)
at
org.mortbay.jetty.servlet.ServletHolder.start(ServletHolder.java:240)
at
org.mortbay.jetty.servlet.ServletHandler.initializeServlets(ServletHandler.java:403)
at
org.mortbay.jetty.servlet.WebApplicationHandler.initializeServlets(WebApplicationHandler.java:288)
at
org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:445)
at org.mortbay.http.HttpServer.start(HttpServer.java:678)
at ServletContainer.startServer(ServletContainer.java:259)
at ServletContainer.main(ServletContainer.java:122)

Ronald Pulleman

2007-08-31 07:28:18 UTC

Could you try the 0.5.0 version. And then upgrade further?

Or: Do you have a lot of data? (users and groups) If you don't,
perhaps it is just as easy to reenter that data.

Images and text are not stored in the database so you won't loose those.

Ronald

Post by c***@abilsoft.com
Ronald,
Thanks for your response and suggestions. Running the standalone
0.5.4 seems to confirm your suspicions.
Here are some snips from the pixory.log
Most notably, see the pxmodel.PXObjectStoreVersion ensureCurrent]
- store version: null and
org.pixory.pxmodel.PXObjectStoreException: Invalid store version
number
messages.
Where do I go from here?
TIA!
......

c***@abilsoft.com

2007-08-31 12:23:54 UTC

I do have a fair amount of data that I don't wish to loose. I
would like to try the 0.5.0 version. However, I don't see a
download section for archived releases on sourceforge. Where
can I locate the 0.5.0 version binaries?

Ronald Pulleman

2007-08-31 23:42:58 UTC

It's here:
http://sourceforge.net/project/showfiles.php?group_id=124041&package_id=136622

Good luck.

Ronald

Post by c***@abilsoft.com
I do have a fair amount of data that I don't wish to loose. I
would like to try the 0.5.0 version. However, I don't see a
download section for archived releases on sourceforge. Where
can I locate the 0.5.0 version binaries?
Could you try the 0.5.0 version. And then upgrade further?
Or: Do you have a lot of data? (users and groups) If you don't,
perhaps it is just as easy to reenter that data.
Images and text are not stored in the database so you won't loose those.
Ronald

c***@abilsoft.com

2007-09-01 14:00:47 UTC

Ronald,

Thanks for the link (I'm not sure how I missed that :)

Anyway, I downloaded the 0.5.5 Standalone version. I get the
same results though: the store version: null error and then the
subsequent Invalid store version error.

Is three a way I could manually tell it what version I have for
the DB reconfig it needs to do? Any other ideas?

Thanks again for all your help!

c***@abilsoft.com

2007-09-01 14:25:42 UTC

Ronald,

More information/mystery. Even though I am sure (I double
checked) that I downloaded the 0.5.0 version from SourceForge,
when I unzip it, the contained version file is marked 0.5.3.

So, it would appear that I've not yet found the actual 0.5.0
binaries? Am I mistaken or are there other ideas?

TIA!

Ronald Pulleman

2007-09-03 08:33:21 UTC

hmm that's strange.
I uploaded he latest version. The 0.5.0 is of Joe's doing.
I'm not sure I can help that. You could check out the 0.5.0 tagged
version from cvs and built it yourself. But still I'm not sure that
will help your problem.
Perhaps Joe knows if the 3.x versions can be updated.

Ronald

Post by c***@abilsoft.com
Ronald,
More information/mystery. Even though I am sure (I double
checked) that I downloaded the 0.5.0 version from SourceForge,
when I unzip it, the contained version file is marked 0.5.3.
So, it would appear that I've not yet found the actual 0.5.0
binaries? Am I mistaken or are there other ideas?
TIA!
Ronald,
Thanks for the link (I'm not sure how I missed that :)
Anyway, I downloaded the 0.5.5 Standalone version. I get the
same results though: the store version: null error and then the
subsequent Invalid store version error.
Is three a way I could manually tell it what version I have for
the DB reconfig it needs to do? Any other ideas?
Thanks again for all your help!

http://sourceforge.net/project/showfiles.php?group_id=124041&package_id=136622

Post by c***@abilsoft.com
Good luck.
Ronald

those.

Post by c***@abilsoft.com
Ronald

skidvd

2007-09-03 15:11:48 UTC

Does Joe still monitor this forum? Or is there a better way t
contact him?

Thanks again for all of your help!

Post by Ronald Pulleman
hmm that's strange.
I uploaded he latest version. The 0.5.0 is of Joe's doing.
I'm not sure I can help that. You could check out the 0.5.0 tagged
version from cvs and built it yourself. But still I'm not sure that
will help your problem.
Perhaps Joe knows if the 3.x versions can be updated.
Ronald

http://sourceforge.net/project/showfiles.php?

group_id=124041&package_id=136622

Post by c***@abilsoft.com
Good luck.
Ronald

those.

Post by c***@abilsoft.com
Ronald

Post by c***@abilsoft.com
Ronald,
Thanks for your response and suggestions. Running the

standalone

Post by c***@abilsoft.com
0.5.4 seems to confirm your suspicions.
Here are some snips from the pixory.log
Most notably, see the pxmodel.PXObjectStoreVersion

ensureCurrent]

Post by c***@abilsoft.com
- store version: null and
org.pixory.pxmodel.PXObjectStoreException: Invalid store

version

Post by c***@abilsoft.com
number
messages.
Where do I go from here?
TIA!
......

Ronald Pulleman

2007-09-03 20:15:24 UTC

I'm not sure. Sorry

Post by skidvd
Does Joe still monitor this forum? Or is there a better way t
contact him?
Thanks again for all of your help!

http://sourceforge.net/project/showfiles.php?

group_id=124041&package_id=136622

Post by c***@abilsoft.com
Good luck.
Ronald

loose

Post by Ronald Pulleman
those.

Post by c***@abilsoft.com
Ronald

Post by c***@abilsoft.com
Ronald,
Thanks for your response and suggestions. Running the

standalone

Post by c***@abilsoft.com
0.5.4 seems to confirm your suspicions.
Here are some snips from the pixory.log
Most notably, see the pxmodel.PXObjectStoreVersion

ensureCurrent]

Post by c***@abilsoft.com
- store version: null and
org.pixory.pxmodel.PXObjectStoreException: Invalid store

version