04/25/2006 Module File
* Support for User Auth Check
* Highly configurable Calendar Style set of options added to
control month name, year format etc.
* Added control on Header - By default is <h3> but can be configured

04/24/2006 Component
* Fix XML file to include toolbar files in Admin interface


04/20/2006
Component 2.4.0 Beta has following features
* Component Listed in Admin Component Menu
* Support for Configurable Parameter from Admin tool bar
* Cleanup of BlogSidebar component backend

Module BlogCal 1.6 Beta has following additional features
* Included support for User Access Check before creating calendar links
* Replace DAY with DAYOFMONTH to support older MySQL versions.

Installed the files above and everityng goes OK, but there is no menu item in components menu that refers to blogsidebar and when i publish the module I get this:

Invalid query: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( created ) AS created_day, created, id, sectionid, YEAR(create Whole query: SELECT DAY( created ) AS created_day, created, id, sectionid, YEAR(created) AS created_year, MONTH(created) AS created_month FROM #__content GROUP BY created_year DESC, created_month DESC, created_day DESC

Please Advise.

Installed the files above and everityng goes OK, but there is no menu item in components menu that refers to blogsidebar and when i publish the module I get this:

Invalid query: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( created ) AS created_day, created, id, sectionid, YEAR(create Whole query: SELECT DAY( created ) AS created_day, created, id, sectionid, YEAR(created) AS created_year, MONTH(created) AS created_month FROM #__content GROUP BY created_year DESC, created_month DESC, created_day DESC

Please Advise.

yes, BlogSidebar doesn't have menu item, so it is okay.

Regarding, query issue, What I see that it is not able to drive MySQL table name and that is kind of funny. Can you post the URL here so that I can see the issue?

Also do you have access to MySQL database/server which you may have on your site? See if you can get prefix name for content table.

www.mgscreativa.com.ar/content1

prefix is "jos_"

www.mgscreativa.com.ar/content1

prefix is "jos_"

Hi Razor7,

this is because u have not written any content on the site yet. Since returning value is null, it is assumed that query is returning with error. I hope, I have guessed correctly. Can you try one of the following?
1. Add a content and see if it still returns error...
OR
2. Go to your joomla installation directory/modules. Open mod_blogcal.php and comment out lines 202 to 206 ( shown below).
// if (!$catlist) {
// $message = 'Invalid query: ' . mysql_error() . "\n";
// $message .= 'Whole query: ' . $query;
// die($message);
// }

Let me know once you have tried it.

yes i have contents...i have installed it into 2 installation...a localhost in my computer (via apache2triad) and in my test site. I have unpublished your mod and the site is back again