Thread

Hi-

I am running ExpressionEngine v 1.6.8

When trying to access the blog:
http://johnsongray.com/blog/

I get this error only *sometimes*

MySQL ERROR:

Error Number: 1142

Description: UPDATE command denied to user ‘jgaeedb’@‘205.178.132.70’ for table ‘exp_members’

Query: UPDATE exp_members set last_visit = ‘1327713923’, last_activity = ‘1328681377’ WHERE member_id = ‘0’

The same error occurs on submit for login for the admin panel:
http://johnsongray.com/blog/myadmin/index.php

To my knowledge nothing has changed on the server.

Also - this is a build with a commercial license - I don’t know how to find the license though or if it’s attached to this forums login - if someone can tell me how to find it I can show the license.

please help!

thanks very much

Hello slbedard,

I am sorry to hear you are running into this problem.

This is very odd because there is no such thing as “member_id = ‘0’”.

Can I get a look at the template code where this error is being generated? Could maybe be that user_id=“0” is hard coded somewhere? You can paste the contents of the template where the error is being generated here.

I would like to start here, I have a few more ideas, but I think we might find what we are looking for with this first step.

I will be on the lookout for your response. Have a great day.

Cheers,

Hi Shane-

Thanks for your reply.

I can’t get into the templates because I get that same MySQL error when trying to login to my admin panel - but—i got into the MySQL database and found what I pasted below in exp_templates.  This is the index page- I removed HTML and just included sections with ee code:

{assign_variable:my_weblog="default_site"}
{assign_variable:my_template_group="jga"}



      <h1>Tweets</h1>
   
{exp:twitter_timeline screen_name="johnsongray"  limit="5"} 

<ul class="arrow"> 
<h3> {created_at format="%m-%d %g:%i"}</h3>
<p><a href="http://twitter.com/JohnsonGray/status/{id}" target="_blank" rel="noopener">{text}</a><br />
</ul></p>

<p>{/exp:twitter_timeline}</p>



<p><h1>Categories</h1></p>

<p>{exp:weblog:categories  show_empty="no"}</p>

<p><span class="title"><a href="http://{path=/jga/post}">{category_name}</a></span><br />
{/exp:weblog:categories}</p>

<p> </p>

<p><br />
   <h1>Archive</h1></p>

<p>{exp:weblog:entries weblog="{my_weblog}" dynamic="off"}</p>

<p>{date_heading display="monthly"}</p><h2>{entry_date format="%F"} </h2>
<p>{/date_heading}</p>

<p> <ul class="arrow"></p>

<p><a href="http://{title_permalink=">{title}</a></p>

<p></ul></p>

<p>{/exp:weblog:entries}   </p>



<p><br />
{exp:weblog:entries weblog="{my_weblog}" orderby="date" sort="desc" limit="8" disable="member_data|trackbacks"}</p>

<p>          <h1>{title}</h1></p>

<p>{summary}</p>

<p><br />
<a href="http://{title_permalink=">Permalink</a>   |   <br />
[removed][removed]</p>

<p> </p>

<p><br />
{/exp:weblog:entries}</p>

<p><br />
{exp:twitter_timeline screen_name="johnsongray"  limit="5"} </p>

<p><ul class="arrow"></p><h3> {created_at format="%m-%d %g:%i"}</h3>
<p><a href="http://twitter.com/JohnsonGray/status/{id}" target="_blank" rel="noopener">{text}</a><br />
</ul></p>

<p>{/exp:twitter_timeline}</p>



<p><br />
<h1>Categories</h1></p>

<p>{exp:weblog:categories  show_empty="no"}</p>

<p><span class="title"><a href="http://{path=/jga/post}">{category_name}</a></span><br />
{/exp:weblog:categories}</p>

<p> </p>

<p><br />
   <h1>Archive</h1></p>

<p>{exp:weblog:entries weblog="{my_weblog}" dynamic="off"}</p>

<p>{date_heading display="monthly"}</p><h2>{entry_date format="%F"} </h2>
<p>{/date_heading}</p>

<p>  <ul class="arrow"></p>

<p><a href="http://{title_permalink=">{title}</a></p>

<p></ul></p>

<p>{/exp:weblog:entries}   </p>



<p><br />
{exp:weblog:entries weblog="{my_weblog}" orderby="date" sort="desc" limit="8" disable="member_data|trackbacks"}</p>

<p>          <h1>{title}</h1></p>

<p>{summary}</p>

<p><br />
<a href="http://{title_permalink=">Permalink</a>   |   <br />
[removed][removed]</p>

<p> </p>

<p><br />
{/exp:weblog:entries}

Other things I can note is that it’s on a server running mysql 4 and that database says 80 of 80mb used (could space be the issue?)

Hello slbedard,

What is the exact version of your MySQL installation?

Can you look check out what your user id in exp_members is? Is it 1?

We might be getting close. 😊

Cheers,
Shane

MySQL client version: 4.1.22

in exp_members, for the user i logiin to the admin panel will the table reads:

member_id and group_id are ‘1’

weblog_id tmpl_group_id upload_id are ‘0’

Hello slbedard,

Just to clarify.

In the exp_members table you see the following?

weblog_id=0
tmpl_group_id=0
upload_id are=0

Would you mind including a screen shot?

Please let me know what you find.

Thank you,

Hi Shane-

So I think the problem was the mysql database was too full (was filled with spam comments).  I cleared the exp_comments entirely and everything seems to be working fine again.

To answer your question before;
weblog_id=0
tmpl_group_id=0
upload_id are=0

is true.

Anyway- everything is up and running again. 

Thanks again for your help!  Really appreciate it.

-summer

Hello Summer,

That is really odd. Hmmmm.

Well if this does come up again, please let me know!!

Cheers,