pacsone.php error

[gregwong]

When I first log in (using my root user name), I get the following error:

"Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\program files\pacsone\php\pacsone.php on line 29

There are patients in PACS database.


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\program files\pacsone\php\display.php on line 52
PatientID PatientName BirthDate Sex Age Details Download

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\program files\pacsone\php\display.php on line 76 "

These lines are sandwiched between the salmon colored toolbars.
The upper one has "Home | Search | Application Entities ..."
The lower has "PatientID | Patient Name | etc. "

The setup ran fine without a hitch. I'm not sure where to go from here.

My configuration is listed below.

Thanks,
g
____________________________________________________________
win 2k - apache 1.3.27 - php 4.3.3 - mysql 4.0.15 - PACSOne v. 1.0.0.14

[gregwong]

When I installed PACSOne, I did not use the default username. I used instead "root".

I read the manual. According to the manual, there are two users when you start using PACSOne, root and the name of the user entered in the install step. If that user happens to have the same name, does everything break?

-g

[gregwong]

I tried reinstalling with a non 'root' username.
This did not work either.

When I logged on as root, I could not find the 'User Administration' link as defined on page 8 of the PacsOne manual.

I'm guessing it's a priviledges problem. Is there a way to correct this?
g

PS On most of the PACSOne pages, I get some type of warning, typically beginning with "Warning: mysql_..."

[pacsone]

From the errors you're getting, it seems that your database tables were not created properly. You can do the following things to check why:

1. Login to MySQL from a command shell by typing:

"C:\mysq\bin\mysql.exe -u {USERNAME} -p {DBNAME}"

where {DBNAME} is the name of the MySQL database you've created for PacsOne, {USERNAME} is the MySQL username you've created for PacsOne (or root if you prefer).

From the MySQL shell, type:

mysql>show tables;

The output should list 8 tables for the Premium Edition. If not, then your tables were not setup properly. If the output does list the correct number of tables, then you can check the tables one by one by typing:

mysql>describe {TABLE};

2. You can also check the MySQL database setup log file under the log sub-directory where PacsOne was installed, there's either a file named db_install.log or db_upgrade.log, depending on whether this is a new install or an upgrade. The log file should tell you what MySQL commands the installer ran during PacsOne installation, and any success/error output resulting from the commands.

[gregwong]

No tables were found.
Is there a script to run which creates the tables?

I looked at the log file. The two errors I repeated get are as follows:
ERROR - RUNQUERY: SQL Bad Query: Table 'mapp.dbjob' doesn't exist
ERROR - Exeption encountered in Database Job Thread

mapp is the name of my database. dbjob is the job thread. I'm not sure how to access that. My guess is that the installer creates the job. Does it not have the correct permission?

greg

[gregwong]

BTW, prior to the ERRORs, these INFO lines appear prepended with date and time information that I took out when I copied and pasted.

INFO - Process Intialized
INFO - Server Socket: 272 created successfully
INFO - Socket: 272 bind to Port: 4444
INFO - Worker Thread: 2292 running
INFO - Worker Thread: 2056 running

greg

[gregwong]

Thanks for your help in pointing out the database error.
I manually ran the two scripts db_schema and then upgrade_schema in that order.

Works now!

The part I'm missing is managing users from the WEB interface. I think this is a user permissions problem. Is there a way to query the usernames and associated permissions?

From the manual, I should see a "Administration" link on the Home page. I dont' for any of my users, even the root and admin users.

Any suggestions appreciated.
-greg

[pacsone]

Thanks for your help in pointing out the database error.
I manually ran the two scripts db_schema and then upgrade_schema in that order.

Works now!

The part I'm missing is managing users from the WEB interface. I think this is a user permissions problem. Is there a way to query the usernames and associated permissions?

From the manual, I should see a "Administration" link on the Home page. I dont' for any of my users, even the root and admin users.

Any suggestions appreciated.
-greg

Did you install the Basic Edition or the Premium Edition? Only the Premium Edition supports web-based user administration and privilege levels.

[gregwong]

Thanks for the info.

I didn't realize the basic edition didn't support administration.
I installed the basic edition.

Depending on whether or not the group likes the product, we may upgrade.