SQL error when installing
Permalink Browser Info Environment
Hello - when I was installing this add-in I saw this SQL error. Any ideas how to get around this? Package is not functionality currently:
An exception occurred while executing 'INSERT INTO atMetaDevodaSeoSettings (akDefaultValue, akID) VALUES (?, ?)' with params ["", 43]: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'akDefaultValue' at row 1
An exception occurred while executing 'INSERT INTO atMetaDevodaSeoSettings (akDefaultValue, akID) VALUES (?, ?)' with params ["", 43]: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'akDefaultValue' at row 1
| Type: | Ticket |
|---|---|
| Status: | Archived |
Weird - I put my c5 version in the ticket but it doesn't look like it came through. Here is version info for both:
# concrete5 Version
Core Version - 8.3.2
Version Installed - 8.3.2
Database Version - 20180122213656
# concrete5 Packages
Devoda SEO (1.5.2)
# concrete5 Version
Core Version - 8.3.2
Version Installed - 8.3.2
Database Version - 20180122213656
# concrete5 Packages
Devoda SEO (1.5.2)
Hi there,
Can you go to this file:
packages/devoda_seo/config/install/base/attributes.xml:29
And change this line (line number 27):
Into this:
Afterwards make sure the Add-On is uninstalled and remove the "atMetaDevodaSeoSettings" database table.
I'm not sure if this fixes it, since I couldn't reproduce the error. It does however do something that may be needed for your situation, but I want to know for sure this is the fix for that. Let me know if you are able to do all this!
Kind regards,
Ramon
Can you go to this file:
packages/devoda_seo/config/install/base/attributes.xml:29
And change this line (line number 27):
<attributekey handle="meta_devoda_seo" name="Devoda SEO" package="devoda_seo" searchable="0" indexed="0" type="meta_devoda_seo" category="collection"> <type default_value=""/> </attributekey>
Into this:
<attributekey handle="meta_devoda_seo" name="Devoda SEO" package="devoda_seo" searchable="0" indexed="0" type="meta_devoda_seo" category="collection"> <type default_value="0"/> </attributekey>
Afterwards make sure the Add-On is uninstalled and remove the "atMetaDevodaSeoSettings" database table.
I'm not sure if this fixes it, since I couldn't reproduce the error. It does however do something that may be needed for your situation, but I want to know for sure this is the fix for that. Let me know if you are able to do all this!
Kind regards,
Ramon
Attention: Since there has been no activity on this issue for two weeks, this issue has been automatically archived.
To re-open this issue, reply to this message.
To re-open this issue, reply to this message.
Attention: Since there has been no activity on this issue for two weeks, this issue has been automatically archived.
To re-open this issue, reply to this message.
To re-open this issue, reply to this message.
Attention: Since there has been no activity on this issue for two weeks, this issue has been automatically archived.
To re-open this issue, reply to this message.
To re-open this issue, reply to this message.
Attention: Since there has been no activity on this issue for two weeks, this issue has been automatically archived.
To re-open this issue, reply to this message.
To re-open this issue, reply to this message.
Attention: Since there has been no activity on this issue for two weeks, this issue has been automatically archived.
To re-open this issue, reply to this message.
To re-open this issue, reply to this message.
Kind regards,
Ramon