HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


[RESOLVED] - Transferring Databases

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#62108 (In Topic #13524)
Avatar

Community saint

Here's another cry for help.

Trying to transfer database information from an older 3.x.x site to the new 5.0.1 falls at the first hurdle. There is no 'XML Database Manager' in version 3.

So I exported the relevant table in XML format using phpMyAdmin, BUT when I tried to import this into the version 5 database it returned an 'invalid token' (or something like that) error. Closer inspection of the XML file also showed that the table in question (FAQs in this instance) had changed its column entries between the older and newer version.

Despite the advice in the tutorial …

Transferring data between websites said

If you want to transfer parts of the database contents to another website (e.g. if you are trying to transfer data from a staging website to a live website) then don't try to do it manually via phpMyAdmin. There is special functionality built into ocPortal that will make your life much easier - see "XML data management" in the Tools section of the Admin Zone.
… my question is whether it is at all possible to import database information from an older version to a newer?

If there is a work-around it will certainly make life very simple indeed …

O_o

Take my advice. I'm not using it!

View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal
Back to the top
 
Posted
Rating:
#62113
Avatar

Try ocp-merge importer. One of the importers.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#62118
Avatar

Community saint

Thanks for the pointer, Chris.

The importer worked until I got to the 'members' bit. Initially it didn't want to import ANYTHING, so I deleted all the members from my old ocp2_f_members table, except for 'Guest' and 'My entry', and then got this …
We cannot continue due to a missing dependency. 66 of type member  is missing. There may be a small corruption in your database - if you contact us (ocProducts) with a copy of the database, we may be able to work around it and get you an updated importer.

So I deleted the two remaining entries, but I get the same error message.

Doesn't seem much point in forwarding the table, because it is empty!

Can't go any further with the import as it says all the other items are dependant on the ones before them.

Where next?

Take my advice. I'm not using it!

View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal
Back to the top
 
Posted
Rating:
#62120
Avatar

The error is saying it cannot import something that depends on the members you deleted. E.g. maybe some posts owned by them.

I would need to know what the error was originally that stopped members importing.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#62125
Avatar

Community saint

Here is the error when trying to import 'Members' after successfully completing the previous four THREE steps: Attachments, Usergroups, Custom Profile Fields ...

PHP NOTICE [8] Undefined index: m_password_compat_scheme in /home/fletch/public_html/anglo/sources/hooks/modules/admin_i
mport/ocp_merge.php on line 1704 (version: 5.0.1, PHP version: 5.2.14, URL: /anglo/adminzone/index.php?page=admin_import&happy=1&type=im
port&session=710927537&importer=ocp_merge)

and here is the Stack trace ...

Expand: Stack trace Stack trace


Take my advice. I'm not using it!

View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal
Back to the top
 
Posted
Rating:
#62126
Avatar

Ah yes, that is likely going to take me 2 mins to fix. Although can't guarantee there won't be another error after it. Trying for a fix now…


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#62127
Avatar

Attachment
sources/hooks/modules/admin_import/ocp_merge.php
» Download: ocp_merge.php (90 Kb, 169 downloads so far)


We'd just renamed a field. We don't guarantee compatibility with the merge importer between versions but we do try and keep it working, and this was a simply fix.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#62128
Avatar

Community saint

Yup, you guessed right. Line 1204, this time - running the 'Calendar' import ...

PHP ERROR [1] Call to undefined function regenerate_event_reminder_jobs() in /home/fletch/public_html/anglo/sources_custom/hooks/modules/
admin_import/ocp_merge.php on line 1204 (version: 5.0.1, PHP version: 5.2.14, URL: /anglo/adminzone/index.php?page=admin_import&happy=1&type=im
port&session=710927537&importer=ocp_merge)

Expand: Stack trace Stack trace



I also got a HUGE error message for the previous 'Members' fix (no stack trace), but it allowed me to move on to the next import item, so I am trying to motor ahead. If you want the error report I may well have to repeat the import step to get the information for you!

Take my advice. I'm not using it!

View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal
Back to the top
 
Posted
Rating:
#62129
Avatar

Ah right, I'll fix that, but calendar events did import and you can ignore that one. Just untick calendar and continue.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#62130
Avatar

Community saint

Another for the 'Catalogues' import - the one I REALLY want …

We cannot continue due to a missing dependency. 18 of type catalogue_category  is missing. There may be a small corruption in your database - if you contact us (ocProducts) with a copy of the database, we may be able to work around it and get you an updated importer.

Expand: Database query failed Database query failed


Sorry about the size of that, but that was what was presented to me.

ALSO, the failure for importing 'Members' was a 'Database query failure'

Happy days …

Take my advice. I'm not using it!

View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal
Back to the top
 
Posted
Rating:
#62139
Avatar

Attachment
» Download: ocp_merge.php (91 Kb, 182 downloads so far)


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#62142
Avatar

Community saint

I know this is turning into a bit of a marathon, BUT, it will probably benefit all users in the long term!

So, running the latest ocp_merge.php fix, starting with a completely new import (deleting all other tasks), I've managed to get as far as 'Catalogues' again, with the following error(s) ...
Database query failed: INSERT INTO ocp5_catalogues (c_name, c_title, c_description, c_own_pages, c_own_template, c_is_tree, c_notes, c_add_date, c_submit_points) VALUES ('dictionary', 14679, 14680, 0, 0, 0, '', 1238639442, 10) [Unknown column 'c_own_pages' in 'field list']<br /> Database query failed: INSERT INTO ocp5_catalogues (c_name, c_title, c_description, c_own_pages, c_own_template, c_is_tree, c_notes, c_add_date, c_submit_points) VALUES ('aidirectory', 14685, 14686, 0, 0, 1, '', 1238639236, 10) [Unknown column 'c_own_pages' in 'field list']<br /> Database query failed: INSERT INTO ocp5_catalogues (c_name, c_title, c_description, c_own_pages, c_own_template, c_is_tree, c_notes, c_add_date, c_submit_points) VALUES ('aipubs', 14709, 14710, 1, 0, 0, '', 1238639356, 10) [Unknown column 'c_own_pages' in 'field list']<br />

and

PHP NOTICE [8] Undefined offset: 67 in /home/fletch/public_html/anglo/sources/catalogues2.php on line 603 (version: 5.0.1, PHP version: 5.2.14, URL: /anglo/adminzone/index.php?page=admin_import&happy=1&type=im
port&session=1049368720&importer=ocp_merge)


Expand: Stack trace ... Stack trace ...



Take my advice. I'm not using it!

View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal
Back to the top
 
Posted
Rating:
#62143
Avatar

Hi,

Do you think you could send me an SQL dump so I can test? This is a bit trickier.

chris@ocportal.com


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#62145
Avatar

Community saint

All the 'catalogue' tables from the old site. Please delete those you don't require.

Despite the 'ocp2_' prefix it was running 3.2.10.

Attachment
» Download: ocp2_catalogues.sql (1.65 Kb, 174 downloads so far)

Attachment
» Download: ocp2_catalogue_fields.sql (4 Kb, 158 downloads so far)

Attachment
» Download: ocp2_catalogues_categories.sql (5 Kb, 175 downloads so far)

Attachment
» Download: ocp2_catalogue_entries.sql (27 Kb, 172 downloads so far)

Attachment
» Download: ocp2_catalogue_efv_long.sql (7 Kb, 171 downloads so far)

Attachment
» Download: ocp2_catalogue_efv_long_trans.sql (12 Kb, 159 downloads so far)

Attachment
» Download: ocp2_catalogue_efv_short.sql (25 Kb, 181 downloads so far)

Attachment
» Download: ocp2_catalogue_efv_short_trans.sql (19 Kb, 159 downloads so far)

Take my advice. I'm not using it!

View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal
Back to the top
 
Posted
Rating:
#62146
Avatar

Community saint

Ooooops!

Just re-read your post. Did you provide the email addy so that I could send the WHOLE db SQL dump?

Don't think so, but thought I'd ask …

Take my advice. I'm not using it!

View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal
Back to the top
 
Posted
Rating:
#62147
Avatar

Ideally, yes, because the translate table also contains data. But you shouldn't post that publicly.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#62148
Avatar

Community saint

OK.

Will go for the SQL dump for the whole db. Will probably take a while …


Update:
zipped and forwarded …

Take my advice. I'm not using it!

View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal
Back to the top
 
Posted
Rating:
#62151
Avatar

Thanks. Reproduced your error now.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#62152
Avatar

Many bug fixes later…

Attachment
» Download: ocp_merge.php (93 Kb, 162 downloads so far)


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#62153
Avatar

Community saint

Did a diff-check, and that's an OUCH!.

Now ….. is there an 'easy' way to return the site to before starting the imports, as I have a whole bunch of stuff already imported, but stuff that doesn't work 100%. Stack traces served up each time I try to access SOME news posts for instance whilst others display OK, catalogues showing hundreds of entries in the index, but not showing anything when clicked. Same with members: all names are there, but no information.

Will running the latest import-fix get that data and put it in the correct place without duplicating entries?

Take my advice. I'm not using it!

View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Expand