[TP 1.0 Beta5-1 + SMF 2 rc3] Block type Articles in Catagory not working

[Blue Steel]

using [TP 1.0 Beta5-1 + SMF 2 rc3 and Bloc's fixed TPortal.php

I go into the blocks menu
I add a new block of type Articles in Catagory
I save that.
I then re-enter it and select a catagory. and press save

nothing shows up in the catagory slot on the maion blocks page for that block

and when i go to view the home page i get this error message

Code Select Expand


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IFNULL(mem.real_name,art.author) as real_name FROM smf_tp_articles AS art
LEFT' at line 2
File: /home/gamersl2/public_html/codingmonkeys.com/Sources/TPortal.php
Line: 1882


I can however see the articles if i view them seperatly. and also using eg: http://www.xxxxxxxxxxxxxxxxxxxxxxxxxxx/index.php?cat=361

both these methods work

also when i go back in to the admin > blocks > modify that block .. the catagory that i selected is still selected in there but not on the main admin > blocks  screen

[bloc]

Did you save inside the single editing block and then went straight to frontpage? or did you save while also on block-overview page for then to go to frontpage? It would seem the block overview screen - with its quick-select - saves the category wrong somehow.

[Blue Steel]

i saved it in the dedicated block edit page . not the main block page that lists all the blocks.

the main block page that lists all the blocks doesn'r show any catagories in its list. Only when i go in and edit that block can i select the catagory

[bloc]

Ah, ok. I will check this up further.

[Blue Steel]

thanks .. eagerly awaiting fix