Answered Custom Tables - Child Record not being deleted

Quote from: opengeek at Apr 11, 2015, 08:34 AM

I don't see anything obviously wrong here. This may be entirely related to the use of a mixed cased field name for "Id", but I would have to test the theory to be sure.

Thanks for the reply opengeek - I think you're right. To try and test my set up I've set up a new site on a different host using the same modx version of 2.3.3, got furls working and did nothing else. Then used bob's CreateXpdoClasses script to build my scheema and maps - at that point I realised that because I had used "Id" instead of "id" for my primary keys the script was creating a scheema that extends="xPDOObject" instead of extends="xPDOSimpleObject" so I've reworked everything to that end but I'm now having problems querying the tables using $modx->getCollectionGraph('Tutor', '{"P":{}, "C":{} }', $c) - I keep getting

"[2015-04-11 15:04:44] (ERROR @ /index.php) No foreign key definition for parentClass: Tutor using relation alias: P
[2015-04-11 15:04:44] (ERROR @ /index.php) No foreign key definition for parentClass: Tutor using relation alias: C"

So I've got something wrong with my scheema. I haven't even tried the delete functionality yet.

I'll rework my tables and without mixing the case and see what happens.

2 steps forward......................

Make sure your schema doesn't have an id field if you're extending xPDOSimple object. That will give you one automatically.

Quote from: goldsky at Apr 14, 2015, 09:59 AM

there's a bug in xPDO
https://github.com/modxcms/revolution/issues/12416

Thanks for that goldsky

If there is a bug that stops the cascade deletion from working in my case - why has no one else had a problem if they are doing what I'm trying to do? If they are doing things differently - what is it that they are doing that I should be doing?

I know I'm not the smartest but I seem to be missing something here - any suggestions????

TYVM

If there is a bug that stops the cascade deletion from working in my case - why has no one else had a problem if they are doing what I'm trying to do?

Because:

1. the error is hidden in database and error log.
2. it's rarely the user delete+purge resource (child: child resources & TVs), has nested categories, or other complex thing

If they are doing things differently - what is it that they are doing that I should be doing?

Anyway, it's been fixed, but slightly different.
https://github.com/modxcms/xpdo/commit/e74922df8c6004f80e6a1ab10aaec1eaf1487c6b

It's not wrapped in else {}.

Thanks very much for your reply

I've looked at the fix and thought I would simply copy the updated xPDO/Om/xPDOObject.php to my install but I don't have that file - mine is xpdoobject.class.php. I looked on the modx downloads page but couldn't see an updated down load.

What should I be doing? Sorry if I'm being dense :-(

Quote from: goldsky at Apr 14, 2015, 09:59 AM

there's a bug in xPDO
https://github.com/modxcms/revolution/issues/12416

I've just updated my install with this fix and the cascade delete is working - Woo Hoo.

THANKS VERY MUCH everyone who responded - 'er Indoors thinks goldsky is amazing - cus now I might stop banging on about my site not working





[ed. note: esradral last edited this post 11 years, 5 months ago.]