In upgrading from drupal 4.7.0 to 4.7.1, I got the database error below.
It looks like the column vid was already added and the data from uid copied as per the update code. I had to manually modify the table to make vid unique.
Geoff
php Date Saturday, May 27, 2006 - 21:10 User admin http://www.greatresultsmarketing.com/?q=user/1 Location http://www.xxxxx.com/update.php?op=do_update http://www.greatresultsmarketing.com/update.php?op=do_update Referrer http://www.xxxxx.com/update.php?op=selection http://www.greatresultsmarketing.com/update.php?op=selection Message Duplicate key name 'vid' query: ALTER TABLE node ADD UNIQUE (vid) in /services/webpages/x/x/xxxx.com/public/includes/database.mysql.inc on line 120.
Geoff Staples wrote:
In upgrading from drupal 4.7.0 to 4.7.1, I got the database error below.
It looks like the column vid was already added and the data from uid copied as per the update code. I had to manually modify the table to make vid unique.
Geoff
php Date Saturday, May 27, 2006 - 21:10 User admin http://www.greatresultsmarketing.com/?q=user/1 Location http://www.xxxxx.com/update.php?op=do_update http://www.greatresultsmarketing.com/update.php?op=do_update Referrer http://www.xxxxx.com/update.php?op=selection http://www.greatresultsmarketing.com/update.php?op=selection Message Duplicate key name 'vid' query: ALTER TABLE node ADD UNIQUE (vid) in /services/webpages/x/x/xxxx.com/public/includes/database.mysql.inc on line 120.
Geoff, Drupal had contained a line to drop the index before the release. My tests revealed that this index was not present when I created a fresh 4.6.7 site and then upgraded to 4.7.1, thus I removed this line. Can you tell me about the development of your site? At which version did you start? Did you apply database changes outside from Drupal's update.php?
Cheers, Gerhard
Hello,
Does anyone know if/how to block a user(ip) if that user has X number of failed consecutive login attempts?
Version 4.6.6.
Thanks FnL
On 5/28/06, Effennel effennel@gmail.com wrote:
Does anyone know if/how to block a user(ip) if that user has X number of failed consecutive login attempts?
It's not exactly what you were looking for, but I think the Bad Behavior module might give you some ideas and might work well for your needs http://drupal.org/node/30501
Regards, Greg
I started with 4.7.0.
I ugpgraded to 4.7.1
I got the error.
I compared the 4.7.0 database ddl to the 4.7.1 ddl and made the change that failed using a sql client.
Geoff
Gerhard Killesreiter wrote:
Geoff Staples wrote:
In upgrading from drupal 4.7.0 to 4.7.1, I got the database error below.
It looks like the column vid was already added and the data from uid copied as per the update code. I had to manually modify the table to make vid unique.
Geoff
php Date Saturday, May 27, 2006 - 21:10 User admin http://www.greatresultsmarketing.com/?q=user/1 Location http://www.xxxxx.com/update.php?op=do_update http://www.greatresultsmarketing.com/update.php?op=do_update Referrer http://www.xxxxx.com/update.php?op=selection http://www.greatresultsmarketing.com/update.php?op=selection Message Duplicate key name 'vid' query: ALTER TABLE node ADD UNIQUE (vid) in /services/webpages/x/x/xxxx.com/public/includes/database.mysql.inc on line 120.
Geoff, Drupal had contained a line to drop the index before the release. My tests revealed that this index was not present when I created a fresh 4.6.7 site and then upgraded to 4.7.1, thus I removed this line. Can you tell me about the development of your site? At which version did you start? Did you apply database changes outside from Drupal's update.php?
Cheers, Gerhard
-
Effennel -
Geoff Staples -
Gerhard Killesreiter -
Greg Knaddison - GVS