Very often when i try to run a google sheet template i get the attached error. Tried with 8.7.0 and 8.6.0.
See below some more info. Attaching the template also.
https://www.quality-tuning.eu:443/administrator/index.php?option=com_csvi&task=importsource.source&runId=384179
Error message data:
1 Cannot use object of type stdClass as array in file: /home/***/public_html/administrator/components/com_csvi/helper/file/import/googlesheet.php line: 120
timestamp: 2023-05-10T13:19:19+00:00
To disable these emails proceed to your Extensions -> Plug-in manager -> disable plg_system_fatal_catcher
It is very important that you fix all php fatal errors on your site. Resend this email to your developer.
Backtrace:
/home/***/public_html/administrator/components/com_csvi/helper/file/import/googlesheet.php:120
#0 /home/***/public_html/administrator/components/com_csvi/models/default.php(396): CsviHelperFileImportGooglesheet->__construct()
#1 /home/***/public_html/administrator/components/com_csvi/models/default.php(292): CsviModelDefault->loadImportFile()
#2 /home/***/public_html/administrator/components/com_csvi/controllers/importsource.php(44): CsviModelDefault->initialiseImport()
#3 /home/***/public_html/libraries/src/MVC/Controller/BaseController.php(702): CsviControllerImportsource->source()
#4 /home/***/public_html/administrator/components/com_csvi/csvi.php(142): Joomla\CMS\MVC\Controller\BaseController->execute()
#5 /home/***/public_html/libraries/src/Component/ComponentHelper.php(402): require_once('...')
#6 /home/***/public_html/libraries/src/Component/ComponentHelper.php(377): Joomla\CMS\Component\ComponentHelper::executeComponent()
#7 /home/***/public_html/libraries/src/Application/AdministratorApplication.php(101): Joomla\CMS\Component\ComponentHelper::renderComponent()
#8 /home/***/public_html/libraries/src/Application/AdministratorApplication.php(159): Joomla\CMS\Application\AdministratorApplication->dispatch()
#9 /home/***/public_html/libraries/src/Application/CMSApplication.php(225): Joomla\CMS\Application\AdministratorApplication->doExecute()
#10 /home/***/public_html/administrator/index.php(51): Joomla\CMS\Application\CMSApplication->execute()
#11 {main}
Kind Regards,
Chris
- atrus
- RO CSVI
- Wednesday, 10 May 2023
- Subscribe via email
Accepted Answer
Accepted Answer
Pending Moderation
Hey Chris,
I have made a patch that should resolve the issue you see. Can you please apply the attached patch and let us know if you still run into the error?
I have made a patch that should resolve the issue you see. Can you please apply the attached patch and let us know if you still run into the error?
Attachments (1)
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- more than a month ago
- RO CSVI
- # Permalink
Accepted Answer
Pending Moderation
Just an update, installed 8.8.0 but i have the same issue.
Using PHP 8.0.27
Using PHP 8.0.27
Accepted Answer
Pending Moderation
Hello Chris,
Looks like this was an old template with old way of saving settings. I resaved the template on your site and now the template works. Please run the import and check.
Looks like this was an old template with old way of saving settings. I resaved the template on your site and now the template works. Please run the import and check.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Thanks Tharuna,
I was also saving the template and run it on 8.6.0 and many times it worked, but then sometimes it didn't.
Let'see if this is fixed with 8.8.0; will let you know.
Regards,
Chris
I was also saving the template and run it on 8.6.0 and many times it worked, but then sometimes it didn't.
Let'see if this is fixed with 8.8.0; will let you know.
Regards,
Chris
Accepted Answer
Pending Moderation
Hello Chris,
With RO CSVI 8.8.0 there are few changes we did with Google API settings so I am hoping this issue will be solved with resaving of template in RO CSVI 8.8.0 version.
Let us know on how it goes.
With RO CSVI 8.8.0 there are few changes we did with Google API settings so I am hoping this issue will be solved with resaving of template in RO CSVI 8.8.0 version.
Let us know on how it goes.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Tharuna,
Got the error again when trying to run an already saved template, (it's called Advanced Report Cost Prices if you want to take a look). I clicked Run from the templates list.
Rgrds,
Chris
Got the error again when trying to run an already saved template, (it's called Advanced Report Cost Prices if you want to take a look). I clicked Run from the templates list.
Rgrds,
Chris
Accepted Answer
Pending Moderation
Hello Chris,
I did nothing but resaved the Advanced Report Cost Prices template on your site and now the Run button works without error
Please check and let me know.
I did nothing but resaved the Advanced Report Cost Prices template on your site and now the Run button works without error

Please check and let me know.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Tharuna,
Unfortunately the problem still exists, very often i have to enter the templates and save them in order to work. But after a while the same thing happens again. It really puzzles me, would appreciate your further insight.
Regards,
Chris
Unfortunately the problem still exists, very often i have to enter the templates and save them in order to work. But after a while the same thing happens again. It really puzzles me, would appreciate your further insight.
Regards,
Chris
Accepted Answer
Pending Moderation
Hello Chris,
You get these errors with same templates? If they are old templates please resave them and check. The format of saving access token in database has been changed a little with latest RO CSVI version. There can be a conflict if the template has old format of access token.
You get these errors with same templates? If they are old templates please resave them and check. The format of saving access token in database has been changed a little with latest RO CSVI version. There can be a conflict if the template has old format of access token.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello Tharuna,
Yes, saving works most of the times, but it's not enough. After some time the error comes again in the same templates.
Regards,
Chris
Yes, saving works most of the times, but it's not enough. After some time the error comes again in the same templates.
Regards,
Chris
Accepted Answer
Pending Moderation
Hello Chris,
I think I know how to reproduce the error. Will check more and get back to you.
I think I know how to reproduce the error. Will check more and get back to you.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello Chris,
The error seems to be very random. I saw error twice with google sheets template and thought it was something to do with new templates but it does not appear all the time. I realised saving template does not solve the error. Is there a situation you know which can help me reproduce this error?
The error seems to be very random. I saw error twice with google sheets template and thought it was something to do with new templates but it does not appear all the time. I realised saving template does not solve the error. Is there a situation you know which can help me reproduce this error?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Tharuna,
Try some more templates which include 'Google' in their titles. Also try to run the template from the templates' list, not from within the template itself.
Rgrds,
Chris
Try some more templates which include 'Google' in their titles. Also try to run the template from the templates' list, not from within the template itself.
Rgrds,
Chris
Accepted Answer
Pending Moderation
Hello,
I don't think it has to do anything with title. It is google access token setting causing the error.
Yes the error appears only with Run button template list page. Still the error does not appear all the time and is random. That is making it difficult to find the cause and fix it.
Try some more templates which include 'Google' in their titles.
I don't think it has to do anything with title. It is google access token setting causing the error.
Also try to run the template from the templates' list, not from within the template itself.
Yes the error appears only with Run button template list page. Still the error does not appear all the time and is random. That is making it difficult to find the cause and fix it.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Many thanks Roland,
Looks good so far, i'll let you know if i encounter the issue again.
Regards,
Chris
Looks good so far, i'll let you know if i encounter the issue again.
Regards,
Chris
Accepted Answer
Pending Moderation
Hello Chris,
Glad to hear that. I will mark the topic as resolved but leave it open for a bit longer just in case you run into it again, you can respond here.
Glad to hear that. I will mark the topic as resolved but leave it open for a bit longer just in case you run into it again, you can respond here.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »