I have created a simple content type, and selected title as the unique field. On creating a new page I get the following error:

* user warning: Unknown column 'node.nid' in 'field list' query: SELECT DISTINCT(node.nid) FROM mysite_node WHERE title = 'Test1' AND type = 'uniquetest' in /home/user/public_html/includes/database.mysql.inc on line 172.
* warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/user/public_html/sites/all/modules/mods_cck/unique_field/unique_field.module on line 138.

I am using a multisite setup with some shared tables, the site I am testing on is called "mysite" with most tables prefixed with "mysite".

Comments

arithmetric’s picture

arithmetric commented
Assigned: Unassigned » arithmetric

scedwar,

Thanks for reporting this issue. I've fixed the database queries to handle table prefixes in my latest update (2/22/2008). Could you give it a try?

scedwar’s picture

scedwar commented

That seems to have fixed it. Thanks, Stephen

scedwar’s picture

scedwar commented
Status: Active » Fixed
Anonymous’s picture

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

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