9 replies to this topic

[WP1]

Hello Agian!

[1] I tried to move a site I had been working on over to Godaddy.
[2] I backed up the web site files and the database. No problem
[3] Unzipped the web site files on the new server. No problem
[4] Attempted to install the database. PROBLEM. This is the message displayed,

Quote

Error

SQL query:

--
-- Database: `vpeople_etomite`
--
-- --------------------------------------------------------
--
-- Table structure for table `etomite_active_users`
--
CREATE TABLE `etomite_active_users` (
`internalKey` int( 9 ) NOT NULL default '0',
`username` varchar( 50 ) NOT NULL default '',
`lasthit` int( 20 ) NOT NULL default '0',
`id` int( 10 ) default NULL ,
`action` varchar( 10 ) NOT NULL default '',
`ip` varchar( 20 ) NOT NULL default '',
PRIMARY KEY ( `internalKey` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COMMENT = 'Contains data about active users.';

MySQL said: Documentation
#1046 - No database selected

QUESTION
How do I correct this?

Thanks in advance for any and all help with this.

WP

[Ralph]

Your description of the process is a bit vague... Are you using phpMyAdmin to install on the new server...??? If so, are you opening the database that you want to add the table into...??? Do you have a database created...??? phpMyAdmin only handles the table portion of exporting and importing, not database creation...

[WP1]

Ralph, on Jan 16 2008, 06:30 PM, said:

Your description of the process is a bit vague... Are you using phpMyAdmin to install on the new server...??? If so, are you opening the database that you want to add the table into...??? Do you have a database created...??? phpMyAdmin only handles the table portion of exporting and importing, not database creation...

Hi Ralph!

Thanks for responding.

Nice to see you hanging in with Etomite. It has improved under your watch.

I have already created the database. The database name [location], userid, password, and database type [mysql] were placed into the config file in the "manager/includes" directory. The config file was then uploaded back up into the directory.

I saved the database from the phpMyAdmin page I was moving from as a sql file and then attempted to upload it into the phpMyAdmin page I was trying to install it into and received this error.

I cannot figure out why this would happen. The site is running fine on the server I am moving the site from.

WP

[mikef]

phpmyadmin doesn't read etomite's management files!

You need to connect to the new database with phpmyadmin before you can attempt to load data into it.

[Ralph]

This pretty much says it all...
MySQL said: Documentation
#1046 - No database selected
Notice the Documentation part... I think it was a hyperlink to the explanation of your error... You weren't connected to a database so the table couldn't be created...

Remember, even in phpMyAdmin, there is more than one way to run SQL scripts... If you run from the left menu panel you need to include database connection code within your script... If you go ahead and open the database and then run the script from the menu in the right panel you don't need it because you are already in the database...

[WP1]

Hi Ralph!

I have attached two images.

If I am understanding you correctly, you are indicating that I should install the database by utilizing the right side of phpMyAdmin. I thought I had done that by utilizing the "Inport" or SQL command windows of phpMyAdmin. Both are on the right side of the window.

 phpMyAdmin_01__600x346.JPG   32.69K   6 downloads

 phpMyAdmin_02__600x343.JPG   18.29K   4 downloads

I had installed this database in another database on the same server. That particular database was for the Lve Etomite site. There was no problem with the install. This particular database is for another site that I will be using to make any changes before putting the changes into the Live site. The database is exactly the same. Why am I having problems installing it now?

QUESTION
I am not trying to be dense about this, but how would you address this issue?

Thanks again for your continued help with this.

WP

Edited by WP1, 18 January 2008 - 12:03 PM.

[mikef]

have you actually connected to the database on the database tab?

thats the only thing I can think of from the snapshots.


If there's something else, the expert will probably be along later

[Ralph]

Well, by looking at the images you posted, it appears that you are attached to the database and either of the methods indicated should work... I have used both Import and SQL to migrate tables into databases without problems...

Did I read that both databases are on the same server...??? If so, couldn't you simply copy the table structures and data from one database to the other using the Operations tab...???

One item to note is that some servers don't play well with the comments text in SQL files... There have been times when I have had to remove the comments as they were causing unexpected errors - some quite ambiguous... It's possible that you are having this problem and are falsely receiving the no database selected error...

[WP1]

Ralph, on Jan 18 2008, 09:30 AM, said:

Well, by looking at the images you posted, it appears that you are attached to the database and either of the methods indicated should work... I have used both Import and SQL to migrate tables into databases without problems...

Did I read that both databases are on the same server...??? If so, couldn't you simply copy the table structures and data from one database to the other using the Operations tab...???

One item to note is that some servers don't play well with the comments text in SQL files... There have been times when I have had to remove the comments as they were causing unexpected errors - some quite ambiguous... It's possible that you are having this problem and are falsely receiving the no database selected error...

Hi Ralph!

I also attempted the cut and paste approach from the original server and the Godaddy server. Got the same result.

QUESTION / ACTION
[1] Is there an online SQL checker?
[2] Will send an email to Godaddy Support As well and report back here.

BTW, I got the following message after attemtping another install

Quote

import.php: Missing parameter: import_type (FAQ 2.8)
import.php: Missing parameter: format (FAQ 2.8)
===========

2.8 I get "Missing parameters" errors, what can I do?

Here are a few points to check:

* In config.inc.php, try to leave the $cfg['PmaAbsoluteUri'] directive empty. See also FAQ 4.7.
* Maybe you have a broken PHP installation or you need to upgrade your Zend Optimizer. See http://bugs.php.net/bug.php?id=31134.
* If you are using Hardened PHP with the ini directive varfilter.max_request_variables set to the default (200) or another low value, you could get this error if your table has a high number of columns. Adjust this setting accordingly. (Thanks to Klaus Dorninger for the hint).
* In the php.ini directive arg_separator.input, a value of ";" will cause this error. Replace it with "&;".
* If you are using Hardened-PHP, you might want to increase request limits.

Still trying to find the answer.

WP1

Edited by WP1, 18 January 2008 - 03:58 PM.

[Ralph]

Ok... Not sure I, personally, can be of much more help without going hands-on... Keep us posted as it seems odd that you'd be getting errors while trying such basic tasks within phpMyAdmin... Keep us posted...