<div>Hello Jason,</div>
<div> </div>
<div>No mods that I'm aware of. The module size, time and date match the one from the distribution file.</div>
<div>Below is my user.module starting at line 365. From what I can see it matches perfectly the user.module in the distribution file.</div>
<div> </div>
<div>Thanks,</div>
<div>Skip</div>
<div> </div>
<div>365 // To reduce the number of SQL queries, we cache the user's permissions<br>366 // in a static variable.<br>367 if (!isset($perm[$account->uid])) {<br></div>
<div>368 $rids = array_keys($account->roles);<br>369 $placeholders = implode(',', array_fill(0, count($rids), '%d'));<br></div>
<div>370 $result = db_query("SELECT DISTINCT(p.perm) FROM {role} r INNER JOIN {permission} p ON p.rid = r.rid WHERE r.rid IN ($placeholders)", $rids);<br></div>
<div>371 $perm[$account->uid] = '';<br>372 while ($row = db_fetch_object($result)) {<br>373 $perm[$account->uid] .= "$row->perm, ";<br><br></div>
<div class="gmail_quote">On Nov 29, 2007 12:56 PM, Jason Flatt <<a href="mailto:drupal@oadaeh.net">drupal@oadaeh.net</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div class="Ih2E3d">On Thursday 29 November 2007 12:33:04 Skip Taylor wrote:<br>> Hello,<br>><br>> I've had this on the Drupal forum for almost a week with no reply. I hope<br>> someone here has an idea!<br>
><br>> Using Drupal 5.3. Site is upgraded. Originally 4.6 (new), then to 4.7, then<br>> to 5.3 if that matters. Theme is BlueMarine.<br>><br>> When I go to the comment/settings page, I get these 4 errors reliably in
<br>> the log:<br>><br>> Location: <a href="http://www.mydomain.com/admin/content/comment/settings" target="_blank">http://www.mydomain.com/admin/content/comment/settings</a><br>> Message: array_keys()<br></div>
> [function.array-keys<<a href="http://drupal.org/node/function.array-keys" target="_blank">http://drupal.org/node/function.array-keys</a>>]:<br>
<div class="Ih2E3d">> The first argument should be an array in /modules/user/user.module on line<br>> 368.<br>> --------<br>> Location: <a href="http://www.mydomain.com/admin/content/comment/settings" target="_blank">
http://www.mydomain.com/admin/content/comment/settings</a><br>> Message: array_fill()<br></div>> [function.array-fill<<a href="http://drupal.org/node/function.array-fill" target="_blank">http://drupal.org/node/function.array-fill
</a>>]:<br>
<div class="Ih2E3d">> Number of elements must be positive in /modules/user/user.module on line<br>> 369.<br>> --------<br>> Location: <a href="http://www.mydomain.com/admin/content/comment/settings" target="_blank">
http://www.mydomain.com/admin/content/comment/settings</a><br>> Message: implode()<br></div>> [function.implode<<a href="http://drupal.org/node/function.implode" target="_blank">http://drupal.org/node/function.implode
</a>>]: Bad arguments.<br>
<div class="Ih2E3d">> in /modules/user/user.module on line 369.<br>> --------<br>> Location: <a href="http://www.mydomain.com/admin/content/comment/settings" target="_blank">http://www.mydomain.com/admin/content/comment/settings
</a><br>> Message: You have an error in your SQL syntax; check the manual that<br>> corresponds to your MySQL server version for the right syntax to use near<br>> ')' at line 1 query: SELECT DISTINCT(p.perm
) FROM role r INNER JOIN<br>> permission p ON p.rid = r.rid WHERE r.rid IN () in<br>> /includes/database.mysql.inc on line 172.<br>><br>> I've disabled ALL modules, yet the error persists. Not sure where to go
<br>> with this next. Is it a problem with comments , something wrong in the<br>> database or the user database/module?<br>><br>> Thanks for any ideas!<br>><br>> Regards,<br>> Skip Taylor<br><br></div>
Has anyone modified that file? What is on lines 368 and 369 of<br>your /modules/user/user.module file?<br><br>--<br>Jason Flatt<br><a href="http://www.oadaeh.net/" target="_blank">http://www.oadaeh.net/</a><br>Father of Six:
<a href="http://www.flattfamily.com/" target="_blank">http://www.flattfamily.com/</a> (Joseph, 14; Cramer, 12; Travis,<br>10; Angela; Harry, 7; and William, 12:04 am, 12-29-2005)<br>Linux User: <a href="http://www.xubuntu.org/" target="_blank">
http://www.xubuntu.org/</a><br>Drupal Fanatic: <a href="http://drupal.org/" target="_blank">http://drupal.org/</a><br><font color="#888888">--<br></font>
<div>
<div></div>
<div class="Wj3C7c">[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></div></div></blockquote></div><br><br clear="all"><br>-- <br>Half of being smart is knowing what you're dumb at. -- David Gerrold
<br>---<br>NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.