Drupal: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'foo.image_dimensions' doesn't exist

I ran into a WSOD on a Drupal site and checking the Drupal 7 log showed me the following:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'foo.image_dimensions' doesn't exist: SELECT * FROM {image_dimensions} id WHERE id.fid IN (:fids_0, :fids_1,

Drupal XMLSiteMap: public://xmlsitemap/ not found or not writable

I ran into the following error (or something like it) while setting up Drupal's xmlsitemap module:

public://xmlsitemap/lOtsOfgoBBlDegOOk not found or not writable

This is as expected some kind of permissions issue. Why the module can't sort this on its own, I do not know. As with everything Drupal, clear the cache first to see if that fixes things. It sometimes does. If not, you will need to get your hands dirty on the commandline (if linux):

Drupal's Twitter module: Column 'twitter_uid' cannot be null

I tried installing the Twitter module for a client and ran into the following error during authentication (oauth):

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'twitter_uid' cannot be null: INSERT INTO {twitter_account} …

Postfix: queue management commands

Here are some postfix queue management commands that I find myself using regularly (on an Ubuntu server):

Slow login into Ubuntu via SSH

Fresh install of Ubuntu Server 12.04 LTS: After installed SSHD, I found that logging in remotely was a time-consuming process as the password prompt took ages to pop up after the username prompt. Binging about, I found that this was due to SSHD performing a reverse DNS lookup of my IP to potentially check if all is kosher. Turning this check off fixes the issue:

Screen .screenrc configuration

All those who SSH into servers ought to use GNU Screen. The following is some additional configuration that can be added to a .screenrc file in your home directory. These lines do wonders to the usability of the system:

caption string "%?%F%{= Bk}%? %C%A %D %d-%m-%Y %{= kB} %t%= %?%F%{= Bk}%:%{= wk}%? %n "
hardstatus alwayslastline
hardstatus string '%{= kG}[ %{G}%H %{g}][%= %{= kw}%?%-Lw%?%{r}(%{W}%n*%f%t%?(%u)%?%{r})%{w}%?%+Lw%?%?%= %{g}][%{B} %d/%m %{W}%c %{g}]'

The drush command '@hostmaster pm-enable hosting_queued' could not be found

Installing Aegir 2 on a fresh install of Ubuntu Saucy in a Virtualbox, I ran into the following message:

The drush command '@hostmaster pm-enable hosting_queued' could not be found.

To fix this run, sudo mysql_secure_installation and ensure that you remove anonymous users. This should do the trick.

this kernel requires an x86-64 CPU, but only detects an i686 CPU, unable to boot

Using Virtualbox (4.3.6) on an XP64 machine, I ran into the following error while trying to install a 64-bit version of Ubuntu:

this kernel requires an x86-64 CPU, but only detects an i686 CPU, unable to boot

This happens even if the host machine is a 64-bit machine. To fix this, reboot the box and enter the BIOS. Look around for a virtualisation setting and enable it. Save and exit the BIOS configuration screen.

What to do when 'dpkg --configure -a' does not work?

I recently had trouble with a MySQL installation in Ubuntu. For some reason or the other, during an upgrade to a newer version of mysql-server, the upgrade script had issues stopping the server and the script failed. This meant that apt could no longer function as it kept raising a red flag over the broken upgrade with the following instructions:

dpkg was interrupted, you must manually run 'dpkg --configure -a' to correct the problem.

Updating Windows Installer on XP 64-bit

I ran into a hitch while trying to install the latest version of TortoiseSVN on my XP 64-bit Windows installation. Apparently, the entire world has forgotten about the existence of this variety of Windows. There's absolutely no mention of it anywhere on TortoiseSVN's installer page. The MSI installer failed stating that the version of Windows Installer that I was using was dated and that I needed to update my version of XP (x86) to SP3 or some other drivel like that. TortoiseSVN has no manual install option either. I did the whole Windows Update thing as well, to no avail.

Pages

Subscribe to languor.us RSS