HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media


Welcome to TinyPortal. Please login or sign up.

July 25, 2024, 08:15:15 PM

Login with username, password and session length
  • Total Posts: 195,347
  • Total Topics: 21,237
  • Online today: 107
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 0
  • Guests: 55
  • Total: 55

article comments 2 bugs

Started by zalias7, January 03, 2012, 10:13:35 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.


Link to my site:localhost
SMF version: SMF ver. 2.0.2
TP version: TP ver. 1.0 RC2
Default Forum Language: lithuanian-utf8
Theme name and version: Theme name here
Browser Name and Version: firefox 9.0.1
Mods installed: TinyPortal
Related Error messages: The database value you're trying to insert does not exist: com

a problem
When I delete the article comments and reading the article in the article, I get an error: The database value you're trying to insert does not exist: com

I see that the table tp_articles Value for the comments field does not change. Changing to a fair number of comments the problem no longer exists.

issue 2
Article comments, removed user name is displayed as 0


Can you post the full error please? I need the file name and line number that it gives.


sorry for my English.


The database value you're trying to insert does not exist: com
Function: doTPpage
File: ../www/Sources/TPortal.php
Line: 801

You need to do is: write article -> write article for comment. Delete comment from article. Read article with comment and you get the error


Find in TPortal.php
array('com' => $count, 'artid' => $article['id'])

Replace $count as $ccount.
array('com' => $ccount, 'artid' => $article['id'])

This is fixed in the next version coming out soon. :)


sorry, but anyway Error:
Unknown column 'i' in 'where clause'
File ..\ www \ Sources \ TPortal.php
Line: 801




Quote from: zalias7 on January 04, 2012, 06:27:25 PM
Quote from: IchBinâ,,¢ on January 04, 2012, 04:14:05 PM
Attach your file please.

Attach TPortal.php  or other ?

Your TPortal.php file is the file you need to attach.




Your last post did not have the TPortal.php file attached but you should be able to attach it to your next post.  Could you try it again please?



Yesterday, I did not attach a file, and add links. Today I can not attach files Thank you  ::)


You removed a couple of characters when you edited the file.

This part:
WHERE i= {int:artid}',

Needs to have been this:
WHERE id = {int:artid}',

I have attached your fixed file.


I do not understand how it happened, but thanks.
As with the other problem: removed user name in article comments?


I don't understand what you are saying about that issue, can you explain how to replicate the issue? Show a screenshot or something?



Yeah, it's showing 0 if the user doesn't have a name.

Try to find this code in Sources/TPortal.php about line#778
Code (find) Select
'poster' => $row['realName'],

Code (replace with) Select
'poster' => !empty($row['realName']) ? $row['realName'] : $txt['tp-guest'];

That was just off the top of my head, so if it doesn't work go ahead and remove the code. It should say "Guest" instead of 0, assuming that is what you want?


Thanks !

and last problem:

this footer with tiniportal logo and with default theme.

this footer with tiniportal logo and theme

What to do? :)


in index.css

Code (find) Select
#footerarea ul li.copyright
display: block;
line-height: 0;
font-size: small;
padding: 1em;

Code (Change to) Select
#footerarea ul li.copyright
display: block;
line-height: 1;
font-size: small;
padding: 1em;