Search the Community

Username "jimbo1qa". My site is jimmyli.org , the domain expired, now in the process of moving to jimmyli.ro.lt until the domain's renewed. Since the Stevie crash, I have been getting MySQL errors with my Drupal install. First error -1, then odd errors: Warning: Cannot modify header information - headers already sent by (output started at /home1/jimbo1qa/public_html/drupal/includes/common.inc:2700) in drupal_send_headers() (line 1217 of /home1/jimbo1qa/public_html/drupal/includes/bootstrap.inc). PDOException: SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] =&--#62; 0 [:db_insert_placeholder_1] =&--#62; cron [:db_insert_placeholder_2] =&--#62; Attempting to re-run cron while it is already running. [:db_insert_placeholder_3] =&--#62; a:0:{} [:db_insert_placeholder_4] =&--#62; 4 [:db_insert_placeholder_5] =&--#62; [:db_insert_placeholder_6] =&--#62; http://jimmyli.org/drupal/ [:db_insert_placeholder_7] =&--#62; [:db_insert_placeholder_8] =&--#62; 50.136.155.136 [:db_insert_placeholder_9] =&--#62; 1403240068 ) in dblog_watchdog() (line 160 of /home1/jimbo1qa/public_html/drupal/modules/dblog/dblog.module). Will this get fixed? Second problem: In my attempts to recover from the database crash, I downloaded a SQL backup. Then I attempted to create a new database to reupload to. Oddly, when I create in cPanel MySQL, it doesn't show up in phpMyAdmin, and when I use a SQL command to create in phpMyAdmin, I cannot access or delete it from cPanel . Now I have an unwanted empty database named jimbo1qa_666 that needs to be deleted. Do NOT delete jimbo1qaz_drup666. Is there any explanation for the invisible databases? 3. After successfully importing to jimbo1qaz_drup666, I cannot create a database user because cPanel does not "see" that database. This depends on the invisible database issue being solved. As a worst-case workaround, is there a way to set up MySQL users from phpMyAdmin?

Hi I Want To Know What is the data base server Name of my sql on heliohost. i want to connect my jsp file with my sql, What to write at Connection connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1/" + mysql_database,mysql_username,mysql_password) what is databse server name here. to write at place of mysql://127.0.0.1.

DELETED

Recently my php scripts to access a MySQL database have stopped working. All pages that try to do this only show an error saying that it can't log into the MySQL server. When I tried going into phpMyAdmin, I got a 1045 error. I tried changing the password for the database user, but it wasn't recognizing the old password. I then made a new user and added it to the database, and tried again, but no luck. (when I tried changing the password for the new user, it also told me the old password was invalid) I've no idea what's going on with the password system, but nothing seems to be working... Any suggestions? Thanks

This topic is a reference for those having problems with the MySQL server on Stevie. Due to a crash in February, Stevie's MySQL server has been experiencing frequent errors and downtime. There are a variety of error codes and problems, and the solutions to each are different. Common Issues Error -2002 ("Can't connect to local MySQL server...") Issue: You're receiving Error -2002 or a message saying you cannot connect to the database server when you try to use certain mysql applications or when you try to log into PhpMyAdmin. Solution: The server is down. Wait several minutes and try again. The server goes down very frequently due to the damage associated with the crash in February, Error -2013 ("Lost Connection during query...") / Database error installing software / Error editing tables in PhpMyAdmin Issue: You receive error -2013 or a message saying the connection was lost during a database query when executing queries in phpmyadmin, when restoring a backup, or when installing various software. This error is caused by attempting to create or modify a database table (or data within the table) that uses the InnoDB storage engine. InnoDB was damaged during the server crash in February. As a result, you cannot edit the data within a table, nor can you create/alter/drop InnoDB tables (or drop any database containing these tables). Instead, you will need to use MyISAM for all database tables. Solution: Solutions vary for this issue. For software installation issues, you will need to seek help from the software developer on how to modify the installer to use MyISAM database tables. If you are trying to edit an existing database table, see the solution for "My site works, but I get database errors when I try to edit my content". If you have a backup that you want to restore, make a copy of your backup's .sql file, then use the solution for "My website works but I get an error when I edit my content", starting at Step 2. My site works, but I get database errors when I try to edit my content Issue: Your application is probably using InnoDB tables in its database. To check if this is the case, log into PhpMyAdmin from cPanel, then select the database for your website. In the list of tables on the right side, look for InnoDB under the Engine column. Solution: If this is the issue, you can convert your database to use MyISAM instead of InnoDB. To do this: Make a backup of your database through cPanel or phpmyadmin. You want a plain text (.sql) file. Open your new backup file in a text editor, then use the "find and replace" feature of your editor. Find all ENGINE=InnoDB and replace them with ENGINE=MyISAM Save and close the backup after editing. Create a new database in cPanel, then import the edited backup file into it using cPanel or phpmyadmin. Assign your website's database user to the new database in cPanel. Edit the config file for your website to use the new database. The exact procedure will vary based upon which software you use. Consult its documentation for information on setting the database name. Ignore the old database. Do not attempt to drop it. Roundcube and Horde don't work Issue: Roundcube and Horde use a database with InnoDB tables to track users and mail. Because of this, they won't work without InnoDB functioning correctly. The issue manifests as either a database error or an infinite redirect in Roundcube, and a "not authorized" message in Horde. Solution: Use another webmail client. Softaculous does not work properly Issue: Softaculous and many of the software programs it can install rely upon InnoDB database tables. Installation of software may not work properly. Any installations performed will not be displayed in Softaculous and cannot be removed through Softaculous even if the software installed successfully. This issue is most commonly seen when installing WordPress (one of the most frequently installed choices), although many other applications will cause errors as well. Solution: Install applications manually. If you wish to remove an application and the installation does not appear in Softaculous, simply remove the installation through conventional means. I dropped my database and now it appears in PhpMyAdmin but not in cPanel. Issue: These "half-dropped" databases result from attempting to drop a database containing InnoDB tables. Attempting to drop these databases also sometimes causes ~10 minutes of MySQL downtime for the server. Solution: Just ignore the unwanted database. There is no fix at this time. When the server has been repaired, an admin will be able to drop these databases for you. We recommend that you do not attempt to drop databases containing InnoDB tables at this time. By not trying to drop them, you will be able to drop them yourself when the server has been repaired. If you are experiencing a problem not described here or need additional help with the solution, please create a new topic in Customer Service.

It looks like after this 'A Dns Entry For Professionalserver.tk Already Exists' problem, I don't have now a capacity to upload my "phpDolphin.sql" file using the import function available in MySQL database.. This is what happened after uploading that SQL file: Can somebody fix my new issue? This problem is not existed when I'm in Johnny server. Okay here is what happening when I Check DB: MySQL Databases Checking Database mbdungo_phpdolphin is now being checked. mbdungo_phpdolphin.admin Error : Table 'mbdungo_phpdolphin.admin' doesn't exist status : Operation failed Check Complete

Can't access phpmyadmin nor mysql on website , i got error #1045 Cannot log in to the MySQL server,when i want to access phpmyadmin and mysql on website doesnt work, also before this i got website error that my webiste is using too much heliohost resources, i need to at least ,export my data from database tnx User: plavo Server: steve

My vb.net application won't open connection with MySql server, please help :(/&--#62;

Hello, I have a problem with MySQL innoDB tables. This happens after Stevie was crashed. Now all InnoDB tables are not accessible with error message: Unknown table engine 'InnoDB'. Thanks in advance!

I created a DB and user but when I run the PHP script I get the error Access denied for user 'waltp_waltp'@'localhost' to database 'waltp_infobase' The command executed is mysql_select_db($dbname) or die(mysql_error()); Did I not set up the DB or user correctly? the script is http://pattinson.heliohost.org/wjp/celeb/celebMake.php

Greetings, I have enjoyed fantastic hosting for the past year with your hosting service, my fansite, CastleWorld. http://castleworld.heliohost.org/ Of late I cannot connect to the site, at first I figured I hit it during downtime but days later it's still down. I am able to ping the site via the command prompt and can access it via ftp and the CP. The problem is in the browser, when I try to access it I get the following error "Database connection error (2): Could not connect to MySQL.". Now I did some looking online and this is a common error caused by misinformation on the configuration.php file, thing is though, I haven't modified the site in a month and after checking the file everything seems to check out. Then I checked the CP and for my Joomla database it shows a size of 0.00MB which leads me to believe someone deleted it somehow. Nobody besides me administrates the site and I beleive I took proper security measures when setting up the database and site. This leads me to ask, did you at helionet somehow end up deleting my database? Am I missing something? What could have happened to it? Did someone do this because I sometimes forgot to log into the CP monthly? Please help. Edit: I just tried logging into my phpmyadmin and got error #1045 Cannot log into the MySQL server, could the problem be on your end?

Hello, i'm trying to connect to mysql but i can't. I am getting this message: Error SQL query: Edit Edit SET CHARACTER SET 'utf8'; MySQL said: Documentation #2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) The server is not responding (or the local server's socket is not correctly configured). This start to happen after i tried to run some new queries username: cmtiger server: johnny

Hey, I've recently started a demonstration project for a class; I'm creating a web app in PHP, and I keep randomly running into "Internal Server Error"...nothing is being output to the error logs, and I can't figure out what's even causing this to happen. It's not a single specific script that causes this, I've gotten them on almost every page at some point. After waiting about a minute or so, it goes away, and the exact same page or script runs correctly... What are common causes of an issue like this? Thanks

Creating MySQL Database and User Learn How to Create MySQL Username and Database Creating a MySQL database with cPanel, which is included in all of SiteGround's hosting plans, can be easily accomplished. In order to create a MySQL database on your hosting account, you need to log in cPanel. In order to create a new database you need to enter the desired name for the database in the New Database field and click on the Create Database button as shown below: A confirmation screen will be displayed, informing that the database has been successfully created: You can click on the Go Back button to return to the database management screen. Click Submit to save your MySQL username. You will be redirected to a screen where you will be prompted to choose the desired privileges. It is advisable to select All Privileges and click on the Make Changes button: Using the MySQL Database Wizard All of the steps above can be accomplished using the MySQL Database Wizard. Click on it and you will be guided trough all steps that you should perform in order to successfully create a new MySQL database and add a user to it. Credits : SiteGround.com : For Complet Tutorial Step by Step .

Plz help me. I want to remotely connect my database via php, for that i need database server address. How can i find that?

upload my printscreen fails ... url: pacifictrashvortex.heliohost.org ftp is running, as website. i can't connect to mysql using dreamweaver, cause the connection returns me the following error: MYSQL Error 1129 host 'MYHOSTNAME INDICATED AS DHCP' is blocked because many connectios errors; unblock with 'mysqladmin flush-hosts' i've created my database i've imported regularly my existing tables i've created my users i've allowed by '%' remote hosts to access to my database why i can't connect dinamically my pages? please help me thaks in advance p.s. why uploading images usually fails?

I'm trying to create a new database for Drupal, but I'm getting a "Mysql server currently offline" error message when going through cPanel. Same issue when using Database Wizard. Update: Mysql appears to functioning correctly as of 12:04pm CST.

Hello. I couldn't figure out if this belongs in the questions section or customer support, so I apologize if it's in the wrong place. When I tried to view my database created in cPanel, I couldn't find it, so I ran softalicious/joomla to automatically create a database, and I cannot view that one either. All I can see is information_schema. I also cannot see the panel on the left which lists the databases, I don't know if that is intentional or not. (screenshot: http://oi40.tinypic.com/1zgg854.jpg) I am trying to import my database from my old host, so I can move my website, but I keep getting this error. .sql backup says: Error SQL query: -- -- Database: `****x10h_******` -- -- -------------------------------------------------------- -- -- Table structure for table `***_assets` -- CREATE TABLE IF NOT EXISTS `ima_assets` ( `id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `parent_id` int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Nested set parent.', `lft` int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.', `rgt` int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.', `level` int( 10 ) unsigned NOT NULL COMMENT 'The cached level in the nested tree.', `name` varchar( 50 ) NOT NULL COMMENT 'The unique name for the asset.\n', `title` varchar( 100 ) NOT NULL COMMENT 'The descriptive title for the asset.', `rules` varchar( 5120 ) NOT NULL COMMENT 'JSON encoded access control.', PRIMARY KEY ( `id` ) , UNIQUE KEY `idx_asset_name` ( `name` ) , KEY `idx_lft_rgt` ( `lft` , `rgt` ) , KEY `idx_parent_id` ( `parent_id` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =56; MySQL said: Documentation #1046 - No database selected XML backup says: Error SQL query: &--#60;?xml version="1.0" encoding="utf-8"?&--#62; &--#60;!-- - phpMyAdmin XML Dump - version 3.5.5 - http://www.phpmyadmin.net - - Host: localhost - Generation Time: Aug 04, 2013 at 03:56 PM - Server version: 5.1.68 - PHP Version: 5.3.22 --&--#62; &--#60;pma_xml_export version="1.0" xmlns:pma="http://www.phpmyadmin.net/some_doc_url/"&--#62; &--#60;!-- - Structure schemas --&--#62; &--#60;pma:structure_schemas&--#62; &--#60;pma:database name="****x10h_******" collation="utf8_general_ci" charset="utf8"&--#62; &--#60;pma:table name="ima_assets"&--#62; CREATE TABLE `ima_assets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set parent.', `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.', `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.', `level` int(10) unsigned NOT NULL COMMENT 'The cached level in the nested [...] MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&--#60;?xml version="1.0" encoding="utf-8"?&--#62; &--#60;!-- - phpMyAdmin XML Dump - version 3' at line 1

Hello, Everyone. I'm having problems with my CGI executable on my site. It gives HTTP 500 Internal Server Error while I have no access to any detailed logs to be able to troubleshoot the problem. It works well on my computer. The permissions of the file are set correctly (755). And another "Hello, World!" CGI program works perfectly on the server. It seems to me that this is a linking issue. Here are the details of the executable: The executable is linked with the following libraries: Source Code: #include <iostream> #include <mysql.h> using namespace std; const string CRLF = "\r\n"; int main() { cout << "Content-Type: text/plain" << CRLF << CRLF; cout << "Hello, World!" << CRLF; try { cout << "MySQL Client Version: " << mysql_get_client_info() << CRLF; } catch(exception& ex) { cout << "ERROR: " << ex.what() << CRLF; } return 0; } Compiled Using: gcc 4.7 with the following specifications: Makefile: #Variables: INCLUDE_DIR = -I/usr/local/mysql/include LIBS_DIR = -L/usr/local/lib64 STATIC_LIBS = -lmysqlclient DYNAMIC_LIBS = -ldl -lpthread -lrt STATIC_LINK_FLAG = -Wl,-Bstatic DYNAMIC_LINK_FLAG = -Wl,-Bdynamic LD_FLAGS = $(LIBS_DIR) $(STATIC_LINK_FLAG) $(STATIC_LIBS) $(DYNAMIC_LINK_FLAG) $(DYNAMIC_LIBS) #Rules: test.cgi: test.cpp g++ test.cpp $(INCLUDE_DIR) $(LD_FLAGS) -o test.cgi

I am getting this error when accessing the homepage of my heliohost site: I checked my 'config.php' file and made sure that the the db name, db user, the password, and the server (stevie.heliohost.org) was correct. I also added the user to the database I created. What could be wrong? Any ideas? Thanks in advance

So i just reccently got acsess to my control panel on the johny server(however my account still needs to be activated, whatever that is), now i was messing around with mysql, and just after the account was setup, phpmyadmin was working just fine. However after i imported a databse into it, i have recieved this error every time i try to start it: Error SQL query SET CHARACTER SET 'utf8'; MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: NO) Now the mysql database must be working, because i can still connect remotely trough a client that perodically inserts some values into the database. However it is a nussance that phpmyadmin doesn't seem to work.

I am new to web development and I am having some problems figuring out how to deploy databases to the heliohost servers. My account is on johnny as I am doing ASP.NET development. I am trying to either deploy a local database to my heliohost account, or start a remote connection to the heliohost database and work with that directly. I tried to create a connection to johnny in mySQL workbench, but have been having problems. I created a new server instance to johnny and that seems to have worked. Then I attempted to create a new DB connection. This seemed to work as well, but then I attempted to create a new model, created a single table as a test and tried to forward engineer this and export the table but keep getting errors: It successfully connects to the DDMS, but when it tried to Execute Forward Engineered Script I get an error: I was wondering if anyone has any idea what I might be missing or what I should try to get this to work? Just to update this, I realized that I had not associated the user with the tstewart_test database on heliohost, but after doing this and giving it full privileges it still did not work.

First I would like to say thank you for all of your time and effort for providing us with such a wonderful service. When trying to access my site I get this error: Unknown storage engine 'InnoDB' [1286] When I checked the engines tab in phpmyadmin it showed MyISAM MyISAM storage engine MRG_MYISAM Collection of identical MyISAM tables MEMORY Hash based, stored in memory, useful for temporary tables BLACKHOLE /dev/null storage engine (anything you write to it disappears) CSV CSV storage engine InnoDB Supports transactions, row-level locking, and foreign keys ARCHIVE Archive storage engine PERFORMANCE_SCHEMA Performance Schema FEDERATED Federated MySQL storage engine And when clicking on the InnoDB entry I am told: InnoDB Supports transactions, row-level locking, and foreign keys This MySQL server does not support the InnoDB storage engine. There is no detailed status information available for this storage engine. So it would seem that there is no InnoDB engine preent in the database. However , in order for me to recieve the initial error Unknown storage engine 'InnoDB' [1286] InnoDB would have had to have been present when the database was written, and now it is not. In order for me to resolve this error I must delete all log files and restart the mysql database. How would I be able to do that? Thanx again .

Hi, I will appreciate any help possible. Details: mysavings.heliohost.org Currently getting error: Failed to find or load the registered .Net Framework Data Provider 'MySql.Data.MySqlClient'. Trying to connect to MySQL from asp.net: Web.config - <configuration> <connectionStrings> <remove name="LocalMySqlServer"/> <add name="MySQLConnectionString" connectionString="Datasource=johnny.heliohost.org;Database=mysaving_401Kmembers; uid=mysaving_admin;pwd=******;" providerName="MySql.Data.MySqlClient"/> </connectionStrings> <system.web> <customErrors mode="Off"/> </system.web> </configuration> If I run the website locally then it is able to connect to MySQL and show records from database table. Am I missing something!!! Thanks in advance for help.

I got an email saying that my account was disabled because no one logged into cPanel in over a month. I went and executed the renewal script and my website was up agian... except with one very important part missing. The MySQL database have suddenly seemed as kthey have lost all of the info stored within them. Also the web applications no longer have access to them rendering my site almost completely unusable. I've had problems with MySQL before but I wonder what caused this. Also I tried to see what was happening by using phpMyAdmin but apparently I can't log into that anymore either. Server: Stevie User: toast Domain: burnedtoast.cu.cc All of my databases were affected.