Hi: I'm really looking forward to using this module; however I get a reproducible MySQL error every time I try.

1. Fresh install of Drupal 5.1, brand-new empty MySQL database

2. No other 3rd-party modules loaded, just pBlog (5.x-1.x-dev from posting date)

3. Create admin account, post a dummy static page for some initial content.

4. Click Create content > pBlog, enter title and body, select a zip file containing about 18 .jpg images.

5. Click Submit; page claims to have been created.

6. Click breadcrumb > Home. Only my first posting (from step 3) appears. Hmm.

7. Click pblog in navigation area. I get:

warning: Invalid argument supplied for foreach() in /Library/WebServer/Documents/drupal/modules/node/node.module on line 504.

warning: implode() [function.implode]: Bad arguments. in /Library/WebServer/Documents/drupal/modules/node/node.module on line 508.

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /Library/WebServer/Documents/drupal/includes/database.mysql.inc on line 172.

I'm using Mac OS X 10.4.8 (desktop, not server), with PHP 5.0.4, Apache 1.3.33, MySQL 5.0.27. Safari 2.0.4 browser.

What am I missing?

Comments

toma’s picture

Nice idea and module, i have the same errors

Chill35’s picture

Stephanie, this looks like there is a call in pblog.module to Drupal's function node_load with an undefined argument.

stella’s picture

I have the same problem.

baldy’s picture

Status: Active » Fixed

I have fixed this error in the latest version. The module uses some system calls at the moment so I am not sure if it would work on OS X. I use and test it on Linux.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.