Phreesoft Support Forum

After changing my database password I have been unable to change the files (config.php in root directory of Phreebooks and in my_files directory right?) and have been unable to access the program. Is it possible to reinstall over the existing installation (or a new install) using the existing database entries. Basically only installing the zip file again without writing the database tables? I tried a new install in a different directory but got SQL errors after the initial install setup screen. I am using the latest version of Phreebooks. Thanks for your help!

you should have no problem changing the config.php file, it should look like this:


you will of course need to make sure the define is correct for your server?
Even if you re install, you will need to know the db user and password...

_________________
Alvin

I had a situation where the permissions were not set properly (I don't know if it was because the installer created those files as opposed to an ftp upload?). Anyways, I got my host to change all permissions but even after replacing the config files with those from an offline backup phreebooks would not load, just a blank screen (no errors). I would like to try a reinstall anyways, are there any options to run the install script without the SQL?
Thanks

Or is there something else that also has to be changed in the phreebooks database files to get the new password to work with the existing install?

Just an update...
I have no idea why my previous install suddenly goofed up, I did a second install in a new folder with the new database info. The install erased my 'configuration' table, luckily I diligently backup so I just emptied the table and inserted my backup table. I can now access again through the new folder. If only I could figure out why the old one is being so difficult...

Long story short: Reinstall works with fresh install but make sure your database is backed up (should be anyways) and you can edit it in your control panel.

Upon further inspection... I can log in, everything looks great & my contacts/vendors/etc are there but I can't edit or change anything and when I try to bring up past invoices (invoice manager) they are blank... ?

Check the paths and access information in the /includes/configure.php file and the /my_files/COMPANY_DB_NAME/config.php file. This is where all your access information is located. If you moved/deleted files, you will need to restore any files in the /my_files/COMPANY_DB_NAME/ directory as there are application files that are created and installed here to generate reports, store attachments, etc.

Dave

The path seems fine in configure, as well as the config file in my DB_NAME folder.

I just noticed that my previous install was 3.1... would that effect the reinstall if I used the current version 3.4? I can log in, see my contacts & find previous invoices/inventory/etc. But I can't click on any of the contacts (previously the search contacts dialog box would come up, I would choose the customer & click them, then the invoice manager screen would populate with their contact info... Now it does nothing when clicking). I looked in my database directory (under my_files) many of the folders are empty; contacts,inventory,phreebooks, shipping. The only one with anything in it is phreeform... was this just an incomplete install? How would I get the rest of those files in there without the installer hanging at the SQL database creation?

I did a lot of JavaScript work since 3.1 Check your JavaScript error log in FireFox and post anything you find here. If 3.4 sees the db set at 3.1 it will automatically upgrade the db to the newest level. It's possible the upgrade failed and now there is a field missing or that hasn't been upgraded causing the trouble.

Dave

These are the errors:

Timestamp: 3/30/2012 12:29:07 PM
Error: syntax error
Source File: http://elementbotanicals.ca/Phreedom/index.php
Line: 24, Column: 28
Source Code:
var decimal_places = ;
Timestamp: 3/30/2012 12:29:07 PM
Error: combo_image_on is not defined
Source File: http://elementbotanicals.ca/Phreedom/includes/common.js
Line: 297

these are the warnings;

Timestamp: 3/30/2012 12:29:22 PM
Warning: Expected declaration but found '*'. Skipped to next declaration.
Source File: http://elementbotanicals.ca/Phreedom/th ... tables.css
Line: 37
Timestamp: 3/30/2012 12:29:22 PM
Warning: Error in parsing value for 'filter'. Declaration dropped.
Source File: http://elementbotanicals.ca/Phreedom/th ... ery-ui.css
Line: 22
Timestamp: 3/30/2012 12:29:22 PM
Warning: Unknown property 'zoom'. Declaration dropped.
Source File: http://elementbotanicals.ca/Phreedom/th ... ery-ui.css
Line: 330
Timestamp: 3/30/2012 12:29:22 PM
Warning: Error in parsing value for 'filter'. Declaration dropped.
Source File: http://elementbotanicals.ca/Phreedom/th ... ery-ui.css
Line: 553

There are repeats for the warnings throughout the same files (ie; where ever filter:Alpha(Opacity=0); is mentioned in jquery-ui.css is mentioned there is a parsing value error...)

Also, when trying to click on a customer in the popup...

Timestamp: 3/30/2012 12:58:25 PM
Error: form_submitted is not defined
Source File: http://elementbotanicals.ca/Phreedom/includes/common.js
Line: 414

And when loading a previous invoice...

Timestamp: 3/30/2012 1:01:45 PM
Error: document.getElementById(field_name) is null
Source File: http://elementbotanicals.ca/Phreedom/includes/common.js
Line: 78
Timestamp: 3/30/2012 1:01:44 PM
Error: icon_path is not defined
Source File: http://elementbotanicals.ca/Phreedom/mo ... /orders.js
Line: 569
Timestamp: 3/30/2012 1:01:44 PM
Error: syntax error
Source File: http://elementbotanicals.ca/Phreedom/in ... ction=edit
Line: 24, Column: 28
Source Code:
var decimal_places = ;

First go into currencies and set the decimal places to a integer, it looks like you have it set to null. The reset may be a symptom of the decimal places not set. Be sure to set the precise also. Even 0 is OK.

Dave

Thanks Dave,

After the updated install the currencies table was rewritten, and I had added CDN as an additional currency originally so that might have thrown it off... I updated the DB and can again access invoices & adjust customer info (via customer manager). I hope that's it, is there anything else that my dirty reinstall might have overwritten in the original DB? It seems like updating from 3.1 to 3.6 is not too bad (even accidentally) as long as you can reinsert your currencies & configuration tables. Anything else I'm missing?

Thanks again!

Hard to say as I haven't tried this but if you run into anything, post it here.

Dave

In plesk it is usually a case of copying the db folder, pasting it in new install, then making the same user db with same db name and password, as these values are already stored in the old script.