[opencms-dev] files owned by a deleted user

[Martin Kuba]

Olli Aro wrote:
> Hi,
> 
> I have had problem with this many times before as well - I have raised this
> as a bug bugzilla so hopefully it will be fixed for version 6. What I
> normally do as a fix, I do sql and get the lines in CMS_RESOURCES table (and
> online and backup versions) and replace the owner id with admin user's id.

Hi Olli,

I tried that by issuing:

  update CMS_ONLINE_RESOURCES set 
USER_CREATED='74ee7e75-c124-11d8-9186-e75e715cfd88' where 
USER_CREATED='898863a6-c124-11d8-9186-e75e715cfd88';
update CMS_BACKUP_RESOURCES set 
USER_CREATED='74ee7e75-c124-11d8-9186-e75e715cfd88' where 
USER_CREATED='898863a6-c124-11d8-9186-e75e715cfd88';
update CMS_OFFLINE_RESOURCES set 
USER_CREATED='74ee7e75-c124-11d8-9186-e75e715cfd88' where 
USER_CREATED='898863a6-c124-11d8-9186-e75e715cfd88';

and I even restarted TomCat, now the explorer shows correctly,
but during module export I still get:

  Exception org.opencms.main.CmsException: 
[org.opencms.db.mysql.CmsUserDriver] where: 
org.opencms.db.generic.CmsUserDriver.readUser(CmsUserDriver.java:906), why: 
org.opencms.main.CmsException: 
[org.opencms.db.mysql.CmsUserDriver]898863a6-c124-11d8-9186-e75e715cfd88 [Code 
10 - Unknown User] [Code 10 - Unknown User]
Root cause was: org.opencms.main.CmsException: 
[org.opencms.db.mysql.CmsUserDriver]898863a6-c124-11d8-9186-e75e715cfd88 [Code 
10 - Unknown User]
at org.opencms.db.generic.CmsSqlManager.getCmsException(CmsSqlManager.java:386)
at org.opencms.db.generic.CmsUserDriver.readUser(CmsUserDriver.java:913)
at org.opencms.db.CmsDriverManager.readUser(CmsDriverManager.java:6388)
at org.opencms.file.CmsObject.readUser(CmsObject.java:3086)
at org.opencms.importexport.CmsExport.appendResourceToManifest(CmsExport.java:687)
at org.opencms.importexport.CmsExport.exportFile(CmsExport.java:579)
at org.opencms.importexport.CmsExport.addChildResources(CmsExport.java:323)
at org.opencms.importexport.CmsExport.exportAllResources(CmsExport.java:540)
at org.opencms.importexport.CmsExport.<init>(CmsExport.java:209)
at org.opencms.file.CmsRegistry.exportModule(CmsRegistry.java:684)
at 
org.opencms.importexport.CmsModuleImportExportHandler.exportData(CmsModuleImportExportHandler.java:108)
at 
org.opencms.importexport.CmsImportExportManager.exportData(CmsImportExportManager.java:266)
at org.opencms.threads.CmsExportThread.run(CmsExportThread.java:76)


Is there any other table where it must be changed ?

Martin
-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Supercomputing Center Brno             Martin Kuba
Institute of Computer Science    email: makub at ics.muni.cz
Masaryk University             http://www.ics.muni.cz/~makub/
Botanicka 68a, 60200 Brno, CZ     mobil: +420-603-533775
--------------------------------------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 2847 bytes
Desc: S/MIME Cryptographic Signature
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041007/d7610255/attachment.bin>