Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.Unknown column 'nid' in 'field list' query: SELECT nid FROM playlist_relate WHERE child_id = 0 in /public_html/ADR/includes/database.mysql.inc on line 66
Hellllllp! I'm not very familiar with PHP and MYSQL. I'm a Drupal newbie. Can someone explain in layman's terms? Much appreciated.
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | playlist.module_1.patch | 656 bytes | oadaeh |
Comments
Comment #1
zirafa commentedHi, did you run the database script that came with all the files? In addition to uploading the files to your server, you'll need to run a script on your database in order for this module to work.
Comment #2
alphadawg commentedHi Zirafa,
Thanks for the response. I installed the Playlist.mysql to my database as described in the install file when I uploaded the module initially.
Comment #3
oadaeh commentedOkay, I have found the cause and cure for this problem. In two places, $nid is used where $parent_id should be. The patch will make everything all better. :^) It helped me to find this because I noticed a problem with audio nodes not recovering their playlist information. I suspected the two issues were related, and they were.
Comment #4
oadaeh commentedOkay, it's nid and parent_id, rather than $nid and $parent_id. :^)
Comment #5
zirafa commentedPatch committed. Thanks.
Comment #6
alphadawg commentedThanks to all of you for your kind help. It's very much appreciated.
Comment #7
zirafa commented