can not find node table when using a table prefix
ajayg - May 25, 2008 - 17:52
| Project: | HTML Export |
| Version: | 6.x-1.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
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.
#1
#2
I'll patch that asap, this could be the reason for pages not publishing out though.
#3
I already tried with this patch, still empty pages are getting created.
#4
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.
#5
Automatically closed -- issue fixed for two weeks with no activity.
#6
Hello,
i am using drupal 6.12 and having the same problem. only with node included in {} it is working.
#7
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.