Jump to content

Am I hosed?


Headhunter

Recommended Posts

I get this error when I log in.  I really don't know code and have about 150 users on my site.

 

Is this on my server side or my code side?

 

___________________________

 

phpBB : Critical Error

 

Error doing DB query userdata row fetch

 

DEBUG MODE

 

SQL Error : 1226 User 'jaycepa1_p_bb1' has exceeded the 'max_questions' resource (current value: 50000)

 

SELECT u.* FROM phpbb_users u, phpbb_sessions_keys k WHERE u.user_id = 2 AND u.user_active = 1 AND k.user_id = u.user_id AND k.key_id = '98bbeb63a1cbd5b84933dade8840d93d'

 

Line : 89

File : sessions.php

Link to comment
https://forums.phpfreaks.com/topic/64848-am-i-hosed/
Share on other sites

It looks like to me that you are not doing a mysql close connection after opening them.

 

After you open the connection make sure to close the connection after running your SQL commands.

 

Brett

 

*EDIT*

 

My bad did not read this to closely.

 

up the limit

 

You can change the variable from the command line, with:

SET @MAX_QUESTIONS=<your new value>;

 

For example:

mysql> set @max_questions=0;

 

Or you can open the my.cfn  or my.ini and change the value there.

Link to comment
https://forums.phpfreaks.com/topic/64848-am-i-hosed/#findComment-323579
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.