| Author |
Message |
SnyperBob
Joined: 22 Aug 2007
Posts: 627
Location: Illinois |
|
 FIXED 0053: Type mismatch in Actions tab |
 |
Hey Vaughn,
After reading your last few posts, I realized that you may not have seen my problem that I posted in other threads. Basically I'm having problems creating locations on the objects tab. I tried a few different ways and the outcome always is the same. After creating the location, I get a type mismatch error when I access the Actions tab.
Because of this problem, I have no way of proceeding until I can get this issue sorted out. Please help, it's getting to be a pain that I have to reload my database everytime to get rid of the error. Essentially I can't enter in my stuff because this error wipes it all out:
Last edited by SnyperBob on Tue Jan 15, 2008 1:09 am; edited 1 time in total |
|
| Thu Jan 10, 2008 6:35 pm |
    |
 |
CribKeeper
Site Admin
Joined: 09 Aug 2007
Posts: 636
Location: Overland Park, KS |
|
| |
|
It has already been fixed, it is an old know issue that I fixed for Humanzee a month ago. I explained I was getting his exe's for you.
When you add a Location, it creates an action and it is setting Action_Enabled to 'Y', Action_Enabled need to be set to 1, not 'Y'. I tried to send you the patched exe that Humanzee is running but your gmail rejected the email. So I am attaching them to this post. You do NOT have to reload the DB for this.
The exe fixes the creation of a new action when you add a location.
To fix existing Actions, go into MySQL query browser and execute this SQL:
UPDATE Actions SET Action_Enabled='1';
if that does not work, dont use quotes, ie
UPDATE Actions SET Action_Enabled=1;
I think the 1st one is right, but just in case =)
Good luck. I am home all day today and tomorrow if you need additional help.
Vaughn
| Description: |
| here is Humazee's current exe. |
|
Download |
| Filename: |
eventsandvcrib.zip |
| Filesize: |
351.19 KB |
| Downloaded: |
71 Time(s) |
_________________
the Crib Keeper
www.vcrib.com |
|
| Sat Jan 12, 2008 1:17 pm |
|
|
SnyperBob
Joined: 22 Aug 2007
Posts: 627
Location: Illinois |
|
| |
|
Thanks Vaughn,
I'll try all this out when I get home in the morning. I didn't intend to be a dick with the bold huge text. I just wanted to make sure you saw it 
I'll post back with my results. I appreciate you tracking this down from Tod. Thanks Tod too!
|
|
| Mon Jan 14, 2008 12:01 am |
|
|
SnyperBob
Joined: 22 Aug 2007
Posts: 627
Location: Illinois |
|
| |
|
Hey Vaughn,
I'm not exactly sure what I need to do. I downloaded your attached two EXEs, and replaced the old ones in my directory with your two new ones.
When I overwrote them, the windows prompt said they were the same size. If I remember correctly, one of yours was older than one of mine that I alreayd had installed. This is in terms of when the file was created.
Anyway, it didn't work. When I create a location object, and then go to the actions tab, I still get the type mismatch error.
The only way now to get around this is to run your SQL query every time after creating a location. I guess that works, as long as that's all I need to do, that's cool.
BTW - the first query you posted works:
 |
|
UPDATE Actions SET Action_Enabled='1'; |
|
|
| Mon Jan 14, 2008 7:21 am |
|
|
SnyperBob
Joined: 22 Aug 2007
Posts: 627
Location: Illinois |
|
| |
|
Heck, I don't know
Now when I create more locations on the objects tab, I don't get that error. It happened on the first two locations that I created, but now no longer. I'm starting to think I didn't create the first two correctly or something. M'eh, I'll keep you posted
Thank you!!!
|
|
| Mon Jan 14, 2008 7:39 am |
|
|
CribKeeper
Site Admin
Joined: 09 Aug 2007
Posts: 636
Location: Overland Park, KS |
|
| |
|
Cool, hope it holds stable for you for a bit. I really tore the code up for 0060 and would hate to have to release it half-ways to fix this bug as it may just introduce more bugs.
I am going to shut down development on 0060 and start testing and try to get it out sooner. I think the mistakes I made are:
1. Keep the source for every release so I can patch bugs independantly of the new build I am working on for a better response time.
2. With only one person testing, I need to give more time to find bugs before releasing the code.
3. I took a break in the middle of a build and kinda lost track of my objectives and where I was... I should take my breaks inbetween builds =)
4. I am still not documenting my work like I used to and should all the time...
Vaughn
_________________
the Crib Keeper
www.vcrib.com |
|
| Mon Jan 14, 2008 11:24 am |
|
|
SnyperBob
Joined: 22 Aug 2007
Posts: 627
Location: Illinois |
|
| |
|
Well, even if there's still a problem creating location objects, that MySQL query fixes the problem.
I'll update the Wiki and include a link to this thread and directions on how to fix that problem/error. Thanks!
|
|
| Mon Jan 14, 2008 4:11 pm |
|
|
CribKeeper
Site Admin
Joined: 09 Aug 2007
Posts: 636
Location: Overland Park, KS |
|
| |
|
BTW Bob,
Not sure how involved in testing you wanna get, but you are not the public and I will gladly give you updates to try before they hit the web site, like Humanzee. You get fixes in minutes instead of days/weeks, and you get priority on requests, bugs, etc. I know you are busy too, but it is not much time. It involves a little more manual stuff, like that SQL fix above, but I walk you through updates and train on general stuff at the same time. It might give you a lot more insight in making the Wiki, plus it cements you as Tester #2 for whatever that is worth =). It gets you on my Christmas list at least. YTek is only a couple weeks from finishing his wiring closet then he will be grabbing a full time tester slot...
Well, if anyone is interested in working directly with me as a tester, chat with Humanzee for his opinion on if it is worth it & how much work it is, etc. Even if he says it sucks though, I am sure he will say it is 100x better since he started... He used to have to wipe his DB for any upgrades =)
Vaughn
_________________
the Crib Keeper
www.vcrib.com |
|
| Tue Jan 15, 2008 12:19 am |
|
|
SnyperBob
Joined: 22 Aug 2007
Posts: 627
Location: Illinois |
|
| |
|
Mauhahahah, I want the tester #2 slot!!!!
Sign me up!!! Actually, yes, that would be nice. I think I may have found another small bug, but I didn't have much time to test it before work (I'm at work now).
But yes, that would be cool. Anything I can do to get more insight for the Wiki is cool with me. I'll also start listing the errors and bugs along with their fixes in the Wiki. So anyone trying to get up and running that runs into the same problems can fix it on the fly until a new major release comes out.
That should take some pressure off your shoulders, allowing all new people to get up and running on their own, and saving you time by not having to answer their questions every 5 mins like you do for me
If you want to email me your info, that's cool (phone, secret email, etc), I'll send you my info.
I was actually just thinking about YTek now, and wondering what he's been up to. My wiring closet isn't 'done' yet, but I couldnt freakin wait. I just scored a deal on some really cheap x10 stuff off cocoontech (the guy better freakin mail me my stuff!). Once I can afford a PLC I'll be able to have a 'real' security system!!
Christmas list here I come! lol
|
|
| Tue Jan 15, 2008 12:25 am |
|
|
CribKeeper
Site Admin
Joined: 09 Aug 2007
Posts: 636
Location: Overland Park, KS |
|
| |
|
Ha, like Humanzee you got screwed by starting in January! Actually I try to give out perks at milestones, Humanzee just never wants anything I offer him! I am like "Hey man, you want RFID or an AB8SS" and he is like "Nah, I don't need none of that and my wife thinks RFID is for losers" heheheheh I exaggerate, but I try to help with HA hardware, especially if it is something I need help testing for anyways. 90% of the people that offered to help never actually carried through so I am prick now and have to get the work out of them first =)
Once there are 5+ testers I won't be able to hook them up, but even my poor ass can take care of the first few of you that believes in me and sticks with the project through some of its early pains. Anyway, sorry I know I have said this before, I just need the help so bad that I am pushing the bribes =)
Anyways, I will email you tomorrow with all my info, including schedules so maybe we can find some common availability to work/play on stuff live and you don't have to wait on me to check emails, etc.
Vaughn
_________________
the Crib Keeper
www.vcrib.com |
|
| Tue Jan 15, 2008 12:56 am |
|
|
Humanzee
Joined: 22 Aug 2007
Posts: 509
Location: Seattle, WA |
|
| |
|
ok, this thread is of topic now. Testing has been fun as long as you are expecting problems. For me it was as much fun discovering how the system works as actually making it run smoothly. Vaughn and I used to argued quite some about some usability things and how I thought some things aught to work vs. how they did. Some discussions about vernacular and organization. But its impossible to please everyone and sometimes great ideas don't work technically for what ever reason.
Vaughn is right vCrib is orders of magnitude better than it was this time last year. Most bugs pop up when you are building your system and adding devices. Once you are up and running, you don't need to interact with the apps as frequently so there is less discovery. Having to wipe the DB was a pain yes, but also flushed out some other problems that needed fixing. If you want to test just keep in mind that the software is free and this is a hobby. You know the saying about gift horses. Well this is a little different because we are supposed to point out the errors. Just don't poke the monkey too much, each time he breaks a little off your stick and you have to stand closer next time.
As far as a wiring closet, I took the same route as Bob, My closet has a bunch of dead wires sitting in it just waiting for me to get to them. I got up and running one circuit and light switch at a time. I figure I will do the closet once when I am more or less ready to. I am much more patient now than I was growing up. I stopped telling myself that I can just re-do things and do them better later because I find I never come back to a project. So I get things done at my own pace and hammer on the nail that is sticking out the furthest. That and there is some harmony that needs to be maintained with the wife. Despite my preference for the sequence of things, those last three doors are not wired yet because I've been hanging pictures on the walls, changing oil, picking up milk etc. I did get my surround sound speakers set up though.
_________________
vCrib Tester #1, Forum moderator, using INSTEON devices, X10 sensors and remotes via W800RF, All doors are wired with contact closures.
vCrib Wiki |
|
| Tue Jan 15, 2008 12:44 pm |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum
|
|
|
