• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

What is wrong with my MySQL database?

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'@'62.149.143.21' 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/www.simonettaaggazzotti.it/home/libraries/joomla/error/exception.php on line 117


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

Thx in advance
0
badwolfff
Asked:
badwolfff
  • 5
  • 3
1 Solution
 
badwolfffAuthor Commented:
One thought is that the site worked perfectly till daylight changes occurred
I had installed a plugin
http://extensions.joomla.org/extensions/hosting-a-servers/servers/9268
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.
0
 
ienaxxxCommented:
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!
0
 
ienaxxxCommented:
The solution, ob.ly, 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.
Bye!
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
badwolfffAuthor Commented:
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
0
 
badwolfffAuthor Commented:
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
0
 
badwolfffAuthor Commented:
Partial and unclear answer which the member never clarified despite the request
Had to work out most of it by myself
0
 
ienaxxxCommented:
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.
0
 
badwolfffAuthor Commented:
Thanks anyway all ok now
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now