Categories

Resolved Global Checkin - won 't clear "o9j1cg4o_csvi_availabletables table"

  1. dhillock
    dhillock
  2. RO CSVI
  3. Wednesday, 24 July 2024
  4.  Subscribe via email
Hello,

For some time now, when I go to Global Check-in, I cannot clear the above. I've attached a screenshot to show you what I mean.

I'm using Joomla 5.1.2, RO CSVI 8.11.2, and PHP 8.2.21

I have run CSVI Maintenance (Updatae available fields), but no difference.

This is not causing a problem - from what I can see. However, it would be nice to have these items checked-in.

Any suggestions. David
Attachments (1)
Screenshot 2024-07-24 at 10.43.41 AM.png Screenshot 2024-07-24 at 10.43.41 AM.png
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello David,
We have already fixed this issue. The problem is with checked_out field in o9j1cg4o_csvi_availabletables table. The default value for this field should be NULL but you should be having existing rows with value 0 which are not updated to NULL value and so you see the error. As you said it is not going to harm import or export but if you want to fix it you can check o9j1cg4o_csvi_availabletables table from PHPMyAdmin and set value of checked_out field to NULL for existing rows.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Sorry, the discussion is currently locked. You will not be able to post a reply or a comment at the moment.