[TYPO3-english] Cannot login anymore

[Ronald Wiplinger (Lists)]

Bas v.d. Wiel wrote:
> Hi Ronald,
> You could try uploading the following PHP script (all warranties are 
> void) and loading it in your browser:
>
>   

Thank you. I could in the meantime manage it. In the Install tool is
under Database Analyser the function Clear tables, which allowed me to
clear that particular table.
I was still not allowed to login for another 10 minutes, but that is
sure because of the webhosters "time difference" to my desk, ...

Glad that after good 40 hours I can login again and my customers can
change their pages again, ...

2 am, ... time to go to bed,


thanks to all of you.

bye

Ronald


> <?php
> $dbname = 'dbname'; //Put the name of your database here
> $dbhost = 'localhost'; //Host where your database runs, likely localhost
> $dbuser = 'username'; //username for your T3 database
> $dbpass = 'password'; //Likewise, the password
>
> $table = 'cache_pages';
>
> $dbLink = mysql_connect($dbhost,$dbuser,$dbpass);
> mysql_select_db($dbname,$dbLink);
>
> $query = 'TRUNCATE '.$table;
> mysql_query($query,$dbLink);
> mysql_close($dbLink);
> ?>
>
> Hopefully you know how to deal with PHP a bit. You should exchange the 
> placeholder values in the above script with the real values for your 
> database. The 'TRUNCATE' SQL command empties the table you define as 
> $table. In this case it's cache_pages.
>
> Be aware that you should only do something like this as a completely 
> last-ditch effort! It's EXTREMELY insecure to leave this script on your 
> server and it may very well corrupt TYPO3's cache, since the clear cache 
> command does more than just truncate db tables. So do flush the cache in 
> the official way as soon as you get your login back, or be prepared to 
> face weirdness on your website.
>
> In any case, you should get a new hoster. Having such a tiny limit on 
> your website is ridiculous by any decent standard. Or are you using one 
> of those $1,00 a month hosting packages?
>
> Hope this helps!
>
> Bas
>
>
> Ronald Wiplinger (Lists) wrote:
>   
>> Dmitry Dulepov wrote:
>>   
>>     
>>> Hi!
>>>
>>> Ronald Wiplinger (Lists) wrote:
>>>   
>>>     
>>>       
>>>> HOW can I clear the table cache_pages, sothat no further damages will occur?
>>>>     
>>>>       
>>>>         
>>> Man, you use TYPO3 :) Have you even seen "clear page cache"? :)
>>>
>>>   
>>>     
>>>       
>> Did I mention that I cannot login?
>> I learned after I am logged out that there is a quota, ... how can I fix
>> it from outside?
>> And yes, I did often clear pages when I could login, however, during a
>> failure in some packages, it increased that badly, ...
>>
>> bye
>>
>>
>> Ronald
>> _______________________________________________
>> TYPO3-english mailing list
>> TYPO3-english at lists.netfielders.de
>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>>   
>>     
>
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>