Monitor Reply

Support

How to obtain copy of latest 5.6 version

Permalink Browser Info Environment January 25, 2019 at 3:07 PM

Hi,

I have taken over an older site running version 1.1.3 of your add on.

Moving to our server gives a mysql error (below).

The client doesn't have access to the original licences and I'd normally purchase another licence but this is no longer possible through the marketplace.

Can you provide the latest 5.6 version of this addon? (I'm happy to pay for it).

Thanks.

mysqlt error: [1064: 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 'recursive=1' at line 1] in EXECUTE("select COUNT(*) as c from PagePassword where cID='1' UNION select COUNT(*) as c from PagePassword where recursive=1")

Type:	Pre-Sale
Status:	In Progress

hanicker replied on Jan 28, 2019 at 8:45 pm Permalink Reply

Hi, sorry for this really late reply. Can you please try downloading
https://drive.google.com/open?id=1CA6Om_dx9jQt8g6EbFT2ZV9grYdQrqC8...

Thanks
Regards

katalysis replied on Jan 29, 2019 at 7:48 am Permalink Reply

HI Hannicker,

This is a 5.7 version?

I need something that will work on 5.6. The version on the site is 1.3.1 - I'm assuming there is a later one?

Thanks

hanicker replied on Jan 29, 2019 at 11:31 pm Permalink Reply

Hi, sorry I read too fast. I added the fix to support MariaDB on the old 5.6 package, should work now. You can download it at
https://drive.google.com/file/d/14CFWdPp39ChY_-PPvRtW9uergnUXTmD1/vi...

Thanks
Regards

katalysis replied on Jan 30, 2019 at 7:02 am Permalink Reply

@hannicker, this is still a 5.7 package...

namespace Concrete\Package\PagePassword;
use Events;
use Concrete\Package\PagePassword\Src\Models\PagePasswordModel;
use View;
use Core;
use SinglePage;
use Concrete\Core\Html\Service\Html;
defined('C5_EXECUTE') or die(_("Access Denied."));
class Controller extends \Concrete\Core\Package\Package {
   protected $pkgHandle = 'page_password';
   protected $appVersionRequired = '5.7.0';
   protected $pkgVersion = '2.0.0';
   public function getPackageHandle(){
      return 'page_password';
   }

Can you provide the last 5.6 version?

Thanks.

hanicker replied on Jan 30, 2019 at 9:09 pm Permalink Reply

Sorry I probably uploaded the wrong file.
Just checked last version on same link and it's
protected $appVersionRequired = '5.5.0';

Thanks
Regards

katalysis replied on Jan 30, 2019 at 9:47 pm Permalink Reply

So this is now version 1.1.4 and it still gives the mysql error with MariaDb:

mysqlt error: [1064: 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 'recursive=1' at line 1] in EXECUTE("select COUNT(*) as c from PagePassword where cID='1' UNION select COUNT(*) as c from PagePassword where recursive=1")

The 5.6 marketplace page says the latest version is 2.0 - does this work with Marai DB and if so, is it possible to get a copy?

Thanks.

Glyn.

hanicker replied on Jan 30, 2019 at 9:55 pm Permalink Reply

That version on the marketplace is for 5.7+ and does not support recent versions of MariaDB anyway.

Can you please try editing file
models\PagePassword.php

line 64
replace

recursive

with

`recursive`

(with ` )

Thanks
Regards

katalysis replied on Jan 31, 2019 at 7:19 am Permalink Reply

That works - thank you

Page Password

Support

How to obtain copy of latest 5.6 version

Issue Reply

concrete5 Environment Information

Browser User-Agent String

Hide Post Content

Request Refund

Code

Delete Post