1. dhillock
  2. RO CSVI
  3. Saturday, 07 March 2026
  4.  Subscribe via email
Hello,

I was told previously that this issue was fixed, but it's persisting, so I'm providing additional information.

I believe ROCSVI may be leaving invalid checkout values in `csvi_availabletables`, which causes Joomla’s **Global Check-in** scheduled task to fail.

**Issue**
Joomla’s Global Check-in task was repeatedly failing with exit code `-2`, even though it was successfully checking in normal Joomla articles.

I traced the problem to this table:

```sql
XXX_csvi_availabletables
```

When I ran:

```sql
UPDATE XXX_csvi_availabletables
SET checked_out = NULL
WHERE checked_out = 0;
```

it cleared 35 rows. After that, the Joomla Global Check-in task ran successfully with no error.

**Relevant schema**

* `checked_out`: allows `NULL`, default = `0`
* `checked_out_time`: `NOT NULL`, default = `0000-00-00 00:00:00`

**Request**
Please check whether ROCSVI should be leaving rows with `checked_out = 0`, rather than `NULL`, in this table. That state appears to conflict with Joomla’s Global Check-in task.

David
Sorry, the discussion is currently locked. You will not be able to post a reply or a comment at the moment.