How to display excerpt (summary) of posts in wordpress using Mystique theme

If you do not want to show the entire post in category, archives and home page, you can do it by following the below steps:

1. Login as the administrator

2. Go to wordpress Dashboard

3. Go to Appearance -> Mystique

4. Click on Content Options tab

5. Under Post Previews section, check the Content checkbox and select Excerpt

6. Click on the Save Changes button.

That’s it! Now you will see the content except in all the places except the single post pages.

Let us know your comments below..

VN:F [1.9.12_1141]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.12_1141]
Rating: 0 (from 0 votes)

Tags: , , ,

How to deactivate all call diverts in any brand mobile?

If somebody is calling you and the call is going to your voice mail or it is diverted to some other number, then you can deactivate all the call diverts by typing ##002# and pressing call button.

This is a universal code ie., you can use this code in any brand of phone and in any network throughout the world!

Hope this tip helps. Let me know your comments..

VN:F [1.9.12_1141]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.12_1141]
Rating: 0 (from 0 votes)

SIM Memory full – Nokia XpressMusic 5800 – Problem

If your Nokia XpressMusic 5800 shows blinking message that SIM memory Full, then follow the below instructions to fix that issue.

Option 1. If you want to empty all sms in the sim, hit messaging > Options > SIM messages > Options > Mark/Unmark > Mark All > Options > Delete > Yes.

Option 2. If you want to delete only few selected sim sms, hit messaging > Options > SIM messages. Select each message and hit Options > Delete.

Please post your comments below..

VN:F [1.9.12_1141]
Rating: 5.5/10 (2 votes cast)
VN:F [1.9.12_1141]
Rating: 0 (from 2 votes)

Tags: , , , ,

My battery is set up to charge to 80%. How to I change it to charge a 100%?

If you are using a Samsung laptop, you might have come accross this issue.

To change the settings, click Start > All programs > Samsung > Battery Life Extender > Battery Life Extender . Click “yes” if prompted. When the program launches you should have the option to go back and forth between 100 and 80% on your battery.

VN:F [1.9.12_1141]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.12_1141]
Rating: 0 (from 0 votes)

Tags: , , ,

Unknown column ‘a.attachment_type’ in ‘field list’

If you are facing issue while upgrading from SMF 1.x version to 2.x and you are pretty new to this, then probably you are encountering the following error:

Unknown column ‘a.attachment_type’ in ‘field list’

Suppose your forum is at http://mysmfforum.com and you tried to run the upgrade using http://mysmfforum.com, you will encounter the above error. The solution is to access the upgrade script using the url http://mysmfforum.com/upgrade.php

That should solve your problem.

Please post your comments below..


VN:F [1.9.12_1141]
Rating: 9.7/10 (7 votes cast)
VN:F [1.9.12_1141]
Rating: +2 (from 2 votes)

Tags: , ,

SMF Forum 1.x – Preventing spam posts – Member Approval

I’ve been getting a lot of spam postings on my SMF 1.x Forums. So I decided to do a bit of research. So here are the things that I could figure out so far:

In SMF 1.x, there is no built-in support for post approvals. I couldn’t figure out any other mods as well. So in SMF 1.x, if you want to prevent spam posting to an extend, the easiest option is to have the memberships approved.

Even though approving members don’t solve the issue totally because once approved, they will still be able to post spam, but a lot of registrations are coming from the same kind of email addresses, so it is very easy to delete most of the requests that way.

In order to enable approval for registration, you need to login as an admin and go to the Settings page:

Admin > Registration > Settings

Once you are in the Settings page, look for the first Select Box, Method of registration employed for new members and change its selected value to Member Approval.

Click on the Save button and you are done. All the new registrations will wait for your approval before going live!

You can go to Admin > Members > Awaiting Approval page and approve/delete any pending registration requests.

The good news is that 2.0 Final has been released. When I started my forum, 2.x was still under development. So if you guys plan to start a new forum, better go for 2.x version because it has got a built in post approval system.

Hope this article was helpful. Please post your comments.

VN:F [1.9.12_1141]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.12_1141]
Rating: 0 (from 0 votes)

Tags: ,

Oracle query to get session pga & uga memory usage for inactive sessions

I’m listing below some of the queries I have created to see various oracle session related memory statistics. Replace all occurrences of XXXXXXXXXXXXXXXX with your database username. Please drop a comment below if these queries are useful for you guys.

Query for getting ‘session pga memory’ usage for inactive sessions:

select sum(ROUND(s.value/1024)) || ‘ KB’ as pga_memory_usage_inactive from v$sesstat s , v$statname n where s.statistic# = n.statistic# and sid in (select sid from v$session where status=’INACTIVE’ and type= ‘USER’ and username=’XXXXXXXXXXXXXXXX‘) and n.name = ‘session pga memory’ group by name ;

Query for getting ‘session pga memory’ usage for all sessions:

select sum(ROUND(s.value/1024)) || ‘ KB’ as pga_memory_usage_total from v$sesstat s , v$statname n where s.statistic# = n.statistic# and n.name = ‘session pga memory’ group by name ;

Query for getting ‘session uga memory’ usage for inactive sessions:

select sum(ROUND(s.value/1024)) || ‘ KB’ as uga_memory_usage_inactive from v$sesstat s , v$statname n where s.statistic# = n.statistic# and sid in (select sid from v$session where status=’INACTIVE’ and type= ‘USER’ and username=’XXXXXXXXXXXXXXXX‘) and n.name = ‘session uga memory’ group by name ;

Query for getting ‘session uga memory’ usage for all sessions:

select sum(ROUND(s.value/1024)) || ‘ KB’ as uga_memory_usage_total from v$sesstat s , v$statname n where s.statistic# = n.statistic# and n.name = ‘session uga memory’ group by name ;

You can determine how much memory each inactive session is consuming using the following query:

select TO_CHAR(ROUND(s.value/1024),99999999) || ‘ KB’ as Memory_Usage , n.name|| ‘(‘||s.statistic#||’)’ as memory_type , sid from v$sesstat s , v$statname n where s.statistic# = n.statistic# and sid in (select sid from v$session where status=’INACTIVE’ and type= ‘USER’ and username=’XXXXXXXXXXXXXXXX‘) and n.name like ‘%ga memory%’ order by value;

VN:F [1.9.12_1141]
Rating: 9.2/10 (5 votes cast)
VN:F [1.9.12_1141]
Rating: +2 (from 2 votes)

Tags: ,

How to get maximum limit of open_cursors, sessions and processes in Oracle

In order to display the maximum limit of open_cursors, sessions and processes in Oracle, you can run the below queries on SQL Plus:

select value from v$parameter where name = ‘open_cursors’

select value from v$parameter where name = ‘sessions’

select value from v$parameter where name = ‘processes’

VN:F [1.9.12_1141]
Rating: 8.0/10 (3 votes cast)
VN:F [1.9.12_1141]
Rating: +1 (from 1 vote)

Tags: , , ,

How to get current open_cursors utilization and maximum limit in Oracle

If you are looking for a query which will list you the current open_cursors utilization and maximum limit in Oracle database, then try the below given query:

select max(a.value) as highest_value, p.value as max_value from v$sesstat a, v$statname b, v$parameter p where a.statistic# = b.statistic# and b.name = ‘opened cursors current’ and p.name= ‘open_cursors’ group by p.value;

VN:F [1.9.12_1141]
Rating: 9.0/10 (2 votes cast)
VN:F [1.9.12_1141]
Rating: 0 (from 0 votes)

Tags: ,

Viewing PGA Statistics of your Oracle Database

VIEWING PGA STATISTICS

———————————-

V$PGASTAT – This view gives instance-level statistics on the PGA memory usage and the automatic PGA memory manager. For example:

SELECT * FROM V$PGASTAT;

VN:F [1.9.12_1141]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.12_1141]
Rating: 0 (from 0 votes)

Tags: ,