|
03-06-2005, 01:55 PM | #1 |
Purple Mole
Join Date: Aug 2004
Location: North Island New Zealand
Posts: 170
|
Unlock a lockdown
Hi If anyone every gets into the situation where PHPDIG throws a wobbler and locks all your index up, until now I have had to clear the locked files using phpadmin one file at a time but I have just discoverd how to change it all back to normal:
You can update the whole lot with a simple SQL query - however, before doing so, I very much suggest you take a backup of the database, as it's very easy to get it wrong. Here's what you do - in phpMyAdmin, select the relevant table and click on the SQL tab. In the query box, type the following - UPDATE sites SET locked = 0; where 'sites' is the table you're editing, and 'locked' is the field you want to change. This will change the field value of ALL of the records from whatever they currently are to 0 (zero). When a site is locked it changes the value of locked from 0 to 1 but using this method can save ages of time editing it all, should phpdig fall over. Hope this helps anyone! All the best Dave A downunder. |
Thread Tools | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Unlock locked sites | Dave A | How-to Forum | 2 | 12-24-2004 03:36 PM |
How to unlock an URL | philbihr | How-to Forum | 2 | 11-08-2004 04:11 AM |