5 days now getting errors with BxDolSessionQuery.php

Database error in name

Query:

REPLACE INTO `sys_sessions` SET `id`='VjW4gj,vv,Cd7L3zy4uAD9DcC??6EL3g', `user_id`='0', `data`='a:2:{s:10:"csrf_token";s:20:"88A7S&rY4Y6fgreYvttB";s:15:"csrf_token_time";i:1306798735;}', `date`=UNIX_TIMESTAMP()

Mysql error: Disk is full writing './admin_/sys_sessions.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)

Found error in the file '/httpdocs/inc/classes/BxDolSessionQuery.php' at line 48.
Called 'query' function with erroneous argument #0.

 

is there anything to do with php.ini file ?

Quote · 31 May 2011

Hello follow these instructions;

 

1. Clear table sys_sessions via your phpmyadmin

2. Make sure that your cron jobs work properly

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 31 May 2011

let me see thanks btw..

i repaired that table yesterday btw.

Quote · 31 May 2011

repaired is not clear !

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 31 May 2011

i know i just said that :P

Quote · 31 May 2011

 

i know i just said that :P

 :)

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 31 May 2011

wow been a while since i last check the access and errors logs and wut the hell are those ? flooding the whole server/page.

 

 

213.129.191.202 - - [31/May/2011:23:36:29 +0100] "GET /modules/?r=online_members/get_member_list/0/3df1d4b96d8976ff5986393e8767f5b2 HTTP/1.1" 200 234 "http://page.com/member.php" "Mozilla/5.0 (Windows NT 6.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1"
213.129.191.202 - - [31/May/2011:23:36:37 +0100] "POST /modules/?r=simple_messenger/get_operation/new_messages&_r=0.42972144364992515 HTTP/1.1" 200 214 "http://page.com/member.php" "Mozilla/5.0 (Windows NT 6.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1"
213.129.191.202 - - [31/May/2011:23:36:39 +0100] "GET /flash/XML.php?module=im&action=updateInvite&recipient=3096&_t=1306880885673 HTTP/1.1" 200 390 "http://page.com/member.php" "Mozilla/5.0 (Windows NT 6.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1"
213.129.191.202 - - [31/May/2011:23:36:39 +0100] "GET /modules/?r=online_members/get_member_list/0/3df1d4b96d8976ff5986393e8767f5b2 HTTP/1.1" 200 234 "http://page.com/member.php" "Mozilla/5.0 (Windows NT 6.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1"
213.129.191.202 - - [31/May/2011:23:36:40 +0100] "POST /modules/?r=simple_messenger/get_operation/new_messages&_r=0.7149551610608362 HTTP/1.1" 200 214 "http://page.com/member.php" "Mozilla/5.0 (Windows NT 6.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1"

 

6mb access log file

208mb error log file.. wut thee.. is goin on here

Quote · 31 May 2011

it's normal! Dolphin used many ajax requests.... If not needed that logs files ask your hosting provider disable them!

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 1 Jun 2011

i removed them with the console.

but i dont get it.. they are flooding the page arent they?

Quote · 1 Jun 2011

 

Hello follow these instructions;

 

1. Clear table sys_sessions via your phpmyadmin

2. Make sure that your cron jobs work properly

 I just encountered this same problem on 7.0.2 and when I looked in the table sys_sessionsI found over 108,000 pages in there. That seems really high even though the table has never been cleared. Of course I did not know I needed to clear this table.

In any case I had to use the SQL Query TRUNCATE TABLE SYS_SESSIONS because trying to use phpmyadmin only produced another error.

This worked and the site is back online for anyone else encountering this problem. I can't help but wonder why this thing gets so full and does not auto clear at a certain point? Bad programming?

Quote · 13 Apr 2012
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.