PostgreSQL-incompatible SQL in activity_delete()

Created on 8 October 2010, about 15 years ago
Updated 29 October 2025, 6 days ago

Under PostgreSQL, here is an error:

DELETE m, at, aa, a FROM activity a LEFT JOIN activity_access aa ON aa.aid = a.aid INNER JOIN activity_targets at ON at.aid = a.aid INNER JOIN activity_messages m ON m.amid = at.amid WHERE a.aid IN (48050,48051,48053,48055)

SQL guidelines for Drupal can be read here:
http://drupal.org/node/555514

MySQLism and PostgreSQLism: avoid deleting data in several tables in one query:
http://drupal.org/node/555648

It seems that this delete query should be split in several queries.

🐛 Bug report
Status

Closed: outdated

Version

2.0

Component

Code

Created by

🇫🇷France grub3

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

No activities found.

Production build 0.71.5 2024