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
Accepted Answer Pending Moderation
Hello David,
You did not mention RO CSVI version you are using. This issue was fixed with RO CSVI 8.5.0 version. If you are using any version above RO CSVI 8.5.0 and you still had this issue it could be that you had old rows in database with checked_out set to 0. Setting it to Null would have solved the problem. You could have also used Verify database button in RO CSVI About page and also Reset tasks and update available fields to solve this.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 hours ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!