[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

:pint:

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

' . 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:

[khan_thep]

du machst ja deinem usernamen alle ehre

da => :stupid: wo sonst?

[nervens?ge]

es war wohl gestern etwas sp?ht, habe es heute ge?ndert uns es geht. :drunk:

[khan_thep]

ja, war wirklich zu sp?t

kein Problem - aber einmal darf ICH auch noch :tweak: