If you have defined table prefix, the since the code does not adhare to "drupal" way it can't find the node table. All
reference to this code

result = db_query("SELECT nid FROM node WHERE status=1 ORDER BY nid")

Need to change to

result = db_query("SELECT nid FROM {node} WHERE status=1 ORDER BY nid")

So it find the correct table with table prefix.

However I could not test this completely because of issue number #245169: Exported pages empty. But the code above is required as without it I get table not found error.

Comments

ajayg’s picture

ajayg commented
Status: Active » Needs review
btopro’s picture

btopro commented

I'll patch that asap, this could be the reason for pages not publishing out though.

ajayg’s picture

ajayg commented

I already tried with this patch, still empty pages are getting created.

btopro’s picture

btopro commented
Status: Needs review » Fixed

New version coming shortly (later today). I believe I've fixed the blank page issue, just tested on a lot of different installs w/ different settings on the URLs and it worked.

Also patched the code that you indicated.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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

christian_gnoth’s picture

christian_gnoth commented
Project: HTML Export » Drupal core
Version: 5.x-1.0-beta2 » 6.8
Component: Code » node system
Status: Closed (fixed) » Active

Hello,
i am using drupal 6.12 and having the same problem. only with node included in {} it is working.

ajayg’s picture

ajayg commented
Project: Drupal core » HTML Export
Version: 6.8 » 6.x-1.0
Component: node system » Code

When I opened this issue it was against HTML export module. Why you changed to drupal core? Chnaging back the project as I am not aware of any issue with core.

btopro’s picture

btopro commented
Version: 6.x-1.0 » 6.x-2.0-alpha1
Status: Active » Fixed

Status: Fixed » Closed (fixed)

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