XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / New Install - MySQL error on Check Privileges
Register
1
BDW
New Install - MySQL error on Check Privileges

  • 2006/7/29 13:17

  • BDW

  • Quite a regular

  • Posts: 280

  • Since: 2002/9/28


I'm trying to install Xoops. I've created the Database with phpMyAdmin but for some reason when I click on Check Privileges I get the following error:

Quote:

Error

SQL-query :

SELECT *
FROM `user`
WHERE NOT (

`Select_priv` = "N" AND `Insert_priv` = "N" AND `Update_priv` = "N" AND `Delete_priv` = "N" AND `Create_priv` = "N" AND `Drop_priv` = "N" AND `Grant_priv` = "N" AND `References_priv` = "N"
)
ORDER BY `User` ASC , `Host` ASC ;



MySQL said:


#1054 - Unknown column 'N' in 'where clause'


This happens with all the databases I have in MySQL.

Any Ideas?
2
Dave_L
Re: New Install - MySQL error on Check Privileges

  • 2006/7/29 15:41

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


What are your phpMyAdmin and MySQL versions? That information should be at the top of the main phpMyAdmin page.
3
BDW
Re: New Install - MySQL error on Check Privileges

  • 2006/7/30 23:05

  • BDW

  • Quite a regular

  • Posts: 280

  • Since: 2002/9/28


PHP Version 4.1.2
SQL 3.23.58

I think, phpMyAdmin doesnt say, but its what my hosts told me. They are doing my head in at the mo cos when they changed the Control Panel to the new one everything got screwed up and its taking over 2 weeks now for everything to get sorted.
4
Dave_L
Re: New Install - MySQL error on Check Privileges

  • 2006/7/30 23:42

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


phpMyAdmin doesn't indicate its version?

You might want to install your own phpMyAdmin, fromhttp://phpmyadmin.net. The newest version is 2.8.2, which I haven't tried. I'm still using 2.8.0.3, and haven't had any problems with it. If you do this make sure you protect it; I recommend selecting the HTTP authentication method in its configuration file; the documentation explains how to do that.
5
BDW
Re: New Install - MySQL error on Check Privileges

  • 2006/7/31 10:33

  • BDW

  • Quite a regular

  • Posts: 280

  • Since: 2002/9/28


Oops I thought you where talking about the PHP version. Doh! wot an idiot I am, that will teach me to read properly before typing.

version 2.5.6

Unfortunately i dont think i'm allowed to install another version of phpMyAdmin. Its all controlled by my hosts.
6
Dave_L
Re: New Install - MySQL error on Check Privileges

  • 2006/7/31 11:27

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


That version of phpMyAdmin is over two years old.

If you can install XOOPS, you should be able to install your own copy of phpMyAdmin. It's just an ordinary PHP script.
7
BDW
Re: New Install - MySQL error on Check Privileges

  • 2006/8/2 21:58

  • BDW

  • Quite a regular

  • Posts: 280

  • Since: 2002/9/28


Thanks anyway, but i've now moved hosts and i've got XOOPS working successfully. And i'm happy

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

113 user(s) are online (71 user(s) are browsing Support Forums)

Members: 0

Guests: 113

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits