I had a terrible issue with my wordpress website www.sherbaz.com. I was unable to submit any post for a long time because of this issue. Every time when I login to wordpress dashboard to post new tips, I see a blank text field as shown below which doesn’t even accept any input either.
How was it fixed?
This was seriously effecting my work and I couldn’t post or edit or update an already existing post either. Finally after few weeks of silence I decided to tweak this out. One fine weekend I started sorting out one by one.
- Cleared browser cache – No luck.
- Changed browsers and even tried on different systems and finally tried even on my Smartphone. – Same error was there everywhere.
- Then I checked the error that was displayed by internet explorer while loading the page. It says “tinyMCE is undefined”. This didn’t give any clue.
- Installed Web developer 1.1.9 add-on to my Mozilla firefox and then executed the new post page again. The web developer error console says “illegal character in wp-tinymce.php”. On clicking the error, the file popped up. I could find only some Unicode characters. So I felt like the files might have got corrupted. I tried replacing the file alone from a new downloaded wordpress-3.3.1 package. That didn’t fix it.
I then took a backup of wp-admin and wp-includes folders, deleted those folders and then uploaded again from the freshly downloaded wordpress 3.3.1 zip file. Hurray! The issue got fixed. The text editor is now showing up and working fine.
The Attached SQL Query can be safely used for rebuilding or reorganizing all indexes in a particular database based on the fragmentation level.
Note: The script is currently set to perform offline index rebuild since online index rebuild is supported only in Enterprise edition SQL Server. Inorder to change it into online mode, add
, ONLINE = ON statement along with
<span style="padding: 2px; border: 1px solid #00ff00;">FILLFACTOR = 80, SORT_IN_TEMPDB = ON, STATISTICS_NORECOMPUTE = ON</span>
in line 100 in the attached script.
3203_AutoIndexRebuild2005andAbove (Click to download the script)
Continue reading “Automatically Rebuild or Reorg index based on fragmentation”
Run below Query. And once the query executes completely, go through the SQL Server Error log to see the results.
declare databases cursor for
select name from sys.databases
where name <> 'master' and name <> 'tempdb'
and name <> 'model' and name <> 'msdb'
declare @dbname varchar(100)
fetch next from databases into @dbname
print @dbname + ' - ';
DBCC CHECKDB (@dbname) with no_infomsgs;
fetch next from databases into @dbname
xp_readerrorlog parameter 1, parameter 2, parameter 3, parameter 4
Parameter 1: To specify the errorlog number. Starts from 0. 0 = current, 1 = Archive #1, 2 = Archive #2
Parameter 2: Log file type. 1 or NULL for Error log and 2 for SQL Agent Log
Parameter 3: Search string
Parameter 4: Second search string further refine your search. Continue reading “Read and filter SQL server error logs using TSQL”
Did you come across any situation where you wanted to make sure that the password you set for a SQL account is what you really wanted? Below is how you can validate the password for a particular account. With this methord, you can find out the forgotten password for a SQL account without causing any audit failures and by not changing any security settings.
SELECT name FROM sys.syslogins WHERE pwdcompare (
When you run the above query, you will get the list of accounts which has password set as SomePasswordWhichYouKnow.
This way, you can figure out what password was set while creating an account (SQL authentication account)
1) Go to MSDB– Security –Users — UserName — User Name Properties — Assigned the ‘TargetServerRole’ in msdb
2) Run the query
select pr.name, dp.permission_name, dp.state_desc
from msdb.sys.database_permissions dp
join msdb.sys.objects o on dp.major_id = o.object_id
join msdb.sys.database_principals pr
on dp.grantee_principal_id = pr.principal_id
where o.name = ‘sp_start_job’
3) Grant Execute permission to concern user to SP_Start_Job and SP_Stop_Job and it resolved the issue.
Service Pack 4 for SQL Server Database Services 2005 ENU (KB2463332)’ could not be installed.
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 2221
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
Error Number : 11032
Error Description : Unable to install Windows Installer MSP file. fileExit Code Returned: 11032.
1) Go to the location.
Continue reading “Unable to install Windows Installer MSP fileExit Code Returned: 11032”
After connecting to SQL Server using SQL Server Management Studio, I am not able to see the green play arrow on the SQL Server DB icon before the instance name. It just shows white circle.
Make sure that the Windows account with which you opened SQL Server Management studio have got admin privilege on the operating system and can retrieve service running status.
In Windows 2008, Even if your account has admin privilege on the OS, you need to run SSMS (for SQL Server 2008) and sqlwb (SQL Server 2005) from command prompt opened with “Run as Administrator”.
If you wanna add a shared disk to the two nodes of a cluster to be built inside a VMware, Follow below steps.
- If your VMware is pretty Old, Then shutdown both the virtual machines to be configured as cluster.
- Then from inside VMware virtual center, right click one of the virtual machine and select ‘edit settings’.
- Create one SCSI control with sharing allowed among multiple virtual machines.
- Now click on Add and select Hard Disk.
- Select to create new virtual disk, provide required size, thin provisioning unchecked and to store with the virtual machine. And in advanced section, select the value for Virtual node (1:x, where 1:0 was selected as virtual node in step 3 and the x can have any value which is unoccupied. Since this SCSI control was newly created, all the nodes will be vacant. So here x can have any value between 0 and 15). Complete the wizard and now you have disk created and mapped to one virtual machine.
- Right click the same virtual machine once again and choose ‘edit settings’. And then click on the Hard Disk we just added. Now in a box at the right top corner, you will get the disk file location and name.
- Next use the tool putty (Let me know if you would like to know what putty is) and connect with the ESX host where the two virtual machines are located and also the disk we created in step 5 will be located.
- Using basic linux commands, navigate and find the Disk file and run below command to make the Disk file Zeroed (All bits on that disk are reset in this process).
- vmkfstools -w /filepath/filename.vmdk
, Continue reading…