arfooo upgrade issue from 2.0.1 to 2.0.2

[craigprunty]

After running the upgrade process from 2.01 to 2.02 I noticed that some fields within Admin Settings wasn’t populated with any data on some of the YES/NO fields.

I then noticed the following error on existing referred submitted sites

-----------------------ERROR START------------------

/admin/site/edit/17
http://directory.linkexchangeforum.co.uk/admin/referrer
(8) Undefined index: siteDescriptionHtmlEnabledAdmin c_1_site_edit_tpl.php line 241 26-11-10 10:42

FrontController->dispatch() # line 18, file: /home/sites/linkexchangeforum.co.uk/public_html/linkdirectory/index.php
Controller->render() # line 225, file: /home/sites/linkexchangeforum.co.uk/public_html/linkdirectory/core/FrontController.php
TemplateLiteView->render(Object:Admin_SiteController) # line 167, file: /home/sites/linkexchangeforum.co.uk/public_html/linkdirectory/core/Controller.php
Template_Lite->fetch("site/edit.tpl") # line 77, file: /home/sites/linkexchangeforum.co.uk/public_html/linkdirectory/views/TemplateLiteView.php
Template_Lite->_fetch_compile("site/edit.tpl", null) # line 360, file: /home/sites/linkexchangeforum.co.uk/public_html/linkdirectory/components/template_lite/class.template.php
include("/home/sites/linkexchangeforum.co.uk/public_html/linkdirectory/co...") # line 482, file: /home/sites/linkexchangeforum.co.uk/public_html/linkdirectory/components/template_lite/class.template.php


-----------------------ERROR END------------------

The error is down to the database update query - "update202.php" which seems to have been unsuccessfully. I think the reason it errors is something to do with the task update. As tasks only show after being run in the db.

----------------------mysql update script issue start----------------------------


$sqls[] = "ALTER TABLE `".$dbConfig['DB_PREFIX']."tasks`
CHANGE `data` `data` longtext NOT NULL";

----------------------mysql update script issue end----------------------------



After checking the "settings" table in phpmyadmin I spotted some fields wasn’t inserted into the table called settings.


I had to adapt the "update202.php" to only carry out the below update which resolved my issue my removing all other sql update scripts that had successfully updated already.

---------------------------run this mysql script----------------------------------------------

$sqls[] = "INSERT INTO ".$dbConfig['DB_PREFIX']."settings (`key` , `value` )
VALUES
('siteDescriptionHtmlEnabled', '0'),
('siteDescriptionHtmlAllowedTags', 'a[href|title|target], br, b, p, ul, ol, li, table[cellspacing|cellpadding|border], tbody, tr, td[colspan|rowspan], strong, span, em, *[style], *[class], img[src]'),
('siteDescriptionHtmlAllowedCssProperties', 'text-align, color, background-color, font-family, font-size, border, text-decoration, padding-left, height, width, font-weight'),
('campaignFilters', ''),
('siteDescriptionHtmlEnabledAdmin', '0'),
('siteDescriptionHtmlAllowedTagsAdmin', 'a[href|title|target], br, b, p, ul, ol, li, table[cellspacing|cellpadding|border], tbody, tr, td[colspan|rowspan], strong, span, em, *[style], *[class], img[src]'),
('siteDescriptionHtmlAllowedCssPropertiesAdmin', 'text-align, color, background-color, font-family, font-size, border, text-decoration, padding-left, height, width, font-weight'),
('duplicateContentCheckerEnabled', '0'),
('duplicateContentCheckerPhrasesToCheckCount', '3'),
('duplicateContentCheckerWordsInPhraseCount', '6'),
('duplicateContentCheckerAllowableDuplicatedPhrasesCount', '0')";

---------------------------end---------------------------------------------

Hope this helps any others who may have come across this issue after upgrading.

Craig

[craigprunty]

also the following mysql table update doesnt have seemed to run about the task mysql script.

this just causes an error when you click the details button on a list listing.

just run this bit again as per my first post

------------------------------------------------------

$sqls[] = "ALTER TABLE `".$dbConfig['DB_PREFIX']."sites`
ADD `descriptionDisplayMethod` enum('text','html','htmlAdmin') NOT NULL DEFAULT 'text',
ADD `isDuplicateContent` enum('0','1') NOT NULL DEFAULT '0'";

------------------------------------------------------

everything else seems to be working fine and its defo worth the update!

Thanks Arfooo team for providing such an excellent directory script

Craig

[craigprunty]

My two sites updated to the new version 2.02 if anyones interested to see are:-





Craig