Updated to Current DB Version: 0.6.4

smcs

I ran the updates and all looked good but now when I try to view my quotes it just says "Nothing to See Here" and I have many quotes that I was just viewing before the update. Can you lead me in the right direction to fix this issue?

smcs

Forgot to add, same for Invoices, they all say Nothing to See Here

johnny

Check updates again to make sure you got them all. Myabe in a private browsing window as sometimes pages get cached.
post your error log when accessing both quotes and invoices.
Check the database structure for quotes and see if you have quote_expire field there.
Also may want to check the invoices and quotes table to see if there is any data in there Your should be able to use phpmyadmin for this

smcs

Ok I will check that and also, I went to clients and there are no clients at all showing and I did have many clients.

smcs

Checked structure and quote_expire is there. Checked in private window and no updates found. In the db all information is still there, just not from the website. It was until I ran the update.

johnny

okay try this:

Drop to shell in directory where ITFlow lives.

Run the following commands in the working directory of ITFlow:

git fetch --all

git reset --hard origin/master

johnny

Also verify if the data is actually in the tables clients, invoices, quotes using phpmyadmin or commandline mysql-client

smcs

Ran it and this is the output

biztxts@cp27-ga ~]$ cd itflow.midmosecurity.com

[biztxts@cp27-ga itflow.midmosecurity.com]$ git fetch --all

[biztxts@cp27-ga itflow.midmosecurity.com]$ git reset --hard origin/master

HEAD is now at bd9b5bdc Hopefully fixed an issue during initial setup after entering DB credentials and writing the config.php files. This was possible due to a rac condition where intially ITflow install checks to see if it can write config.php to currect directory by actually writing a config.php file then deleting it. This could sometimes interfere with the creation of the config.php file in the next step

[biztxts@cp27-ga itflow.midmosecurity.com]$

smcs

Verified with phpadmin, all clients, quotes and invoices are there, just not when I click it in the website, just says nothing to see here

smcs

Hey just checked and after running your commands they are showing back up now!

smcs

but clients are still missing.

johnny

verify your clients are in the DB then go to clients listing page then post your error logs, we'll see if we can track down the issue from there

smcs

Sorry I jumped the gun Quotes are back but invoices and contacts are still missing.

smcs

Where do I gather error logs?

johnny

okay verify to see if you have the field contact_primary in your contacts tables and also let me know if you have a field called client primary contact field in the clients table?

johnny

logs should be in /var/log/apache2/error.log just grab the logs that match the timestamp when you accessed the contacts and invoices page

smcs

I do not see - contact_primary or Primary Contact. Getting logs now, once I find out how to get them from host,

smcs

Here is what I have found so far:

2023-07-18 14:03:07.407062 [INFO] [2078084] [T0] [163.172.74.29:45816#APVH_smcsmail.biztxts.com] File not found [/home/biztxts/smcsmail.net/403.shtml]

2023-07-18 13:51:58.406912 [INFO] [2078084] [T0] [162.244.177.42:35778-H3:254721CE1D68BF76-4#APVH_itflow.midmosecurity.com:443] File not found [/home/biztxts/itflow.midmosecurity.com/404.shtml]

2023-07-18 13:51:58.406898 [INFO] [2078084] [T0] [162.244.177.42:35778-H3:254721CE1D68BF76-4#APVH_itflow.midmosecurity.com:443] File not found [/home/biztxts/itflow.midmosecurity.com/plugins/inputmask/min/inputmask/inputmask.min.js]

2023-07-18 13:51:13.381628 [INFO] [2078084] [T0] [162.244.177.42:48265-H3:C4CBDCD4C8FC9BBF-4#APVH_itflow.midmosecurity.com:443] File not found [/home/biztxts/itflow.midmosecurity.com/404.shtml]

2023-07-18 13:51:13.381614 [INFO] [2078084] [T0] [162.244.177.42:48265-H3:C4CBDCD4C8FC9BBF-4#APVH_itflow.midmosecurity.com:443] File not found [/home/biztxts/itflow.midmosecurity.com/plugins/inputmask/min/inputmask/inputmask.min.js]

2023-07-18 13:51:01.503845 [INFO] [2078084] [T0] [162.244.177.42:1996-H3😃DC44B29DF9C0EA6-4#APVH_itflow.midmosecurity.com:443] File not found [/home/biztxts/itflow.midmosecurity.com/404.shtml]

2023-07-18 13:51:01.503831 [INFO] [2078084] [T0] [162.244.177.42:1996-H3😃DC44B29DF9C0EA6-4#APVH_itflow.midmosecurity.com:443] File not found [/home/biztxts/itflow.midmosecurity.com/plugins/inputmask/min/inputmask/inputmask.min.js]

2023-07-18 13:50:12.942379 [INFO] [2078084] [T0] [66.249.88.70:62874-1#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/404.shtml]

2023-07-18 13:50:12.942366 [INFO] [2078084] [T0] [66.249.88.70:62874-1#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/files/april.jpg]

2023-07-18 13:50:12.766213 [INFO] [2078084] [T0] [66.249.88.70:62874#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/404.shtml]

2023-07-18 13:50:12.766199 [INFO] [2078084] [T0] [66.249.88.70:62874#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/files/april.jpg]

2023-07-18 13:43:22.308565 [INFO] [2078084] [T0] [185.204.216.66:41854#APVH_biztxts.com:443] File not found [/home/biztxts/public_html/403.shtml]

2023-07-18 13:43:02.634041 [INFO] [2078084] [T0] [64.233.172.43:59665#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/404.shtml]

2023-07-18 13:43:02.634012 [INFO] [2078084] [T0] [64.233.172.43:59665#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/files/april.jpg]

2023-07-18 13:43:02.423229 [INFO] [2078084] [T0] [64.233.172.41:50688#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/404.shtml]

2023-07-18 13:43:02.423214 [INFO] [2078084] [T0] [64.233.172.41:50688#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/files/april.jpg]

2023-07-18 13:42:55.250561 [INFO] [2078084] [T0] [64.233.172.42:53405#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/404.shtml]

2023-07-18 13:42:55.250537 [INFO] [2078084] [T0] [64.233.172.42:53405#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/files/april.jpg]

2023-07-18 13:42:45.192273 [INFO] [2078084] [T0] [64.233.172.43:47277#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/404.shtml]

2023-07-18 13:42:45.192260 [INFO] [2078084] [T0] [64.233.172.43:47277#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/files/april.jpg]

2023-07-18 13:42:32.706507 [INFO] [2078084] [T0] [64.233.172.42:64918#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/404.shtml]

2023-07-18 13:42:32.706479 [INFO] [2078084] [T0] [64.233.172.42:64918#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/files/april.jpg]

2023-07-18 13:42:22.373100 [INFO] [2078084] [T0] [64.233.172.43:58656#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/404.shtml]

2023-07-18 13:42:22.373079 [INFO] [2078084] [T0] [64.233.172.43:58656#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/files/april.jpg]

2023-07-18 13:42:12.396827 [INFO] [2078084] [T0] [64.233.172.41:42672#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/404.shtml]

2023-07-18 13:42:12.396811 [INFO] [2078084] [T0] [64.233.172.41:42672#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/files/april.jpg]

2023-07-18 13:42:01.591698 [INFO] [2078084] [T0] [64.233.172.43:64822#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/404.shtml]

2023-07-18 13:42:01.591680 [INFO] [2078084] [T0] [64.233.172.43:64822#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/files/april.jpg]

2023-07-18 13:41:51.721468 [INFO] [2078084] [T0] [64.233.172.41:38572#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/404.shtml]

2023-07-18 13:41:51.721453 [INFO] [2078084] [T0] [64.233.172.41:38572#APVH_smcsmail.biztxts.com:443] File not found [/home/biztxts/smcsmail.net/files/april.jpg]

2023-07-18 13:35:38.670422 [INFO] [2078084] [T0] [162.244.177.42:56703-H3:4881B35E551CF44E-4#APVH_itflow.midmosecurity.com:443] File not found [/home/biztxts/itflow.midmosecurity.com/404.shtml]

2023-07-18 13:35:38.670409 [INFO] [2078084] [T0] [162.244.177.42:56703-H3:4881B35E551CF44E-4#APVH_itflow.midmosecurity.com:443] File not found [/home/biztxts/itflow.midmosecurity.com/plugins/inputmask/min/inputmask/inputmask.min.js]

2023-07-18 13:35:11.558925 [INFO] [2078084] [T0] [162.244.177.42:61292-H3:81E2E1EB180FA047-4#APVH_itflow.midmosecurity.com:443] File not found [/home/biztxts/itflow.midmosecurity.com/404.shtml]

2023-07-18 13:35:11.558912 [INFO] [2078084] [T0] [162.244.177.42:61292-H3:81E2E1EB180FA047-4#APVH_itflow.midmosecurity.com:443] File not found [/home/biztxts/itflow.midmosecurity.com/plugins/inputmask/min/inputmask/inputmask.min.js]

2023-07-18 13:34:27.265242 [INFO] [2078084] [T0] [162.244.177.42:18732-H3:87C61BDD126B4CA9-4#APVH_itflow.midmosecurity.com:443] File not found [/home/biztxts/itflow.midmosecurity.com/404.shtml]

2023-07-18 13:34:27.265228 [INFO] [2078084] [T0] [162.244.177.42:18732-H3:87C61BDD126B4CA9-4#APVH_itflow.midmosecurity.com:443] File not found [/home/biztxts/itflow.midmosecurity.com/plugins/inputmask/min/inputmask/inputmask.min.js]

2023-07-18 13:34:20.919292 [INFO] [2078084] [T0] [162.244.177.42:52885-H3:EEE14CC40FF775EB-4#APVH_itflow.midmosecurity.com:443] File not found [/home/biztxts/itflow.midmosecurity.com/404.shtml]

smcs

and just so you know the domain is /home/biztxts/itflow.midmosecurity.com, not the other errors. I looked and iputmask.min.js is in the directory

smcs

And I was wrong, quotes, invoices and contacts are all not working. Quotes and invoices you can see them on main display, but if you try to access one it says nothing to see here. Contacts not seen on main page at all.