AbleDesign

[Ellie]

OK......I admit I'm brand new at php and mysql. I searched the forum but I can't seem to find how to add the mini calendar to other pages on my site.

Any help would be greatly appreciated!!

Thanks

[Dan]

Hi Ellie,

You need to be using the v2.10 beta to include the mini month calendar elsewhere in your site, otherwise some script modifications are required.

Take a look at month_mini_include.php. You will need to set $calendar_path according to your installed directory. The rest should be ok. Then, simply include month_mini_include.php in any file where you want the mini calendar to appear, i.e.:

include("/home/user/www/calendar/month_mini_include.php");

Cheers,
Dan

[Ellie]

OK........I am not using the Beta version...but I did download.
So.....I guess that means I should upgrade to it.
Apparently I am the only brand new newbie for php and mysql!! I searched again for info on how to upgrade...and I am coming up short!!

I see in the upgrade.txt...there is info to make changes to MySql.....

Here are my questions...(if you feel I should know this things...then please point me in the best direction to find how to)

1) I see there is a upgrade.php - how do I use that?

2) Should I first be making the changes to MySql...then upload new files to my server?

3) This is a bit confusing....if I upload new files....I just lost all my original configurations!

4) What is the sequence to do this upgrade???

Thanks,
Ellie

[Dan]

Hi Ellie,

Don't worry, there are lots of people unfamiliar with any given aspect of web life. Once you've been around PHP and MySQL for a bit, I think you'll start to feel more comfortable. It just has a learning curve like anything else.

1) I'm not sure what exactly you are looking at. There is an upgrade_2_0.php which is for automatically upgrading a database to the v2.0 structure (which you don't need to do) and an upgrade.txt which contains instructions for making the individual database changes of the upgrade.

upgrade.txt contains database commands that can be given directly to MySQL through phpMyAdmin or whatever database administration program you have chosen to use. Just copy the upgrade commands into the SQL monitor (the text input box of your database admin program) and submit the form, and everything should be done for you.

2 & 4) It doesn't really matter what order you make the changes in, so long as you are fairly quick about it. If you upgrade the files first, then they will be accessing incorrect (old) database structures. If you upgrade the database first, then the old files may not recognize important database info. Same result either way.

I generally prefer to update the database first to ensure data integrity is maintained (always good to make a backup of important database tables, which can be done through the database admin program by copying the table structure/data to a new table name), but if you're on a slower FTP connection, you may want to upload the files first so as to have less dead time in between upgrade steps.

3) The only file you need to keep your settings in is config.php, which is why it is recommended to make a backup of that file before any upgrades. You can name it as something like config_bu.php and copy the relevant settings from it over to config.php before uploading.

Cheers,
Dan

[Dan]

p.s. You may also want to make a backup of variables.php so as to not have to set all your options from memory.

Cheers,
Dan

[connieM]

OK Dan, well I, too, have a glitch getting the mini calendar to show on our homepage
http://www.chemainus.com
I think I have not done the $calendar_path correctly. Since nothing shows, including no error messages, I thought maybe I forgot to upload some file *G*, but I don't think so. I am sure this "must" be simple but is a stumbling block for this non-tech person.
help... connieM

[Dan]

Hi Connie,

Could you show me what you have for the $calendar_path setting in month_mini_include.php?

Cheers,
Dan

[connieM]

Hi Dan:
I tried a number of things, the last of which is this:
$calendar_path = "home/connemara/www/calendar";
connie

[Dan]

Try changing that to:

$calendar_path = "/home/connemara/www/calendar";

The difference being the forward slash in front of 'home'. Without that leading slash, the path is seen as relative to the current directory instead of a full server path.

Cheers,
Dan

[connieM]

well, uh this might be called a "blonde" moment (I'ss say that because I'm not) Now that I have correctly uploaded the file as .php - there's the 'duh', I now get the error message, again a problem with the database connection. . . so here's the message:

Warning: Unable to access ../calendar/includes/dbx.inc in /home/connemara/www/calendar/config.php on line 394

Warning: Failed opening '../calendar/includes/dbx.inc' for inclusion (include_path='.:/usr/local/lib/php') in /home/connemara/www/calendar/config.php on line 394
Unable to locate the database at this time.
?? Tell me it's not a loose screw.
*With these technical "blocks", my paints are starting to look better. . . those paintbrushes never give me this much trouble.*
connieM

[Dan]

I think the problem is that we had you move the 'includes' folder to solve a previous problem and you probably now have the $dbConnect (in config.php) path as a relative one? Changing it to the following should address that:

$dbConnect = "/home/connemara/www/calendar/includes/dbx.inc";

Cheers,
Dan

[connieM]

Yes! Thank you Dan for your patience. It works.
connieM

[Dan]

Excellent!

Cheers,
Dan

[Sanguinarius]

[Dan]