Databases Archive

  • drupal

    How to Reset Drupal Administrator Password?

    Posted on April 13, 2011 | No Comments
    Tweet There are two ways you can do to reset the Admin password. 1. Use the ‘Forgot password’ option to email you a new password.  This only works if you have setup an email to the account. 2. Access the database and update the users...

    Full Story

  • drupal

    Drupal: Chinese Characters in URL

    Posted on April 7, 2011 | 2 Comments
    Tweet Recently, we ran into a problem with Drupal when displaying Chinese characters or any non English characters (UTF-8) in the URL.   All the URL returned with a 400 Bad Request error along with a 403 Forbidden Error. e.g. Bad Request Your browser sent a...

    Full Story

  • MySQL Tables With UTF-8

    MySQL Tables With UTF-8

    Posted on April 6, 2011 | No Comments
    Tweet Here is how to properly setup your database to store and query UTF-8 characters 1. You will need to make sure your tables are setup to store UTF-8 values. e.g. show create table {tablename};  <– this will output table setup If you see the...

    Full Story

  • drupal

    PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062

    Posted on March 28, 2011 | No Comments
    Tweet Today, we came across a problem with Drupal.  Every time when we tries to add new contents, it is giving us the following error message PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’0′ for key 2 INSERT INTO {node}… At first, we thought...

    Full Story

  • Syntax error or access violation: 1226 User ‘username’ has exceeded the ‘max_questions’ resource (current value: 75000)

    Syntax error or access violation: 1226 User ‘username’ has exceeded the ‘max_questions’ resource (current value: 75000)

    Posted on March 23, 2011 | No Comments
    Tweet Recently, one of our CMS site receives the following error message: Syntax error or access violation: 1226 User ‘username’ has exceeded the ‘max_questions’ resource (current value: 75000) This is clearly an issue with our hosting company.  They have setup a MAX limits on the...

    Full Story

  • mysql

    How To Reset MySQL Password?

    Posted on October 28, 2010 | No Comments
    Tweet To reset the password for MySQL - First you will need to telnet into your server using a telnet client.  * For example, use the ‘Putty’ telnet to telnet into your server.  - Once logged in, type mysql -u root -p *  You will...

    Full Story

  • Oracle Database Errors

    Oracle Database Errors

    Posted on March 2, 2010 | No Comments
    Tweet If you are getting the following errors when trying to connect to your Oracle database. ORA-01034 ORACLE NOT AVAILABLE ORA-27101 SHARED MEMORY REALM DOES NOT EXIST Checklists to Check: -Check your TNANAMES.ORA and SQLNET.ORA files and make sure it is correct and  pointing to...

    Full Story

  • IPS Driver Error

    IPS Driver Error

    Posted on January 6, 2009 | No Comments
    Tweet IPS Driver Error Is you are getting this error, most likely there is some connection problem to the database. Check your settings. And lastly, check with your ISP. 99% of the time it is the ISP fault. Tweet

    Full Story