It is currently Fri Nov 27, 2020 7:44 pm


All times are UTC


Forum rules


Please click here to view the forum rules



Post new topic Reply to topic  [ 21 posts ] 
Author Message
 Post subject: Help! My forum stopped! :S
PostPosted: Fri May 20, 2005 2:21 pm 
Noobie
Noobie

Joined: Sun Feb 27, 2005 8:43 am
Posts: 40
Code:
phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1044 Access denied for user: 'jemarx_forum@70.84.139.2' to database 'jemarx_forum'

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('d8e7640bceb4101d07a64c7b16474520', 2, 1116595757, 1116595757, '91350b69', 0, 1)

Line : 170
File : sessions.php


My site; jemarx.freecoolsite.com


I want to go to my forum and now this! Whats the problem? HELP ME! My forum is very popular...


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 20, 2005 4:12 pm 
Noobie
Noobie

Joined: Sun Feb 27, 2005 8:43 am
Posts: 40
BUMP


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 20, 2005 4:40 pm 
Noobie
Noobie

Joined: Sun Feb 27, 2005 8:43 am
Posts: 40
BUMP!


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 20, 2005 5:58 pm 
Noobie
Noobie

Joined: Sun Feb 27, 2005 8:43 am
Posts: 40
BUMP!

(you are fast here... sjeeze...)


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 20, 2005 11:40 pm 
Moderator
Moderator

Joined: Sat Feb 12, 2005 4:48 pm
Posts: 575
Location: Largo, Florida USA
I just went to the http://www.phpbb.com/phpBB/ and did a search on
Quote:
1044
and came up with the phpbb_sessions table is full.

I would suggest opening a ticket with support if the article at http://www.phpbb.com/phpBB/viewtopic.php?t=291185&highlight=1044 dosent fix it.

_________________
Bob G.

Grout Recoloring Systems: http://coloryourgrout.com

Save Your Data - Do Backups
http://forum.100webspace.com/viewtopic. ... highlight=


Top
 Profile  
 
 Post subject:
PostPosted: Sat May 21, 2005 1:47 pm 
Noobie
Noobie

Joined: Sun Feb 27, 2005 8:43 am
Posts: 40
The people on the phpbb support forum say:

Quote:
Verify with your host if the permissions of your mysql user has changed.


Top
 Profile  
 
 Post subject:
PostPosted: Sat May 21, 2005 2:06 pm 
I have no life!
I have no life!

Joined: Sun Feb 13, 2005 6:12 pm
Posts: 1504
Location: My Office
Hey,

It looks like your sessions table for your phpBB Database is not completely complete. I can help you fix this if you want, as I am a very good user of phpBB. :wink: :D

Also, I have a very good Web Dev. tool at my site, MYSQL to PHP converter. This will let you to transform your MySQL into PHP and just run a script to update it.

I will send you a PM. :D

Moved to Forum Related Support!

_________________
Best Regards:
Aaron McGowan (aka: CyberGeek, =cipher=)

CyberGeek's Software Solutions
-- WWW: http://www.cybergeeksoftware.com
-- Tech Line: 1-519-860-4557
-- Email: cybergeek@cybergeeksoftware.com


Top
 Profile  
 
 Post subject:
PostPosted: Sat May 21, 2005 8:52 pm 
I have no life!
I have no life!

Joined: Sun Feb 13, 2005 6:12 pm
Posts: 1504
Location: My Office
Read http://www.thetechbase.com/viewtopic.php?t=226

That should help!

_________________
Best Regards:
Aaron McGowan (aka: CyberGeek, =cipher=)

CyberGeek's Software Solutions
-- WWW: http://www.cybergeeksoftware.com
-- Tech Line: 1-519-860-4557
-- Email: cybergeek@cybergeeksoftware.com


Top
 Profile  
 
 Post subject:
PostPosted: Sun May 29, 2005 6:18 am 
Noobie
Noobie

Joined: Sun Feb 27, 2005 8:43 am
Posts: 40
I went to PhpBB support forums, en they ALL (10 people) said that my this comes from the host. Access denied :evil:


Top
 Profile  
 
 Post subject:
PostPosted: Mon May 30, 2005 7:53 pm 
Noobie
Noobie

Joined: Sun Feb 27, 2005 8:43 am
Posts: 40
Again, they keep saying that the error

Code:
phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1044 Access denied for user: 'jemarx_forum@70.84.139.2' to database 'jemarx_forum'

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('87950d748e39a772f0d3eccd768bcc00', 2, 1117432481, 1117432481, '91350b69', 0, 1, 0)

Line : 172
File : sessions.php


comes from my host, they have to change my permissions they say (the people of phpbb.com and .nl)


Top
 Profile  
 
 Post subject:
PostPosted: Mon May 30, 2005 8:52 pm 
I have no life!
I have no life!

Joined: Sun Feb 13, 2005 6:12 pm
Posts: 1504
Location: My Office
There is no problem with the host. I and many others (hundreds) are using phpBB Powered websites and we do not have any problems. Please go to your PHPMyAdmin and check and see if your phpbb_sessions table is there... So it?

_________________
Best Regards:
Aaron McGowan (aka: CyberGeek, =cipher=)

CyberGeek's Software Solutions
-- WWW: http://www.cybergeeksoftware.com
-- Tech Line: 1-519-860-4557
-- Email: cybergeek@cybergeeksoftware.com


Top
 Profile  
 
 Post subject:
PostPosted: Tue May 31, 2005 6:35 am 
Yes, I can see it...


Top
  
 
 Post subject:
PostPosted: Tue May 31, 2005 2:59 pm 
I have no life!
I have no life!

Joined: Sun Feb 13, 2005 6:12 pm
Posts: 1504
Location: My Office
Greetings,

1. Please login :D
2. Go to your PHPMyAdmin and put this / add it to your database:
Code:
INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('87950d748e39a772f0d3eccd768bcc00', 2, 1117432481, 1117432481, '91350b69', 0, 1, 0)


This should work.

_________________
Best Regards:
Aaron McGowan (aka: CyberGeek, =cipher=)

CyberGeek's Software Solutions
-- WWW: http://www.cybergeeksoftware.com
-- Tech Line: 1-519-860-4557
-- Email: cybergeek@cybergeeksoftware.com


Top
 Profile  
 
 Post subject:
PostPosted: Tue May 31, 2005 3:49 pm 
Which code do I exaxtly have to add? Also that
Code:
INSERT INTO phpbb_sessions
?


Top
  
 
 Post subject:
PostPosted: Tue May 31, 2005 3:58 pm 
I have no life!
I have no life!

Joined: Sun Feb 13, 2005 6:12 pm
Posts: 1504
Location: My Office
Greetings,

PLEASE Login next time Or I will not proceed to help. :wink:

Ok. Follow this:
1. Go to PHPMyAdmin
2. Locate and click on your phpbb_sessions table
3. New window / page appears. Click on "SQL" in the top of the page
3. Where is says "SELECT * FROM `phpbb_sessions` WHERE 1" delete that, and put this into that textarea:
Code:
INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('87950d748e39a772f0d3eccd768bcc00', 2, 1117432481, 1117432481, '91350b69', 0, 1, 0)

4. Now push "GO". :D

_________________
Best Regards:
Aaron McGowan (aka: CyberGeek, =cipher=)

CyberGeek's Software Solutions
-- WWW: http://www.cybergeeksoftware.com
-- Tech Line: 1-519-860-4557
-- Email: cybergeek@cybergeeksoftware.com


Top
 Profile  
 
 Post subject:
PostPosted: Tue May 31, 2005 4:43 pm 
Code:
SQL-query : 

INSERT INTO phpbb_sessions( session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin )
VALUES (

'87950d748e39a772f0d3eccd768bcc00', 2, 1117432481, 1117432481, '91350b69', 0, 1, 0
)

MySQL reterned:


#1044 - Access denied for user: 'jemarx_forum@70.84.139.2' to database 'jemarx_forum'


:roll:


Top
  
 
 Post subject:
PostPosted: Tue May 31, 2005 7:06 pm 
Hey cipher.... wouldn't it be this :?:

INSERT INTO phpbb_sessions VALUES ( '87950d748e39a772f0d3eccd768bcc00', 2, 1117432481, 1117432481, '91350b69', 0, 1, 0 )


Top
  
 
 Post subject:
PostPosted: Tue May 31, 2005 8:14 pm 
Site Admin
Site Admin

Joined: Fri Feb 11, 2005 7:43 am
Posts: 1818
Location: 100WebSpace's Headquarters
Please go to your web hosting control panel and take a look at the Account Usage table. On the MySQL MB what does it say? How many MBs do you have free?

_________________
Read the F.A.Q. before asking a question!


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jun 01, 2005 6:59 pm 
support4 wrote:
Please go to your web hosting control panel and take a look at the Account Usage table. On the MySQL MB what does it say? How many MBs do you have free?


5 used, 0 free


Top
  
 
 Post subject:
PostPosted: Wed Jun 01, 2005 7:05 pm 
I have no life!
I have no life!

Joined: Sun Feb 13, 2005 6:12 pm
Posts: 1504
Location: My Office
Thats why it doesnt work. Your MySQL has already used its limit of physical hdd space.Also, I am fed up with the guest stuff. Please LOGIN to post.

_________________
Best Regards:
Aaron McGowan (aka: CyberGeek, =cipher=)

CyberGeek's Software Solutions
-- WWW: http://www.cybergeeksoftware.com
-- Tech Line: 1-519-860-4557
-- Email: cybergeek@cybergeeksoftware.com


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jun 01, 2005 7:11 pm 
Site Admin
Site Admin

Joined: Fri Feb 11, 2005 7:43 am
Posts: 1818
Location: 100WebSpace's Headquarters
You can purchase additional MySQL space from the Service Upgrades section of your control panel.

_________________
Read the F.A.Q. before asking a question!


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 21 posts ]  Moderators: KJ, fhmagic, Moderators, Support Team

All times are UTC


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
100WebSpace © 2011