Help with templates...

[Boofo]

Can anyone please help me with my templates problem? I did the upgrade from 2.2.5 to 2.2.6 patch, (3 files) and I am still having problems with the templates not all showing. I have included a picture of what my templates listing looks like fully expanded.

[FWC]

If you have hacked the template file, see if you have this query:

PHP Code:

$templates=$DB_site->query("SELECT t1.title,t2.templateid,t2.title,NOT ISNULL(t2.templateid) AS found".iif(isset($searchstring),",INSTR(t1.template,'".addslashes($searchstring)."') AS globalcontain,INSTR(t2.template,'".addslashes($searchstring)."') AS localcontain","")." FROM template AS t1 LEFT JOIN template AS t2 ON (t1.title=t2.title AND t2.templatesetid=$templateset[templatesetid]) WHERE t1.templatesetid=-1 AND t1.title<>'options' ORDER BY t1.title"); 


If you do, replace it with this one:

PHP Code:

$templates=$DB_site->query("SELECT t1.title AS title,t2.templateid, NOT ISNULL(t2.templateid) AS found" . iif(isset($searchstring), ",INSTR(t1.template,'".addslashes($searchstring)."') AS globalcontain,INSTR(t2.template,'".addslashes($searchstring)."') AS localcontain","")."
                                FROM template AS t1
                                LEFT JOIN template AS t2 ON (t1.title=t2.title AND t2.templatesetid=$templateset[templatesetid])
                                WHERE t1.templatesetid=-1 AND t1.title<>'options'
                                ORDER BY t1.title"); 


I ran into the same problem when I copied a hack into the upgrad file. That fixed it. Of course, you may have a completely different issue.

[Logician]

For testing purposes I applied the fix to my localhost and it didnt correct the problems regarding new PHP version here either. I then upgraded to v.2.2.6 and it's ok now. Also changing the settings in php.ini file helps but of course since we are talking about your site here which is hosted remotely, this is not an option for you.

Buttom line is, fix does not always work, IMO your best bet is to upgrade to v.2.2.6..

[Boofo]

FWC,

That did the trick. Thank you very much!

Do you have any idea what the hack is that was in that code that was messing things up? I've got over 100 installed and have no idea which one it would be.

Originally posted by FWC
I ran into the same problem when I copied a hack into the upgrad file. That fixed it. Of course, you may have a completely different issue.

[FWC]

Originally posted by Boofo
FWC,

That did the trick. Thank you very much!

Do you have any idea what the hack is that was in that code that was messing things up? I've got over 100 installed and have no idea which one it would be.

That's great! I think it's the one that makes the custom templates behave like the default templates in the template listing with grouping and expansion and contraction. That query is in the middle of it. If you copy the hack over from your old files you get the pre-4.2.1 query. So, we just replaced that part with the current query.

[Boofo]

Well, whatever it was, you IS the man! (Or is that supposed to be...you BEES the man?)

So, basically then, what was in there before I moved it to the new template.php and messed it up was supposed to be there for version 2.2.5 and was changed to what it is now for 2.2.6, right? Ah-ha, now it makes a little more sense.

Thanks again for saving me a lot of grief from having to re-install everything.

[FWC]

No problem. Glad to help.

[Boofo]

FWC,

Maybe you can help me with this. Have you had any strange goings on with the user.php file, too?