opencats.org

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.

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

Hi,

No i am unaware of that.

Regards
Kedar.

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

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.

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.

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."

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.