create new user problem

[Ishmael]

The gallery seem to work fine with on exception.

When I select "add new user" I get the following error:

While executing query "INSERT INTO cpg132_users(user_regdate, user_active) VALUES (NOW(), 'YES')" on 0

mySQL error: Table 'mysql.proc' doesn't exist


Checking the db through mysql I confirmed that the cpg132_users table exists and that the referenced fields exist as well. (the admin user does appear in the user list.)

I'm running FreeBSD, Apache 1.3.x, php 4.3.x and mysql 5.0.x

Any ideas out there?

Ishmael

[Nibbler]

Can you try running query with a space between cpg132_users and the opening bracket ?

Code Select Expand

INSERT INTO cpg132_users (user_regdate, user_active) VALUES (NOW(), 'YES')

[kegobeer]

There isn't anything wrong with the Coppermine tables.  A Google search turns up this:

http://lists.mysql.com/mysql/166486
http://article.gmane.org/gmane.comp.db.mysql.general/44018
http://archives.neohapsis.com/archives/mysql/2004-q1/0597.html

This appears to be a MySQL 5.0 installation issue with the GRANT tables.  See if any of those links help you out.