Database Error.

Discussion in 'MySQL' started by superrichguy, Aug 31, 2007.

  1. #1
    I run a dating site and now when you type in the url it just says

    "error database access error. "

    The email i got is this:
    Error in /guestbook.php: User 'my_username' has exceeded the 'max_questions' resource (current value: 50000)
    Query: '
    SELECT ProfileMemLevels.IDLevel as ID,
    MemLevels.Name as Name,
    UNIX_TIMESTAMP(ProfileMemLevels.DateStarts) as DateStarts,
    UNIX_TIMESTAMP(ProfileMemLevels.DateExpires) as DateExpires

    FROM ProfileMemLevels
    RIGHT JOIN Profiles
    ON ProfileMemLevels.IDMember = Profiles.ID
    AND (ProfileMemLevels.DateStarts IS NULL
    OR UNIX_TIMESTAMP(ProfileMemLevels.DateStarts) <= 1188567772)
    AND (ProfileMemLevels.DateExpires IS NULL
    OR UNIX_TIMESTAMP(ProfileMemLevels.DateExpires) > 1188567772)
    LEFT JOIN MemLevels
    ON ProfileMemLevels.IDLevel = MemLevels.ID

    WHERE Profiles.ID = 0

    ORDER BY ProfileMemLevels.DateStarts DESC

    LIMIT 0, 1'


    Now when I went to my phpmyadmin thing it says no databases and comes up with:
    Error
    SQL query:

    SELECT USER( ) ;



    MySQL said:

    #1226 - User 'my_username' has exceeded the 'max_questions' resource (current value: 50000)



    Does anyone know what I can do?
    Thanks a bunch

    Jason
     
    superrichguy, Aug 31, 2007 IP
  2. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #2
    It means that you have a limit of 50000 queries which you can run within a time period, maybe an hour or 24 hours. To overcome this, you can:

    1) Reduce the number of queries.

    2) Create another database user and modify your application to split the queries across more than one database user.

    3) Move to a higher hosting plan.
     
    Kuldeep1952, Aug 31, 2007 IP
  3. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #3
    How low is your hosting plan?
     
    gibex, Sep 2, 2007 IP