Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?

plz help me

Asked Modified Viewed 1,887 times
I
ImmOr7aL
I
  • Junior Member, joined since
  • Contributed 14 posts on the community forums.
  • Started 5 threads in the forums
  • Started this discussions
asked
Junior Member

after the update to 6.00.300 ... i can't go to the articles section... when i'm going there i have an error message:
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 'LIMIT 0,15' at line 1You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,15' at line 1

It is the same with web links section... how can i fix it?
sorry for link, but maybe someone can look?:
http://warezland.puslapiai.lt/articles.php

also, i can't edit my settings_misc page.. when i'm writing in it and clicking save changes.. nothing happens... i see no changes when i'm reloading page...

and also i can't do the MySQL database backup... i'm selecting tables, then clicking backup button... but nothing happens too, after reloading page there is no mysql backup (i have this problem since update to 6.00.2x version)

PlZ help :|
Edited by ImmOr7aL on 28-12-2005 01:54,
0 replies

5 posts

S
shedrock
S
phpfusion-themes.com/siriuslogo.jpg
  • Senior Member, joined since
  • Contributed 232 posts on the community forums.
  • Started 10 threads in the forums
answered
Senior Member

TIP: a subject with a "plz help me" usually won't get answered in a hurry.

Shedrock
Edited by shedrock on 28-12-2005 02:49,
0 replies
K
Krazyone
K
  • Member, joined since
  • Contributed 63 posts on the community forums.
  • Started 8 threads in the forums
answered
Member

Can you post the code from articles.php that you are using. Also the table shema. With this i may be able to help. :)
0 replies
I
ImmOr7aL
I
  • Junior Member, joined since
  • Contributed 14 posts on the community forums.
  • Started 5 threads in the forums
  • Started this discussions
answered
Junior Member

articles.php code:
<?php
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
include LOCALE.LOCALESET."articles.php";

if (!isset($cat_id)) {
   opentable($locale['400']);
   $result = dbquery("SELECT * FROM ".$db_prefix."article_cats WHERE ".groupaccess('article_cat_access')." ORDER BY article_cat_name");
   $rows = dbrows($result);
   if ($rows != 0) {
      $counter = 0; $columns = 2;
      echo "<table cellpadding='0' cellspacing='0' width='100%' class='tbl'>\n<tr>\n";
      while ($data = dbarray($result)) {
         if ($counter != 0 && ($counter % $columns == 0)) echo "</tr>\n<tr>\n";
         $num = dbcount("(article_cat)", "articles", "article_cat='".$data['article_cat_id']."'");
         echo "<td align='center' valign='top' width='50%'><a href='".FUSION_SELF."?cat_id=".$data['article_cat_id']."'>".$data['article_cat_name']."</a> <span class='small2'>($num)</span>";
         if ($data['article_cat_description'] != "") echo "<br>\n<span class='small'>".$data['article_cat_description']."</span>";
         echo "</td>\n";
         $counter++;
      }
      echo "</tr>\n</table>\n";
   } else {
      echo "<center><br>\n".$locale['401']."<br><br>\n</center>\n";
   }
   closetable();
} else {
   $res = 0;
   if (!isNum($cat_id)) fallback(FUSION_SELF);
   $result = dbquery("SELECT * FROM ".$db_prefix."article_cats WHERE article_cat_id='$cat_id'");
   if (dbrows($result) != 0) {
      $cdata = dbarray($result);
      if (checkgroup($cdata['article_cat_access'])) {
         $res = 1;
         opentable($locale['400'].": ".$cdata['article_cat_name']);
         $rows = dbcount("(article_id)", "articles", "article_cat='$cat_id'");
         if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
         if ($rows != 0) {
            $result = dbquery("SELECT * FROM ".$db_prefix."articles WHERE article_cat='$cat_id' ORDER BY ".$cdata['article_cat_sorting']." LIMIT $rowstart,15");
            $numrows = dbrows($result); $i = 1;
            while ($data = dbarray($result)) {
               if ($data['article_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
                  $new = " <span class='small'>[".$locale['402']."]</span>";
               } else {
                  $new = "";
               }
               echo "<a href='readarticle.php?article_id=".$data['article_id']."'>".$data['article_subject']."</a>$new<br>\n".stripslashes($data['article_snippet']);
            echo ($i != $numrows ? "<br><br>\n" : "\n"); $i++;
            }
            closetable();
            if ($rows > 15) echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,15,$rows,3,FUSION_SELF."?cat_id=$cat_id&")."\n</div>\n";
         } else {
            echo "<center>".$locale['403']."</center>\n";
            closetable();
         }
      }
   }
   if ($res == 0) redirect(FUSION_SELF);
}

require_once "side_right.php";
require_once "footer.php";
?>
0 replies
I
ImmOr7aL
I
  • Junior Member, joined since
  • Contributed 14 posts on the community forums.
  • Started 5 threads in the forums
  • Started this discussions
answered
Junior Member

can anyone help me?
0 replies
— 7 months later —
J
Jeff Bolin
J
  • Newbie, joined since
  • Contributed 6 posts on the community forums.
  • Started 1 thread in the forums
answered
Newbie

You need to check out this thread for the fix:

http://www.php-fusion.co.uk/forum/vie...ad_id=9425
Edited by Jeff Bolin on 09-08-2006 17:54,
0 replies

Category Forum

Bugs and Errors - 6

Labels

None yet

Statistics

  • Views 0 views
  • Posts 5 posts
  • Votes 0 votes
  • Topic users 4 members

0 participants

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet