SQL Error 1064 has shutdown website

Permalink Browser Info Environment
mysqli 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")

Not sure what to do. Can I uninstall PagePassword from cPanel? What do I do to get the website back up?

Type: Discussion
Status: In Progress
kdrobnak
View Replies:
jasteele12 replied on at Permalink Reply
jasteele12
The author is probably using an older version of MySQL server that does not have 'recursive' as a reserved keyword. You should contact him about getting a new package ASAP.

Maybe your hosting provider updated their MariaDB server software?

You can try just moving the package directory up one level (i.e. /path/to/your/site/page_password/ instead of /path/to/your/site/packages/page_password/

Of course, you will have no protected pages at that point (you could temporarily change permissions). Probably better than no site at all.

If you are comfortable editing code you could change recursive to `recursive` (note the backticks) in src/Models/ (2 files).

It would be better if the developer changed the field name to recurse or recurziv or something in the database itself...
hanicker replied on at Permalink Reply
hanicker
Hi, sorry for late reply. Your provider probably updated Mysql to MariaDB as Jasteele12 stated. You can download an updated package here:
https://drive.google.com/file/d/1CA6Om_dx9jQt8g6EbFT2ZV9grYdQrqC8/vi...

Let me know if you have any problem with this package.

Regards

Nicola
kdrobnak replied on at Permalink Reply
kdrobnak
Thanks! How do I install this package without access to the dashboard? (I am not a programmer). I'm sure there's a path through cPanel, but I lack that knowledge.
hanicker replied on at Permalink Reply
hanicker
Hi, sure, you can just replace the package (after unzipping it) with the files already present in the packages folder.
If you have any problem you can remove the folder named page_password inside packages/ and upload this new one.

You should be able to do that using the cPanel file manager or through an ftp client.

Thanks
Regards
Nicola

concrete5 Environment Information

Website will not run and cannot access Dashboard.

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:62.0) Gecko/20100101 Firefox/62.0

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.