Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
I am getting some mismatched errors for this module
they are as follows. I am not an SQL person. How do I go about fixing these?
Thanks
* opengraph_meta.description is type text and may not have a default value
* opengraph_meta.optional is type text and may not have a default value
* blogapi_files.fid is part of the primary key but is not specified to be 'not null'.
Comments
Comment #1
matason CreditAttribution: matason commentedHi thiftyngreen, MySQL text and blob fields cannot have default values so opengraph_meta.install could do with lines 58 and 75 removing.
Slightly different issue with blogapi_files, primary key fields should be specified to be NOT NULL so that needs adding in blogapi_files.install
I'll raise issues and patches with the respective projects.
Comment #2
matason CreditAttribution: matason commentedI investigated a little further on the blogapi_files schema issue, I think Schema is at fault here, a quote from http://dev.mysql.com/doc/refman/5.1/en/create-table.html
So in that case Schema should ignore primary key fields that do not have a "not null" set instead of flagging them up.
Comment #3
thriftyngreen CreditAttribution: thriftyngreen commentedHi matason thanks for getting back to me. I checked out that file there are several default values in it other than the lines you mentioned. I am a PHP novice will the module function if i remove these? Also there are about 10 mismatched tables and so forth identified in the Schema admin panel. There are a lot of issues. Should I be worried about these?
Comment #4
thriftyngreen CreditAttribution: thriftyngreen commentedHi again I really want to fix this so it works properly and I am not worried it is going to bring my site down. I have 10 tables that are different in the database than in the schema. I do not know exactly what this means or how to fix it. Is there a resource I could follow to do so? And I still need clarification on the Open Graph Module and its default values. There are still a number of default values in there. Aside from the 2 you pointed out so that puzzled me a bit. I did not want to just take them all out. Had no idea what that would do. Thanks
Here are my errors I was able to fix the open graph but after adding what asked of you to blog api I am getting this.
*
blogapi_files
o indexes not null: missing in database * - (if I can get instructions here i will fix thanks)
tried to fix this one but could not find where to put this without getting parse errors.
then there are several more.
Comment #5
gregglesThe 6.x branch of this module is no longer supported.
If this issue is still present in the 7.x version can you please reopen it and adjust the version?