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

  1. Hello, I have tried to install IOMAD which is an edition of Moodle, but when checking the server information, there are points that have stopped at. I have currently set PHP version to 7.0, but can update to 7.2 if possible. It was not creating the database, so I tried to install Moodle from cpanel at softaculous, but it stuck for hours on the 95%, but it created the database, I tried to connect IOMAD to Moodle database, the connection is fine, but I could not find barracuda file format for each of the tables, what is available are compact and redundant. So the problem remained the same. Here are some details of the requests by Moodle & IOMAD 1- The most important point is that it requires Barracuda file format in the MySQL database. Without it, it cannot continue installation. 2- It prefers to have opcashe, I have seen that is was installed in another post and found that it is in php info, but actually Moodle is not identifying that it is enabled. I am using my account on heliohost with the username sola, the folder of installation in question is at /moodlebase. Would someone be able to help me in this? Thanks and best regards,
  2. Hi, I am struggling with my Phpbb forum database, any help would be appreciated. - I have uploaded my files by FTP in a directory: public_html/forum - I have imported my sql backup in PhpMyAdmin - I have edited my config.php file And I cannot connect to my forum, I have an Internal Server Error: http://greed-is-good.fr/forum/ In order to go further and check if I was doing something wrong, I have also installed Phpbb thanks to softaculous, in public_html/phpbb and here it is working fine, but I cannot find where the error is? In the config.php file there are some differences: - Mysql vs mysqli - @define('PHPBB_ENVIRONMENT', 'production'); Even if I change those lines I still have the issue, I also tried to change localhost to 127.0.0.1 Any ideas? Regards, G
  3. Hi! I just wanted to make a simple relationship between two basic tabes, that I've created. To make this action, I use "dbForge Studio for MySQL" but when I tried to create the connection, the software said the following: So, what to do? Your servers/setup do not provide to make foreign keys? Thanks for all!
  4. Dear all, Today I tried to access on my site (http://arkham19.heliohost.org/mb/), but unfortunately I've got an error: Error report: [Home]Could not initialize class com.mysql.jdbc.Driver StackTrace: java.lang.NoClassDefFoundError: Could not initialize class com.mysql.jdbc.Driver java.lang.Class.forName0(Native Method) java.lang.Class.forName(Class.java:264) beans.ConnectionManagerBean.connect(ConnectionManagerBean.java:47) beans.ConnectionManagerBean.getCon(ConnectionManagerBean.java:66) org.apache.jsp.index_jsp._jspService(index_jsp.java:198) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:458) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) java.lang.Thread.run(Thread.java:748) It 's very strange because I have not uploaded code updates and few days ago I could easily access to my site.I also tried to access the database from my local site with Eclipse and it work well. Can you give me assistance, please?Thanks in advance!
  5. Greetings! Created my first ever SQL database for my heliohost control panel and got number of questions(probably due to lack of enough knowledge or so). I can access my database from my control panels phpMyAdmin. But, is there any other method to do so? using any GUI, or Prompt, or anything of that sort! I simply dont wanna use phpMyAdmin.I rarely use PHP and use JDBC and ADO.NET to connect to my databases.Both JDBC and ADO.NET use a connection string of database configured with some user and password. - user: I have created and assigned to DB along with passwords! no problems here.What will be the connection string for both java JDBC and c# ADO.NET??????????Also, java uses drivers to connect to the databases due to common set of classes. So, is there any need to have this driver to my control panel account?Basically, when using Apache Tomcat server with java, Driver files are placed in "lib" of the Tomcat(locally). WHAT IS THE PROCEDURE FOR Cpanel. Please help me through it asap. Even i would love if someone speaks more on the topic, beyond the points I mentioned 'cz I might have missed something!!! Also, I have read the documentations on MySQL but am unable to find any particularly satisfying solution or support! Please support! Thank you!
  6. Hello, yesterday everything was working fine but today I can't add or edit data in my database. I am getting error: table fotot is in read only mode. Any idea how to fix that? Thanks
  7. Hi I have this website questioninmind.com from couple of days my login was not working after that i was busy in some other task so not able to debug the issue ,now today when i saw my website only not responding when i check after login into the cpanel databse showing no record. Can someone please help em resolve the issue?
  8. I'm testing a remote connection to my Mysql DB and table. I followed the basic procedure: 1 - I created DB ("employee101") by Mysql wizard. 2 - I created employee_data table by Myphpdamin. 3 - I created two DB users ("hazak" (cpanel user) and "remcon". 4 - I set users access and rights to "employee101" DB. 5 - I built two PHP scripts to remotely access Db and table, and put them in "hazak" public_html directory, as follows: 1 - conn.php (connection): <?php$db_name = "hazak_employee101";$mysql_username = "hazak";//$mysql_username = "remcon";//$mysql_password = "&cx=Q******";$mysql_password = "al********";$server_name = "localhost:3306";$conn = mysqli_connect($server_name, $mysql_username, $mysql_password, $db_name);if($conn){echo "connection success";}else{echo "connection not success";}?> 2 - login.php (login): <?php require "conn.php";$user_name = $_POST["user_name"];$user_pass = $_POST["password"];$mysql_qry = "select * from employee_data where username like '$user_name' and password like '$user_pass';";$result = mysqli_query($conn, $mysql_qry);if(mysqli_num_rows($result) > 0){$row = mysqli_fetch_assoc($result);$name = $row["name"]; echo "login success - user ".$name;}else{echo "login not success";}mysqli_close($conn)?> 6 - Remotely run the script. First using "hazak" user set in conn.php and second, using "remcon" user in the same script. I got the same error message (bellow) and when I created an email acoount to "hazak" (cpanel) user the message gone away and I could remotely connect to DB and access "employee_data" table. but the same didn't happened to the "remcon" user. Since I could't find reference to this error on heliohost.org Mysql pages I´m not sure about what is the error cause. Can anybody tell the possible cause/solution for this error and help me? Error message: Warning: mysqli_connect(): (HY000/1045): Access denied for user 'remcon'@'localhost' (using password: YES) in /home/hazak/public_html/remcon/conn.php on line 8
  9. username: goark server: ricky main domain: ping.usehype.ga Could you please increase max_user_connections? Thank You.
  10. johnny.heliohost.org I'm trying to connect mysql from node. It shows InnoDB is in read only modewhen I write/update/drop tables. Please help. It was working properly before. Suddenly it started showing this error.
  11. Hi. I'm bfpsw on johnny. I'm trying to modify the length of a column in a table of my database (bfpsw_jaw) using phpMyAdmin, but the response is: "#1874 - InnoDB is in read-only mode". It seems it is not possible to rename the table; if I try to drop it, the error is: "#1051 - Unknown table bfpsw_jaw.UTENTI". Can you help me? Thanks
  12. I'm making a login system for Unity, and I'm using your hosting website for online testing because it worked in localhost. I uploaded my 2 PHP files that are attached on the bottom and then when I test the login system in Unity it says "Empty" on the registration and "Username or Password cannot be empty." which means that $_REQUEST is not getting any information from the game. I would like a quick answer on how to fix this (it is not an error in the code, definitely) login.php register.php
  13. Hi. I wrote some SQL statements, referencing table names in uppercase. When my java code tries to execute them, an error is send, telling that table name does not exist. I also saw that in phpMyAdmin table names are in lowercase. Is there a way to reference them in uppercase (or in a not case sensible way)? Thanks
  14. Hi I've been trying to make a windows desktop application with visual studio using C# and i'm having trouble connecting to the mySQL database. my connection string is "Database=jackt_database;Address=johnny.heliohost.org;User Id=jackt_un;Password=*******" (obviously password isn't *******) the user ID has been added to the database and has been given all privileges. I've added the wildcard "%" to the remote mySQL section to allow connections from all IP addresses. I've tried resetting the password and changing it in my code multiple times. It is 100% not the code because i have tested it using a different host and it worked. // sql server connection here string constring = "Database=jackt_database;Address=johnny.heliohost.org;User Id=jackt_un;Password=********"; SqlConnection sqlcon = new SqlConnection(constring); try { sqlcon.Open(); MessageBox.Show("sqlconnection successful"); } catch (Exception error) { MessageBox.Show(error.ToString()); } finally { sqlcon.Close(); } i get the error "a network related or instance specific error occurred while establishing a connection to SQL server. The server was not found or was not accessible. Verify that the instance name is correct and that the sql server is configured to allow remote connections." later in the error it says "the network path was not found". Any help would be greatly appreciated. Cheers Jack
  15. Hi, Is create user syntax allowed when i execute that statement? I wanted to allow a user to be registered on MySQL (not thru cpanel) so that the max_user connection will not show in the future.
  16. That is, there is a certain select query, it is necessary to determine when the last time it was found. the value fell into the sample. Of course we can : Create a Timestamp field = on update_current_timestamp field than update any field, but the user has only the Select Privileges. Is it possible to somehow realize?
  17. Hi, I've activated remote mysql from CPanel, setting IP adress as % . However, on SQLYog (a MySQL client for Windows) when I execute a query I got this error: Query: USE `maicol_gamer` Error occured at:2017-12-09 19:09:04 Line no.:16 Error Code: 1044 - Access denied for user 'maicol07_user'@'%' to database 'maicol_gamer' Do you know how to solve this? Thanks!
  18. Incorrect Disk Usage showing up for MySQL, It says 2807MB of space in mySQL but the highest file size i have as shown in PHPMyadmin is not that. Is there some trash which is not emptying? Please help me out, I'm attatching the screenshots here.
  19. Trying to change password for mysql user The MySQL server is currently offline. Any help would be appreciated
  20. I've setup free website with heliohost.org. Though the website works well from browser, it is not working from android apk through 'HttpURLConnection' Actually the page that updates mysql database is not working. I want to know that this free hosting allow us to connect mysql from android apk ?
  21. I want to access the SQL DB to my local machine for reporting so I was finding hostname for my Mysql server. May anyone letme know where I may get?
  22. username : skarthi1 server : http://skarthi1.heliohost.org:12143/ commands to execute "sudo gem install bundler" "sudo gem install mysql" "bundle install --local" "rake db:create" "rake fedena:plugins:install_all" "script/server"
  23. Hi, I'm having a problem connecting users simultaneously. is it possible to set MAX_USER_CONNECTIONS to 30? or 15? if the answer is yes, how can I do this? i'm using a Jhonny , host: midas.heliohost.org email rogiviela@gmail.com tnks
  24. Hi, I have some PHP pages (from my last topic: https://www.helionet.org/index/topic/28805-dropdown-with-mysql-tables-names-of-a-database-as-options-and-php-mysql-errorssuggestions/) that integrates MySQL that don't work very well... here are my problems: If you go on http://apps.maicol07.tk/app/sld/voti/ and you register/login you can see what doesn't work... When you click on the pencil or the trash button (after you have inserted a new record with the + button on the right-bottom of the screen) it gives this error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE id=1' at line 2 SQL QUERY: SELECT * FROM $materia WHERE id=$id; The dropdown in the view.php (or view-paginated.php) file it is blank (except the first option that I've added) while on XAMPP it works... The table of view.php doesn't work on Tommy, while on XAMPP it works.Source Code: http://s000.tinyupload.com/index.php?file_id=87380380194489995693 Thanks
  25. Hi, I'm trying to build a dropdown in a form with, as options, the names of the tables of one database. How can I do? This is my script, it doesn't work: there isn't the dropdown... <form method="get"> <?php // database connection include('connect-db.php'); $result = mysql_query("SHOW TABLES") or die(mysql_error()); ?> <select name="select1"> <?php while ($line = mysql_fetch_array($result)) { ?> // The database I choose is "members", as can you see in the code below <option value="<?php echo $line['Tables_in_members'];?>"> <?php echo $line['Tables_in_members'];?> </option> <?php } ?> </select> <input type="submit" class="btn waves-effect waves-light" value="SEND"> </form> connect-db.php <?php /* CONNECT-DB.PHP Allow PHP to connect to the database */ // Database variables (I'm trying on XAMPP) $server = 'localhost'; $user = 'root'; $pass = ''; $db = 'members'; // Database connection $connection = mysql_connect($server, $user, $pass) or die ("Impossible connecting to the server ... \n" . mysql_error ()); mysql_select_db($db) or die ("Impossible connecting to the database ... \n" . mysql_error ()); ?> Thanks
×
×
  • Create New...