Categories
View Replies (16)

Resolved 'Cannot use object of type stdClass as array' Error when trying to run google sheet import

  1. atrus
    atrus
  2. RO CSVI
  3. Wednesday, 10 May 2023
  4.  Subscribe via email
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
Attachments (2)
error-std.jpg error-std.jpg
csvi_templates_www.quality-tuning.eu_20230510.xml
0
Accepted Answer
rolandd
rolandd
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?
Attachments (1)
patch_googlesheet_20230618.zip
Kind regards,

RolandD

=========================
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
Responses (16)
atrus
atrus
Accepted Answer Pending Moderation
Just an update, installed 8.8.0 but i have the same issue.

Using PHP 8.0.27
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
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.
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. # 2
atrus
atrus
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
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
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.
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. # 4
atrus
atrus
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
  1. more than a month ago
  2. RO CSVI
  3. # 5
tharuna
tharuna
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.
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. # 6
atrus
atrus
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
  1. more than a month ago
  2. RO CSVI
  3. # 7
tharuna
tharuna
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.
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. # 8
atrus
atrus
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
  1. more than a month ago
  2. RO CSVI
  3. # 9
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Chris,
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
  1. more than a month ago
  2. RO CSVI
  3. # 10
tharuna
tharuna
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?
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. # 11
atrus
atrus
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
  1. more than a month ago
  2. RO CSVI
  3. # 12
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
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
  1. more than a month ago
  2. RO CSVI
  3. # 13
atrus
atrus
Accepted Answer Pending Moderation
Many thanks Roland,

Looks good so far, i'll let you know if i encounter the issue again.

Regards,
Chris
  1. more than a month ago
  2. RO CSVI
  3. # 14
rolandd
rolandd
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.
Kind regards,

RolandD

=========================
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. # 15
  • Page :
  • 1


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