[SPT/CWIS] SPT--DBEntry.php shows a SQL error message; not able to add new resource

[Juan Zuluaga]

Dear SPT people, 

As an admin, when trying to add a resource, 
either via clicking on the main page "add" little
link,
http://192.168.x.x/SPT/MetadataTool/SPT--DBEntry.php 
or
by going to the Metadata Tool green menu
http://192.168.x.x/SPT/MetadataTool/SPT--DBEntry.php?AddNewResource=1

the page complains saying

SQL Statement: LOCK TABLES Resources write, APUsers
read, APSessions write, APSessionData write
SQL Error: Access denied for user
'sptcustom'@'localhost' to database 'spt'

However, editing a record works OK
(http://192.168.x.x/SPT/MetadataTool/SPT--DBEntry.php?ResourceId=21)

The same error appears when trying to import data, 
http://192.168.x.x/SPT/MetadataTool/SPT--ImportDataExecute.php
"SQL Statement: LOCK TABLES Resources write, APUsers
read, APSessions write, APSessionData write
SQL Error: Access denied for user
'sptcustom'@'localhost' to database 'spt' "


--------
How is this possible? how can I fix it? 

more info:
mysql> show grants;
+------------------------------------------------------------------------------------------------------------------+
| Grants for sptcustom at localhost                      
                                                      
     |
+------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'sptcustom'@'localhost'
IDENTIFIED BY PASSWORD 'blablabla' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP,
ALTER ON `spt`.* TO 'sptcustom'@'localhost'           
      |
+------------------------------------------------------------------------------------------------------------------+

(this machine is Linux Slackware 10.2, php 4.4.4,
mysql 4.1.21). 




http://socioenlinea.blog.lemonde.fr/socioenlinea/
Comentarios sobre politica, sociedad y ciencia social.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com