What is wrong with my MySQL database?

Posted on 2011-10-31
Last Modified: 2012-08-13
When I access my joomla site I get this error:

jtablesession::Store Failed
DB function failed with error number 1142
INSERT command denied to user 'Sql295714'@'' for table 'jos_session' SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'r1naudn4q8g8kdcrju9sd89435','1320054994','','0','1','0' ) Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 3 bytes) in /web/htdocs/ on line 117

Please tell me how I might fix this? I am panicking!

Thx in advance
Question by:badwolfff

    Author Comment

    One thought is that the site worked perfectly till daylight changes occurred
    I had installed a plugin
    for joomla 1.5 to auto adjust the published and publish/archive time on all my blog articles

    I don't have a copy of the db before this error appeared
     I can download the database as it is right now though (unfortunately with above error)

    I hope I can still fix it.
    LVL 10

    Expert Comment

    Hi, you should check the authorizations your user has on that table.

    This problem is often caused by a misconfiguration of the default permissions of a user for newly created tables.

    I mean: if your user is only allowed to read by default and then manually allowed to write over a specific table set, when a new table is created from another interface, your user is not allowed to write on that table.

    HTH Bye!
    LVL 10

    Accepted Solution

    The solution,, is to login on the MySql mgmt console and add write permission to your user on all the tables where these are not present, if you're allowed to do so.
    Otherwise is to request that actions to an administrator.

    Author Comment

    Thanks so much for the reply
    I will definitely try it out as soon as I get home tonight
    If, in the meantime, I understand you right, by changing the perms and then refreshing the website homepage, it should work?

    Also last question: I access my database using phpmyadmin console with admin access - can I manage to change perms using that?

    Thanks again for the help

    Author Comment

    hi ienaxxx

    your explanation is unclear
    Could you please explain more clearly what I need to do as I was unable to fix the database so far

    thx in advance

    Author Closing Comment

    Partial and unclear answer which the member never clarified despite the request
    Had to work out most of it by myself
    LVL 10

    Expert Comment

    Sry Badwolfff,
     never intended letting u alone...

    Here in Italy the 1st of November is holiday (since it's the all-saiints Christian celebration) and i didn't check EE for requests.

    Anyway, EE answers are not intended to do the work for you, but to point you in the right direction.
    I told you to add permissions on the tables, that is really easy, using phpmyadmin or another mysql admin software.

    Glad to be of help and again sorry, anyway.

    Author Comment

    Thanks anyway all ok now

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Suggested Solutions

    This article is filled with multiple code samples and explanations for mathematical calculations. They are as follows: 1. General tips 2. Quadratic formula 3. Object collision 4. Projectile path General Tips       Here are some of my tips f…
    This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now