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.

QUOTE:
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.

http://www.mgscreativa.com.ar/content1

prefix is "jos_"

QUOTE:
http://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

QUOTE:
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

If you can try #2, i.e. commenting it, u will see atleast calendar but some functionality will be missing.

I tried running MYSQL query and it runs perfectly... probably it is because of MysQL version issue. Anyway lets comment offensive code in mod_blogcal.php. Please let me know MySQL version as well.

my MySql version 4.0.26-standard

I get this
Warning: Invalid argument supplied for foreach() in /home/mc000197/public_html/content1/modules/mod_blogcal.php on line 209


And there is no content link in the calendar...no even for the starndar Joomla demo content

QUOTE:
my MySql version 4.0.26-standard

I get this
Warning: Invalid argument supplied for foreach() in /home/mc000197/public_html/content1/modules/mod_blogcal.php on line 209


And there is no content link in the calendar...no even for the starndar Joomla demo content

Above is expected.

Problem is with your MySQL version. DAY () function is not supported in 4.0.26.
--->
DAY() is a synonym for DAYOFMONTH(). It is available as of MySQL 4.1.1.
--->

Uncomment lines 202 - 206 in the file. Lets keep die function commented. And replace DAY with DAYOFMONTH in line 193. Interesting!!

Also if you can give me temporary access to your file, I can try it out quickly. PM me with details, if you want me to look at it.

I maded the change of DAY to DAYOFMONTH, the errors dissapeared but the calendar stills does not show nothing, I have setted the section ID to 1.

I have attached the modified file.