 | [Solved] Error message |  |
 Posted: 06/14/2007 1:46 PM |
 |
|
|
|
|
| Citation |
| Posts |
556 |
| Word Cnt. |
20,326 |
| BDay |
Jan 26 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Nov 26, 2006
Local time: 12:00 AM
Location: west midlands:uk
|
|
|
|
|
 |
| I was just trying to PM someone and i just found out that my private messages have a debug error |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Error message | |
| Posted: 06/14/2007 2:58 PM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 7:00 PM
Location: Denver, PA
|
|
|
|
|
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Error message | |
| Posted: 06/14/2007 3:13 PM |
|
|
|
|
|
| Citation |
| Posts |
556 |
| Word Cnt. |
20,326 |
| BDay |
Jan 26 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Nov 26, 2006
Local time: 12:00 AM
Location: west midlands:uk
|
|
|
|
|
|
| Code:
|
Could not insert/update private message sent info.
DEBUG MODE
SQL Error : 1062 Duplicate entry '0' for key 1
INSERT INTO phpbb_privmsgs (privmsgs_type, privmsgs_subject, privmsgs_from_userid, privmsgs_to_userid, privmsgs_date, privmsgs_ip, privmsgs_enable_html, privmsgs_enable_bbcode, privmsgs_enable_smilies, privmsgs_attach_sig) VALUES (1, 'test', 3, 1, 1181851968, '5409a86f', 1, 1, 1, 1)
Line : 1375
File : privmsg.php
|
Sorry couldnt add it earlier |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Error message | |
| Posted: 06/14/2007 3:38 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Mar 31, 2007
Local time: 12:00 AM
Location: Birmingham, UK.
|
|
|
|
|
|
| Going by the duplicate entry message I think the tables are already in the database Karen |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Error message | |
| Posted: 06/14/2007 3:44 PM |
|
|
|
|
|
| Citation |
| Posts |
556 |
| Word Cnt. |
20,326 |
| BDay |
Jan 26 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Nov 26, 2006
Local time: 12:00 AM
Location: west midlands:uk
|
|
|
|
|
|
| yea i get that, but why is it there lol, i never use pms that often, the only time i wante dto use it was to pm every1 at the same time but theres nothing that does that, so today was the first time in a long time iv tried to pm someone and it aint working and i cant even say how long its been like that coz like i say i dont use them and my members usually leave a message on the forum if they have problems not by pm! |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Error message | |
| Posted: 06/14/2007 3:50 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 12:00 AM
Location: Birmingham, UK.
|
|
|
|
|
|
| Oh lol ok, well find what made the SQL changes and just remove them then. Providing the you restored all the original files back when you removed the mod you should be able use the standard pm again |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Error message | |
| Posted: 06/14/2007 4:09 PM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 7:00 PM
Location: Denver, PA
|
|
|
|
|
|
Karen, open your privmsg.php and find the Line : 1375 and see if there is some duplicate code in there.  |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Error message | |
| Posted: 06/14/2007 4:21 PM |
|
|
|
|
|
| Citation |
| Posts |
556 |
| Word Cnt. |
20,326 |
| BDay |
Jan 26 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Nov 26, 2006
Local time: 12:00 AM
Location: west midlands:uk
|
|
|
|
|
|
| ermmmm.... iv looked but i cant see anything thats duplicated, maybe iv missed summat, il keep looking lol |
|
|
|
|
| Back to Top |
|
|
| Re: Error message | |
| Posted: 06/14/2007 5:03 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:00 PM
Location: St Pete, FL
|
|
|
|
|
|
Karen, try it again. For some strange reason, the privmsgs_id was set to allow 0 for the default rather than auto-incrementing the value. Since the privmsgs_id field is a keyed (indexed) field, it has to have a unique value assigned to it, so you could only have one record with the privmsgs_id field value set to 0, so setting the default to zero made no sense. I changed it to auto-increment in your Live database, so it should be working correctly now...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Error message | |
| Posted: 06/14/2007 5:09 PM |
|
|
|
|
|
| Citation |
| Posts |
556 |
| Word Cnt. |
20,326 |
| BDay |
Jan 26 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Nov 26, 2006
Local time: 12:00 AM
Location: west midlands:uk
|
|
|
|
|
|
It works fine now thanks!! No wonder i couldn't find the problem though!!
I tested this in my test forum earlier and got a different error:
| Code:
|
Warning: Division by zero in /home/toddlers/public_html/test/includes/functions_cash.php on line 1255
Warning: Cannot modify header information - headers already sent by (output started at /home/toddlers/public_html/test/includes/functions_cash.php:1255) in /home/toddlers/public_html/test/includes/functions.php on line 1120
|
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
