[solved] Database error 1142

Advanced Questions & Problems

[solved] Database error 1142

Postby jezza2243 » 6:25pm, Thu 25 Sep, 2008

Hello

What is "Database error 1142 while doing query INSERT command denied to user" please ?

I've used phplist for over a year now and had no problem sending out my automatic daily newsletter to 25000 subscribers...but for a week now...the newsletter is not coming out and when I log in to the phplist config panel, I've got this error message.

I don't think I am the only one with this problem as I found another user on Google (except that this guy has the "SELECT" instead "INSERT":

http://antiquewatchcouk.com/maillist/?p=unsubscribe

Anyone know what it is please ?

Thanks

J.
jezza2243
phpLister
 
Posts: 9
Joined: 9:48am, Fri 07 Sep, 2007

Re: Database error 1142

Postby H2B2 » 6:50pm, Thu 25 Sep, 2008

jezza2243 wrote:What is "Database error 1142 while doing query INSERT command denied to user" please ?
This thread could be related to the issue you are having: http://www.webdeveloper.com/forum/archi ... 69150.html

Try google with this search string for many more hits: database "error 1142"
H2B2
Moderator
 
Posts: 7188
Joined: 1:51am, Wed 15 Mar, 2006

Postby jezza2243 » 10:47am, Mon 29 Sep, 2008

Thx for your reply.

It was a "One and One" (apparently) common issue.

For everyone else using the 1&1 Cpanel to check the MySql database size and quota, I invite you to open the Phpadmin and check the files in the DB.

You will see that, although 1&1 is telling that you still have 15 MB left..., you will see in the phpadmin that you've got file way over the limit...
Empty them and after about one hour...the phplist should be back and running (back up your db just in case).

I personnaly empty the "userhistory" and "usermessage".
jezza2243
phpLister
 
Posts: 9
Joined: 9:48am, Fri 07 Sep, 2007


Return to Advanced Questions & Problems

Who is online

Users browsing this forum: No registered users and 1 guest