TinyPortal

[Kindred]

ok.... some more odd issues, working with articles.

1- upload a PNG image as Alternative listing icon (128x128 px):
a- transparent BG is now black
b- the system prepends and appends some odd numbers and letters...
c- where is this icon used? I have one selected, but it does not appear any where

2- articles link?  How do I get a list of categories for the users?

3- in the category, it displays all articles in that category, but lists a button link to category 1 and no other.

4- in the category list, the "read more" article link is broken unless I use the article ID in the article setup, Query title:
   if I use ANYTHING else, the link is broken. (i.e. article #2 must have Query title: "2", although I want it to be "July-Aug Newsletter")

5- in articles settings, Assign global tags: -> Create new tag:  -- I added the tag "Newsletter"   it shows as (checkbox []) $value   (yes, exactly that... $value)



in the profile "tinyPortal" link...
it shows "Shouts" even though I have the shoutbox turned off.

side note: This should not be titled TinyPortal in the profile settings, IMO...    most people won't know what that is.
I'd suggest "Content Submissions" (and add a link to the standard post list as well)

There should also be a link in this profile/article section to ADD NEW ARTICLE.

[miosha]

good day
sorry to bring this up again but did u manage to resolve this?

Code Select Expand


Unknown column 'value9' in 'smf_tp_variables'
File: /var/www/html/Packages/temp/SMF2/tp_upgrade.php
Line: 347

I have this error when trying to install tinyPortal 1 RC2 via Package manager. Previously I had SMF 1.1.14 with TinyPortal 0.98.
Then I upgraded SMF to 2.0 without uninstalling old tinyPortal. SMF seem upgraded successfully and shows now that no other packages installed.

[miosha]

Well solved it by wiping all previous tp tables so don't mind my previous question and thankies anyways =)

[IchBin™]

ok.... some more odd issues, working with articles.

1- upload a PNG image as Alternative listing icon (128x128 px):
a- transparent BG is now black
b- the system prepends and appends some odd numbers and letters...
c- where is this icon used? I have one selected, but it does not appear any where

That icon is used for when you select a different layout option. Like if you were to change the layout option in the front page settings to be "Picture + Article".  I think Bloc had put the hash of numbers/letters on it for security reasons or something. I'm not sure exactly why yet. As for the image losing it's transparency, I don't know. I would assume at this point it loses the transparency when it has to resize the image if it's over 128x128. I really don't know anything about the image functions, so I'll have to test that out when I get a chance. Try testing with an image under 128x128 to see if you get the same problem.

2- articles link?  How do I get a list of categories for the users?

There is a catlist block that will list all the categories that you select in the admin interface for this. Or if you select the option in the articles to show the categories. It should show the categories as tabs at the top of the page IIRC.

3- in the category, it displays all articles in that category, but lists a button link to category 1 and no other.

In the categories admin you need to select which categories are allowed to be displayed there in the catlist option.

4- in the category list, the "read more" article link is broken unless I use the article ID in the article setup, Query title:
   if I use ANYTHING else, the link is broken. (i.e. article #2 must have Query title: "2", although I want it to be "July-Aug Newsletter")

5- in articles settings, Assign global tags: -> Create new tag:  -- I added the tag "Newsletter"   it shows as (checkbox []) $value   (yes, exactly that... $value)

I'll have to look into these.

in the profile "tinyPortal" link...
it shows "Shouts" even though I have the shoutbox turned off.

Awesome... I'll have to fix that too. lol

side note: This should not be titled TinyPortal in the profile settings, IMO...    most people won't know what that is.
I'd suggest "Content Submissions" (and add a link to the standard post list as well)

There should also be a link in this profile/article section to ADD NEW ARTICLE.

Thanks for the reports and suggestions. I'll take a look as I get time and see what I can do.

[IchBin™]

Well solved it by wiping all previous tp tables so don't mind my previous question and thankies anyways =)

Sorry miosha I didn't get here sooner. Yes there are problems for people who upgrade from SMF1 to SMF2 using TP. I've posted a fixed database upgrade file at the TP site. But since you removed your tables, you really don't have to worry about that.

[DarkAngel612]

well I am glad you did that cause if we should decide to --- oneday--- upgrade to 2.0 then we won't have to delete all tables cause would that also take out all site/member info from before?

[IchBin™]

Well, he only said he had to delete the TP tables. Not all tables. Deleting SMF tables would not be necessary. But still, it's nice to not have to lose articles and blocks etc.

[DarkAngel612]

that is good to know...it is so hot here in kansas that I totally only swa the words tables and that was it...lol

thanks for pointing that out and yes don't want to lose tables, menus aor articles especially now that they are working again.

[Kindred]

Ok....   For 1....   The png background is lost, no matter what. If the png is resized up or down or event if it is 128x128 already.

For the cat list... I found the admin part that handles it.
However, when attempting to add my category to that list, I get an error

Code Select Expand


The database value you're trying to insert does not exist: val



Tiny portal has come a long way since I first used it, years ago....    Is all of this admin functionality documented anywhere?   Because it seems that several of my questions are "how do I do this" an
D the answer is merely, find the correct admin section. (which is not always specifically, clearly obvious, on first glance)

Also, things like what the various panel layout descriptions mean would be helpful, since the red and grey boxes are somewhat arcane to me.

eit- specific error logs for the category issue

Code Select Expand


http://...../index.php?action=tpadmin
The database value you're trying to insert does not exist: val
Function: do_postchecks
File: /...../Sources/TPortalAdmin.php
Line: 2794

http://...../index.php?action=tpadmin
8: Undefined variable: catname
File: /...../Sources/TPortalAdmin.php
Line: 2791


logs for the queryname / article name

Code Select Expand


http://...../index.php?page=July_August_Newsletter
Wrong value type sent to the database. Integer expected. (page)
Function: TP_loadTheme
File: /...../Sources/TPortal.php
Line: 252


logs for the "value" bug

Code Select Expand


http://..../index.php?action=tpadmin
8: Undefined variable: value
File: /...../Sources/TPortalAdmin.php
Line: 3461


[IchBin™]

For the first error:

TPortalAdmin.php

Code (find) Select Expand

$smcFunc['db_query']('',
'UPDATE {db_prefix}tp_settings
SET value = {string:val}
WHERE name = {string:name} LIMIT 1',
array(
'val' => $catname,
'name' => 'cat_list',
)
);

Code (replace) Select Expand

$smcFunc['db_query']('',
'UPDATE {db_prefix}tp_settings
SET value = {string:val}
WHERE name = {string:name} LIMIT 1',
array(
'val' => $catnames,
'name' => 'cat_list',
)
);

For the second error (page wrong type): Sources/TPortal.php

Code (find) Select Expand

else
$request =  $smcFunc['db_query']('', '
SELECT id_theme FROM {db_prefix}tp_articles
WHERE shortname = {int:page}',
array('page' => $pag)
);

Code (replace) Select Expand

else
$request =  $smcFunc['db_query']('', '
SELECT id_theme FROM {db_prefix}tp_articles
WHERE shortname = {string:page}',
array('page' => $pag)
);

For the $value error, goto that line number in TPortalAdmin.php and change the $value in the query to $name. I think that is what it should be. Thanks for reporting all the errors. They are the result of changing all the database queries to be the same as SMF2's... And me learning them in the process.

[Kindred]

For the second error (page wrong type):

Code (find) Select Expand

else
$request =  $smcFunc['db_query']('', '
SELECT id_theme FROM {db_prefix}tp_articles
WHERE shortname = {int:short}',
array('short' => $pag)
);

Code (replace) Select Expand

else
$request =  $smcFunc['db_query']('', '
SELECT id_theme FROM {db_prefix}tp_articles
WHERE shortname = {string:short}',
array('short' => $pag)
);

hmmm....

in TPortal, I do not have that code...

The closest that I can fine looks like looks like

Code Select Expand


    else
      $request =  $smcFunc['db_query']('', '
        SELECT id_theme FROM {db_prefix}tp_articles
        WHERE shortname = {int:page}',
        array('page' => $pag)
      );


so, should it be {string:page}?


--edit - that seems to have worked.
and fixed the catlist bug...

However, the value bug does noo seem to have been corrected.



edit 2- After doing these 3 edits, I am now getting the following error when I (as admin) got to view an article

Code Select Expand

http://...../index.php?action=tpadmin;sa=clist
Sorry, you are not allowed to view this article

Since there are only two articles in the system at the moment and both are approved and visible to everyone, this is an odd error.

[Dramber]

I had the same problem:

in TPortal, I do not have that code...

The closest that I can fine looks like looks like

Code: [Select]
    else
      $request =  $smcFunc['db_query']('', '
        SELECT id_theme FROM {db_prefix}tp_articles
        WHERE shortname = {int:page}',
        array('page' => $pag)
      );

so, should it be {string:page}?

changing it from {int:page} to {string:page} got rid of the errors and allowed me access to the list.
Thanks for continuing to work on this great portal mod.


*Removed stuff. Nub mistake, Thanks Kindred for pointing that out. *

[Kindred]

you probably don't want to change anything except for the ONE spot that IchBin mentions...  All of the other int:page seem to be appropriate, since they are looking for the page ID, not the page shortname.

[Dramber]

That's strange. I was still getting errors and couldn't see my cat list page until I changed it in all 3 places.

[Kindred]

I changed the one place and it works for me....

[Dramber]

You are correct sir. I uploaded the wrong changed file to my webserver. Silly nub mistake. Edited my original post to reflect that.

[IchBin™]

Sorry about that, yes Kindred you found the right code. lol Glad you figured that out.

Yes all instances of int:page should be kept. It checks for the ID (int) number in those instances, instead of the query name (string).

So kindred, are you saying after making just those changes you now can access the catlist page in categories?

[Kindred]

yes, after making those changed, the catlist is working correctly.

The Queryname seems to be working correctly as well.

The article global tags is still broken though.  It saves the field as "$value" in the db, regardless of what I enter. I was able to work around it by adding three and then going into the database and changing them directly.

[IchBin™]

Aha. In Sources/TPortalAdmin.php

Code Select Expand

                    if(!empty($value))
                        $smcFunc['db_query']('REPLACE',
                            '{db_prefix}tp_variables',
                            array('value1' => 'string', 'type' => 'string'),
                            array($value,'globaltag'),
                            array('id')
                        );


Change db_query to db_insert.

That fixes entering tags from tags admin. Will check out adding tags from articles.

[Dramber]

Made the change but for a tag I get $value instead of the word I entered for a tag, from the article page. It works just fine on /index.php?action=tpadmin;sa=modules;tags page.

I do have one last error, when I go to /index.php?cat=docs or /index.php?cat=1 I get this error in my log:

Code Select Expand

/index.php?cat=18
Undefined index: page
File: /public_html/Sources/TPSubs.php(1744) : eval()'d code
Line: 286