database not working with PHP

Discussion in 'Databases' started by malramahi, Jun 20, 2013.

  1. please i need to solve this problem below:

    I having a problem with my website.
    my system built on PHP and mysql database.
    the operation SQL statements (SELECT, DELETE) work without any problem, but when we try to use INSERT, UPDATE Statement we have problems, it doesn't work, without any error message retrieve.

    so I try something else ,I put our website in local machine (MY PC), and connect direct to your database . it work without any problems.

    and I try something else .I put all website on another host, and it work without any problems.
     
  2. ComputerMan

    ComputerMan Winhost Staff

    On our MySQL database we will remove the INSERT and UPDATE command if the MySQL database has reached it's quota.

    Can you check to see if the MySQL database hosted on our server is full? You should be able to check this in the control panel. If it is full try increasing the MySQL disk space quota.

    If you reached the limit then you might need to upgrade the hosting plan so it will allow you to increase the MySQL disk space quota. Read our knowledge base article on how to upgrade the hosting plan here: http://support.Winhost.com/KB/a502/how-do-i-change-the-plan-for-my-site-upgradedowngrade.aspx

    Otherwise you will need to delete things from the current MySQL database to increase disk space.

    Also, please allow up to one hour after increasing the disk space quote for the MySQL database so our system will allocate the permissions again.
     
    Last edited by a moderator: Oct 14, 2015
  3. my database usage 2 MB from 1 GB so my database is free .....
     
  4. ComputerMan

    ComputerMan Winhost Staff

    In that case maybe the problem might be coming from your ACL permissions.

    Did you recently upload your site using Web Deploy? If you did its a good chance that you may have misconfigured your ACL permissions.

    If you did contact our support department and ask them to reset your ACL permissions.

    Also, please read our knowledge base article on how to prevent this again here: http://support.Winhost.com/KB/a890/acl-was-altered-after-using-vs-web-deploy.aspx

    Or read our blog article here: http://blog.Winhost.com/how-to-stop-web-deploymsbuild-from-skewing-server-permissions/

    Have you tried connecting to the MySQL database directly using MySQL Workbench? http://support.Winhost.com/KB/a832/connect-to-mysql-with-mysql-workbench.aspx

    Then running the following query to see what permissions the MySQL database user has:

    SHOW GRANTS FOR CURRENT_USER;
     
    Last edited by a moderator: Oct 14, 2015

Share This Page