PDOException Help

I'm getting the error below in conjunction with using Ubercart for ecommerce on our site. Not quite sure where to start in fixing it. Any suggestions?

Search custom fields

Isn't there a Search module that searches custom fields, namely fields used for Drupal Commerce products?

Drupal's core search module should do this but doesn't. Custom Search doesn't do it either. Using Views with exposed forms is clumsy. Solr seems overkill.

What's the solution?

domain name lost, how to convert all linkes to new domain


I did my homework. All google search result suggests when I change the domain name, the easiest way is to make a symbolic link under 'sites', or to write URI redirect/rewrite rules in .htaccess.

But that is on the assumption I still own the old domain. Both methods would not work for me, because I lost the domain name. In fact not me, the webmaster belongs to someone else, and he forgot to prolong the domain name for so long that there is no hope to recover it.

Suddenly can't upload images - An unrecoverable error occurred

I'm brand new to using Drupal (been using about 4 days), but I'm a pretty quick study (i think)~

I was trying to create a Slideshow using Views just to see how it works. I was able to upload some images without any issues, and I got a nice little tester slideshow on my home page.

But when I tried to create a second Slideshow, all of a sudden when I went to upload an image, I got the message:
An unrecoverable error occurred. The uploaded file likely exceeded the maximum file size (8 MB) that this server supports.

Invalid URL cause PDO Exception: Drupal+Postgres

Steps to reproduce:

  1. Install a fresh drupal 7.16 with an empty postgres database
  2. Access to a bad formed url like: "http://drupal_test.local/node/a"

instead of get a propper message like:

Page not found

The requested page could not be found.

you will get an:


The website encountered an unexpected error. Please try again later.
Error message
PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "a" LINE 5: WHERE (base.nid IN ('a')) ^: SELECT revision.vid AS vid, base.uid AS uid, revision.title AS title, revision.log AS log, revision.status AS status, revision.comment AS comment, revision.promote AS promote, revision.sticky AS sticky, base.nid AS nid, base.type AS type, base.language AS language, base.created AS created, base.changed AS changed, base.tnid AS tnid, base.translate AS translate, revision.timestamp AS revision_timestamp, revision.uid AS revision_uid FROM {node} base INNER JOIN {node_revision} revision ON revision.vid = base.vid WHERE (base.nid IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => a ) in DrupalDefaultEntityController->load() (line 196 of /media/respaldolaptop/asusul30/workspace/drupal_test/drupal-7.16/includes/entity.inc).

Page content not available in drupal 7


I recently installed drupal 7 (minimal configuration). I have been using drupal 5 & 6 and never had any issues in creating pages.

When I click on Create Content though, I don't get the "Basic Page" content type listed....... I just have a "Product" content type from the Ubercart 3 module I installed (which creates product nodes okay)

Do I need to activate some particular module to create pages content type?


Subscribe with RSS Subscribe to RSS - Drupal 7.x