Search
Other Articles Anywhere questions
Forum

Articles Anywhere 14.1.1 Pro just loads and times out on pages. (Old version did not).

Collin Lafrance's Avatar Collin Lafrance
Hello Peter,

I am trying to upgrade from 14.1.0-dev2679519 PRO to 14.1.1 PRO

The update goes ok but when I go to pages that have the plugin in use, it just loads and loads and loads and times out.

I went back to the above DEV version and works perfectly (loads in a few seconds).

I can't seem to get any error reporting for the issue because it just keeps loading or timing out so not sure what is happening.

Anything I can do to resolve this or any advise?

Thanks.
Peter van Westen's Avatar Peter van Westen ADMIN
Please try the latest development version from:
regularlabs.com/development-releases
Please post a rating at the Joomla! Extensions Directory
Collin Lafrance's Avatar Collin Lafrance
Just tried the DEV version, still loads and loads and times out.

Just went back to the previous version (14.1.0-dev2679519 PRO) and loads ok once again.
Peter van Westen's Avatar Peter van Westen ADMIN
Can you give me (super) admin and (s)ftp access so I can take a look?
And tell me on what url I can see/reproduce the issue.
You can use the 'Confidential information' button in the forum editor to hide sensitive information.
Please post a rating at the Joomla! Extensions Directory
Collin Lafrance's Avatar Collin Lafrance
Posted thanks.

Confidential information:
(hidden)
Peter van Westen's Avatar Peter van Westen ADMIN
Please try the latest development version from:
regularlabs.com/development-releases
Please post a rating at the Joomla! Extensions Directory
Collin Lafrance's Avatar Collin Lafrance
Hi Peter, I tried the new version. This time it loads in around 2 seconds but shows no results, just empty on the page where it should be.

I left the latest dev version on the site.
Peter van Westen's Avatar Peter van Westen ADMIN
Please try the latest development version from:
regularlabs.com/development-releases
Please post a rating at the Joomla! Extensions Directory
Collin Lafrance's Avatar Collin Lafrance
Just installed the latest version and now I get

500 A database error has occurred. Please enable debug mode for more information.

mysqli_sql_exception [500]
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '00?? AND `field`.`name` = 'date' AND `field`.`state` = 1 AND `field`.`context...' at line 4
.../libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:137

132 		$this->connection   = $connection;
133 		$this->query        = $query;
134 
135 		$query = $this->prepareParameterKeyMapping($query);
136 
137 		$this->statement  = $connection->prepare($query);
138 
139 		if (!$this->statement)
140 		{
141 			throw new PrepareStatementFailureException($this->connection->error, $this->connection->errno);
142 		}

I rolled back to the old version for now until you reply back, as it breaks quite a few important pages.
Peter van Westen's Avatar Peter van Westen ADMIN
Can you reproduce this on a test site, so I can do some debugging, without causing issues on your live site?
Please post a rating at the Joomla! Extensions Directory
Collin Lafrance's Avatar Collin Lafrance
You can try on the live site. I just can't leave it in that state indefinitely for hours but now is fine. The next little bit is the best time to do this thing during the day. (I wasn't sure how quickly you'd reply).
Peter van Westen's Avatar Peter van Westen ADMIN
I'll look into this later today.
Please post a rating at the Joomla! Extensions Directory
Collin Lafrance's Avatar Collin Lafrance
Thanks Peter. Feel free to try any dev version or whatnot. All clear on this end for now.

Thank you.
Peter van Westen's Avatar Peter van Westen ADMIN
Sorry for the delay. Currently at a location where internet is really workable. Doing my best to look into this at the moment.
Please post a rating at the Joomla! Extensions Directory
Collin Lafrance's Avatar Collin Lafrance
Thanks Peter. No worries. I appreciate your help.
Peter van Westen's Avatar Peter van Westen ADMIN
Can you check if all is ok with latest dev version?
Please post a rating at the Joomla! Extensions Directory
Collin Lafrance's Avatar Collin Lafrance
Hi , testing it now and the pages with the Articles tag just timeout and don't load successfully. Same as the other versions.
Peter van Westen's Avatar Peter van Westen ADMIN
New try:
regularlabs.com/development-releases
Please post a rating at the Joomla! Extensions Directory
Collin Lafrance's Avatar Collin Lafrance
Hi Peter.

We did some testing, it is showing article results, however we rolled back temporarily to the old version as it eventually became clear that it wasn't showing all the results it should have been. (On the new version, it was showing for Tomorrow only 5 results, when there should have been 9). Went back to the previous version and it immediately showed all 9.

I couldn't figure out the pattern or some similarity of which were showing and which were not.

We can coordinate another day so that I can show you. As the results change throughout the day and from one day to the next, the best opportunities are Friday night to Monday morning since we stop updating the site during that period. I will reach out again on Friday.

Thanks again for your help.
Peter van Westen's Avatar Peter van Westen ADMIN
Preferably, can you make a copy of the site or a new setup where you can reproduce the issue?
Please post a rating at the Joomla! Extensions Directory
You can only post on the extension support forum if you have an active subscription and you log in

Buy a Pro subscription