cpg 1.4.5 ÷òî èçìåíèëîñü?

[Alex Revo]

Êòî-íèáóäü óæå ïðîáîâàë îáíîâèòüñÿ äî âåðñèè 1.4.5? Ïîäåëèòåñü îïûòîì, ÷òî íîâîãî çàìåòèëè, íå áûëî ëè ïðîáëåì ïðè àïäåéòå?

ß íåäàâíî òîëüêî íàñòðîèë 1.4.4 íà ðàáîòó ñ êîäèðîâêîé windows-1251, ïîýòîìó ñïåøèòü îáíîâëÿòüñÿ íå õî÷ó...

[Makc666]

Êòî-íèáóäü óæå ïðîáîâàë îáíîâèòüñÿ äî âåðñèè 1.4.5? Ïîäåëèòåñü îïûòîì, ÷òî íîâîãî çàìåòèëè, íå áûëî ëè ïðîáëåì ïðè àïäåéòå?

ß íåäàâíî òîëüêî íàñòðîèë 1.4.4 íà ðàáîòó ñ êîäèðîâêîé windows-1251, ïîýòîìó ñïåøèòü îáíîâëÿòüñÿ íå õî÷ó...

Îáíîâëÿòñÿ íóæíî îáÿçàòåëüíî, ò.ê. èñïðàâëåíû ñåðüåçíûå îøèáêè!!!

Îíè îïèñàíû â ýòîé òåìå:
http://forum.coppermine-gallery.net/index.php?topic=30655.0

Ôèêñ, êîòîðûé òàì ïðèâåäåí, íóæíî ïðèìåíèòü 100%.
Èíà÷å áóäóò ïðîáëåìû.
Îïèñàíî òóò:
http://secunia.com/advisories/19665/

[Alex Revo]

Îáíîâèëñÿ äî âåðñèè 1.4.5 òîëüêî ïåðåâîä ñòàðûé îñòàâèë, òàì íè÷åãî íå èçìåíèëîñü, à ìîé çàòî÷åí ïîä ñàéò... Ïðîáëåì íå âîçíèêëî.

Îäèí âîïðîñ òîëüêî åñòü.  êîðíå îñòàëñÿ ëåæàòü ôàéë relocate_server.php, ïîñëå ïðîøëûõ àïäåéòîâ âñåãäà íóæíî áûëî óäàëÿòü ýòîò ôàéë, à ñåé÷àñ ãàëåðåÿ íå ïðîñèò ýòî äåëàòü... Îñòàâëÿòü?

[Makc666]

Îáíîâèëñÿ äî âåðñèè 1.4.5 òîëüêî ïåðåâîä ñòàðûé îñòàâèë, òàì íè÷åãî íå èçìåíèëîñü, à ìîé çàòî÷åí ïîä ñàéò... Ïðîáëåì íå âîçíèêëî.

Îäèí âîïðîñ òîëüêî åñòü.  êîðíå îñòàëñÿ ëåæàòü ôàéë relocate_server.php, ïîñëå ïðîøëûõ àïäåéòîâ âñåãäà íóæíî áûëî óäàëÿòü ýòîò ôàéë, à ñåé÷àñ ãàëåðåÿ íå ïðîñèò ýòî äåëàòü... Îñòàâëÿòü?

Îòâåò íà òâîé âîïðîñ:

In cpg1.4.5, I re-added a file named relocate_server.php to make sure that users who upgrade actually fix the older, dangerous version of that file. The file I have added to cpg1.4.5 is harmless and will only forward users to your index page.

Åñëè íóæåí ïåðåâîä, ñêàæè

[Alex Revo]

Êîðî÷å, ôàéë òåïåðü áåçîïàñåí è ìîæíî îñòàâèòü...

[Alex Revo]

Çàìåòèë òàêèå âåùè:

1. Ê îäíîé ôîòî ó ìåíÿ íà ñàéòå åñòü êîììåíòàðèé: "Àðõèòåêòîð çäàíèÿ èç Ïèòåðà - Ñåðãåé ×îáàí, îí ðàçðàáîòàë ýòîò ïðîåêò ïî çàêàçó "Ñòðîèòåëüíûå êîìïàíèè Ìàçàíîâà", îêíàìè îíè òîæå çàíèìàþòñÿ..."
Åñëè íàéòè ýòó çàïèñü â album=lastcom (â ìåíþ ïîñë. êîììåíòàðèè), òî òàì òàêîé òåêñò: Àðõèòåêòîð çäàíèÿ èç Ïèòåðà - Ñåðãåé ×îáàí, îí ðàçðàáîòàë ýòîò ïðîåêò ïî çàêàçó "Ñòðîèòåëüíûå êîìïàíèè Ìàçàíîâà&q..."

Òî, ÷òî â lastcom äëèíà êîììåíòàðèÿ íå ïðåâûøàåò êàêîå-òî ÷èñëî ñèìâîëîâ ýòî ïîíÿòíî, â êîíöå ïîäñòàâëÿåòñÿ òðîåòî÷èå. Ïðîñòî â äàííîì ñëó÷àå ñî÷åòàíèå ", çàìåíèëîñü íà &q  - ñòðàííî....

ññûëêà íà ôîòî

2. Ïðè çàãðóçêå èçîáðàæåíèé åñëè ïðè âûáîðå êëþ÷åâûõ ñëîâ èç ñïèñêà íàæàòü Ïåðåñîáðàòü ñëîâàðü (keyword_create_dict.php) ïîÿâëÿåòñÿ êîä:

/************************* Coppermine Photo Gallery ************************ Copyright (c) 2003-2006 Coppermine Dev Team v1.1 originally written by Gregory DEMAR This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. ******************************************** Coppermine version: 1.4.5 $Source: /cvsroot/coppermine/stable/keyword_create_dict.php,v $ $Revision: 1.5 $ $Author: gaugau $ $Date: 2006/03/02 08:17:40 $ **********************************************/ /* vim: set expandtab tabstop=4 shiftwidth=4: */ // +----------------------------------------------------------------------+ // | Filename: keyword_create_dict.php | // +----------------------------------------------------------------------+ // | Copyright (c) http://www.sanisoft.com | // +----------------------------------------------------------------------+ // | Description: | // +----------------------------------------------------------------------+ // | Authors: Original Author | // | SANIsoft Developement Team | // +----------------------------------------------------------------------+ define('IN_COPPERMINE', true); define('EDITPICS_PHP', true); require('include/init.inc.php'); if (!(GALLERY_ADMIN_MODE)) cpg_die(ERROR, $lang_errors['access_denied'], __FILE__, __LINE__); $query = "SELECT keywords from {$CONFIG['TABLE_PREFIX']}pictures"; $result = cpg_db_query($query); $i=0; while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $keywords = $row["keywords"]; $keyArr = explode(" ",$keywords); foreach ($keyArr as $keyword) { $query = "SELECT keyword from {$CONFIG['TABLE_PREFIX']}dict WHERE keyword = '$keyword'"; $result2 = cpg_db_query($query); if (mysql_num_rows($result2) == 0 && $keyword != "" && $keyword != " ") { $query = "INSERT INTO {$CONFIG['TABLE_PREFIX']}dict SET keyword = '$keyword'"; cpg_db_query($query); echo "* "; $i++ ; } else { echo "% "; } } mysql_free_result($result2); flush(); } echo "

{$lang_editpics_php['new_keywords']} = ".$i; echo "* = {$lang_editpics_php['new_keyword']}"; echo "% = {$lang_editpics_php['existing_keyword']}
"; mysql_free_result($result); ?>

ò.å. êîä ôàéëà, à äåéñòâèé íå ïðîèñõîäèò...

[Makc666]

Çíà÷îê &q - ýòî íîðìàëüíî. Ýòî íå îøèáêà. Ïðîñòî òàê PHP ðàáîòàåò ñ áàçîé äàííûõ.
ß ñ òàêèì ñòàëêèâàëñÿ â phpBB è ïèñàë â Bugtracker èõ.
Ìíå òàì îáúÿñíèëè, ÷òî ïî äðóãîìó, ê ñîæàëåíèþ, áûòü íå ìîæåò.
Âîò ññûëêà:
http://www.phpbb.com/bugs/viewreport.php?b=859
Âîò ÿ òåáå äàæå ñêðèíøîò ïîêàæó
(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fimg67.imageshack.us%2Fimg67%2F4206%2Fphpbbpostsubjectbug4mw.png&hash=ba585204ff15fe4418876c33c7193a2338bcca2f)

Ïðîáëåìà òàì èìåííî â ñèìâîëå äâîéíûõ êàâû÷åê è äðóãèõ ïîäîáíûõ.
Ò.ê. òàêèå ñèìâîëû êîäèðóþòñÿ â áàçå äàííûõ íå îäíèì çíàêîì, à êîìáèíàöèåé.
À äàëüøå ìîæåò áûòü íåñêîëüêî âàðèàíòîâ. Èëè ýòà êîìáèíàöèÿ íå çàïèñûâàåòñÿ ïîëíîñòüþ â áàçó äàííûõ, à îáðåçàåòñÿ.
Òàêîå ïðîèñõîäèò â phpBB, åñëè äëèíà ïðèâûøàåò äîïóñòèìóþ äëèíó â áàçå äàííûõ.

Èëè êàê òâî¸ì ñëó÷àå, êîìáèíàöèÿ çàïèñàëàñü â áàçó äàííûõ, à âîò ïðè îòîáðàæåíèè íà ìåñòå ýòîé êîìáèíàöèè áûë ïðèâûøåí ëèìèò, è CPG îáðåçàë ïðîñòî.

Code Select Expand

Àðõèòåêòîð çäàíèÿ èç Ïèòåðà - Ñåðãåé ×îáàí, îí ðàçðàáîòàë ýòîò ïðîåêò ïî çàêàçó "Ñòðîèòåëüíûå êîìïàíèè Ìàçàíîâà", îêíàìè îíè òîæå çàíèìàþòñÿ...
Âîò òàê âûãëÿäèò òâîÿ ñòðîêà â áàçå äàííûõ
Âûäåøü, êàê îòîáðàæàþòñÿ êàâû÷êè --- "

===============================

Íàñ÷åò âòîðîé îøèáêè.
1-ûõ, äàâàéòå ñîçäàâàòü äëÿ êàæäîé îøèáêè îòäåëüíóþ òåìó.  ýòîò ðàç ñäåëàåì èñêëþ÷åíèÿ.
Íî ïîòîì áóäó ÓÓÓÓÓÓÓÓÓ äåëàòü!

2-ûõ.
ß ïðîâåðèë íà ñâîåé ãàëåðåè, ó ìåíÿ íåò ïîäîáíîãî ýôôåêòà.
Êîãäàÿ ÿ îòðûâàþ (íà òâî¸ì ïðèìåðå):
http://www.temernik.ru/keyword_select.php
è æìó:
http://www.temernik.ru/keyword_create_dict.php
òî ó ìåíÿ âñå ïåðåñîáèðàåòñÿ.

Ïîÿâëÿåòñÿ ñòðàíè÷êà, ãäå êó÷à çíàêîâ ïðîöåíòà è çâåçäî÷åê:

À â êîíöå íàïèñàíî:
Íàéäåíî íîâîå êëþ÷åâîå ñëîâî = 51
* = Íîâîå êëþ÷åâîå ñëîâî
% = Èìåþùååñÿ êëþ÷åâîå ñëîâî

Èëè åñëè ÿ äåëàþ ïîâòîðíî, òî óæå íàïèñàíî:
Íàéäåíî íîâîå êëþ÷åâîå ñëîâî = 0
* = Íîâîå êëþ÷åâîå ñëîâî
% = Èìåþùååñÿ êëþ÷åâîå ñëîâî

Òàê ÷òî âèäíî òû ïëîõî çàãðóçèë ôàéë íà ñåðâåð.

[Alex Revo]

Äà äåéñòâèòåëüíî, çàïèñü â áàçå âûãëÿäèò èìåííî òàê, òåïåðü ïîíÿòíî...

2. Ïåðåçàïèñàë ôàéë íà ñåðâåðå è äåéñòâèòåëüíî âñå çàðàáîòàëî. Ñëîâàðü ïåðåñîáèðàåòñÿ íîðìàëüíî, ñïàñèáî çà ïîäñêàçêó ïðàâèëüíîãî ïóòè.

[serega7777777]

При существующей кодировке е могу вписать в тело шаблона русские слова. А при изменение кодировки в win 1251 при которой понимаются русские буквы, перестает работать поиск. Может кто чего посоветует

[Alex Revo]

Òåìà óæå îáñóæäàëàñü, ñìîòðè çäåñü