[Home] [Downloads] [Search] [Help/forum]

Gammon Software Solutions forum

See www.mushclient.com/spam for dealing with forum spam. Please read the MUSHclient FAQ!

[Folder]  Entire forum
-> [Folder]  MUSHclient
. -> [Folder]  Plugins
. . -> [Subject]  Calendar - todo list, events
Home  |  Users  |  Search  |  FAQ
Username:
Register forum user name
Password:
Forgotten password?
(New message)
Subject: Calendar - todo list, events
Name:
Your forum user name.
Register forum user name
Password:
Your forum password.
Forgotten password?
Message:
Message to be posted (in English, please).
Forum codes:
Check this if your message uses 'forum codes' or templates (auto-detected for new posts).
Forum codes Templates

Save this message ...

Subject review (reverse sequence)

Pages: 1 2  3  

Posted by Zhamel   USA  (67 posts)  [Biography] bio
Date Sun 15 Dec 2002 01:32 AM (UTC)  [ quote  ]
Message
Once again you save the day. It's working fine now. Thanks for the calendar.mdb.
[Go to top] top
Posted by Nick Gammon   Australia  (15,726 posts)  [Biography] bio
Date Sun 15 Dec 2002 12:15 AM (UTC)  [ quote  ]
Message

Hmm - sounds like it is related to the known bug with timers in plugins, as the database is created by a timer set up by the plugin in its initialisation.

I have made an empty database, and zipped it up. You should be able to find it at:

http://www.gammon.com.au/mushclient/plugins/calendar.zip (11 Kb).

- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top
Posted by Zhamel   USA  (67 posts)  [Biography] bio
Date Sat 14 Dec 2002 10:28 PM (UTC)  [ quote  ]
Message
Sorry to say the same thing happens. Hmm. Maybe you could put together a little .zip with the .mdb files I need? I'm at a total lost on what to do. Never had this kinda trouble before from any of your stuff.

Oh yeah, great job on an awesome MU* client. Use to be a diehard Portal fan, then I got introduced to your wonder client and been an addict since then.
[Go to top] top
Posted by Nick Gammon   Australia  (15,726 posts)  [Biography] bio
Date Sat 14 Dec 2002 10:30 AM (UTC)  [ quote  ]
Message
Maybe it has got confused and thinks the database is created already. Sounds like it. Try removing the plugin, then going into the plugins "state" directory (subdirectory under plugins) and removing files with "805364a6309ecdf2b4e366cf" in the name. This will be the state file for the calendar plugin.

Then reinstall the plugin, and it should start again from scratch.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top
Posted by Zhamel   USA  (67 posts)  [Biography] bio
Date Sat 14 Dec 2002 04:33 AM (UTC)  [ quote  ]

Amended on Sat 14 Dec 2002 04:34 AM (UTC) by Zhamel

Message
I am having similar problems as Linda. I see nothing printed like this:
Quote:

Plugin Calendar installed.
Database 'C:\Program Files\MUSHclient\worlds\calendar.mdb' created.
Table 'todo' created.
Table 'event' created.
Database is: C:\Program Files\MUSHclient\worlds\calendar.mdb
Nothing to do.
No events.
Type 'calendar:help' for help.


I get this message when I try to enter an event: Could not find file 'C:\Program Files\MUSHclient\worlds\calendar.mdb'.
I have updated my DLLs withe the link on your plugins page and have VBscript Version 5.6. Was wondering if you could enlighten me on what to do?
[Go to top] top
Posted by Shadowfyr   USA  (1,766 posts)  [Biography] bio
Date Sat 16 Nov 2002 11:36 PM (UTC)  [ quote  ]
Message
With respect to ODBC... There are only as far as I know about three ways to install database drivers: 1. with programs like excel, word, etc., 2. Individually by downloading them or 3. as a basic set that comes with the ODBC install. The fact that these prepackaged with the OS as 'part of' ODBC does not guarentee that they are there. The options... Install ODBC even if you don't plan to use it, hope you can find a download of the specific driver or install a big MS product you inho could have found a better option to replace. lol So yes, ODBC has nothing to do with how we are accessing them, but it does have an indirect influence on what types of files you can access.

With regard to the possible version conflicts.. I have seen a few cases where the driver name was employed as the access point, but only for 1-2 types. I am not sure how it works exactly, but it is version independent. The whole implimentation is imho a major mess compared to installing the correct driver with the program that will use it. lol
main {
__if (Schrodinger_Cat is Alive or version >= "XP"){
____if version = "Vista" then Performance /= Number_of_Cores;
____call Functional_Code();}
__else
____call Crash_Windows();}
[Go to top] top
Posted by Nick Gammon   Australia  (15,726 posts)  [Biography] bio
Date Sat 16 Nov 2002 09:59 PM (UTC)  [ quote  ]
Message
Each plugin has an "id" which is near the start of the plugin file. In the case of the Calendar it is "805364a6309ecdf2b4e366cf". Removing the state files with that in the second part of the file name would have been sufficient. In my case the file was called:

dc68d2c6f8b154d243e917bc-805364a6309ecdf2b4e366cf-state.xml

The first part of the name is the world's ID, the second part the plugin's ID.

Thus, this command would have worked (in a DOS window):

del *-805364a6309ecdf2b4e366cf-state.xml

However *why* you had to do that isn't totally clear.

I am glad it is now working, hopefully it will now solve the problems you wanted solved. You can change the number of days in the future showed when you type "events" by modifying the number "14" in about the 3rd line of the plugin.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top
Posted by Linda   Sweden  (164 posts)  [Biography] bio
Date Sat 16 Nov 2002 09:31 PM (UTC)  [ quote  ]
Message
Nope, didn't type setdatabase.

Well, at least it did work eventually and now the created db does work in Access.

I had to uninstall the plugins from all worlds, save the worlds and clean out the state directory, and then it seemed to work. So I guess that removed all traces of the previous install.

And okay, now I have the hang of the dating. I was confused by how it would return my system dating even if I entered in another format, but now its sorted out. It works whether I use dd/mm/yyyy or yyyy/mm/dd to enter.
[Go to top] top
Posted by Nick Gammon   Australia  (15,726 posts)  [Biography] bio
Date Sat 16 Nov 2002 09:17 PM (UTC)  [ quote  ]

Amended on Sat 16 Nov 2002 09:18 PM (UTC) by Nick Gammon

Message
Ugh. OK, I did keep a variable there that stops you creating a database once you typed "setdatabase" but you didn't type that did you?

Anyway, which example are you referring to? All my examples I did "my way" which were dd/mm/yy.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top
Posted by Linda   Sweden  (164 posts)  [Biography] bio
Date Sat 16 Nov 2002 09:10 PM (UTC)  [ quote  ]

Amended on Sat 16 Nov 2002 09:11 PM (UTC) by Linda

Message
Ah, I thought I had to stick to the date format listed in the example.

But I can't open it in Access yet because right now I am unable to get the database created. I've installed and reinstalled the plugin a few times, in different worlds, but no luck.

In all worlds except one nothing happens (although it does install, because if I type events it reports it can't find the db file), and in one world it is reported as installed, but it also reports it can't find the db file.

Update: Okay, deleting the files in the 'state' directory allowed me to reinstall the plugin and get the db created.
[Go to top] top
Posted by Nick Gammon   Australia  (15,726 posts)  [Biography] bio
Date Sat 16 Nov 2002 08:58 PM (UTC)  [ quote  ]

Amended on Sat 16 Nov 2002 08:59 PM (UTC) by Nick Gammon

Message
I am successfully entering events using dd/mm/yy, eg.


event boxing day AT 26/12
futureevents

Event 'boxing day' AT '26/12' added to the database

--------Future events--------

#2: water garden AT 20/11/02
#1: Christmas AT 25/12/02
#4: boxing day AT 26/12/02


As for the install problem, there was a recently-reported problem that timers in plugins are not working properly. Perhaps this is related to that? I saw the same thing myself when I opened the world from scratch.

However once the database is created the problem should go away (for you) for good.

Can you open it from Access now?
- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top
Posted by Linda   Sweden  (164 posts)  [Biography] bio
Date Sat 16 Nov 2002 08:47 PM (UTC)  [ quote  ]
Message
And yes, the discrepancy between the worlds remains: only the world with pueblo/mxp enabled reports back anything at all when the plugin is installed.
[Go to top] top
Posted by Linda   Sweden  (164 posts)  [Biography] bio
Date Sat 16 Nov 2002 08:44 PM (UTC)  [ quote  ]
Message
1) The date format: It appears to display properly (according to my system settings), I was just confused by the fact that it has to be entered as mm/dd/yyyy

2) I deleted the old db, downloaded the updated plugin and changed the engine to 4. However, upon reinstalling it I once again get the error of it not creating the db and then saying the file doesn't exist. Maybe the plugin should include a 'createdatabase' command?

[Go to top] top
Posted by Nick Gammon   Australia  (15,726 posts)  [Biography] bio
Date Sat 16 Nov 2002 08:26 PM (UTC)  [ quote  ]
Message
Quote:

This is what make me nervous about using Microsoft.Jet.OLEDB.4.0 as the provider field without first having some why to make sure that v4.0 is installed and more importantly, that the Access driver is installed.


It makes me nervous too, but the checks in the plugin to see if "CreateObject" succeeds should partly guarantee that the drivers are there.

Also, distributing the database drivers is both an overhead, and possibly not legal, however I have put pointers to the pages where they can be found on the plugins page.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top
Posted by Nick Gammon   Australia  (15,726 posts)  [Biography] bio
Date Sat 16 Nov 2002 08:23 PM (UTC)  [ quote  ]
Message
Quote:

Anyhow, it did work when I installed it from one other world ... although isn't the db created supposed to be Access compatible? I can't seem to open it, at least.


Yes it certainly is, however I also seem to recall from earlier discussions that there was an incompatibility between the engine type 5 and Access 97. Ah, the joys of Microsoft products!

Linda, if you open the plugin (you can do this from the Plugins menu by selecting the plugin and clicking Edit) and then change the line which has "Engine Type=5" to "Engine Type=4", and then save and reinstall, you should get an Access 97 database. See this forum post, last entry on the first page:


http://www.gammon.com.au/forum/bbshowpost.php?bbsubject_id=1552


However you will then need to delete your database file and let it get recreated as it won't be backwards compatible, ie. the damage is done once it is created.

It is probably worth it in your case to get the earlier engine, because then you can just open the database in Access and play around with it.


- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top

The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).

To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.

13,171 views.

This is page 1, subject is 3 pages long: 1 2  3  [Next page]

[Reply to this subject]  Reply to this subject   [New subject]  Start a new subject   [Refresh] Refresh page

Go to topic:           Search the forum

[Go to top] top

[Home]

Written by Nick Gammon - 5K

Comments to: Gammon Software support
[RH click to get RSS URL] Forum RSS feed ( http://www.gammon.com.au/rss/forum.xml )

[Best viewed with any browser - 2K]    [Internet Contents Rating Association (ICRA) - 2K]    [Web site powered by FutureQuest.Net]