You're right. DSpace 3 still uses the collection2item table. DSpace 4
doesn't use it anymore (by default, it reads the counts from Solr instead
of the database).
You should be able to update it like this. Make sure to have a backup of
the database because I haven't tested it in any way.
UPDATE community2item
SET community_id=NewCommunityID
WHERE item_id IN (SELECT item_id FROM collection2item WHERE collection_id =
'22')
Update the index and run itemcounter afterwards
Regards,
~~helix84
Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
------------------------------------------------------------------------------
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience. Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette