db upgrade 1.1.4
-
-
-
-
hi victor,
to cut the story short i did everything as i mentioned in the last time and everything went fine but service did not came up.running the service from command line told that my db has a version of 232 and the server is compiled for version 240.
i did an upgrade and it failed and the error message said :" sql query failed (table 'business_services' already exists): " and then it writes the sql command: "create table business_services........" and all of it's data.Best Regards,
Lindeamon -
-
Hi!
Looks like database was messed up during all these upgrades. Can you please run
nxdbmgr upgrade -X
(it will ignore errors), and then try to run server. Also, if possible, export and send to me database schema - I'll check it for correctness.
Best regards,
Victor -
-
regarding the schema,is there any quick way to export it without any records ? if it is not possible then i will not be able to send it to you.
but there is something the makes me wonder,after each installation i tried with the different patches you gave me i have restored the databse to the one that worked with v1.1.3 so why would it give me errors ?
maybe i will try to make a clean install and check it.10x,
lindeamon -
hi victor,
i found a way to export with no data.here is the v1.1.4 schema
-
@lindeamon said in db upgrade 1.1.4:
what version of the sql.ddr patches do i have to save for now ? the latest one ?
Yes.
Best regards,
Victor
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login