mySQL Error #1064

Posted on August 23rd, 2008 by graeinler
Filed under: applications, console, troubleshooting, webhosting | No Comments »

Importing and exporting mySQL dumps for most of the time is quick and easy even for both phpMYadmin and SSH. Unexpected errors do occur, considerably, if you are transferring your data between WebHosts and their different mySQL versions.

One of these is the Error #1064 which occurs due to a mismatch between the mySQL versions and it’s corresponding reserved words, which if used causes the error occur.

The simplest and most effective solution for it is.
Read the rest of this entry »

Lightbox 2 Quick Fix

Posted on May 23rd, 2008 by graeinler
Filed under: applications, hacking, troubleshooting | No Comments »

Author Homepage » http://www.stimuli.ca/
Plugin Homepage » http://www.stimuli.ca/lightbox/
On Wordpress » http://wordpress.org/extend/plugins/lightbox-2/installation/

I’ve addded Lightbox 2 for my plugin arsenal as part of this website semantic facade. Uncommon for most plugin installs, I got an error for this installation :(

Error:
Warning: opendir(/webpages/xx/bxxxxxxxxx/htdocs/xxxxx/domain.com/wp-content/plugins/lightbox-2/Themes) [function.opendir]: failed to open dir: No such file or directory in webpages/xx/bxxxxxxxxx/htdocs/xxxxx/domain.com/wp-content/plugins/lightbox-2/options.php on line 28

This “No such file or directory” gave it away as a quick check on the directory structure confirmed that its actually there. So it can only be of 2 things, the permissions on the folder or its filename.

I renamed the folder to ‘themes’ and it worked like a charm. I’ve never thought of linux to be picky on filenames but I have noticed that most have them in lowercase. I can’t explain why it happened, could be on the code of Lightbox or could be something else. But hey it works and I just love Lightbox 2.

Btw, if anyone can help me with my questions above, please feel free to educate me.

fixing data directory errors in squirrelmail

Posted on May 13th, 2008 by graeinler
Filed under: applications, console, troubleshooting | No Comments »

I decided to reinstall SquirrelMail hoping to be able to archive my current emails since those wont be carried over. when I switch mail service to Gmail. For the uninitiated, Squirrelmail is a webmail package written in pure Php, has few requirements and is very easy to configure and install.

Here’s a quick guide:

1. download squirrelmail here
2. Unpack the SquirrelMail package: [via ftp or tar]
3. run the installation script from shell. [perl conf.pl]
4. select ‘General Options‘ by hitting ‘4‘ on your keyboard and edit the ‘Data Directory‘ by selecting ‘1‘
this part here gets a bit tricky, but the idea is to provide the server path for the directories. If you directories aren’t existing yet then you would have to create them first.
5. Once satisfied with the changes - ‘S‘ to save your changes then ‘Q‘ to quit from the menu.
You may then check if your configuration worked via this link. http://your-squirrelmail-location/src/configtest.php

Hope this helps. Please feel free to ask questions if you got some.

continue: