Warning: strpos() [function.strpos]: needle is not a string or an integer in /home/beardedd/public_html/home/index.php on line 41
hOme.beardedDonkey - Mazda CX9 / Vehicle Spare Parts
Mazda CX9 / Vehicle Spare Parts 
This is an entry to explain how to look up spare parts for cars online.

SupercheapAuto My Garage


The best way to find spare parts for your Mazda CX9 or any vehicle is to go to supercheapauto.com.au and use their "My Garage" feature. Enter your vehicle registration number, or choose which model vehicle you want to find parts for, click the little yellow arrow head that points down on the My Garage section on the main website page and then click "Shop All Parts For My Vehicle".

The page that loads will look a bit like a website from 1998, and it shows you all the spare part categories on the left which you can use to filter the products shown on the right. This catalog system is pretty good and it shows you photos of the parts in some cases which is really helpful. Once you find a part you want, you should then get some sort of part number, code or brand name you can google further to get more info.

Google for more Info


For example, I was after an air conditioning/heater blower motor for my Mazda CX9. I looked up the part in SCA's My Garage, then noticed it was made by a company called JAS Oceania.

Googling JAS Oceania brought up a location only about 1km away from the SupercheapAuto store's location in my area. In other words, the supplier of the part is in the same suburb as SupercheapAuto's store. I might be able to buy directly from the spare part manufacturer? The advantage to doing this is a lower lead time. I might be able to get the part immediately instead of waiting for SCA store to have it sent over to them, which can take at least a half day and usually takes a day on average in my experience.

Most spare parts, but not all, will have a part number on them and perhaps a brand name. This is a really good way to find the part online. Google for the brand and part number and you will find you can probably buy the part from a number of online stores, but buyer beware - I found the blower part I wanted on AliExpress but it wasn't the full part with the cylindrical fan blades attached. It was only the motor segment of the part and the pricing was about the same as buying the whole part locally. I prefer and recommend buying locally over online, especially for automotive spares because if the part is incorrect you can return it and exchange it or get a refund. Doing this is a big hassle with online purchases.

[ view entry ] ( 126 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 3 / 120 )
SQLite How to select a particular day of the week using date function 
This will select last Thursday's date:

SELECT date('now', 'weekday 4', '-7 days')


weekday 4 = Thursday, but if we want last week we have to -7 days from it.

If you want the date to be returned as unix epoch value, do the following:

SELECT strftime('%s', date('now', 'weekday 4', '-7 days'))


[ view entry ] ( 281 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 3 / 226 )
KVS Build Error Found character '}' (Unicode 7d) where an instruction was expected 
There is an error that you can get when building your KVS code and it tells you it found a curly brace when it shouldn't.

This can happen if you start writing a section of code and then forget about it and lose track of where you were in the Code Editor. This error is saying to you, "you've left out a curly brace or a parenthesis or something" and it will report to you a line number but this is the problem. The line number given sometimes is not helpful. In my case, it said:
[15:11:46] [KVS] Compilation error: Found character '}' (Unicode 7d) where an instruction was expected
[15:11:46] [KVS] In script context "kvirc::corecall(run)", line 978, near character 5
[15:11:46] [KVS] Code listing:
[15:11:46] [KVS] 976 ...
[15:11:46] [KVS] 977
[15:11:46] [KVS] 978 }
[15:11:46] [KVS] 979 }
[15:11:46] [KVS] 980 ...
[15:11:46] [KVS] Window:
[15:11:46] [KVS] classeditor [ID: 24]

So I knew what the problem was, and I knew it was in my classes code ("Window: classeditor" but it said "script context kvirc::corecall(run), line 978". This is not that helpful because when you're using Code Editor inside KVIrc all the code is split into classes and functions so line numbers don't match what you're looking at.

How to find the location of the problem


The way to find where this problem is, is to do the following:
1. In Class Editor, click Save button
2. Next, opposite click the class in the Class Editor's hierarchical tree and export the classes code to a new temporary file somewhere (keep a backup of your old classes code just in case)
3. Now go to Scripting -> Execute Script in KVIrc and select the file you just exported. KVIrc will try to load the code but fail with the same error it found before. But this time it will give you a line number you can actually find. In my case it said:
[16:16:38] [KVS] Compilation error: Found character '}' (Unicode 7d) where an instruction was expected
[16:16:38] [KVS] In script context "F:/temp/classes.kvs", line 2598, near character 5
[16:16:38] [KVS] Code listing:
[16:16:38] [KVS] 2596 ...
[16:16:38] [KVS] 2597
[16:16:38] [KVS] 2598 }
[16:16:38] [KVS] 2599 }
[16:16:38] [KVS] 2600 ...
[16:16:38] [KVS] Window:
[16:16:38] [KVS] classeditor [ID: 24]

Now I could go to the exported file, line 2598, and see the section of my code that was causing the problem.

Ohthankgoodness.

[ view entry ] ( 408 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 3 / 400 )
mysqldump gives Error 1045 access denied when using .my.cnf for automated backups using sh script 
I had to change my passwords recently and I found that after I did this for the credentials used to access my mysql databases that my automated backup scripts became broken. I finally found a fix for this.

It turned out that if you use special characters in your passwords like !@#$%^&*() this will confuse mysqldump when it's reading your login credentials from a my.cnf file.

The my.cnf file is used mostly when you want to create an automated method of backing up your mysql database contents. Since the process is automated and it needs a password, it's a security risk to just use the -p switch with mysqldump in your shell script because the password will be exposed in plain text in the process list of the machine while the mysqldump process runs.

The my.cnf file holds the login credentials on disk, but are set to be only readable by your user, so other users can see what's in the file. The mysqldump process can read the file to get the credentials, keeping them safe.

I found a forum posts here: https://www.virtualmin.com/node/21032 by chitoz that had a small mention about the character # being used in his password and it creates problems.

The fix for this was to edit the my.cnf file and enclose the password string in single quotes:

[client]
username = user
password = 'specialChars@$#&%'

[ view entry ] ( 452 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 3 / 612 )

<<First <Back | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | Next> Last>>