Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Nextid db_sequence ??Error

Help
Psymon4
2005-03-02
2013-04-09
  • Psymon4
    Psymon4
    2005-03-02

    here is my problem
    when my page tries to pull nextid i get the error
    <b>Database error: Invalid SQL: lock tables db_sequence write
    MySQL Error: 1044 (Access denied for user: 'claeve_1@%' to database 'claeve_db1')
    Session halted.</b>

     
    • Joe Stewart
      Joe Stewart
      2005-03-02

      Since mysql 4.02 you have to have the global lock table privilege granted.

      " As of MySQL 4.0.2, to use LOCK TABLES you must have the LOCK TABLES privilege and a SELECT privilege for the involved tables. "

      http://dev.mysql.com/doc/mysql/en/lock-tables.html

       
      • Psymon4
        Psymon4
        2005-03-03

        Thank you, i will try it