Hi,

I just recently bought and installed EE 1.0. I’ve been a pMachine user since Feb. 2003.

In my installation of EE, I’m encountering this error message:

Both pMachine and EE is residing on the same database and accessing it using the same database user.

To make sure things are working fine, I checked the database using phpMyAdmin. All of the exp_ tables were created including exp_member_groups. I even ran an SQL statement on such table, and it does contain a record of group_id=3.

Both my index.php and control panel shows the same error message. Btw, this is a fresh install.

Can anyone kindly assist me in resolving this matter? Moreover, if you need more detailed information (server runtime environment, etc); let me know and I’ll provide such details.

Looking forward to some enlightenment.

You might try opening your config.php and set it to use non-persistent connections:

Someone also reported the same error/behavior and getting it fixed by changing the hostname from the IP address to “localhost”.

The config.php I’ve been using has:

I’ve tried both persistent (1) and non-persistent (0), and still shows the same error.

For the IP address, I also tried both the “localhost” and “127.0.0.1” IP address, but to no avail.

The server environment is:
PHP: 4.3.8
MySQL: 4.0.18-standard

Using phpMyAdmin, the “exp_” tables were created by EE. Such tables doesn’t have any problem when you issue an SQL statement.

Any leads on how to fix this?

I found a solution to this problem.

Apparently, it’s not the persistent or non-persistent, which causes the problem.

I changed the password of the MySQL user. Previously, I had a password using the characters (not in any order): “@#$%!)#”.

Now, I’m using an alpha-numeric password, and it works.

Very strange.  I would have expected some other MySQL error to appear if there was a problem with the password. [shrug] Well, at least you got it working!

Hi.
I Experience the same problem as you guys. When trying to login i get:

MySQL ERROR:
Query: SELECT * FROM exp_member_groups WHERE group_id = ‘3’

Have changed:
1. In The config.php :
$conf[’db_conntype’] = “1”; $conf[’db_conntype’] = “0”;

2. localhost” to “IP address”

The symptoms still the same.
Can you please tell me how to proceed.
Thanks,

Is that the full error?  Is there any other details provided?

no that is the only error message.
thanks.

Ah, how unhelpful.  Since that is a perfectly valid query, it is a problem with MySQL itself.  You might try to change your password, if possible, just like above.  It might just work, although I cannot fathom why.

You might also try going into the Admin section of the Control Panel.  Choose SQL Manager->Manage Database Tables.  Select the exp_member_groups checkbox, and then scroll to the bottom of the page and choose “repair selected tables” from the pulldown menu.

done all the suggested.
1. repairing the exp_member_groups table in SQL Manager
2. changing the password (although alphanumeric already).
Error message still the same, however it takes ages for the result to parse…
???

Try going into the SQL Manager and using the Database Query Form try submitting that query.  If that works, then I suggest you contact your host and see if they have any idea why MySQL might be spitting out an invalid error message.

I have received the same reply from my host to your last one.
Can you please advise me how to reinstall EE.
thanks,
m

I believe you could also get an error like that if MySQL is out of available connections.  You might want to ask your Host about that.  Find out whether they prefer persistent or non-persistent connections.

Did you try the query in phpMyAdmin or the Database Query Form with this query?

Hi Paul.*
yes i have succesfuly ran query in phpMyAdmin.
I have just received a note from my host that they prefer non-persistent connections: “We prefer that you end your mysql session at the end of each page.”

Now what, mate?

That is the first query preformed by the Session class, and so we believe that is the first query for the entire system.  The fact that there is not a database connection error seems to indicate that you can connect.  However, it is darn odd that MySQL is not giving us any more information too.

Really we’re at a loss.  If you have switched to non-persistent connections and repaired tables, then there might be a PHP to MySQL problem.

Hi Paul.*
what should i do know? wait for the miracle?
Please advise. thanks.
Regards

If you send me an email with FTP and Control Panel access I can look at it in more depth and see if I can see where the problem is happening.

This error message happens when MySQL is not running!
I guess the error message comes from PHP