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?
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 |
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
https://drive.google.com/file/d/1CA6Om_dx9jQt8g6EbFT2ZV9grYdQrqC8/vi...
Let me know if you have any problem with this package.
Regards
Nicola
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.
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
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
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...