PhpDig.net

Go Back   PhpDig.net > General Forums > Coding & Tutorials

Reply
 
Thread Tools
Old 03-06-2005, 01:55 PM   #1
Dave A
Purple Mole
 
Dave A's Avatar
 
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.
Dave A is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT -8. The time now is 01:23 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.