Database Error

Hi, now is around 5 days i don't modify the site, all was ok untill today when i receveid this database error message.

I really don't know nothing about database, so if somebody can help me i really appreciad.. What i change is a fixed for safari 4 and Chroma.

I recevedi this message when a new couple as sign up (i don't know if is a connection...)

The error is this :

Database error in xxx 
Query:

INSERT ProfileMemLevels (IDMember, IDLevel, DateStarts, DateExpires, TransactionID)
VALUES (25, 3, FROM_UNIXTIME(1245740595), FROM_UNIXTIME(1247036595), NULL)

Mysql error:
Duplicate entry '25-3-2009-06-23 09:03:15' for key 1

Found error in file /var/www/vhosts/xxx.ro/httpdocs/chat6/inc/membership_levels.inc.php
at line 801. Called db_res function 
with erroneous argument #0

Debug backtrace:
Array
(
[1] => Array
(
[file] => /var/www/vhosts/xxx.ro/httpdocs/chat6/inc/membership_levels.inc.php
[line] => 801
[function] => db_res
[args] => Array
(
[0] => 
INSERT ProfileMemLevels (IDMember, IDLevel, DateStarts, DateExpires, TransactionID)
VALUES (25, 3, FROM_UNIXTIME(1245740595), FROM_UNIXTIME(1247036595), NULL)
)

)

[2] => Array
(
[file] => /var/www/vhosts/xxx.ro/httpdocs/chat6/profile_activate.php
[line] => 130
[function] => setMembership
[args] => Array
(
[0] => 25
[1] => 3
[2] => 15
[3] => 1
)

)

[3] => Array
(
[file] => /var/www/vhosts/xxx.ro/httpdocs/chat6/profile_activate.php
[line] => 48
[function] => PageCompPageMainCode
[args] => Array
(
)

)

)


Called script: /chat6/profile_activate.php

Request parameters:
Array
(
[ConfID] => 25
[ConfCode] => YzJWbE9ITkxRMFpMU1hSdmR3PT0=
)


--
Auto-report system

...
Quote · 23 Jun 2009

I have a database error too. Except mine doesn't seem to be able to connect to my local MySQL server.


"Mysql error:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)"

Not quite sure what it means or how to fix it. Everything seems fine when I look but one of my beta testers told me she can't see my profile.

Darn database errors.

Quote · 25 Jun 2009

 

Hi, now is around 5 days i don't modify the site, all was ok untill today when i receveid this database error message.

I really don't know nothing about database, so if somebody can help me i really appreciad.. What i change is a fixed for safari 4 and Chroma.

I recevedi this message when a new couple as sign up (i don't know if is a connection...)

 

The error is this :

 

Database error in xxx 
Query:

INSERT ProfileMemLevels (IDMember, IDLevel, DateStarts, DateExpires, TransactionID)
VALUES (25, 3, FROM_UNIXTIME(1245740595), FROM_UNIXTIME(1247036595), NULL)

Mysql error:
Duplicate entry '25-3-2009-06-23 09:03:15' for key 1

Found error in file /var/www/vhosts/xxx.ro/httpdocs/chat6/inc/membership_levels.inc.php
at line 801. Called db_res function 
with erroneous argument #0

Debug backtrace:
Array
(
[1] => Array
(
[file] => /var/www/vhosts/xxx.ro/httpdocs/chat6/inc/membership_levels.inc.php
[line] => 801
[function] => db_res
[args] => Array
(
[0] => 
INSERT ProfileMemLevels (IDMember, IDLevel, DateStarts, DateExpires, TransactionID)
VALUES (25, 3, FROM_UNIXTIME(1245740595), FROM_UNIXTIME(1247036595), NULL)
)

)

[2] => Array
(
[file] => /var/www/vhosts/xxx.ro/httpdocs/chat6/profile_activate.php
[line] => 130
[function] => setMembership
[args] => Array
(
[0] => 25
[1] => 3
[2] => 15
[3] => 1
)

)

[3] => Array
(
[file] => /var/www/vhosts/xxx.ro/httpdocs/chat6/profile_activate.php
[line] => 48
[function] => PageCompPageMainCode
[args] => Array
(
)

)

)


Called script: /chat6/profile_activate.php

Request parameters:
Array
(
[ConfID] => 25
[ConfCode] => YzJWbE9ITkxRMFpMU1hSdmR3PT0=
)


--
Auto-report system

 

 

The above has it's solution listed direclty above.  It's stating you have a duplicate entry, thus the same exact item twice being called as it tries to create the profile. 

 

[1] => Array
(
[file] => /var/www/vhosts/xxx.ro/httpdocs/chat6/inc/membership_levels.inc.php
[line] => 801
[function] => db_res
[args] => Array

 

Note that the above is the specific issue.

 

Now for the 2nd person:  Yours is either a port issue, as in the port may not be open, or your login/password is not working and thus it can't connect to the database and thus your getting the error.  This 2nd error happens more often on installs or when a major modification is done (such as integrating phpBB3 into a Dolphin site) than just randomly.

 

 

Quote · 27 Jun 2009
 
 
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.