Категории

[FAQ] Часто задаваемые вопросы и ответы

Проблемы и решения

Ошибки и исправления

Общие вопросы

Расширения

Установка и обновление

Модули

Шаблоны

Локализация интерфейса

Коммерческие предложения

Учимся бизнесу

Бизнес книги

Поисковая оптимизация (SEO)

Магазины на ShopOS

Хостинг для ShopOS

Предложения и пожелания

Курилка

Изменение цен ОШИБКА ShopOS 2.4.1 RC4 хелп

В общем это очень странно, он всетаки, на локалхосте изменение цен работает как часы. То есть все меняется как надо.
Но однако на сервере при переходе на другую страницу (На первой странице в списке товара все работает, но только цены не меняет в магазине вообще).

Выводит "Интернет-магазин закрыт на техническое обслуживание, заходите позже!".

Единственное чем различаются серваки - это версией php? На моем 5ая, на хостинге 4ая.

Но рекомендуемые пораметры php 4.2, а на хосте вертиться 4.4.

тоесть в теории и в php дела не могут быть...

И вот еще в /admin/mysql_db_error.log
Вот чего

19/08/2009 15:08:16 | 1054 - Unknown column 'start' in 'field list' | INSERT into os_admin_access (customers_id,start) VALUES ('5','1') | /admin/create_account.php?action=edit
25/08/2009 08:08:13 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd, os_products_to_categories pc where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = pc.products_id and pc.categories_id = '24' and p.manufacturers_id = Array   | /admin/quick_updates.php?page=2&=&cPath=24&manufacturer=Array&sort_by=&row_by_page=20&search=&search_model_key=
25/08/2009 08:08:27 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd, os_products_to_categories pc where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = pc.products_id and pc.categories_id = '24' and p.manufacturers_id = Array   | /admin/quick_updates.php?action=update&page=2&sort_by=&cPath=24&row_by_page=20&manufacturer=Array&search=&search_model_key=
25/08/2009 08:08:34 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd, os_products_to_categories pc where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = pc.products_id and pc.categories_id = '24' and p.manufacturers_id = Array   | /admin/quick_updates.php?page=2&sort_by=&cPath=24&row_by_page=20&manufacturer=Array&search=&search_model_key=&action=calcul&page=2&sort_by=&cPath=24&row_by_page=20&manufacturer=Array
25/08/2009 08:08:16 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd, os_products_to_categories pc where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = pc.products_id and pc.categories_id = '24' and p.manufacturers_id = Array   | /admin/quick_updates.php?page=2&=&cPath=24&manufacturer=Array&sort_by=&row_by_page=20&search=&search_model_key=
25/08/2009 09:08:47 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd, os_products_to_categories pc where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = pc.products_id and pc.categories_id = '24' and p.manufacturers_id = Array   | /admin/quick_updates.php?action=update&page=2&sort_by=&cPath=24&row_by_page=20&manufacturer=Array&search=&search_model_key=
25/08/2009 09:08:56 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd, os_products_to_categories pc where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = pc.products_id and pc.categories_id = '24' and p.manufacturers_id = Array   | /admin/quick_updates.php?manufacturer=Array&cPath=24&row_by_page=50
25/08/2009 09:08:01 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = Array   | /admin/quick_updates.php?&cPath=0&manufacturer=Array&sort_by=&row_by_page=20&search=&search_model_key=&page=2
25/08/2009 09:08:32 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = Array   | /admin/quick_updates.php?action=update&page=2&sort_by=&cPath=0&row_by_page=20&manufacturer=Array&search=&search_model_key=
25/08/2009 09:08:36 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = Array   | /admin/quick_updates.php?&cPath=0&manufacturer=Array&sort_by=&row_by_page=20&search=&search_model_key=&page=2
25/08/2009 09:08:47 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = Array   | /admin/quick_updates.php?page=2&=&cPath=0&manufacturer=Array&sort_by=&row_by_page=20&search=&search_model_key=
25/08/2009 09:08:07 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = Array   | /admin/quick_updates.php?page=2&=&cPath=0&manufacturer=Array&sort_by=&row_by_page=20&search=&search_model_key=
25/08/2009 09:08:36 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = Array   | /admin/quick_updates.php?page=2&=&cPath=0&manufacturer=Array&sort_by=&row_by_page=20&search=&search_model_key=
25/08/2009 09:08:44 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = Array   | /admin/quick_updates.php?page=2&=&cPath=0&manufacturer=Array&sort_by=&row_by_page=20&search=&search_model_key=
25/08/2009 09:08:13 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = Array   | /admin/quick_updates.php?page=6&=&cPath=0&manufacturer=Array&sort_by=&row_by_page=20&search=&search_model_key=
25/08/2009 09:08:15 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = Array   | /admin/quick_updates.php?page=6&=&cPath=0&manufacturer=Array&sort_by=&row_by_page=20&search=&search_model_key=
25/08/2009 09:08:18 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = Array   | /admin/quick_updates.php?page=6&=&cPath=0&manufacturer=Array&sort_by=&row_by_page=20&search=&search_model_key=
25/08/2009 09:08:33 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = Array   | /admin/quick_updates.php?page=2&=&cPath=0&manufacturer=Array&sort_by=&row_by_page=20&search=&search_model_key=
25/08/2009 09:08:42 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = Array   | /admin/quick_updates.php?page=2&=&cPath=0&manufacturer=Array&sort_by=&row_by_page=20&search=&search_model_key=
25/08/2009 10:08:40 | 1054 - Unknown column 'Array' in 'where clause' | select count(*) as total  from  os_products p, os_products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = Array   | /admin/quick_updates.php?page=2&=&cPath=0&manufacturer=Array&sort_by=&row_by_page=20&search=&search_model_key=



В чем проблема? Кто знает помогите... Я битый час бьюсь, по магазину докуметация ужасная, для разработчика нечего нету толком.


В общем вопрос решен, ошибка в скрипте найдена.

Чтоб эта хрень не появлялась, надо сделать следующее дерьмо.

Открыть скрипт /admin/quick_updates.php найти вот это:
<?php
echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_ROW_BY_PAGE, MAX_DISPLAY_PAGE_LINKS, $split_page, '&cPath='. $current_category_id . '&manufacturer='. $manufacturer .'&sort_by='.$sort_by . '&row_by_page=' . $row_by_page . '&search=' . $search . '&search_model_key=' . $search_model_key);
?>
и поменять на:
<?php
if ((is_array($manufacturer))==true) $manufacturer1=0; else $manufacturer1=$manufacturer;

echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_ROW_BY_PAGE, MAX_DISPLAY_PAGE_LINKS, $split_page, '&cPath='. $current_category_id . '&manufacturer='. $manufacturer1 .'&sort_by='.$sort_by . '&row_by_page=' . $row_by_page . '&search=' . $search . '&search_model_key=' . $search_model_key);
?>

Да и не надо только писать что я дерьмово условие прописал, можно обойтись без лишней переменной, я просто не вкурил что дальше эта переменная делает и не стал её занулять.


Источник



Copyright ShopOS