Archive for the ‘General’ Category

My PayPal horror story, and why I’m never using them again.

It all begins with me setting up a business paypal account.
I COULD have used my personal account that was established when paypal launched, but I decided that a dedicated business account would be a better choice.

So, I set it up, gave them all the information they requested, and I was up and running.
I get a “account is limited” email a few days later, they want some more information, a credit card number, basic stuff, which I’m happy to provide. Upon doing so I’m back and “unlimited”. Everything seemed fine.

Fast forward exactly 2 weeks, I get an email like before saying my account is locked. This time they want very specific information; proof of my SSN/birthdate, proof that I was actually shipping products, invoices, and my supplier’s information.
I’m a bit confused, but agree to send them all the information they requested. A scan of my SSN, a screenshot of my stamps.com account showing that the orders were shipped, PDF’s of invoices, and a PDF with orders for 5 sets of materials.

The proof of shipping was almost immediately acknowledged and checked off the list, as was my birthdate.
However, my SSN, invoices, and supplier information sat as “In Progress” for a while. I called and asked how long it normally takes and was told 24-72 hours. Ok, I can live with that, I could still accept orders, I was just prohibited from withdrawing money.

About 5 hours go by, I get an email with a subject “PayPal appeal denied” I thought, that’s weird, I didn’t think I was appealing anything…I open the email to find “For the safety and security of the PayPal network, we often review accounts for potential risks. After reviewing your account, we have decided to close it because of security issues. We are making every effort to minimize any disruption to your business.”

SERIOUSLY? For one, there were no security issues, I was operating a completely legitimate business, with no issues what so ever. Secondly, “We are making every effort to minimize any disruption to your business” what a bunch of BS! The least they could do was CALL ME, or say “we’re closing your account in 24 hours”. I would still be mad, but far less furious… to find out my account was outright closed with no warning, thus preventing any further orders from coming in…. I IMMEDIATELY called PayPal, spoke to a person with the authority of a store greeter, who forwarded me to the account department. I spoke to a “Jermey”, who was unhelpful to say the least… He couldn’t provide ANY information except from what he was reading from a script, I asked for his supervisor and was transferred to “Gavin” who claimed he was the highest in the department. (which I doubt, but moving on) Gavin stated that my account was closed and would not be reopened under any circumstances. I asked what the reasoning behind this was, and he provided a very vague answer, “the risk of the account was too high” and that it was a “newly opened account”. Just like Jermey, he was reading from a script, they both said the exact same things when I questioned them. I told Gavin to put himself in my shoes, what would he do if his bank decided to close his account without warning. He agreed, saying he would be very frustrated, but still would not provide any real information. He basically summed the conversation up by saying, “I can’t tell you because it’s internal company information, the decision is final, the account will not be reinstated for any reason, and there is no one higher to speak with.”

At this point, I realized I wasn’t getting anywhere, I said thank you for your time and ended the conversation.

I immediately signed up for Google Checkout, and have been using it since.

At this point, I’m stuck with a locked paypal account with $800 trapped inside that can’t be accessed for 180 days. I should also mention that paypal ALSO locked my personal account that I’ve had since about 2000. I’m never using paypal again, for anything, or for any reason.

2010 Pioneer Road Show!

A huge thanks again to Pioneer for sending me to their 2010 Pioneer Road Show! This will be the third year they have graciously invited me to attend on behalf of AVIC411.com.

Their 2010 Road Show will take place on April 28th, stay tuned to AVIC411.com for the latest info from the road show.

Restoring a deleted topic from PHPBB.

To anyone who runs a forum based website, there will come a time when you accidentally delete, or a moderator will delete a topic that should not have been deleted.
This is devastating to a forum running on PHPBB since there is no “undo” or “trash can”, once it’s deleted, the posts/topic are dropped from the sql database, and the attachments (if any) are removed from the attachment directory. They are truly “gone”.

Now, lets assume you have server backups, as you should. Also, this is a complicated process and should only be done in extreme cases. (like when a 63 page topic with 942 posts gets accidentally deleted by a moderator)

The requirements:
First, you’ll need the sql database backup, if there were any attachments with the topic, you’ll need a web file backup as well.
Second, you’ll need to know the ID of the topic you’re trying to restore. Let’s say for example the topic_id was 26446.
Third, you’ll need either a empty database and/or a virtual environment.

Lets begin:
1. Extract your sql backup into an empty database. I’ll be using phpmyadmin for this example.
2. Go to search, enter your ID number as the search value, exact match, select all tables, and specify “topic_id” for the inside field.

3. This will return a result that looks like this:

3. There are only a few tables here that are required: “phpbb_attachments”(if you have any), “phpbb_posts”, and “phpbb_topics”. Click browse on each of these, being sure to open them in a new tab/window.

4. At the bottom of each browse window is a “Export” link, click that, you’ll get a screen like this:

UNCHECK THE STRUCTURE BOX! You just want the data. You also want to save this as a file. Repeat these steps with the two other tables.
5. Now switch over to your live/production database, go to the “Import” tab, and upload the 3 files to it.

Assuming there are no import errors, you’re done importing the sql data! The restored topic should be visible and functional again, the only thing missing at the moment should be attachments.

Now lets assume you have attachments, as a good portion of topics do:

1. Open the phpbb_attachments sql file that we made in step 4 with a text editor.

2. I know this looks crazy, but trust me, it’s easier then you think. All we care about is the large random string in the middle: “32106_0ffb39ce936e4c0b5237c01859df9041″ This is the “image” after phpbb converts it.
3. Open your web file backup to the directory where attachments are stored, and search for the string. You should get something like this:

4. FTP the file, and the thumb file (if it exists) to your live/production attachment file directory. Repeat for each file in the phpbb_attachment table.

THAT’S IT! Thank god it’s over… Be more careful next time!

Why Hard Drive Upgrades are Important

You may think Hard Drives are all the same, and that there is no reason to upgrade unless you need more space, however that is NOT the case. Drives are getting faster and faster all the time, with more and more cache.
Take for example this mac mini with the standard 5400 RPM Hitachi Laptop Drive, it was replaced with a 7200 RPM Western Digital Black Drive. The drive benchmarks over 3 times higher, and the system has a dramatic performance boost.

Apple WWDC Here I Come!

Well, since I wasn’t accepted to go via the Student Scholarship program, I dove into my savings, and credit card, to finance the $1300 ticket. I’ll see you guys (and Robert) there!
its final!
WWDC $1300

Apple WWDC 2008 developers conference sold out

WWDC has never sold out before, but presumably the influx of iPhone developers has brought registration to new levels. Good thing I already got a ticket!
Sold Out

read more | digg story

Apple WWDC Student Scholarship Denied

Denied!
Well, it was almost a month coming…tonight I got a “sorry your on a waiting list” email from Apple regarding my application for WWDC08.

Network+ Certified!

As of June 14th 2007, I am CompTIA Network+ Certified! This is an add-on to my A+ Certification which was on 8/2/05.

Disney Grad Nite 2007!

Disney Grad Nite was AMAZING!
Congratulations Class of 2007!

I have a 30 minute video here:

jasonhilton.us/gradniteweb.wmv (95mb)

XM Radio Launches 4th Satellite

XM Radio announced the launch of the XM-4 broadcast satellite today, planned for October 26.
Designed for a 15-year lifespan, the XM-4 satellite will have 18 kilowatts of total power at the beginning of life on orbit.

read more | digg story

Return top