<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Thanks<br>
<br>
Well I found the specific error - it's that there's a double distinct
in the sql - <br>
instead of SELECT COUNT( DISTINCT (n.nid) ) AS count... (which works,
when querying directly against the database)<br>
it's calling SELECT COUNT(DISTINCT DISTINCT(n.nid)) AS count...<br>
I looked at the code and the extra DISTINCT is not in the sql so it's
getting stuck in there by something - perhaps another module I
installed or something? I can't figure out what that other module
might be, or where the extra DISTINCT is getting inserted.<br>
<br>
.s<br>
<br>
p.s. - i backed up both the specific table in question as well as the
entire database before starting to do anything.<br>
<br>
<br>
Shai Gluskin wrote:
<blockquote
cite="mid:9f68efb70709191028h5adc0307l9eb48bc179ff2317@mail.gmail.com"
type="cite">Sandor, I have no experience with that particular module.<br>
<br>
One thing you might try if you have cpanel access is to click the mysql
button on cpanel, find the appropriate database in the list of
databases for your account and then click on "repair" (obviously you
should back up the db before you do this). That worked for me once when
there were sql errors appearing.
<br>
<br>
As for reinstalling... disabling the module will not affect any info in
the db. Deleting the module should delete the appropriate tables from
the db if the module was written correctly. Neither of those activities
affects the files in your files directory. You could always delete
those and reinstall them with the latest version of the module.
<br>
<br>
Shai<br>
<br>
<div><span class="gmail_quote">On 9/19/07, <b
class="gmail_sendername">sander-martijn</b> <<a
moz-do-not-send="true" href="mailto:sander@sander-martijn.com">sander@sander-martijn.com</a>>
wrote:</span>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi,<br>
<br>
I'm having a problem with a module that was working before. It's with<br>
the location module and there's an sql error suddenly. As far as I know<br>
nothing was changed. I was thinking that a good first start would be
to
<br>
reinstall the module and see if that fixes it, since the module worked<br>
in the beginning. Is there a way for me to do that without deleting the<br>
data that's already been mentioned? Can I just trigger the install
<br>
function in some way? If I disable and/or delete the module will it<br>
delete the relevant data already entered? Pardon me if this is<br>
something that's different per module, I'm hoping there's a standard
<br>
answer, or that someone has specific experience with this module and<br>
this problem.<br>
<br>
.s<br>
<br>
--<br>
[ Drupal support list | <a moz-do-not-send="true"
href="http://lists.drupal.org/">http://lists.drupal.org/</a> ]<br>
</blockquote>
</div>
<br>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<hr align="center" noshade="noshade" size="1" width="100%">
<p
style="text-align: center; font-family: verdana,arial,helvetica,sans-serif; color: rgb(51, 51, 51); font-size: 10px; text-transform: lowercase; font-style: normal; font-weight: normal;"><a
href="mailto:sander@sander-martijn.com"
style="text-decoration: none; color: rgb(0, 0, 255); font-family: verdana,arial,helvetica,sans-serif;">sander-martijn</a><br>
interface developer | architect<br>
<a href="mailto:sander@sander-martijn.com"
style="text-decoration: none; color: rgb(0, 0, 255); font-family: verdana,arial,helvetica,sans-serif;">sander@sander-martijn.com</a><br>
<a href="http://www.sander-martijn.com"
style="text-decoration: none; color: rgb(0, 0, 255); font-family: verdana,arial,helvetica,sans-serif;">www.sander-martijn.com</a>
</p>
<hr align="center" noshade="noshade" size="1" width="100%"></div>
</body>
</html>