Jump to content

Search the Community

Showing results for tags 'MySql'.

  • Search By Tags

    Type tags separated by commas.

  • Search By Author

Content Type


Forums

  • General Discussion
    • Website Management and Coding
    • Technology and the Internet
    • Philosophy, Politics, and Science
    • Art and Entertainment
    • Other Discussion
  • HelioHost
    • Questions
    • Customer Service
    • How You Can Help
  • HelioNet
    • News
    • Contact HelioNet

Find results in...

Find results that contain...


Date Created

  • Start

    End

Last Updated

  • Start

    End

Filter by number of...

Joined

  • Start

    End

Group

AIM

MSN

Website URL

ICQ

Yahoo

Jabber

Skype

Location

Interests

Found 206 results

  1. dt340a
    I have only just setup my account about 24hrs ago. I am able to log into the server remotely from home with the following: mysql -u dt340a -h dt340a.heliohost.org -p But I am having problem trying to log in from a different computer in college (times out when connecting). But both computers have been setup the same. I have enabled remote hosts through cPanel with %. So not really sure what the problem is. Any help would be great.
  2. Spencer
    Hey. I'm trying to make a banned user script. I want it so if a banned user trys to enter the chatroom, it brings them to a new page. My problem is, it acts like every user is a banned user... o.O Here is the part in the php code that gets the users "rank" from the db when they login. $row = mysql_fetch_assoc($result); session_register($row['rank']=$userlevel); Then here is the part of the code for the chatroom that checks if the user is a banned user or not: <?php session_start(); if(!session_is_registered(myusername)){ header("location:/login/main_login.php"); //This is just checking if the user is logged in or not. } if(session_register($userlevel=='banned')) { header("location:../banned.html"); } So that's it. Thanks. ~ Spencer
  3. jvicenci
    Hello! I'm trying to access MySQL server through my Mac's terminal. Any ideas how I can do this? I can use myphpAdmin no problem but I'ld like to be able to type my queries via my computer. What are the steps if any from the very beginning? 1. I have an account already. 2. I have a database set up already 3. I have a username/password associated to that database Any help would be appreciated. Thank you.
  4. Spencer
    Hey there! Recently, I have made a comment section on my website. It worked great, but to show who posted a comment, a user would have to type in who they are in the "Comment By:" inputbox. I don't want this anymore, due to users being able to impersonate one another. I want to make it show actually who posted it. ( Yes. I have a working register and login ). Here is my news:chatroom_first_priority.php code ( Note: I have removed the Comment By: inputbox and all the rest of that stuff. This is my attempted code. If needed, tell me you want to see my original code. ) : <?php session_start(); if(!session_is_registered(myusername)){ header("location:/login/main_login.php"); } $myusername = $_SESSION['myusername']; ?> <html> <head> <title>Mbox:News</title> <script> </script> <style> /*3DS SCREEN START*/ div#topscreen { position: absolute; top: 0px; left: 0px; height: 1300px; width: 320px; background-color:#1E90FF; z-index:2; } div#bottomscreen { position: absolute; top: 218px; left: 0px; height: 212px; width: 320px; background-color:#1E90FF; } /*3DS SCREEN STOP*/ /* WELCOME USERNAME STYLE START */ div#welcome_username { text-decoration:none; color:#000000; font-weight: bold; background-color:aqua; text-align:center; } /* WELCOME USERNAME STYLE STOP */ a.logout { text-decoration:underline; color:#000000; font-weight:bold; background-color:#FFFFFF; position:absolute; top:0px; left:250px; } a.home { text-decoration:underline; color:#000000; font-weight:bold; background-color:#FFFFFF; position:absolute; top:0px; left:5px; } a:link { color:#000000; text-decoration:underline; } a:visited { color:#000000; text-decoration:underline; } a:hover { color:#FF0000; text-decoration:none; } p.article_by { background-color:lime; text-align:left; font-weight:bold; } </style> <meta name="viewport" content="width=320"> </head> <body> <!-- TOP SCREEN --> <div id="topscreen"> <?php //echo "Welcome, " . $myusername . "!"; ( OLD CODE ) echo "<div id=\"welcome_username\">Welcome, $myusername ! </div>"; ?> <!-- WELCOME USERNAME PHP SCRIPT STOP --> <!-- REST OF STUFF DOWN --> <a href="../login/logout.php" class="logout">Log out</a> <a href="../homepage.php" class="home">Home</a> <!-- MAKE THE LINE BELOW THE WELCOME --> <br/> <hr/> <a href="/news/news.php"><img src="http://www.pokernewsreport.com/wp-content/uploads/2011/04/news-icon.png" style="width:75px; height:75px; position:absolute; top:60px; left:120px;"></a> <br/> <br/> <br/> <p class="article_by">Spencer:</p> <!-- ARTICLE START --> <p style="background-color:white;">This is just a test section for now</strong> <br/> <strong>~ Spencer</strong></p> <!-- ARTICLE STOP --> <hr/> <form action="/news/post_comment.php" method="post"> <table> <tr><td> </td><td><input type="hidden" name="comment_on" size="" readonly="readonly" value="<?php print md5($_SERVER['PHP_SELF']); ?>"/></td></tr> <tr><td>Comment: </td><td><textarea name="comment" cols=24></textarea></td></tr> <tr><td></td><td><input type="submit" value="Submit" /></td></tr> </table> </form> <?php $db_sitename="spencer_register"; $db_hostname="localhost"; $db_username="spencer_mega"; $db_password="PASSWORD HERE"; $no_of_comments="10"; /* Leave the script below as it is */ mysql_connect($db_hostname, $db_username, $db_password); mysql_select_db($db_sitename); $pagename=md5($_SERVER['PHP_SELF']); $query=mysql_query("Select * from comments where comment_on='$pagename' ORDER BY id DESC LIMIT 0, $no_of_comments"); echo "<hr />"; echo "<h3>Latest Comments</h3>"; while($fetch=mysql_fetch_array($query)) { echo "<p>".$fetch['comment']."<br/><sub><b>Comment by: </b>".$myusername."</sub><hr /><p>"; } mysql_close(); ?> </div id="topscreen"> <!-- BOTTOM SCREEN --> <div id="bottomscreen"> </div id="bottomscreen"> </body> </html> Here is my post_comment.php: <?php $db_sitename="spencer_register"; $db_hostname="localhost"; $db_username="spencer_mega"; $db_password="PASSWORD HERE"; /* Leave the script below as it is */ mysql_connect($db_hostname, $db_username, $db_password); mysql_select_db($db_sitename); $comment_on=$_POST[comment_on]; $comment_by=$_POST['$myusername']; $comment=$_POST[comment]; $query=mysql_query("INSERT INTO comments (comment_by,comment_on,comment) VALUES ('$myusername','$comment_on','$comment')"); if($query) { $ref=$_SERVER['HTTP_REFERER']; header("location: $ref"); } else { echo "Error when posting the comment."; } mysql_close(); ?> I actually know what I am doing wrong, but don't know how to fix it. myusername whatever the person types into the username login inputbox before logging in, to make it at the top say, Welcome, Username! So now, it will say all of the comments are posted by YOU. Thanks for the help! I appriciate it! ~ Spencer
  5. asnime
    Hello, I have a problem: I can't connect to MySql with the connector: ODBC <asp:SqlDataSource ID="DataSourceDato" runat="server" ProviderName="System.Data.Odbc" SelectCommand="select * from cosa" ConnectionString="DRIVER={MySQL ODBC 3.51 Driver};Server=localhost;Database=zarkios_prueba;User=zarkios_prueba;Password=***;Option=3;"></asp:SqlDataSource> And shows the next error: System.DllNotFoundException: libodbc.so at (wrapper managed-to-native) System.Data.Odbc.libodbc:SQLAllocHandle (System.Data.Odbc.OdbcHandleType,intptr,intptr&) at System.Data.Odbc.OdbcConnection.Open () [0x00000] in <filename unknown>:0 MySQL Client <asp:SqlDataSource ID="DataSourceDato" runat="server" ProviderName="MySql.Data.MySqlClient" SelectCommand="SELECT * FROM cosa" ConnectionString="Server=localhost;Database=zarkios_prueba; User=zarkios_prueba;Password=***;" /> And shows the next error: System.Configuration.ConfigurationErrorsException: Failed to find or load the registered .Net Framework Data Provider 'MySql.Data.MySqlClient'. at System.Data.Common.DbProviderFactories.GetFactory (System.String providerInvariantName) [0x00000] in <filename unknown>:0 at System.Web.UI.WebControls.SqlDataSource.GetDbProviderFactory () [0x00000] in <filename unknown>:0 at System.Web.UI.WebControls.SqlDataSource.GetDbProviderFactoryInternal () [0x00000] in <filename unknown>:0 at System.Web.UI.WebControls.SqlDataSourceView.InitConnection () [0x00000] in <filename unknown>:0 at System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect (System.Web.UI.DataSourceSelectArguments arguments) [0x00000] in <filename unknown>:0 at System.Web.UI.DataSourceView.Select (System.Web.UI.DataSourceSelectArguments selectArgs, System.Web.UI.DataSourceViewSelectCallback callBack) [0x00000] in <filename unknown>:0 at System.Web.UI.WebControls.DataBoundControl.PerformSelect () [0x00000] in <filename unknown>:0 at System.Web.UI.WebControls.BaseDataBoundControl.DataBind () [0x00000] in <filename unknown>:0 at System.Web.UI.WebControls.GridView.DataBind () [0x00000] in <filename unknown>:0 at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound () [0x00000] in <filename unknown>:0 at System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls () [0x00000] in <filename unknown>:0 at System.Web.UI.Control.EnsureChildControls () [0x00000] in <filename unknown>:0 at System.Web.UI.Control.PreRenderRecursiveInternal () [0x00000] in <filename unknown>:0 at System.Web.UI.Control.PreRenderRecursiveInternal () [0x00000] in <filename unknown>:0 at System.Web.UI.Control.PreRenderRecursiveInternal () [0x00000] in <filename unknown>:0 at System.Web.UI.Control.PreRenderRecursiveInternal () [0x00000] in <filename unknown>:0 at System.Web.UI.Control.PreRenderRecursiveInternal () [0x00000] in <filename unknown>:0 at System.Web.UI.Page.ProcessLoadComplete () [0x00000] in <filename unknown>:0 at System.Web.UI.Page.InternalProcessRequest () [0x00000] in <filename unknown>:0 at System.Web.UI.Page.ProcessRequest (System.Web.HttpContext context) [0x00000] in <filename unknown>:0 Am i doing something wrong?
  6. Sandip
    After customer filling the form, the form data will be send to mysql, and an email will sent to me with the last form data that customer submitted. All is working, but only the problem is in the email "last mysql data" is not going as inline text. So, how to do this? I am doing in PHP. In am new in PHP. Please help me. Sample code is given below. <?php define('DB_NAME', 'sandi565_form11'); define('DB_USER', 'XXXXXXX'); define('DB_PASSWORD', 'XXXXXXX'); define('DB_HOST', 'localhost'); $link = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD); if (!$link) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db(DB_NAME, $link); if (!$db_selected) { die('Can\'t use ' . DB_NAME . ': ' . mysql_error()); } //Start Posting the data in Mysql database from Form Input $value = $_POST['input1']; $value2 = $_POST['MAmount']; $sql = "INSERT INTO demo (input1, MAmount) VALUES ('$value', '$value2')"; if (!mysql_query($sql)) { die('Error: ' . mysql_error()); } //start print the database $data = mysql_query("SELECT * FROM demo ORDER BY ID DESC LIMIT 1") or die(mysql_error()); Print "<table border cellpadding=3>"; while($info = mysql_fetch_array( $data )) { Print "<tr>"; Print "<th>ID:</th> <td>".$info['ID'] . "</td> "; Print "<th>Input1:</th> <td>".$info['input1'] . "</td> "; Print "<th>MAmount:</th> <td>".$info['MAmount'] . " </td></tr>"; } Print "</table>"; mysql_close(); //end print the database on form processing page //start emailing the data date_default_timezone_set('Asia/Kolkata'); require_once('class.phpmailer.php'); //include("class.smtp.php"); // optional, gets called from within class.phpmailer.php if not already loaded $mail = new PHPMailer(); //$body = "gdssdh"; //$body = preg_replace("[\]",'',$body); $mail->IsSMTP(); // telling the class to use SMTP $mail->Host = "ssl://XXXXXXX.XXXXXXX.org"; // SMTP server $mail->SMTPDebug = 1; // enables SMTP debug information (for testing) // 1 = errors and messages // 2 = messages only $mail->SMTPAuth = true; // enable SMTP authentication $mail->SMTPSecure = "ssl"; // sets the prefix to the servier $mail->Host = "XXXXXXX.XXXXXXX.org"; // sets GMAIL as the SMTP server $mail->Port = 465; // set the SMTP port for the GMAIL server $mail->Username = "contact@XXXXXXX.com"; // GMAIL username $mail->Password = "XXXXXXX"; // GMAIL password $mail->SetFrom('contact@XXXXXXXX.com', 'HAL'); //$mail->AddReplyTo("user2@gmail.com', 'First Last"); $mail->Subject = "Halmira 469"; THE PROBLEM IS HERE WHEN I WANT TO SEND THE DATA AS INLINE TEXT TO EMAIL FROM MYSQL IT IS NOT WORKING. ONLY "PRINT THE DATA" IS SENDING TO EMAIL. HOW TO DO THIS? $body = 'Print the data'; mysql_connect("localhost","XXXXXXX","XXXXXXX"); @mysql_select_db("sandi565_form11"); $query["SELECT * FROM demo ORDER BY ID DESC LIMIT 1"]; $result = mysql_query($query); //while ($row = mysql_fetch_array ($result)) { // $mail->AltBody = "To view the message, please use an HTML compatible email viewer!"; // optional, comment out and test $mail->MsgHTML($body); $address = "XXXXXXX@gmail.com"; $mail->AddAddress($address, "user2"); //$mail->AddAttachment("images/phpmailer.gif"); // attachment //$mail->AddAttachment("images/phpmailer_mini.gif"); // attachment if(!$mail->Send()) { echo "Mailer Error: " . $mail->ErrorInfo; } else { echo "Message sent!"; } ?>
  7. gacanepa
    Hi there, Just wanted to let you know that the MySQL server in Johnny has been offline for at least 7 hours. (My website www.gabrielcanepa.com.ar is working fine though, except for a delay in displaying pages). Regards, gacanepa
  8. varundeboss
    Hi I have hosted a python web app which is throwing an error. /tmp/MySQL_python-1.2.3-py2.7-linux-x86_64.egg-tmp/_mysql.so: failed to map segment from shared object: Operation not permitted Can anyone explain what is going wrong?
  9. HiddenAdmiral
    Hey, I'm trying to use a MySQL database with remote access and I can connect to it fine. However, I'm getting a message saying I've reached "max_user_connections" with very few connections. Is there any way to change this value? Thanks, HiddenAdmiral
  10. ethanh
    I am connecting to my MySQL server using PHP and getting the error: Warning: mysql_connect() [function.mysql-connect]: Too many connections in file on line # Failed to connect to server: Too many connections I am using mysql_close() when I redirect or when the script stops. Why am I getting this error? Is there anyway to prevent this from happening?
  11. Sisteema
    Hello, Can you upgrade mysql to ver 5.5. ??? I've install very simple web app, and there is a problem with it. With ver 5.5, there's no problem. Regards Raphael
  12. deidyomega
    xeround is a MySQL web host, which works great. But when I try to call xeround from inside of my heliohost account, it doesn't work. I wrote a small script to test if xeround is up or not, and posted it on one of my servers, and heliohost servers. The code always reports good for my server, and always fails for yours. Could anyone give me a helping hand? (Hiliohost) http://expressivecomputing.com/testing/index.php (private server) http://expressivecomputing.homelinux.org:8080/sql/index.php The script, in case anyone cares: <?php $con = @mysql_connect("instance25706.db.xeround.com:16855","username","password"); if (!$con) { echo '<font color="red">Xeround Not Working</font><br /><br />'; } else { echo '<font color="green">Xeround Working</font><br /><br />'; } $con = @mysql_connect("expressivecomputing.homelinux.org","username","password"); if (!$con) { echo '<font color="red">Expressive Computing Internal Not Working</font><br /><br />'; } else { echo '<font color="green">Expressive Computing Internal Working</font><br /><br />'; } $con = @mysql_connect("direct.expressivecomputing.com","username","password"); // I use cloudflare, so don't mind the subdomain weirdness if (!$con) { echo '<font color="red">Hilio Not Working</font><br /><br />'; } else { echo '<font color="green">Hilio Working</font><br /><br />'; } ?>
  13. marcelfb
    Hi I'm developing a website that has been suspended twice now for causing too high MySQL load. It's a Drupal 7 site with a few relatively common modules installed + CiviCRM, PHP software for NGO's to manage members, contacts, donations etc. CiviCRM has its own MySQL database and it also interacts directly with the Drupal MySQL database (AFAIK). In the hope that it might help, I have updated Drupal and all modules to the most recent version (with the exception of CiviCRM). However I have no clue how/where I can see if the MySQL load has been reduced? The technical details of the site are: Before: Drupal 7.14, now Drupal 7.15 Modules installed as of today: Administration menu 7.x-3.0-rc3 Chaos tool suite (ctools) 7.x-1.2 Date 7.x-2.6 Entity API 7.x-1.0-rc3 Entity reference 7.x-1.0-rc3 Relation 7.x-1.0-rc3 Views 7.x-3.5 Wysiwyg 7.x-2.1 CiviCRM 4.1.2 The theme is a sub theme of Bartik with minor changes. Suggestions on how to analyse the problem and/or clues as to what might be causing them are very welcome. Thanks
  14. JavadRah
    hi i can`t believe this, but yesterday when i was opened my website(based on WP), i see a messeage: unable to connect to Database... when i go to my cPanel it show me there is no data in database and no user was added to database!!!! it mean all of my data is lose!!!! excuse me for my bad english... EDIT: The wordpress database user was not associated with the wordpress database.
  15. Coldwin
    I am trying to connect my mysql database via my computer and when I do i get this error. ySql..Data.MySqlClient.MySqlException (Ox8øøø4Aø5): User coldwinroot already ha nore than ‘nax_user_connections’ active connections at MySql.Data.MySqlClient.MySqlStrean.ReadPacket() at MyßqLflata..Myßqlclient .NativeDriver..AuthenticateNew(Hoolean reset) at MySql.Data.MySqlClient .NativeDriver.Authenticate(Boolean reset) at MyßqLflata..MyßqlClient.NativeDriver..Open() at MySql.Data.MySqlClient.Driver.Open() at MyßqLflata..MySqlClient.Driver..Create(MyßqlConnectionßtringBuilder settings ) at MySqLflata..MyßqlClient .MyßqlPool. ..ctor(MyßqlConnectionStringBuilder settin s) at MyßqLflata..MyßqlClient.MyßqlPoolManager..GetPool(MyßqlConnectionßtringBuild r settings) at MySqLData..MyßqlClient.MyßqlConnection..Open() at Phoenix.Storage.Classl. .ctor(Class2 Jianager) at Phoenix.Storage.Class2.nethod_ß() at Phoenix.HabboHotel.ClassS. .ctor(1nt32 conns) at Phoenix.Class4nethod_ø() at Phoenix.CClassø.llain(String[] args) My connection settings are, host name = stevie.heliohost.org database port = 3306 username = (my username hidden)_root database = (my database hidden)_hotel password = (my password hidden) Please help :-( I am not sure what's wrong :'( EDIT: Was trying to open more than max number of database connections at once.
  16. chglove
    i got an error when using mysql_connect() function, this is my code and error info: <?php $conn = mysql_connect('118.114.134.59:3307', 'test', '123456'); if (!$conn) echo mysql_error(); else echo "OK!"; ?> Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '118.114.134.59' (4) in /home1/chglove/public_html/test.php on line 2 Can't connect to MySQL server on '118.114.134.59' (4) but if i change the server port to 3306, mysql_connect('118.114.134.59', 'test', '123456'); it worked, and i can connect to my server use port 3307 from other sites, what's the problem? you can use http://blog.chglove.tk/test.php to see this error
  17. tswsabeer
    Does heliohost support remote mysql database hosting. Please Reply. I have project to complete.
  18. halison
    we have a problem in the php or mysql is returning 500 error on pages with mysql and php. which may be? -- ERRO Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, webmaster@infiniteisover.com and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. Apache/2.2.16 (Unix) mod_ssl/2.2.16 OpenSSL/0.9.8e-fips-rhel5 FrontPage/5.0.2.2635 mod_bwlimited/1.4 mod_auth_passthrough/2.1 mod_wsgi/3.3 Python/2.7.1 Server at infiniteisover.com Port 80 --- Tanks guys
  19. theepdinker
    Importing MySQLdb into Python appears to cause an error. The file below, when run, does not appear to get past the import MySQLdb statement. This is edited down from the Python example at Any ideas what I am doing wrong?(I am running on Stevie)output:here we go Code:#!/usr/bin/pythonprint "Content-type: text/html\r\n\r\n"print "here we go "try: import MySQLdb tx = 'successfully imported MySQLdb' print "out of try "except: tx = str(sys.exc_info()) print "except "print tx
  20. hyrum.clyde
  21. Deltac0
    Warning: mysql_connect() [function.mysql-connect]: User **** already has more than 'max_user_connections' active connections in /home1/*****/public_html/***** on line ** Failed to connect to server. I get this error when I'm trying to access my site. Hosted @ Stevie. When I quickly checked phpMyAdmin, it said that max user connections = 3. I think that is way too low number, even a little forum takes about 10.
  22. almaisyah
    Hello everybody, I'm interesting in online shop development with simple language like PHP and database like MySQL, especially built with Prestashop. It is easy to build and maintain because : 1. Open source 2. Community support 3. Excellent feature I hope we can discuss here, although you use another e-commerce software like OSCommerce, Magento, Zen Cart, etc. Regards, Alma
  23. aloz1
    Hello all I'm moving accross from a different free host and have made a backup of the database off of that host. I used phpmyadmin to do an export on the other host and now that I have moved over to you guys as a host, I am having problems importing the database. I am getting an access denied error that keeps popping up, and the username that it keeps saying is my default username. Just in case it is helpful in any way, I am on the stevie server. Thanks everyone
  24. aloz1
    Hello all I'm moving accross from a different free host and have made a backup of the database off of that host. I used phpmyadmin to do an export on the other host and now that I have moved over to you guys as a host, I am having problems importing the database. I am getting an access denied error that keeps popping up, and the username that it keeps saying is my default username. Just in case it is helpful in any way, I am on the stevie server. Thanks everyone
  25. deadmann
    Hello there, i'm new user, trying to connect to my sql with remote connection from my computer, through navicat application,... I already make a user name inside cPanel.. also allow my home ip, the public Ip google say, and in the end any thing domain % to access... i'm wonder if i try to connect with currect Port, but the thing i use is 3306. I receive : 2003 - Can't connect to MySQL server on 'stevie.heliohost.org' (10060) i also try the thing you see in attachment
×
×
  • Create New...