Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 44

  Posted: Sep 17, 2004 - 10:52 PM

  since i have upgraded to postnuke 750 my tix_archive mod doesnt work.
  
  look at
  http://www.senerap.org/modules.php?op=modload&name=TiX_Archives&file=index
  
  
  the error is:
  You have an error in your SQL syntax near '='eng' OR ='')' at line 1
  
  Does anyone know a solution or know another mod with the same features as tix-archive from www.trollix.com which works on pn750???
  tixarchive wasnt developed any more for about 2 years now...
  
  thanks

  • 
  •  
• **unknown user**
  

  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 1097

  Posted: Sep 18, 2004 - 02:15 AM

  Here is the index.php that will work (most of it) with pn0.750...
  
  (Do a backup just in case) and replace the index.php in the Tix_Archives folder :
  
  http://www.pnconcept.com/projects/postnuke/fix/Tix_Archives_pn0.750_index.zip
  
  (In action on http://www.postnuke-france.org/Tix_Archives.html )
  
  

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 44

  Posted: Sep 18, 2004 - 02:28 AM

  thanks
  
  i got already mine to work
  i added l
  
  ist($dbconn) = pnDBGetConn();
  
  $pntable = pnDBGetTables();
  
  
  before
  
  $currentlang= pnGetLang();
  
  
  what are the changes is your index.php? or is it the same????
  
  thanks anyway!!!

  • 
  •  
• **unknown user**
  

  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 1097

  Posted: Sep 18, 2004 - 02:40 AM

  Strangely, we probably don't have the same version because mine doesn't use dbconn, he was using directly mysql functions...
  So your change would have no influence on mine...
  
  But mine fix the sort, order, pages problem being empty and breaking the links here and there on the page (along with maybe some other little fixes I don't remember)...
  :)

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 44

  Posted: Sep 18, 2004 - 08:44 PM

  ok
  thank you man!
  i will use yours
  
  
  THANXXX

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 44

  Posted: Sep 18, 2004 - 08:47 PM

  now i have uploaded your index.php but i get this error now:
  
  You have an error in your SQL syntax near '='eng' OR ='')' at line 1

  • 
  •  
• **unknown user**
  

  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 1097

  Posted: Sep 19, 2004 - 12:37 AM

  Now what you added is important :
  
  

  Code

  $pntable = pnDBGetTables();

  
  
  After or before
  

  Code

  $currentlang = pnUserGetLang();

  
  
  :)

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 44

  Posted: Sep 19, 2004 - 12:50 AM

  i thought it was already included in your index.php???
  
  i am confused now....

  • 
  •  
• **unknown user**
  

  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 1097

  Posted: Sep 19, 2004 - 12:53 AM

  I'm as surprised as you about your error and me who don't have it but there is one thing that could be the reason... :
  
  

  Code

  if (pnConfigGetVar('multilingual')==1)......

  
  
  You have the error because you site is multilingual (or your configuration says it is... and mine must not be. And this is the only place where $pntable is in use in all the file. Since mine is not, the $queryW is empty for me so no error.
  
  

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 44

  Posted: Sep 19, 2004 - 01:09 AM

  i havent understood your last postbut ok i am not good in that coding thing
  where can i set up if postnuke is multilangual or not?
  
  
  thanks

  • 
  •  
• **unknown user**
  

  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 1097

  Posted: Sep 19, 2004 - 01:36 AM

  In the past, it was in the settings.......... but if it is not there anymore, only change the code
  
  

  Code

  if (pnConfigGetVar('multilingual') == 1) {
          $column = &$pntable['stories_column'];
          $querylanA = "AND ($column[alanguage]='$currentlang' OR $column[alanguage]='')";
          $querylangW = "WHERE ($column[alanguage]='$currentlang' OR $column[alanguage]='')";
      } else {
          $querylangA = '';
          $querylangW = '';
      }

  
  to
  

  Code

  //if (pnConfigGetVar('multilingual') == 1) {
      //    $column = &$pntable['stories_column'];
      //    $querylanA = "AND ($column[alanguage]='$currentlang' OR $column[alanguage]='')";
      //    $querylangW = "WHERE ($column[alanguage]='$currentlang' OR $column[alanguage]='')";
      //} else {
          $querylangA = '';
          $querylangW = '';
      //}

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 44

  Posted: Sep 19, 2004 - 09:05 PM

  is there a possibility to download somewhere a version with the latest hacks and support of pn750

  • 
  •  
• **unknown user**
  

  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 1097

  Posted: Sep 19, 2004 - 10:11 PM

  See the link in this thread and if you have the same problem, follow the instructions from my previous post.

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 44

  Posted: Sep 20, 2004 - 02:28 AM

  which link?

  • 
  •  
•  
•  

Users on-line

• alfonsomarin

This list is based on users active over the last 60 minutes.