Trying to Migrate from 9.3 to 9.4 Please Help!!

Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules
Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
Post Reply
kedar
Posts: 5
Joined: 24 Nov 2016, 08:44
what is two(2) plus three(3) ?: 5

Trying to Migrate from 9.3 to 9.4 Please Help!!

Post by kedar » 04 Aug 2017, 11:54

Hi,

I am trying to migrate from 9.3 to 9.4 can anyone guide me how do i go about it without loosing the previous data? the documents arent helpful and they wont mention the process.

Regards
Kedar.

User avatar
cptr13
Posts: 414
Joined: 23 Apr 2008, 01:53
what is two(2) plus three(3) ?: 5
Location: Mobile, AL
Contact:

Re: Trying to Migrate from 9.3 to 9.4 Please Help!!

Post by cptr13 » 04 Aug 2017, 12:40

Do you know how to backup and restore your opencats system?

kedar
Posts: 5
Joined: 24 Nov 2016, 08:44
what is two(2) plus three(3) ?: 5

Re: Trying to Migrate from 9.3 to 9.4 Please Help!!

Post by kedar » 07 Aug 2017, 11:04

Hi,

No i am unaware of that.

Regards
Kedar.

User avatar
cptr13
Posts: 414
Joined: 23 Apr 2008, 01:53
what is two(2) plus three(3) ?: 5
Location: Mobile, AL
Contact:

Re: Trying to Migrate from 9.3 to 9.4 Please Help!!

Post by cptr13 » 10 Aug 2017, 22:06

I have posted the backup/restore/upgrade section to the documentation. It is incomplete at the moment though.

Give it a try. If you can't do it with the GUI backup (install) restore, let me know, and I'll try to finish it up in the next day or two.

http://opencats-documentation.readthedo ... store.html

lmrxd
Posts: 2
Joined: 22 Sep 2017, 10:35
what is two(2) plus three(3) ?: 5

Re: Trying to Migrate from 9.3 to 9.4 Please Help!!

Post by lmrxd » 24 Sep 2017, 18:30

Hi,

I'm also trying to upgrade from 9.3 to 9.4 and I don't want to lose data.

Unfortunately, the GUI backup of my 9.3 isn't working. I've tried the manual approach but not sure if I did it correctly. Below are my steps:

1. Copied the attachments folder in 9.3
2. Used mysqldump in 9.3
3. Copied 9.3 attachments to new 9.4 folder
4. Finally, I've run mysql -u opencats < opencatsbak.sql in my 9.4 installtion

I was able to login but then the following error showed up:

MySQL Query Failed: Table 'cats_dev.user' doesn't exist

SELECT
user.user_name AS username,
user.password AS password,
user.access_level AS accessLevel
FROM
user
WHERE
user.user_name = 'admin'

I'm currently at a lost.

User avatar
cptr13
Posts: 414
Joined: 23 Apr 2008, 01:53
what is two(2) plus three(3) ?: 5
Location: Mobile, AL
Contact:

Re: Trying to Migrate from 9.3 to 9.4 Please Help!!

Post by cptr13 » 24 Sep 2017, 18:35

I was actually looking at this today to try to finish this part of the documentation.
Here are the abbreviated instructions.

Merge/overwrite old attachments folder into new Opencats attachments directory

In phpmyadmin:
Create new database in phpmyadmin - Follow install documentation for this step if necessary
Select newly created database from list on the left
Click import in the upper row
browse
select your opencatsdatabasebackup.sql file
Scroll to the bottom and click "go"
Create user (follow steps from documentation) for the database and assign rights.

In NEW opencats directory
Check for INSTALL_BLOCK file or folder in opencats directory
Install opencats through browser

When you get to the intall type step (new, demo, restore, etc. ) You should see:
Use existing OpenCATS installation and automatically preform any necessary upgrade (recommended).
Select that option.

That should work. Post back with any questions/issues.

lmrxd
Posts: 2
Joined: 22 Sep 2017, 10:35
what is two(2) plus three(3) ?: 5

Re: Trying to Migrate from 9.3 to 9.4 Please Help!!

Post by lmrxd » 26 Sep 2017, 09:55

Thanks for clarifying the process. I've successfully migrated to 9.4 but I wasn't able to use phpmyadmin.

Here are the steps I've performed in CentOS7 for reference:
1. Backup attachments and database from old OpenCATS installation.
  • a. To backup attachments, just copy the attachments folder
    b. To backup database, perform the following command:

    Code: Select all

    mysqldump -p -u dbusername opencatsdb > opencatsbak.sql
2. In the new OpenCATS directory, restore the attachments and database.
  • a. To restore attachments, perform the ff. command:

    Code: Select all

    cp -p -r cats-x.x.x/attachments/ cats-0.9.4/attachments/
    b. To restore database, perform the ff. command:

    Code: Select all

    mysql -u opencatsdb < opencatsbak.sql
3. Install OpenCATS_0.9.4 in browser and select upgrade.

Hope this helps others.

However, now I'm encountering a new issue which I can't access previously uploaded attachments and can't upload .doc, .docx, etc. But pdf works fine. The following error shows when viewing previous attachments from OpenCATS:

"Some of the information you provided doesn't follow the correct format and CATS can't interpret what it is. Please go back and complete each field paying close attention to any instructions provided.

This attachment is momentarily offline, please try again later. The support staff has been notified."

User avatar
cptr13
Posts: 414
Joined: 23 Apr 2008, 01:53
what is two(2) plus three(3) ?: 5
Location: Mobile, AL
Contact:

Re: Trying to Migrate from 9.3 to 9.4 Please Help!!

Post by cptr13 » 27 Sep 2017, 00:54

Yes.....I'm not entirely sure what that's all about.

You can create an issue on our github page and the developers will take a look at it. There have been conversations recently on the forums about different formats and their recognition in the system.

Post Reply