Hallo...
Hier ein Fehler den ich wahrscheinlich bei Einstellungen verursacht haben könnte...muss aber auch nicht!
Diese Datei hat in dieser Zeile folgenden Code
Was könnte der Fehler sein und wo muss ich in den Einstellungen suchen.
Könnte es auch sein, dass da ein Ausführungszeichen fehlt?
Wo muss ich suchen um das abzustellen?
------------------------------------------------------------------------------------
Meine Provider und Serverdaten
Tarif: 1blu-Homepage Professional
Server Betriebssystem: Linux 2.6.8-11-amd64-k8-smpD
Datenbank: MySQL 4.1.11-Debian_4sarge5
PHP Version: 4.4.2-Debian-0.1~sarge1 (Zend: 1.3.0)
HTTP Server: Apache/2.0.54 (Debian GNU/Linux) mod_ssl/2.0.54 OpenSSL/0.9.7e
Hier ein Fehler den ich wahrscheinlich bei Einstellungen verursacht haben könnte...muss aber auch nicht!
Warning: Division by zero in /hp/aa/ah/uy/www/zc/includes/classes/split_page_results.php on line 76
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 '-0,' at line 7
in:
[select p.products_model, p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen135de_products_description pd, zen135de_products p left join zen135de_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen135de_products_to_categories p2c left join zen135de_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '43' and p2c.categories_id = '141' order by p.products_sort_order, pd.products_name limit -0, ]
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 '-0,' at line 7
in:
[select p.products_model, p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen135de_products_description pd, zen135de_products p left join zen135de_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen135de_products_to_categories p2c left join zen135de_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '43' and p2c.categories_id = '141' order by p.products_sort_order, pd.products_name limit -0, ]
Code:
$this->number_of_pages = ceil($this->number_of_rows / $this->number_of_rows_per_page);
Könnte es auch sein, dass da ein Ausführungszeichen fehlt?
Wo muss ich suchen um das abzustellen?
------------------------------------------------------------------------------------
Meine Provider und Serverdaten
Tarif: 1blu-Homepage Professional
Server Betriebssystem: Linux 2.6.8-11-amd64-k8-smpD
Datenbank: MySQL 4.1.11-Debian_4sarge5
PHP Version: 4.4.2-Debian-0.1~sarge1 (Zend: 1.3.0)
HTTP Server: Apache/2.0.54 (Debian GNU/Linux) mod_ssl/2.0.54 OpenSSL/0.9.7e
Kommentar