Database error when acessing unnaproved articles

[Nifelhein]

Link to my site: http://www.againsttheshadow.org
SMF version: SMF 1.1.13
TP version: TP 1.0 RC1
Default Forum Language:English
Theme name and version: Mercury TP with a modified CSS and some other parts (Check if my credits for the theme are ok).
Browser Name and Version: Google Chrome v 10.0.648.204
Mods installed: Visual Verification Options 0.5.2, Stop Spammer 2.3.9, Spoiler Tag 0.7.2, TinyPortal
Related Error messages:
Database Error
Unknown column 'mem.real_name' in 'field list'
File: .../Sources/TPortalAdmin.php
Line: 1363

Ok, all the hard information is above, I am getting the error above every time I acess the userbox link to my articles pending approval, it is consistent and only show if I use the link from the userbox. The link that gives me that error is the following: http://www.againsttheshadow.org/index.php?action=tpadmin;sa=submission

The first time the error appeared it said my databse was a different version than my smf install and asked me to run upgrade.php, I did that and the only change has been the absence of the info regarding the databse version and smf version.

Thans for any and all assistance,

Nif.

[IchBin]

Line 1357 in TPortalAdmin.php find this line:

SELECT   art.id,art.date,art.frontpage, art.category, art.author_id as authorID, IFNULL(mem.real_name, art.author) as author, art.subject,

Change mem.real_name to mem.realName

[Nifelhein]

Hey Ichbin!

Thanks a lot for the reply and help, I changed the term and it is now working perfectly, funny thing that I made the move from TP 0.9.8 to the latest RC in two forums and one worked fine while the other gave that error.

I would like to congratulate everyone who works and worked on TP and also those giving their time here in the site to help those who find problem in the use of this great mod.

Cheers!