forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Permissions & Access Rights => Topic started by: Ishmael on January 16, 2005, 04:45:18 pm

Title: create new user problem
Post by: Ishmael on January 16, 2005, 04:45:18 pm

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

Title: Re: create new user problem
Post by: Nibbler on January 16, 2005, 04:55:04 pm

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

Code: [Select]

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

Title: Re: create new user problem
Post by: kegobeer on January 16, 2005, 05:33:34 pm

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.