Cant save

[Cody Jordan]

After filling out the visit form for a patient, I click the check mark that says save. Then if I click export as PDF or print the program tells me I need to save the file first. then it allows me to export or print it, but it still doesn't show up in the calandar. If i exit the program and restart it, any visits I had previsouly typed in are gone.

[Leonardo Robol (leo.robol)]

Thanks for taking the time to report this bug. I'd like to ask you some information in order to be able to track it down correctly.

Which version of Clinica are you using? Did you installed it using the repositories, a PPA or by compiling the sources?

Did this bug appear after some time that you have used Clinica, or right from the start?

Would you be able to reproduce the bug? For example, it would be helpful for me if you could follow these steps:
1) Create a new user account on your machine (so that we don't ruin the current data in Clinica and we can start from a clean database)
2) Login with that user and start using Clinica, and try to trigger the bug.
3) As soon as you are able to reproduce it, attach the Clinica db to this bug report, so I can inspect it. You can perform this last step with the following command from a terminal (with the new user):
cd && tar cvzf clinica_data.tar.gz .local/share/clinica .config/clinica
that will produce a file called clinica_data.tar.gz in your home directory. Attach that to this bug report.

Thanks again for your help,
Leonardo Robol.

[Cody Jordan (jeeper74)]

On 04/13/2013 09:07 AM, Leonardo Robol wrote:
> Thanks for taking the time to report this bug. I'd like to ask you some
> information in order to be able to track it down correctly.
>
> Which version of Clinica are you using? 0.3.0
Did you installed it using the repositories, a PPA or by compiling the
sources?

/I installed via synaptic. I am running Pear Linux 7 which is based off
of ubuntu 12.10 I think./

Did this bug appear after some time that you have used Clinica, or right
from the start?

/From the start/

Would you be able to reproduce the bug? For example, it would be helpful
for me if you could follow these steps:
1) Create a new user account on your machine (so that we don't ruin the
current data in Clinica and we can start from a clean database)

2) Login with that user and start using Clinica, and try to trigger the
bug.

3) As soon as you are able to reproduce it, attach the Clinica db to
this bug report, so I can inspect it. You can perform this last step
with the following command from a terminal (with the new user): cd &&
tar cvzf clinica_data.tar.gz .local/share/clinica .config/clinica that
will produce a file called clinica_data.tar.gz in your home directory.
Attach that to this bug report.

/It is not a "Bug" I can operate all the software fine, it just will not
save any "visits" that are performed. I can have a pdf or a printout of
it but when I close the program, that information is gone. I will try
the last step above and see if I can get you any further information./

Thanks again for your help, Leonardo Robol.

[Leonardo Robol (leo.robol)]

Perfect, I'll wait for your results, and in the mean time I will investigate more. By the way, could you also try to launch clinica from a terminal (with the command "clinica --debug"), try to save a new visit, and paste the output here?

[Cody Jordan (jeeper74)]

On 04/14/2013 02:14 AM, Leonardo Robol wrote:
> Perfect, I'll wait for your results, and in the mean time I will
> investigate more. By the way, could you also try to launch clinica from
> a terminal (with the command "clinica --debug"), try to save a new
> visit, and paste the output here?
>
> ** Changed in: clinica-project
> Assignee: (unassigned) => Leonardo Robol (leo.robol)
>
the output for the debug is:

cody@cody-i7:~$ clinica --debug
[DEBUG] PluginEngine.vala:36: Adding /usr/lib/clinica/plugins to the
search path for plugins
[DEBUG] ResourceManager.vala:328: Plugin Codice Fiscale found but disabled
[DEBUG] ResourceManager.vala:328: Plugin Agenzia del Farmaco found but
disabled
[WARNING] Type not found in introspection: 'ClinicaCoreActivatable'
[WARNING] Method 'ClinicaCoreActivatable.activate' was not found
[DEBUG] Application.vala:215: Starting the DBus Clinica Service
[DEBUG] Application.vala:161: Activating ClinicaService on DBus
[DEBUG] Application.vala:221: Showing Clinica user interface
[WARNING] Type not found in introspection: 'ClinicaUserInterfaceActivatable'
[WARNING] Method 'ClinicaUserInterfaceActivatable.activate' was not found
[DEBUG] PatientLens.vala:35: Starting PatientLens
[WARNING] unity-scope-factory.vala:78: Unable to search for scopes: No
such file or directory
[DEBUG] Application.vala:168: Could not acquire bus
[WARNING] SqliteDataProvider.vala:101: An error occurred while saving
the doctor with id 0: no such table: visits

[Cody Jordan (jeeper74)]

On 04/13/2013 09:07 AM, Leonardo Robol wrote:
> Thanks for taking the time to report this bug. I'd like to ask you some
> information in order to be able to track it down correctly.
>
> Which version of Clinica are you using? Did you installed it using the
> repositories, a PPA or by compiling the sources?
>
> Did this bug appear after some time that you have used Clinica, or right
> from the start?
>
> Would you be able to reproduce the bug? For example, it would be helpful for me if you could follow these steps:
> 1) Create a new user account on your machine (so that we don't ruin the current data in Clinica and we can start from a clean database)
> 2) Login with that user and start using Clinica, and try to trigger the bug.
> 3) As soon as you are able to reproduce it, attach the Clinica db to this bug report, so I can inspect it. You can perform this last step with the following command from a terminal (with the new user):
> cd && tar cvzf clinica_data.tar.gz .local/share/clinica .config/clinica
> that will produce a file called clinica_data.tar.gz in your home directory. Attach that to this bug report.
>
> Thanks again for your help,
> Leonardo Robol.
>

[Leonardo Robol (leo.robol)]

Thanks for your data, Cody, I was actually able to replicate your problem. It seems that your database is missing the visits table, most likely due to an error in a previous database upgrade. I assume you are using our Clinica daily ppa, that always contains the latest changes and may be unstable from time to time. Anyway, I've introduced some stricter checks at startup that should repair your installation (and will hopefully cope with similar problems in the future).

If you are still using the PPA you should get the update tomorrow through the update manager. If that's the case it would be the best way to fix the problem. In any other case the following command should fix the problem for you:

echo "CREATE TABLE IF NOT EXISTS visits (subsequent_checks TEXT, systemic_therapy TEXT, ID INTEGER PRIMARY KEY, laboratory_exam TEXT, diagnosis TEXT, histopathology TEXT, anamnesis TEXT, date TEXT, patient INTEGER, physical_examination TEXT, topical_therapy TEXT);" | sqlite3 ~/.local/share/clinica/clinica.db

So, I suggest you the following procedure:
1) Wait until tomorrow and check in your update manager for updates to Clinica. If you get them, try to start clinica again (this may require to log off and log in again, to be sure you can just reboot your PC).
2) If the step above doesn't solve your issue (or you don't get the updates, for whatever reason), use the command that I've posted above.

If even step 2) doesn't work, come back to me and we'll see what we have got wrong.

Thanks for your testing,
Leonardo Robol.

[Cody Jordan (jeeper74)]

On 04/14/2013 12:32 PM, Leonardo Robol wrote:
> ** Changed in: clinica-project
> Importance: Undecided => Medium
>
you have fixed my issue! thanks a ton!

now I have a question about an idea... would it be possible to make
this so i could enter information for persctiptions? i mean my wife is
the intended user, and will be using for herbal stuff. can i enter say
"aloe" with a dosage or a little information about it?

thanks again for your help,
Cody

[Leonardo Robol (leo.robol)]

I'm happy that your issue is finally fixed, so I'm closing this bug report.
Regarding your proposal, that can be definitely done, and Clinica even has some infrastructure to make that easy. I suggest that you open a different bug report about that marking it as "wishlist" so we can carry out further discussion on this topic in there.

Thanks again for your contribution,
Leonardo Robol.