Question: My invoices is not working

My invoices is not working

My invoices is not working. When I click on sales, there is a blank screen. I looked at the sql database and there is nothing present. Please help.

HL

horace L

Asked
My invoices is not working. When I click on sales, there is a blank screen. I looked at the sql database and there is nothing present. Please help.
  • MS

    Mian Saleem

    Answered
    I am sorry to listen that you having issues. Please let me know if this is new install or update? If new install the database tables should be created with installation. The install instructions are in the help folder. If tables are already created that mean the installation was completed but there might be compatibility issue, please make sure that MySQL `only_full_group_by` mode is disabled.

    Blank pages errors are caused due to 500 internal server errors, you need to check your server error logs and let us know the error detail so that we can suggest solution.
  • HL

    horace L

    Answered
    Hi, yes it is a new install. All the database tables were create fine and everything is working perfectly, except the "sales" and "quotes" tables were not created. The tables of empty and this is why the error is showing.
  • HL

    horace L

    Answered
    So all I need it to the SQL date table for the "sales" and "qoute" for me to import them in.
  • MS

    Mian Saleem

    Answered
    If all other tables created then there should be sim_sales and sim_quotes tables too. If you are saying tables are empty. Then you can try to add quote. I just wanted to know what is your MySQL modes config? I am not very sure if it is due to mode but I strongly suspect. You can check mysql mode with query below
    ```sql
    # Get modes
    SELECT @@sql_mode;

    # Disable ONLY_FULL_GROUP_BY
    SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

    # Disable NO_ZERO_DATE & NO_ZERO_IN_DATE
    SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'NO_ZERO_DATE',''));
    SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'NO_ZERO_IN_DATE',''));
    ```
    Please restart mysql after this and check the modes again if the previous changes were saved or not then try to check your site. If still same, please email me server details to [email protected] so that I can check it for you.
  • HL

    horace L

    Answered
    Hi Support,

    Yes, I do have the tables sim_sales and sim_quotes tables, but there is nothing in there. Also, when I try to click on to "Add Invoice" and "Add Quote", I get a blank page. Also, when I click on "List Invoices" "List Quotes" I get the same blank page and I am not able to add invoices or quotes. Everything else works as I can add products and customers and the calendar is working fine as well.
  • HL

    horace L

    Answered
    Any chance you can only provide me with the info on those two tables for me to import that data table details?
  • MS

    Mian Saleem

    Answered
    I am sorry but what is the issue here? The tables are empty? So they should be for new install. You can add the quotations/sales. If you can't add quotations/sales. You need to let me know your php version, mysql mode as I told above and error from server error logs.

    If it was update, you should have backup to restore back. Update won't delete any data just modifies the tables where necessary.

    As I know you said you have blank screen on sales and you never share your error details from server error log. I will need the error details to suggest. I hope, I am making it clear for you now. If you have any question, please let me know.
  • HL

    horace L

    Answered
    It is a new install. I just get an empty screen and I do not see any error messages. Please check it out for yourself..

    http://www.coolpergola.com/order
    User= [email protected]
    Password= hello100
  • MS

    Mian Saleem

    Answered
    I will need 500 error details to suggest. Please check error logs. If you say there is no error in logs, ask host why 500 errors are not logged.

    You can enable app logs by changing the `log_threshold` in `app/config/config.php` to 1 and the visit the page to produce errors. The app logs will be in app/logs/ folder.

    You have not posted the of mysql modes.
  • HL

    horace L

    Answered
    Okay, I just gave you an invite to access my account. Please check it out.
  • Login to Reply