Categories
View Replies (4)

Resolved ROCSVI checkout state may cause Joomla Global Check-in task to fail

  1. New
  1. dhillock
    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
0
Responses (4)
tharuna
tharuna
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. 10 hours ago
  2. RO CSVI
  3. # 1
dhillock
dhillock
Accepted Answer Pending Moderation
Apologies for not mentioning the version numbers - ROCSVI is 9.5.3, Joomla is 6.0.3, and PHP 8.4.18.

I took your advice and ran Verify Database, then in maintenance, I updated fields, and optimized tables.

For clarity and given the above, are you saying that the 35 checkout issue should no longer appear?

Take care.

David
  1. 5 hours ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hi David,

For clarity and given the above, are you saying that the 35 checkout issue should no longer appear?
Correct, at least not for the RO CSVI component. There may be other components that do not allow the checked_out field to be NULL.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 4 hours ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
Hello David,
For clarity and given the above, are you saying that the 35 checkout issue should no longer appear?

Yes by doing Verify database default of checked_out field in #__csvi_availabletables will be set to NULL, Reset task will reset records in #__csvi_availabletables table which makes checked_out field to get NULL as default value for records. Since tasks are reset it is recommended to update available fields as well.
Kind regards,

Tharuna

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


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