Support is offline. We are back Monday 23 November, 09:00.

ROCSVI Checkout Values #85960

Resolved Locked dhillock opened this topic Friday, 20 March 2026 ยท 14 replies
Author

I'm using Joomla 6.0.3, PHP 8.4.19, and ROCSVI 9.6.1

I have reported on a couple of occasions, an issue with checkout values. For the last while, the problem has not showed itself, and you advised me here, that the problem with resolved. However, I've discovered now that when ROCSVI is updated, the problem immediately appears. This happened with the update today, and the previous update.

I can easily resolve the problem by issuing the following SQL statement:

UPDATE XXXXX_csvi_availabletables
SET checked_out = NULL
WHERE checked_out = 0
AND checked_out_time IS NULL;

However, i thought you would want to know the problem appears when updating.

TY and take care.

David

Support

Hello David,
I am not able to see this issue with RO CSVI Update. Can you share a screenshot on what you see in Global Check in page? We will see if we can find the cause on why you see it.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Sincere apology for the delay. No excuse.

I downloaded the latest release today, and installed, then took a screen shot, which is attached.

David

  • For_ROCSVI.png
Support

Hi David,

I am quite stumped and I don't even think it is something RO CSVI is doing. After your previous report we added a routine that after installation all checked_out fields are set to NULL. This is what Joomla checks to show tables as being checked-in.

Can you tell me, is it all the records in the availabletables that are seen as checked in? Is the checked_out_time also filled? If so, is it the time of the update?

We have tried on several different instances but cannot reproduce it, so it is hard to see what is going on.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

It is reproducible on my system - I just have to download and install the latest update, or install an update from within the Joomla update screen.

Given your questions, I'm sure the answers would generate other questions. So this might be a situation where you want to log into the backend and see for yourself.

Let me know if you want that and I can setup a Super User account and provide the credentials.

David

Support

Hi David,

Please create an account for us to check, if possible also (S)FTP access so we can check the files and see what happens with it. You can enter the details in the Site Details tab which is shown below the textarea.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

I have added the requested information. TY for looking into this.

David

Support

Hello David,
Thank you for posting requested details. For some reason checked_out value is saved as 0 in database whereas default value for this field is set to NULL in RO CSVI code. I was not able to check the database table structure as there is no access to it. Please post access details for DB as well. You can post it in Site Details tab under your reply.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

This will get you into our plesk server and you want to click the database for TorontoCameraClub.com (jtkdb_htlc5t)

https://admin.torontocameraclub.com:8443

User name: rocsvi

Password: _hdea0CNpj8Rmvp44

Author

See the site details, and thank you.
David

Support

Hello David,
Thank you for posting DB details. We are looking into the issue and will get back with an update.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Support

Hello David,
We have fixed this issue and have included it in our release RO CSVI 9.7.0 version coming on Tuesday, April 7th. You can update to this version and check the issue. Let us know how it goes.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

I'll be flying overseas on April 7th. However, I can look at it - most likely - April 8th and I'll report back.

TY so much for tracking down the issues - most appreciated.

David

Support

Hi David,

Todays release is out and should fix the issues. It might be that you still see it after the first install but if you reset the tasks, there should no longer be any checked out values.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

I reset the tasks, then installed the update, and the problem did not show itself.

I'll monitor and wait for the next update to ensure the problem is completely resolved.

Close this ticket if you like and I'll open a new one, if necessary.

Again, thank you for tracking down the issue.

David

This topic is locked. New replies are not possible.

Log in to reply to this topic.