You are viewing the PKP Support Forum | PKP Home Wiki

OCS to OJS data export

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

OCS to OJS data export

Postby johnkperks » Wed Jun 13, 2012 4:43 pm


We have a database of 300 delegates in OCS. Recently, we try to export that OCS database of users to OJS and keep on getting error "OJS DB Error: Column 'last_name' cannot be null". Can someone help please?
Posts: 14
Joined: Wed Nov 02, 2011 3:10 am

Re: OCS to OJS data export

Postby asmecher » Wed Jun 13, 2012 5:16 pm

Hi johnkperks,

Are you doing a direct database conversion (i.e. right from your OCS MySQL to your OJS MySQL)?

The message suggests that you're trying to insert a value into the users table without supplying a value for the last_name column, which requires a value.

Alec Smecher
Public Knowledge Project Team
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Return to OJS Technical Support

Who is online

Users browsing this forum: Google [Bot] and 2 guests