By radiofranky on

how do i clean up my "log file"? is getting too big. tks

Comments

heine’s picture

heine commented

What log file do you mean?

If you are asking about watchdog go to Adminster >> Settings (admin/settings) and decrease the time log items are kept. This requires cron.php te be run now and then.

--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

radiofranky’s picture

radiofranky commented

User 'xyzhas exceeded the 'max_questions' resource (current value: 50000) query: UPDATE sessions SET uid = 0, hostname = '64.233.172.35', session = 'messages|a:0:{}', timestamp = 1136421243 WHERE sid = '4ff43afa06614e15d7469e5d82ffd0a1' in /home/xyz/public_html/includes/database.mysql.inc on line 66

heine’s picture

heine commented

See the other thread for the error.

You never had cron.php running before? Via cron or poormanscron?
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

radiofranky’s picture

radiofranky commented

never. i thought it should run itself..

heine’s picture

heine commented

How did you install Drupal? Was it via a packager, fantastico or by hand? Activating cron tasks is point 6 of INSTALL.txt.
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

radiofranky’s picture

radiofranky commented

manually did

heine’s picture

heine commented

Did you read INSTALL.TXT?
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

wellsy’s picture

wellsy commented

open your database in phpMyAdmin

First step....backup your database! (Export>>>Select All tables>>>Structure and Data)

Then....Browse the watchdog table>>>choose to DROP the watchdog table

Then>>>>copy and paste the below into the SQL window and hit GO (for 4.6.3 or 4.6.4 or 4.6.5 database)

The table will be rebuilt with no content



CREATE TABLE watchdog (
  wid int(5) NOT NULL auto_increment,
  uid int(10) NOT NULL default '0',
  TYPE varchar(16) NOT NULL default '',
  message longtext NOT NULL,
  severity int(5) NOT NULL default '0',
  link varchar(255) NOT NULL default '',
  location varchar(128) NOT NULL default '',
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY  (wid)
) TYPE=MyISAM;

wellsy

orchidsonline.com.au

heine’s picture

heine commented

No more queries for today. At least; I hope it's for today...

You can also choose Empty or TRUNCATE TABLE `watchdog`
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

wwwoliondorcom’s picture

wwwoliondorcom commented

hi,

the path to set the delay to discard log entries is /admin/settings/error-reporting and I also see an option called Error reporting: that proposes to Write errors on the log or Write errors on the log and to the screen, but do you know

if it is possible to write the errors on the screen only for the admin and not for any user ?

Thanks a lot!