[xt Sql Error] Catalog/specials.php

[nervens?ge]

moin,
ich benutze local xammp 1.4.11 (umgeschaltet auf php4) und bekomme diesen fehler beim aufruf der catalog/specials.php


1064 - 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 '-9, 9' at line 13

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '2' and s.status = '1' order by s.specials_date_added DESC limit -9, 9

[XT SQL Error]

woran kann das liegen ?

[khan_thep]

suche => "1064"

[techway]

http://www.xt-commerce.com/modules/ipboard...post-10080.html
int:

das gleiche problem (negativer limit)

[nervens?ge]

ich habe schon die suche benutzt aber was ist die l?sung ?

[khan_thep]

http://www.xt-commerce.com/modules/ipboard...-post-8729.html

[nervens?ge]

das benutze ich
# MySQL 4.1.8,
# PHP 5.0.3
# PHP 4.1.10
zeile 40 bis 45 sieht so aus: admin\includes\classes/split_page_results.php

$current_page_number = $num_pages;
}
$offset = ($max_rows_per_page * ($current_page_number - 1));
if ($offset < 0) $offset=0;
$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;
}
das ist immer noch der fehler: auf der catalog/specials.php

1064 - 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 '-9, 9' at line 13

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '2' and s.status = '1' order by s.specials_date_added DESC limit -9, 9

[XT SQL Error]

Warum soll der fehler aus dem admin bereich kommen ?
falls die l?sung in diesem beitrag steht ,so habe ich keinen zutritt.

http://www.xt-commerce.com/modules/ipboard...-post-9012.html

hat sonst jemand vorschl?ge ? :?:

[khan_thep]

steht doch dran => mysql version herabsetzen oder core entsrpechend umcodieren oder Sponsorenforum

[nervens?ge]

soll ich wegen diesem fehler meinen Provider wechseln oder 98 euro f?r die l?sung ausgeben?
das kann nicht euer ernst sein. :stupid: :abgelehnt: :wall:

was soll ich umcodieren wenns schon so is ?

$current_page_number = $num_pages;
}
$offset = ($max_rows_per_page * ($current_page_number - 1));
if ($offset < 0) $offset=0; :grml:
$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;
}

[khan_thep]

das muss nat?rlich v.a. in die

includes/classes/split_page_results.php rein

[nervens?ge]

und wo soll in der catalog/includes/classes/split_page_results.php
was ge?ndert werden ?
Ich habe hier nicht die zeilen wie in der anderen.


<?php
/* -----------------------------------------------------------------------------------------
$Id: split_page_results.php,v 1.3 2004/04/26 12:28:47 fanta2k Exp $

XT-Commerce - community made shopping
http://www.xt-commerce.com

Copyright &copy; 2003 XT-Commerce
-----------------------------------------------------------------------------------------
based on:
&copy; 2000-2001 The Exchange Project (earlier name of osCommerce)
&copy; 2002-2003 osCommerce(split_page_results.php,v 1.14 2003/05/27); www.oscommerce.com
&copy; 2003 nextcommerce (split_page_results.php,v 1.6 2003/08/13); www.nextcommerce.org

Released under the GNU General Public License
---------------------------------------------------------------------------------------*/

class splitPageResults {
var $sql_query, $number_of_rows, $current_page_number, $number_of_pages, $number_of_rows_per_page;

// class constructor
function splitPageResults($query, $page, $max_rows, $count_key = '*') {
$this->sql_query = $query;

if (empty($page) || (is_numeric($page) == false)) $page = 1;
$this->current_page_number = $page;

$this->number_of_rows_per_page = $max_rows;

$pos_to = strlen($this->sql_query);
$pos_from = strpos($this->sql_query, ' from', 0);

$pos_group_by = strpos($this->sql_query, ' group by', $pos_from);
if (($pos_group_by < $pos_to) && ($pos_group_by != false)) $pos_to = $pos_group_by;

$pos_having = strpos($this->sql_query, ' having', $pos_from);
if (($pos_having < $pos_to) && ($pos_having != false)) $pos_to = $pos_having;

$pos_order_by = strpos($this->sql_query, ' order by', $pos_from);
if (($pos_order_by < $pos_to) && ($pos_order_by != false)) $pos_to = $pos_order_by;

if (strpos($this->sql_query, 'distinct') || strpos($this->sql_query, 'group by')) {
$count_string = 'distinct ' . xtc_db_input($count_key);
//$count_string = xtc_db_input($count_key);
} else {
$count_string = xtc_db_input($count_key);
}

$count_query = xtc_db_query($query);
$count = xtc_db_num_rows($count_query);

$this->number_of_rows = $count;
$this->number_of_pages = ceil($this->number_of_rows / $this->number_of_rows_per_page);

if ($this->current_page_number > $this->number_of_pages) {
$this->current_page_number = $this->number_of_pages;
}

$offset = ($this->number_of_rows_per_page * ($this->current_page_number - 1));

:stupid:
$this->sql_query .= " limit " . $offset . ", " . $this->number_of_rows_per_page;
}

// class functions

// display split-page-number-links
function display_links($max_page_links, $parameters = '') {
global $PHP_SELF, $request_type;

$display_links_string = '';

$class = 'class="pageResults"';

if (xtc_not_null($parameters) && (substr($parameters, -1) != '&')) $parameters .= '&';

// previous button - not displayed on first page
if ($this->current_page_number > 1) $display_links_string .= '' . PREVNEXT_BUTTON_PREV . '';

// check if number_of_pages > $max_page_links
$cur_window_num = intval($this->current_page_number / $max_page_links);
if ($this->current_page_number % $max_page_links) $cur_window_num++;

$max_window_num = intval($this->number_of_pages / $max_page_links);
if ($this->number_of_pages % $max_page_links) $max_window_num++;

// previous window of pages
if ($cur_window_num > 1) $display_links_string .= '...';

// page nn button
for ($jump_to_page = 1 + (($cur_window_num - 1) * $max_page_links); ($jump_to_page <= ($cur_window_num * $max_page_links)) && ($jump_to_page <= $this->number_of_pages); $jump_to_page++) {
if ($jump_to_page == $this->current_page_number) {
$display_links_string .= '' . $jump_to_page . '';
} else {
$display_links_string .= '' . $jump_to_page . '';
}
}

// next window of pages
if ($cur_window_num < $max_window_num) $display_links_string .= '...';

// next button
if (($this->current_page_number < $this->number_of_pages) && ($this->number_of_pages != 1)) $display_links_string .= '' . PREVNEXT_BUTTON_NEXT . '';

return $display_links_string;
}

// display number of total products found
function display_count($text_output) {
$to_num = ($this->number_of_rows_per_page * $this->current_page_number);
if ($to_num > $this->number_of_rows) $to_num = $this->number_of_rows;

$from_num = ($this->number_of_rows_per_page * ($this->current_page_number - 1));

if ($to_num == 0) {
$from_num = 0;
} else {
$from_num++;
}

return sprintf($text_output, $from_num, $to_num, $this->number_of_rows);
}
}
?>

wo soll es den sein ? :tweak: