Nov 8, 2009

Forum SQL Error

free web hosting
Open Discussion & Free Web Hosting > Computers & Tech > Databases

Forum SQL Error

Shadow X
Hello everyone! Well anyway, i've just tried to go to my site narutoglobal.astahost.com and this comes up:

QUOTE
mySQL query error: SELECT moderator.mid as is_mod, moderator.allow_warn, m.id, m.name, m.mgroup, m.password, m.email, m.restrict_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track,
                              m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post,
                  m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, m.org_perm_id, m.temp_ban, m.sub_end, g.*
                  FROM astahost_members m
                    LEFT JOIN astahost_groups g ON (g.g_id=m.mgroup)
                    LEFT JOIN astahost_moderators moderator ON (moderator.member_id=m.id OR moderator.group_id=m.mgroup )
                  WHERE m.id=1

mySQL error: Too many connections
mySQL error code:
Date: Saturday 05th of November 2005 07:13:41 AM


Anyone who can help me please do. I'm really stuck on what to do.

 

 

 


Comment/Reply (w/o sign-up)

dhanesh
QUOTE(Shadow X @ Nov 5 2005, 07:16 PM)
Hello everyone! Well anyway, i've just tried to go to my site narutoglobal.astahost.com and this comes up:
Anyone who can help me please do. I'm really stuck on what to do.
*



Seems to be working fine there shadow .. i see your using mkportal .. hope that while installation you went carefully tru the install notes, including the parts where it needs you to replace certain portions of the code.

Overall... nice site ... and i dont see any SQL errors smile.gif

Regards
Dhanesh

Comment/Reply (w/o sign-up)

yordan
And it works nice from from my computer too, your site is really nice.
I could not post on your forum because I have no login, but everything seems to work fine.
However, if you really have 100 users, if all of them try to connect at the same time, you will experience the limitations of your free astahost account. Nevertheless, no problem, the people experiencing "too many connections" will simply have to try again later.
Regards
Yordan

Comment/Reply (w/o sign-up)

Shadow X
Okay I get it now. Thanks for the comments from both of you. And yes I fixed the problem, I don't think anymore SQL errors will come up again but thanks for the help! smile.gif

Comment/Reply (w/o sign-up)


Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)

Similar Topics

Keywords : forum, sql, error

  1. I Have An Error With My Mysql Connection
    mysql connection error (7)
  2. Sql Syntax Error [corrected]
    apostrophes missing (2)
    QUOTE #1054 - Unknown column 'Eggie' in 'where clause' i get that error when
    i type this in MYSQL CODE select bike from members where username=Eggie i have column
    bike,members and username... and i have information in every of those columns... but why does it say
    that there is no COLUMN because i said i want info from row where column 'username' is
    'Eggie' btw-YAY..my 101 post EDIT:sorry...i just solved it i forgot to put apostrophes
    CODE select bike from members where username='Eggie' ....
  3. Lost Connection To Mysql ,..., System Error: 111 In
    (3)
    While I was trying to connect to my database or even create one using PhP mySQL I was given the
    followoing error: Lost connection to MySQL server at 'reading initial communication
    packet', system error: 111 in Has somebody encontered a similar report? I have my database
    created using the cpanel together with a user name and password. I wonder if it is a server issue?
    What can you do if you have not access to the configuration files?....
  4. Do You Know Of Any Good Free WAP Enabled Forum
    Wap forum wheres a good free one (18)
    I'm not sure if this is the right section for this so please alert me or redirect this post to
    the right section. I own a wap site that is visited my nearly everyone in my country on a daily
    basis. What I would like to know is if its posible to put up a FORUM section on it and host it on
    ASTAHOST, also is the WAP forum a Sql type? i'm kinda new to this stuff, btw, the wap site is
    in php3 but i'm gonna use wml and upload it to ASTA for hosting because my other(use to be)
    server is advertising on my site. Is there a free(good) wap site forum availabe out ther....
  5. New MySQL Server & Blank Fields Problem With Jsp
    empty fields and data trancation error (0)
    New mysql server doesn’t take blank field through JSP code. If you write this code in jsp it will
    show error. String sqlInsertDateIntoTable = “insert into TableName values( “”,
    ‘”+request.getParameter(“inputFieldName”)+”’,’”+request.getParameter(“inputFieldName2”)+”’,’’)”;
    stm.executeUpdate(sqlInsertDateIntoTable); %> This code shows error , But in old alpha version of
    mysql allow the blank field for autoincreaments. Error shows of “Data truncation“ This can be
    easily remove by just write or add or table values in your query e.g String
    sqlInsertDateIntoTable = ....
  6. ~* Backing Up Forum & Database *~
    (10)
    Hello folks .. I started using IPB forums .. and i have a few queries i would like to ask ..
    Assume i have installed the forums with the database and its working now .. I have 50 users that
    have signed up .. now sumthing just comes up like reg problem ( happend recently with me and my
    previous installations got deleted ) well in that case the forum tables and catagories i have made
    plus the users that have signed up .. all these things i would like to back up .. Its like
    sumthing similar to a Norton Ghost Image .. lol .. i want to back up everything every month .. s....
  7. phpMyAdmin-MySQL Error #1251:client Authentication
    Stupid error (6)
    After I installed phpMyAdmin and tried logging in with the root password, I get this : #1251 -
    Client does not support authentication protocol requested by server; consider upgrading MySQL client
    I already installed mySQL administrator and enabled old passwords. Any help would be
    appreciated. Oh yeah I have : mySQL version 4.1.11-nt mySQL client 5.04 Apache 2.0.54 PHP 4.3.11
    phpMyAdmin 2.6.1-pl3....
  8. MySQL: Help Needed With MySQL_fetch_array() Error
    help needed (7)
    I have my site up and running, it it written in php but the problem im getting is the mysql database
    the warning is: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
    resource in /home/mrogers/public_html/config.php on line 47 but on line 47 it shows this: $email =
    mysql_fetch_array($adminemail); any one help on this + my site wont connect to my database. I have
    feeled out all the requirements that has asked and i know its write. All help would be apreciated
    as i would like my site fully functional by next week. /smile.gif" style="vertical....
  9. Help Needed With MySQL_fetch-array() Error
    (3)
    databasing is quiet hard to learn but im starting to get the hang of it. on my home page i have a
    few errors like this Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
    resource in /home/mrogers/public_html/html/nav.php on line 80 i have checked whats on line 80 and
    this is what i ended up with $row = mysql_fetch_array($sql); but it does not look like anything is
    wrong and i kind of do not under stand the mysql witch i am learning at the moment, but any one know
    what the problem is please tell me. need any more info like the whole .nav fil....
  10. How To Create Database...
    Database for forum (8)
    OK I got the script and hopefully I'll get my account back at astahost.. I just wana know how
    can I make the database for this forum.. I have ipb 2.0.4 script.. and how can I creat tables etc
    etc wwaiting for reply .. -----I changed your topic to a more descriptive title. You should
    never use undescriptive titles like the one you used, "How To..."-----szupie ....
  11. Rep Mods Needed
    I need a Reputation mod for my forum. (1)
    I need a Reputation mod for my forum site plz also include how to insert the mod in the Asta Forums.....
  12. Error In Installing MySQL Server
    MySQL server cannot be started (9)
    I try to upgrade my MySQL server from 4.018 to 4.1.10a. Firstly, I downloaded mysql-4.1.10a (not the
    essential one) for win XP Then I install the new version after the old version was uninstalled.
    After the installation process, Instance Configurator comes up to help for the configuration. But an
    error occured when it try to start the MySQL service. Error messageis "cannot create windows
    service for MySQL. Error:0" So my MySQL server cannot be started. It is running win XP on my
    computer. Does anybody can tell me what is wrong?. Thanks (sorry for my bad english)....
  13. Help To Build A Forum Site Without Ads
    Links to Forum Board Scripts (9)
    can anyone help me... cauz i am building a forum without ads for my class... and i wan them to have
    good communications with teachers... can anyone teach me how to make it?.......
  14. Error In MySQL ?
    (2)
    This message was in PHPMyAdmin! "The additional Features for working with linked Tables have been
    deactivated. PMA Database ... not OK General relation features Disabled" Can anyone give me a hint
    to what this means? Everything seems to be working just fine. All my tables are errorfree and I
    haven't got a clue! But I'm not comfortable with having an error /wink.gif"
    style="vertical-align:middle" emoid=";)" border="0" alt="wink.gif" />....
  15. No Record Found Error
    (2)
    I am trying to run the following asp function:
    code:-------------------------------------------------------------------------------- Private
    Function GetAbs(dThisDate, lPartID) sql_abs = "SELECT AbsCode FROM Absence WHERE AbsDate = '" &
    dThisDate & "' AND PartID = " & lPartID Set rs_abs = conn.Execute(sql_abs) GetAbs =
    rs_abs(0).Value Set rs_abs = Nothing End Function
    -------------------------------------------------------------------------------- It works fine if
    it finds a record but returns an error if it doesn't. How can I avoid this error? Thank....

    1. Looking for forum, sql, error

See Also,

*SIMILAR VIDEOS*
Searching Video's for forum, sql, error
advertisement



Forum SQL Error

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com