yes I have corrected the quires.

Okay Bro, all is good. Haha. Thanks a lot, man.

Please set the ENVIRONMENT back to production

Error 500 is gone, run or ruined correctly the /update installer once again. I could login written after that 3.3.10 version ?

Please tell me where this goes wrong or to where I can mail to share some details.

You can email to support@tecdiary.com Thank you

I sent it already, it looked fixed but found another major bug with not calculating the taxes well after you updated it from 3.1 to 3.4 (information is already sent by mail) Hope for a fast fix as the program is now useless at the moment

I have found that the installer is not adding the correct db prefix to config. Please try to edit the app/config/database.php and add replace 'dbprefix' => '', with 'dbprefix' => 'sim_', I hope this will fix the issue. Thank you

Hi Tecdiary, i have made the changes you have suggested, but have some issue on the loading invoices, or products, also the invoice view has no css, where i can send you some pic. or login to have a look, thanks.

Please email to support@tecdiary.com Thank you

Can you check your db if the tables are created. You can download the files to install again. Thank you

Hi,

Your reports_model file is has query pointing to table ‘sales’ .. where as our table name starts with sim_

see here. public function getDailySales($year, $month) { $this->db->select(“date AS date, SUM ) AS inv_total, SUM ) as tax, sum( COALESCE ) as total, SUM ) as paid”, false) ->from(‘sales’) >where(‘status !=’, ‘canceled’)>where(“DATE_FORMAT( date, ‘%Y-%m’ ) = ‘{$year}-{$month}’”, null, false) >group_by(‘DATE_FORMAT( date, \’%Y%m-%d\’ )’); $q = $this->db->get(); if ($q->num_rows() > 0) { foreach (($q->result()) as $row) { $data[] = $row; } return $data; } return false; }

public function getMonthlySales($year) {
    $this->db->select('date, SUM( COALESCE( total, 0 ) ) AS inv_total, SUM( COALESCE( grand_total, 0 ) ) AS total, SUM( COALESCE( total_tax, 0 ) ) as tax, SUM( COALESCE( paid, 0 ) ) as paid', false)
         ->from('sales')
         >where('status !=', 'canceled')>where("DATE_FORMAT( date,  '%Y' ) =  '{$year}'", null, false)
         >group_by('DATE_FORMAT( date, \'%Y%m\' )')
         ->order_by('date_format( date, \'%c\' ) ASC');
    $q = $this->db->get();

That’s fine as the prefix will be automatically added.

This is manual update as there are few db changes that can’t be easily managed with migration. I hope, you have added the expenses controller, model and view separately, then you need to backup them with header file for links and perform update. Once updated you can replace back your expenses related files and edit the new header to add the links. You can copy from older header and paste it to new one. If you don’t have separate files for the expenses, you will need to make them as every update will replace the old files and if you have different then only you can save them. Thank you

views was done separately, model is using the sales_model and the controller also using the sales.php controller !! any hint of your implementations for the note to include it in the sales for each sale? that’s what interest me in your new version even though your new version use the note in settings but I plan to make it in different way by making it an internal note for each sale in the sale model and controller. if you happy we could communicate by email, just pm me here for your details. Thanks

You will need to move those methods to separate controller and model, then will won’t be replaced. If you want to just add the note suggestions, you can check the settings controllers and then the js code in themes/default/asserts/js/custom.js Thank you

I am sorry as there is no such option/feature. Thank you

No, you can add multiple companies and then create quotes/invoices but the companies won’t have any panel or management and all users are system level not company level. Thank you

Only admin have the permissions to delete. Please check if you are logged in as admin. Thank you

NM… duh..

Hello, you need to update the db settings in app/config/database.php and if the url is changed then please update the base_url in app/config/config.php Thank you

You can m modify the email method of app/controllers/sales.php and email_invoice method of app/controllers/cron.php and update the subjects as you need. Thank you

Sorry, unfortunately, it was not the simple to tackle on. Can you please specify more details how to actually do it? I could seem to find email method in app/controllers/sales.php and there about 9 email_invoice in app/controllers/cron.php so not very sure how and where to? Thanks.

You need to check the email_invoice method around line no 103 and look for $subject variable to change the subject. The other (you mentioning) are calls to this method. The line number could be different but you can search for function email_invoice Thank you

I am sorry as there is no shortcuts at this moment. We will check about this. Thank you

Please disregard this after all. TY

I am sorry as I am out of country so can’t answer the calls while roaming. Your emails will be replied but the email response is very slow. Thank you

Hi Saleem, will make a call to you on Monday regarding our requests. Thanks for the reply!

No, you will need to modify the view files to add any new option. Thank you

skip that – it’s working – just takes forever. I’ll bump up my RAM see if goes a little quicker… over 5 minutes to produce a PDF doc.

Hello, Please checked if the images are upload and exists. You can enable the debug by modifying the line no 130 of app/third_party/mpdf/config.php Yes, mpdf require high resources (cpu and ram) to generate the files. Thank you

Hello, I am sorry as we don’t have video tutorials. Can you please let us know on which step you are having difficulty. If the file are copied and the installer is access from browser, it will be straight forward then. Thank you

You can try php mail function or sendmail. OR you can try to check it with simple email. Thankyou

hmmm I tried php it does the same thing – I’ve looked through logs and can’t seem to find anything.. oh well I’ll figure it out.

You can try to print the email debug report by comment the line 188 & 191 in app/libraries/sim.php