Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome Bug Reports
 PowerHome Messageboard : PowerHome Bug Reports
Subject Topic: Global Variables Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
krommetje
Super User
Super User
Avatar

Joined: December 29 2004
Location: Netherlands
Online Status: Offline
Posts: 695
Posted: April 16 2005 at 13:14 | IP Logged Quote krommetje
Hey Dave,

1: The PIII runs and done some initial tests... The global Variables page is not available from the web/network...
(inside the webcenter) The page doesn't load.... In both instances the page doesn't load: As well as over the network as when I go into the webcenter locally!

2: It seems that in the new version the updating of the temperatures to be impossible after a fire-alarm is now an isue in the new version... After about 1 hour of updating the temps, PH stops updating and the GV's are set to 0

Peter

Edited by krommetje
Back to Top View krommetje's Profile Search for other posts by krommetje Visit krommetje's Homepage
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: April 16 2005 at 13:57 | IP Logged Quote dhoward
Peter,

The problem with the GV page showing on the web is most likely due to a character in either the GV data or the GV ID that is not expected. This has been an ongoing problem for little while now. It seems that everytime I fix it, another char breaks it.

Depending upon the number of GV's that you have, could you send me a screenshot or export them for me so that I can try to pinpoint the character that is causing the hangup?

If you want to export them for me, the procedure to do so is below:

1. Open the SQL Query under the Reports menu.

2. Type the following SQL statement: select * from global_variables

3. When the report window opens, go to File->Export and save the file with a filename of: global_variables.sql. The Saveas filetype should be set to: SQL.

4. Email the file to me.

Concerning the firealarm and the GV's. Is the behavior the same as in the previous version or is it different? You say after about an hour of updating the temps, PH stops updating the GV's. Is this behavior consistent or does it seems to be tied to some other occurence within PowerHome.

Dave.

Back to Top View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 
krommetje
Super User
Super User
Avatar

Joined: December 29 2004
Location: Netherlands
Online Status: Offline
Posts: 695
Posted: April 16 2005 at 18:50 | IP Logged Quote krommetje
dhoward wrote:

Concerning the firealarm and the GV's. Is the behavior the same as in the previous version or is it different? You say after about an hour of updating the temps, PH stops updating the GV's. Is this behavior consistent or does it seems to be tied to some other occurence within PowerHome.


No, just "out of the blue" PH stops updating the GV's However I am starting to think more and more about a problem at file level perhaps with the location declared in the formula... Perhaps a full path in the ph_readfile(... formula will do the trick. I will do some tests but in the meanwhile the temps are updated through the gamporttemp.exe webserver...for all 4 sensors. This has been working OK now for the last 6 hours...

Peter
Back to Top View krommetje's Profile Search for other posts by krommetje Visit krommetje's Homepage
 
krommetje
Super User
Super User
Avatar

Joined: December 29 2004
Location: Netherlands
Online Status: Offline
Posts: 695
Posted: April 17 2005 at 03:51 | IP Logged Quote krommetje
Here is a small update:

I have added the full path to the templcd.txt formula and done that yesterdayevening around 8... Now it is Morning and the GV's are normailly updated... I'll let you know how thong develop in the next few days...

you wanted my sql from the GV list... Here they are:

CREATE TABLE global_variables (
     id char(25),
     value char(1024));
INSERT INTO global_variables VALUES (
     'SENSOR0',
     '2272');
INSERT INTO global_variables VALUES (
     'SENSOR1',
     '1812');
INSERT INTO global_variables VALUES (
     'SENSOR2',
     '6788');
INSERT INTO global_variables VALUES (
     'SENSOR3',
     '262');
INSERT INTO global_variables VALUES (
     'SENSOR00',
     '22,76');
INSERT INTO global_variables VALUES (
     'SENSOR01',
     '18,17');
INSERT INTO global_variables VALUES (
     'SENSOR02',
     '67,88');
INSERT INTO global_variables VALUES (
     'MAILFIRE',
     'Waarschuwing:het veiligheidsprotocol is uitgevoerd vanwege rookdectie in de woning; controleer de woning !');
INSERT INTO global_variables VALUES (
     'MAILFIRESAFE',
     'Het brandalarm is opgeheven!');
INSERT INTO global_variables VALUES (
     'LIGHTMIUTES',
     '15');
INSERT INTO global_variables VALUES (
     'A1ON',
     '');
INSERT INTO global_variables VALUES (
     'A1OFF',
     NULL);
Back to Top View krommetje's Profile Search for other posts by krommetje Visit krommetje's Homepage
 
krommetje
Super User
Super User
Avatar

Joined: December 29 2004
Location: Netherlands
Online Status: Offline
Posts: 695
Posted: April 17 2005 at 03:52 | IP Logged Quote krommetje
Here is a small update:

I have added the full path to the templcd.txt formula and done that yesterdayevening around 8... Now it is Morning and the GV's are normailly updated... I'll let you know how thong develop in the next few days...

you wanted my sql from the GV list... Here they are:

CREATE TABLE global_variables (
     id char(25),
     value char(1024));
INSERT INTO global_variables VALUES (
     'SENSOR0',
     '2272');
INSERT INTO global_variables VALUES (
     'SENSOR1',
     '1812');
INSERT INTO global_variables VALUES (
     'SENSOR2',
     '6788');
INSERT INTO global_variables VALUES (
     'SENSOR3',
     '262');
INSERT INTO global_variables VALUES (
     'SENSOR00',
     '22,76');
INSERT INTO global_variables VALUES (
     'SENSOR01',
     '18,17');
INSERT INTO global_variables VALUES (
     'SENSOR02',
     '67,88');
INSERT INTO global_variables VALUES (
     'MAILFIRE',
     'Waarschuwing:het veiligheidsprotocol is uitgevoerd vanwege rookdectie in de woning; controleer de woning !');
INSERT INTO global_variables VALUES (
     'MAILFIRESAFE',
     'Het brandalarm is opgeheven!');
INSERT INTO global_variables VALUES (
     'LIGHTMIUTES',
     '15');
INSERT INTO global_variables VALUES (
     'A1ON',
     '');
INSERT INTO global_variables VALUES (
     'A1OFF',
     NULL);

Peter
Back to Top View krommetje's Profile Search for other posts by krommetje Visit krommetje's Homepage
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: April 18 2005 at 16:52 | IP Logged Quote dhoward
Peter,

I think you'll find that the full path will probably solve the problem. Everything was indicating that the file could not be found.

Concerning the global variables...I found the problem. It's the A1OFF GV. Because it has a value of NULL, it causes the entire page to fail. As a quick fix, open the explorer, go the value for A1OFF. Type a character, save the changes, erase the character, save the changes. The NULL should now be an empty string which should work just fine.

Ive gone ahead and fixed this so it will be ready in the next beta.

Dave.
Back to Top View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 
krommetje
Super User
Super User
Avatar

Joined: December 29 2004
Location: Netherlands
Online Status: Offline
Posts: 695
Posted: April 19 2005 at 05:16 | IP Logged Quote krommetje
dhoward wrote:
I think you'll find that the full path will probably solve the problem. Everything was indicating that the file could not be found.


I think so too... hardheaded me

dhoward wrote:

Concerning the global variables...I found the problem. It's the A1OFF GV. Because it has a value of NULL Ive gone ahead and fixed this so it will be ready in the next beta.


Actually this GV was a leftover from expirimenting with these ghost alarms... Up until now the new PH on the PIII PC runs smoothly and without any flaws.... What can I think of next to put my teeth in as a new project...

Peter

Edited by krommetje
Back to Top View krommetje's Profile Search for other posts by krommetje Visit krommetje's Homepage
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: April 19 2005 at 11:01 | IP Logged Quote dhoward
Heh, well Im just glad that it's all working out now .

New projects, hmmmm...you could look at expanding your system to include IR control .

Let me know if you run into any more problems.

Dave.


Back to Top View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum