Clean install problem

[All4Data]

Hi there .. I am trying to do a clean install and it keeps giving me this problem

first
-------------------------------------------------------

The following error must be resolved before you can continue the installation process:
We were unable to lock a test table on your MySQL database server. We tried locking a table with the command LOCK TABLES drupal_install_test WRITE and MySQL reported the following error: 1044.

* To start over, you must empty your existing database and replace the appropriate settings.php with an unmodified copy.
* To install to a different database, edit the appropriate settings.php file in the sites folder.
* To upgrade an existing installation, proceed to the update script.

-------------------------------------------------

and then

-------------------------------------------------

Drupal already installed
* To start over, you must empty your existing database and replace the appropriate settings.php with an unmodified copy.
* To install to a different database, edit the appropriate settings.php file in the sites folder.
* To upgrade an existing installation, proceed to the update script.

-------------------------------------------------

sorry I have installed a number of vbdrupals and now it is making me go monkey

:)

your thoughts appreciated

I went into myphpadmin and deleted the following

drupal_cache_filter
drupal_cache_menu
drupal_cache_page


EDIT: I am running PHP 4.3.9 and MySQL Version 4.1.20

[All4Data]

to add to this .. I changed the settings in my config.php

from false to true

// ****** FORCE EMPTY SQL MODE ******
// New versions of MySQL (4.1+) have introduced some behaviors that are
// incompatible with vBulletin. Setting this value to "true" disables those
// behaviors. You only need to modify this value if vBulletin recommends it.
$config['Database']['force_sql_mode'] = true;



EDIT: changed it back to false

[webdzinez]

what are the contents of your settings.php?

[All4Data]

are you talking about

$vb_dir = '/home/virtual/site13/fst/var/www/html/forums';

I put that in when it asks me and then it gives me that message

Thanks

EDIT: I have now made a clean install with the very latest vbdrupal 5.4 and the same error occurred

The following error must be resolved before you can continue the installation process:
We were unable to lock a test table on your MySQL database server. We tried locking a table with the command LOCK TABLES drupal_install_test WRITE and MySQL reported the following error: 1044.

[elmuerte]

You must have the "LOCK TABLES" permission in mysql.