[Urgent] Page Password 0.9.5 cannot be installed due to an error
Permalink Browser Info Environment
When trying to install Page Password 0.9.5 on ConcreteCMS 8.5.12, the following error occurs and it cannot be used.
An exception occurred while executing 'ALTER TABLE PagePassword CHANGE recursive `recursive` INT DEFAULT NULL': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; for the right syntax to use near 'recursive `recursive` INT DEFAULT NULL' at line 1
Is there any way to improve it?
Thank you.
An exception occurred while executing 'ALTER TABLE PagePassword CHANGE recursive `recursive` INT DEFAULT NULL': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; for the right syntax to use near 'recursive `recursive` INT DEFAULT NULL' at line 1
Is there any way to improve it?
Thank you.
| Type: | Ticket |
|---|---|
| Status: | In Progress |
Thank you for your quick response.
I installed the version you provided but still the same error.
If you go back and reload the browser, it will be installed like the image, but the "Page Password" item will not enter the management screen.
Thank you very much.
I installed the version you provided but still the same error.
If you go back and reload the browser, it will be installed like the image, but the "Page Password" item will not enter the management screen.
Thank you very much.
Hi, I'm trying to debug the error. You had previously installed an other version of Page Password and the upgrade caused the first error?
Can you please try editing the file "db.xml" and change
with
? The error seems related to the database version or software or some other settings of the database.
Thanks in advance
Can you please try editing the file "db.xml" and change
<field name="`recursive`" type="I"> </field>
with
<field name="recursive" type="I"> </field>
? The error seems related to the database version or software or some other settings of the database.
Thanks in advance
I made db.xml as you said, but it doesn't improve.
Thank you.
As described below
<?xml version="1.0"?>
<schema version="0.3">
<table name="PagePassword">
<field name="cID" type="I">
<key />
<unsigned />
</field>
<field name="password ID" type="I">
<key />
<unsigned />
</field>
<field name="recursive" type="I">
</field>
<!--
//TODO: add options..
-->
</table>
<table name="Page Password Passwords">
<field name="password ID" type="I">
<key />
<autoincrement />
<unsigned />
</field>
<field name="value" type="X2">
</field>
</table>
</schema>
Thank you.
As described below
<?xml version="1.0"?>
<schema version="0.3">
<table name="PagePassword">
<field name="cID" type="I">
<key />
<unsigned />
</field>
<field name="password ID" type="I">
<key />
<unsigned />
</field>
<field name="recursive" type="I">
</field>
<!--
//TODO: add options..
-->
</table>
<table name="Page Password Passwords">
<field name="password ID" type="I">
<key />
<autoincrement />
<unsigned />
</field>
<field name="value" type="X2">
</field>
</table>
</schema>
Are you still receiving the error
"'ALTER TABLE PagePassword CHANGE recursive `recursive` INT DEFAULT NULL'" ?
Can you please try, using phpmyadmin, altering the PagePassword table and changing column name from "recursive" to "recurs".
Then it should be possible to use this new package where I changed every occurrence
https://drive.google.com/file/d/1Bm68jM-GHe_NPvo7x6jQKwNN3CcRRbIC/vi...
Thanks
Regards
"'ALTER TABLE PagePassword CHANGE recursive `recursive` INT DEFAULT NULL'" ?
Can you please try, using phpmyadmin, altering the PagePassword table and changing column name from "recursive" to "recurs".
Then it should be possible to use this new package where I changed every occurrence
https://drive.google.com/file/d/1Bm68jM-GHe_NPvo7x6jQKwNN3CcRRbIC/vi...
Thanks
Regards
Many apologies.
After all, it cannot be installed correctly, so reinstall ConreteCMS and try again.
Which files should I install?
Is it due to an addon or theme I'm using?
Thank you for your confirmation.
After all, it cannot be installed correctly, so reinstall ConreteCMS and try again.
Which files should I install?
Is it due to an addon or theme I'm using?
Thank you for your confirmation.
Hi, the error should be related to some specific version of the database. You should try installing the lastest zip linked. Anyway let me know in any moment if you prefer to get the purchase refunded.
Thanks
Regards
Thanks
Regards
https://drive.google.com/file/d/1B3ZJvpANBWoQ6fzuHlLa4cc0TE942UUF/vi...
Thanks in advance
Regards
Nicola