Error with Date in Zone Module

grantbroadcasters2

When I installed v6.0.19 I got error Call to a member function toSql() on string and when doing more research found it was saying the error was on line 1067 of helper.php file ($dateok = $jnow->toSql(true);. So $jnow is already set to a string on line 327 $jnow = $jnow->toSQL(true);.

I made a edit to the code on the lines that would of cause a error so the site would work again. Could you please fix the code correctly please.

alindinca

Hi,

Please let me know if your Joomla version is not J3.x

Kind Regards,
Alin

grantbroadcasters2

alindinca Joomla is running 3.8.10 but that makes no difference to a PHP coding error that exists.

You can't have a call to 'toSQL' on a variable that is already a string.

alindinca

Hi,

Unfortunately I can not replicate this issue on our sites, toSql() function is applied to an Object. I need your site administrator and ftp access in order to debug and find a solution on your site.

Kind Regards,
Alin

grantbroadcasters2

I not sure how this can work on your version and not anywhere else. The code is clearly wrong as I have checked it. it has nothing to do with the version of joomla or or install

Ninja

grantbroadcasters2
Hi
As requested kindly edit fields in the first post and submit site super user login with FTP account details.
So that we can check and help you to fix this issue.
https://cl.ly/3y3R0p24250G

Regards

grantbroadcasters2

Ninja This not installed on any site with FTP access as it does not work and it won't help. I have told you exactly where the error is in the original post, including line numbers.

I have no idea how you can say there is no issues as I just downloaded the version 6.0.19 again and I still get the same error. This is a coding error not a PHP or Joomla version issue.

I can fix the error myself but I am not doing that on 50+ websites and the amount we pay for it it should not have bugs that are simply fixed by your development team.

Ninja

grantbroadcasters2
Hi
We request the details as this issue is not showing our side.
I just install latest version and Joomla is 3.8.10
PHP version : 7.2.9
Kindly give me complete information to replicate this issue or share a site login details where we can test it.

Regards

grantbroadcasters2

Ninja
If not showing on your side the version is different to the version I can download off the website. Send me the version of the helper file you have and I check it against my version as I can upload the php file here.

Ninja

grantbroadcasters2
Hi
Here is the download package
6.0.19 its same package for everyone, If you have the error again provide us the request details. so that we can help you better to fix the issue.

Regards

grantbroadcasters2

Ninja Again I just checked the helper file and it clearly wrong.

Lines 324-328

$timezone = new DateTimeZone( JFactory::getConfig()->get('offset') );
$jnow = new JDate('now');
$jnow->setTimezone($timezone);
$jnow = $jnow->toSQL(true);
$dateok = $jnow;

So '$jnow' is now a string based on these lines and is use as such in the query lines 330-342. Then the next time '$jnow' is used is line 1064 and not reinitialize before this line.

$dateok = $jnow->toSql(true);

This code is trying to use '$jnow' as a joomla datetime object and it currently a string so this causes the 'Call to a member function toSql() on string' error. You can't make a object into a string then try to use it as a object later in the code.

Your testing version must have this error as or you have different code to the released version.

Also I see many people are having the same issue as per https://www.joomlart.com/forums/d/3491-adagency-6-0-19-upload-crashed-website/15

Ninja

grantbroadcasters2
Hi
its weird some of Joomla site is not giving the same error, the latest Joomla has changed the query to tosql and we applied changes in most of the places.
I will share it with development team to add condition on it and release it in the next update.

Regards

alindinca

Hi,

All these changes will be added in the next version.

Kind Regards,
Alin