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.

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.

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

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

# 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.

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.

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

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.

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

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.

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