[MODDB] View or Mark Unread Posts for PHPBB3

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Scam Warning
ThePhantom2
Registered User
Posts: 72
Joined: Tue Feb 05, 2008 11:26 am
Location: NSW, Australia
Contact:

Re: [RC3] View or Mark Unread Posts for PHPBB3

Post by ThePhantom2 » Sun Feb 10, 2008 2:48 pm

After installing this mod I have lost all my private messages in my inbox (although at the top it says Folder is 100% full (50 from 50 messages stored)) and I get the following message if I click on a message stored in my saved folder
General Error
SQL ERROR [ mysql4 ]

Unknown column 'PRIVMSGS_HOLD_BOX' in 'where clause' [1054]

SQL

SELECT t.*, p.*, u.* FROM phpbb_privmsgs p, phpbb_privmsgs_to t, phpbb_users u WHERE t.msg_id = p.msg_id AND p.author_id = u.user_id AND t.folder_id NOT IN (-3, PRIVMSGS_HOLD_BOX) AND t.user_id = 2 AND (p.root_level = 714 OR (p.root_level = 0 AND p.msg_id = 714)) ORDER BY p.message_time DESC

BACKTRACE


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/functions_privmsgs.php
LINE: 1703
CALL: dbal_mysql->sql_query()

FILE: includes/ucp/ucp_pm_viewmessage.php
LINE: 241
CALL: message_history()

FILE: includes/ucp/ucp_pm.php
LINE: 801
CALL: view_message()

FILE: includes/functions_module.php
LINE: 471
CALL: ucp_pm->main()

FILE: ucp.php
LINE: 310
CALL: p_master->load_active()
Any ideas?

asinshesq
Registered User
Posts: 6266
Joined: Sun Feb 22, 2004 9:34 pm
Location: NYC
Name: Alan

Re: [RC3] View or Mark Unread Posts for PHPBB3

Post by asinshesq » Sun Feb 10, 2008 2:57 pm

ThePhantom2 wrote:Any ideas?
I don't have access to my files right now, but re-check
The changes you made to constants.php (did you inadvertently delete the entry for privmsgs_hold_box??) As well as the changes to functions_privmsgs.@:@ and all the changes in the files that are under the ucp folder.

ThePhantom2
Registered User
Posts: 72
Joined: Tue Feb 05, 2008 11:26 am
Location: NSW, Australia
Contact:

Re: [RC3] View or Mark Unread Posts for PHPBB3

Post by ThePhantom2 » Sun Feb 10, 2008 3:28 pm

asinshesq wrote:
ThePhantom2 wrote:Any ideas?
I don't have access to my files right now, but re-check
The changes you made to constants.php (did you inadvertently delete the entry for privmsgs_hold_box??) As well as the changes to functions_privmsgs.@:@ and all the changes in the files that are under the ucp folder.
You are a legend :D , there was an error I made in the contants.php file, somehow several entries here were on the same line.

All is working perfect and I owe you a big hug. :oops:

asinshesq
Registered User
Posts: 6266
Joined: Sun Feb 22, 2004 9:34 pm
Location: NYC
Name: Alan

Re: [RC3] View or Mark Unread Posts for PHPBB3

Post by asinshesq » Sun Feb 10, 2008 3:36 pm

ThePhantom2 wrote:All is working perfect...
Not bad given that I read your post and replied via blackberry without a real browser and without any files ;)

Anyway, glad it's all working now.

Paph
Registered User
Posts: 362
Joined: Tue Dec 25, 2007 7:58 am
Location: Georgia - USA
Contact:

Re: [RC3] View or Mark Unread Posts for PHPBB3

Post by Paph » Thu Feb 21, 2008 8:01 pm

Well, it looks like it hasn't been approved yet, he says patiently taping his fingers. :mrgreen:
Hawk

asinshesq
Registered User
Posts: 6266
Joined: Sun Feb 22, 2004 9:34 pm
Location: NYC
Name: Alan

Re: [RC3] View or Mark Unread Posts for PHPBB3

Post by asinshesq » Thu Feb 21, 2008 8:10 pm

Paph wrote:Well, it looks like it hasn't been approved yet, he says patiently taping his fingers. :mrgreen:
Not yet. I submitted it on February 10th. I am guessing I'll hear from the validators some time in the next two weeks. I am also guessing there will be at least one more round, since the eagle eye validators usually catch some things that we mortals otherwise don't. I'll let you know as soon as I hear.

Paph
Registered User
Posts: 362
Joined: Tue Dec 25, 2007 7:58 am
Location: Georgia - USA
Contact:

Re: [RC3] View or Mark Unread Posts for PHPBB3

Post by Paph » Thu Feb 21, 2008 10:50 pm

Great! Good luck. :D
Hawk

sovietpop
Registered User
Posts: 14
Joined: Fri Nov 16, 2007 5:15 pm

Re: [RC3] View or Mark Unread Posts for PHPBB3

Post by sovietpop » Sun Feb 24, 2008 3:23 pm

Has anyone installed this mod on a board that uses the Ubuntu* template? I can't work out what changes I need to make to the template files as my html is pretty damn weak.


this template is based on subsilver2 I think.

asinshesq
Registered User
Posts: 6266
Joined: Sun Feb 22, 2004 9:34 pm
Location: NYC
Name: Alan

Re: [RC3] View or Mark Unread Posts for PHPBB3

Post by asinshesq » Sun Feb 24, 2008 5:30 pm

Paph wrote:Well, it looks like it hasn't been approved yet, he says patiently taping his fingers. :mrgreen:
This has now been validated. Please make any further comments in the thread for the validated mod here: http://www.phpbb.com/community/viewtopi ... 9&t=788695

User avatar
Jim_UK
Former Team Member
Posts: 18478
Joined: Tue Oct 12, 2004 5:36 pm
Location: Darwen N.West UK

Re: [MODDB] View or Mark Unread Posts for PHPBB3

Post by Jim_UK » Sun Feb 24, 2008 6:27 pm

This mod is now in the Mod Databases Releases and support will continue in the topic

http://www.phpbb.com/community/viewtopi ... 9&t=788695

Closing this one.

Jim
The truth is out there.
Unfortunately they will not let you anywhere near it!

Locked

Return to “[3.0.x] MODs in Development”