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

matason’s picture

Status: Active » Closed (won't fix)

Hi 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.

matason’s picture

Status: Closed (won't fix) » Needs work

I 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

A PRIMARY KEY is a unique index where all key columns must be defined as NOT NULL. If they are not explicitly declared as NOT NULL, MySQL declares them so implicitly (and silently).

So in that case Schema should ignore primary key fields that do not have a "not null" set instead of flagging them up.

thriftyngreen’s picture

Hi 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?

thriftyngreen’s picture

Hi 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.

greggles’s picture

Issue summary: View changes
Status: Needs work » Closed (outdated)

The 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?