LG Better Meta 1.7.x - Now with sitemap meta and generator! - Official Support Thread

You might also want to check out: http://leevigraham.com/cms-customisation/expressionengine/lg-better-meta/#outputting-entry-meta-data

When I select it from the Plugin Manager i get this error “Unable to load the following plugin: lg_better_meta_php.php”

I’m getting the same error, and the plugin file is definitely named lg_better_meta_pi.php. Have deleted and reuploaded all files and I continue to get the same error.

Ok I have finally tracked down the “Unable to load the following plugin: lg_better_meta_php.php” error. Expressionengine is ding some replacements on the filename to build the query string. This is causing the error.

For those of you who are getting this error don’t worry. The error is not affecting your public site or CP, LG Better Meta will still run fine. There is no need to uninstall or deactivate the extension.

The CP page you are trying to view just had basic plugin details and a link to the documentation.

I’ll fix this in the next release of the extension by changing the plugin name. Unfortunately that will also mean some small template changes.

Thanks, Leevi. It’s a great add-on!

Leevi,

I am getting the “Unable to load the following plugin: lg_better_meta_php.php” error, though after your explanation, I’m not worries about it.

However, when I enable the {exp:lg_better_meta_pi:template} tag, I get this MySQL error on all pages except my home page:

MySQL ERROR:

Error Number: 1054

Description: Unknown column ‘exp_lg_better_meta.include_in_sitemap’ in ‘field list’

Query: SELECT exp_members.screen_name as author, exp_weblog_titles.entry_id as entry_id, exp_weblog_titles.weblog_id as weblog_id, exp_weblog_titles.title as title, exp_weblog_titles.url_title as url_title, exp_weblog_titles.entry_date as date_created, exp_weblog_titles.edit_date as date_modified, exp_weblog_titles.expiration_date as date_valid, exp_lg_better_meta.title as meta_title, exp_lg_better_meta.description as description, exp_lg_better_meta.keywords as keywords, exp_lg_better_meta.publisher as publisher, exp_lg_better_meta.author as meta_author, exp_lg_better_meta.rights as rights, exp_lg_better_meta.index as robots_index, exp_lg_better_meta.follow as robots_follow, exp_lg_better_meta.archive as robots_archive, exp_lg_better_meta.include_in_sitemap as include_in_sitemap, exp_lg_better_meta.change_frequency as change_frequency, exp_lg_better_meta.priority as priority FROM exp_weblog_titles INNER JOIN exp_members ON exp_weblog_titles.author_id = exp_members.member_id LEFT JOIN exp_lg_better_meta ON exp_weblog_titles.entry_id = exp_lg_better_meta.entry_id WHERE exp_weblog_titles.url_title = ‘philosophy’ LIMIT 1

I upgraded from version 1.4, and probably get the steps wrong.

Please advise, thanks

Hmm… looks like something went wrong with the upgrade.

This should fix it:

Run this SQL statement:

ALTER TABLE exp_lg_better_meta ADD `priority` VARCHAR( 5 ) NOT NULL , ADD `change_frequency` VARCHAR( 50 ) NOT NULL , ADD `include_in_sitemap` VARCHAR( 1 ) NOT NULL

If that doesn’t work:

1. Backup your db
2. Paste your extension settings into a text document
3. Deactivate the extension
4. Re-activate the module
5. Re-entrer settings.

This should re-install the extension using the new settings and creating the correct database tables without destroying your meta data.

I just had to run that SQL statement myself tonight as well. Took me a long time to find that answer as the previous post hadn’t been written yet. It was elsewhere in this thread, though.

Sorry for any inconvenience. When I get a sec I’ll find out why that code isn’t running and add it to the update method.

Don’t take my EE developer of the year award away! 😊

Wouldn’t think of it! The fact that you responded to my post only 2 minutes later shows me that my choice was justified.

Leevi:

Fixed!! Thanks for the quick response.

Version 1.7.1 of LG Better Meta has been released which addresses the curly quotes issue.

I have also tweaked the styling of the tab and added quick save, revision and preview support.

Replace the old files and you’re done.

I just bought a couple of licenses for two sites I am working on and had zero problems getting it up and running but I have a question regarding sitemaps.

I created a template within my “site” template group which contains my home page and called it sitemap.xml. Do I then go into the webmaster tools to specify the location of that sitemap? I just wasnt sure how the bots know where to find it.

Do you recommend a sitemap for each blog or can you pipe all your blogs into one xml sitemap?

I realize these are super basics and appreciate your time. I have 2 more sites that I plan to add do you expect to do any volume licensing?

Thanks

You really have a couple of options for sitemap generation

1. Add multiple weblogs in the weblog paramater
2. Add multiple weblog:entries tags in a single template
3. Create multiple templates that only display a single weblog and use an XML sitemap index file.

If you have lots of entries go with option 3 else use option 1.

There are plans for volume licensing in the works but they are only at a very early stage.

Hello, I read that there is a free version but I can’t seem to find it on Leevi’s site, I only see the commercial version, and no link to the free one.

Is it still available?

thanks!

The free version was discontinued at version 1.4 in favour of adding more features to the pro version.