How To Fix Incorrect Disk Space
/scripts/fixquotas /scripts/updatemysqlquota
Never been to TextSnippets before?
Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)
About this user
Sasha http://nothing-less.net
How To Turn Off/On Stats For One Account
http://forums.cpanel.net/showthread.php?t=15967&highlight=urchin
You can edit the:
file and add settings for the stats packages.
That will turn them off and override the server setttings.
To update the stats now:
You can edit the:
pico /var/cpane/users/accountname
file and add settings for the stats packages.
skipanalog=1 skipawstats=1 skipwebalizer=1
That will turn them off and override the server setttings.
To update the stats now:
/scripts/runweblogs username /scripts/runlogsnow
How To Fix Fantastico SourceGuardian Error
http://netenberg.com/forum/viewtopic.php?t=1937
http://www.netenberg.com/forum/viewtopic.php?t=2480
Please make sure to select "Sourceguardian" in WHM -> Tweak Settings (section "Software"). If that doesn't work:
change:
to
and
to
http://www.netenberg.com/forum/viewtopic.php?t=2480
Please make sure to select "Sourceguardian" in WHM -> Tweak Settings (section "Software"). If that doesn't work:
pico /usr/local/cpanel/3rdparty/etc/php.ini
change:
extension_dir = ./ ;
to
extension_dir = ;
and
;;;;;;;;;;;;;;;;;;;;;; ; Dynamic Extensions ; ;;;;;;;;;;;;;;;;;;;;;;
to
;;;;;;;;;;;;;;;;;;;;;; ; Dynamic Extensions ; extension="/usr/local/cpanel/3rdparty/etc/ixed/ixed.lin.4.3.10.pxp" ;;;;;;;;;;;;;;;;;;;;;;
How To Fix MySQL Error 28
MySQL: 1030: got error 28 from server handler
Delete anything that�s not supposed to be there.
Stop all databases:
Then fix tables:
Check each letter for errors:
Repair where necessary:
Turn everything back on:
cd /tmp df -i /tmp df -h /tmp
Delete anything that�s not supposed to be there.
Stop all databases:
/etc/rc.d/init.d/chkservd stop /etc/rc.d/init.d/mysql stop
Then fix tables:
cd /var/lib/mysql
Check each letter for errors:
myisamchk -cs a*/*.MYI
Repair where necessary:
myisamchk -r a*/*.MYI myisamchk -r b*/*.MYI myisamchk -r c*/*.MYI myisamchk -r d*/*.MYI myisamchk -r e*/*.MYI myisamchk -r f*/*.MYI myisamchk -r g*/*.MYI myisamchk -r h*/*.MYI myisamchk -r i*/*.MYI myisamchk -r j*/*.MYI myisamchk -r k*/*.MYI myisamchk -r l*/*.MYI myisamchk -r m*/*.MYI myisamchk -r n*/*.MYI myisamchk -r o*/*.MYI myisamchk -r p*/*.MYI myisamchk -r q*/*.MYI myisamchk -r r*/*.MYI myisamchk -r s*/*.MYI myisamchk -r t*/*.MYI myisamchk -r u*/*.MYI myisamchk -r v*/*.MYI myisamchk -r w*/*.MYI myisamchk -r x*/*.MYI myisamchk -r y*/*.MYI myisamchk -r z*/*.MYI
Turn everything back on:
/etc/rc.d/init.d/chkservd start /etc/rc.d/init.d/mysql start
Quick Cheat Sheet
DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Quick Cheat Sheettitle>
"Weblog IDs" cellpadding="5">
"heading">
Full Weblog Name
Short Name
Weblog ID
{exp:query sql="SELECT weblog_id, blog_name, blog_title, blog_url FROM exp_weblogs ORDER BY blog_title"}
{blog_title}
{blog_name}
{weblog_id}
{/exp:query}
"Custom Field IDs" cellpadding="5">
"heading">
Full Field Name
Short Name
Field Type
{exp:query sql="SELECT group_id, field_name, field_label, field_type FROM exp_weblog_fields ORDER BY field_name"}
{field_label}
{field_name}
{field_type}
{/exp:query}
"Category IDs" cellpadding="5">
"heading">
Full Category Name
Category ID
{exp:query sql="SELECT cat_name, cat_id, group_id FROM exp_categories ORDER BY group_id"}
{cat_name}
{cat_id}
{/exp:query}