TP-Docs
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome to TinyPortal. Please login or sign up.

December 10, 2024, 05:18:16 AM

Login with username, password and session length
Members
Stats
  • Total Posts: 195,443
  • Total Topics: 21,252
  • Online today: 144
  • Online ever: 6,457 (November 30, 2024, 02:40:09 PM)
Users Online
  • Users: 0
  • Guests: 76
  • Total: 76

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.

zalias7

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

IchBin

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

zalias7

sorry for my English.

error:

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

IchBin

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. :)

zalias7

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

IchBin


zalias7


lurkalot

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.

zalias7


ZarPrime

zalias7,

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?

ZarPrime

zalias7

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

IchBin

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.

zalias7

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

IchBin

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

zalias7


IchBin

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?

zalias7

Thanks !

and last problem:

this footer with tiniportal logo and with default theme.



this footer with tiniportal logo and green_theme_rc5.zip theme http://custom.simplemachines.org/themes/index.php?lemma=2265



What to do? :)

Lesmond

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;

zalias7