Making jQuery selector/contains case insensitive

Posted by mkhairul - November 26, 2008 at 03:11:49 pm - No Comments

Categories: Troubleshoot, blog, code

Just another stuff from work. There’s huge list to select people to be put into groups in the LMS. I added a javascript function for the user to type in a name and it will search and select a user in the list box.

I use Selector/contains for this but the problem is, it is case sensitive. That’s gonna be a problem to type in the exact case from the list. Here’s a snippet to extend the selector.

jQuery.extend(
        jQuery.expr[':'], {
                contains : "jQuery(a).text().toUpperCase().indexOf(m[3].toUpperCase())>=0"
});

Took the snippet from StackOverflow, but it has a typo.

CodeIgniter 1.7 DBForge Error (Array to string conversion error)

Posted by mkhairul - November 20, 2008 at 11:11:13 am - No Comments

Categories: Troubleshoot, blog, code, php

I think the ellislab team is swamped with bug reports and stuffs. But I’m sure the next release will solve this problem.

I found this solution at the forum, CI 1.7 Forge Problems. Basically what you need to do is find DB_driver.php inside the database folder. Go to function _protect_identifiers (most probably on line 1193).

Add in this code (inside the function).

if (is_array($item))
{
	$array = array();

	foreach($item as $one)
	{
		$array[] = $this->_protect_identifiers($one, $prefix_single, $protect_identifiers, $field_exists);
	}

	return $array;
}

Alright, that should fix it up.

Debugging an SQL Query

Posted by mkhairul - November 12, 2008 at 11:11:26 pm - No Comments

Categories: Tips, Troubleshoot, blog, code

So, I debugged an error for a good friend recently. Only certain kind of item would be displayed, everything else was not found in the search. The first thing I suspect is the SQL Query. I printed out the SQL Query and tried to debug it.

The first thing I did is to arrange the SQL Query in a readable manner.

Since I do not have the time to follow the trail from the SQL Query manually, I just comment out 3 conditions at a time, and add a condition each time until the item was found. In the above picture, I’ve found the culprit its the one below the commented out line.

When I commented out the line, the results for the keyword appeared as follow.

So thats the divide and conquer part. So now I know the problem is with the commented out criteria and the one below it. I traced it back to its table (products_to_categories) and found out that the category_id value is empty. Thats why it can’t join in with the categories table and thus there’s no result.

So what did I do? I told my friend about the problem, explained it to him (I gave him a couple of screenshots to explain the problem) and gives him a solution. UPDATE products_to_categories SET categories_id = xx. So that all the item have a category and will be displayed when it is searched by the application.

Erm, yeah. Thats about it.

Steam Problem

Posted by mkhairul - November 4, 2008 at 10:11:34 pm - No Comments

Categories: Troubleshoot, rants

I bought fallout 3 using steam (digital distribution service from Valve), the first problem that I had was updating steam. I downloaded steam through their site and installed it normally. When I run steam, it updates something and then it can’t find a DLL (steam.dll). Searched through the forum on the net, found some answers, try it out, still the problem persists.

I went ahead and find steam.dll, downloaded it, and it says can’t find steamui.dll. I downloaded that too and continued, it updates just fine.

Few hours ago, when I arrived home from work, ran steam and it doesn’t load. It says there’s no connection to steam. I deleted cleanregistry.blob and still no luck (but this time all the login info is lost). Restored the blob file and restarted the router. Finally it runs smoothly. This is some crappy software that valve have. Time to shoot some mutants!

Take a step back and think!

Posted by mkhairul - September 15, 2008 at 11:09:08 am - No Comments

Categories: Troubleshoot

On the weekend, I reviewed the tree traverse function that I did for an ongoing freelance project. Each node have 3 child. I tried to insert 200 records and it took quite a long time to insert the records into the database. 23 seconds.

I am quite sure of the code that I didn’t bother to look at it first and search for other means of alternative on improving the insertion. I googled around for MySQL performance and found a few posts on MySQL Performance Blog. Merge Tables. I need to find out more about this storage engine. I opened up High Performance MySQL, and read up on it.

After an hour reading the book, thinking of ways to implement it and including the constraints of current web host, I thought to myself, this is too hard and complicated, not that I can’t solve hard problems. Haha! I took a few steps back, and try to do something else like watching a funny anime, Gintama. Sometimes taking a break unravel the mind from all the messy thinking being done and makes it easier to think clearly.

Later on I try to think about it again and found out that I’m doing a depth-first search. Which is why it is taking such a long time. I rewrote it to use breadth-first search and it solved my problem for the mean time. I still have to test if it can handle 6165 data insertion.

Javascript, hide paragraph

Posted by mkhairul - August 6, 2008 at 04:08:58 pm - No Comments

Categories: Development, Troubleshoot

While I was developing a new app for use here at work. I tried to use javascript to hide an element and all of its contents.

To hide this html stuffs

When I click on the link "NEW CATEGORY", it executes the javascript function but the only thing that it hides is the label. Everything else stays. I thought there was a duplicate or some shit, but no, there's none. Then I remembered that you cannot put block elements inside an inline element (thanks to weekly check using w3cvalidator on my blog).

Cannot delete folder: Access is denied

Posted by mkhairul - May 20, 2008 at 07:05:40 am - 4 Comments

Categories: Tips, Troubleshoot

Ever stumble upon this message while trying to delete a file or a folder?

Cannot delete folder: Access is denied

Make sure the disk is not full or write-protected and that the file is not currently in use

Most probably you have, and most probably doesn't know how to handle this.

Continue reading Cannot delete folder: Access is denied...

Google App Engine static_dir workaround, windows

Posted by mkhairul - April 11, 2008 at 07:04:52 pm - No Comments

Categories: Development, Tips, Troubleshoot, blog

There's two workaround for Google App Engine dev_appserver.py workaround regarding the app.yaml configuration file.

Change lines 2369-70 in <installdir>\google\appengine\tools\dev_appserver.py from:

to:

or

The latter works for me.

Search