Page 1 of 1
"Error while browsing related articles"
Posted: Thu 21. Aug 2008, 02:56
by ourpobox
Hi All,
I just upgraded from 1.1.4RC4 to the current version 1.3.9 and ran into an issue when I tried to get into the Article Center. I get an error message saying: {STATUS_MESSAGE} error while browsing related articles
I don't know where to begin to look for the resolution. Can anybody tell me if they have seen this issue, and how to resolve it? I can't get a list of articles in the Article Center to be able to edit them. I really need to figure this one out.
Thank you,
Greg
Re: "Error while browsing related articles"
Posted: Thu 21. Aug 2008, 08:43
by update
Did you try to delete your browser's cache? You should try this first of all
Re: "Error while browsing related articles"
Posted: Thu 21. Aug 2008, 20:29
by ourpobox
Hi Claus,
Yes, I definitely deleted the cache and even tried a couple of different browsers.... Any other suggestions anybody?
Thanks!
Greg
Re: "Error while browsing related articles"
Posted: Thu 21. Aug 2008, 22:20
by Jensensen
[x]
Re: "Error while browsing related articles"
Posted: Thu 21. Aug 2008, 22:51
by marcus@localhorst
hi, i get this message just yesterday after an update.
The only thing I did, was to rerun all sql updates and there is a link (item six?) on the upgrade site, which build all article aliases. you need to execute this script, and it should work, if there a list with your articles will shown.
Re: "Error while browsing related articles"
Posted: Fri 22. Aug 2008, 16:51
by ourpobox
Thanks Marcus and Jensensen,
The Article Alias updated didn't do it, but for future reference, anyone else who sees this error in the Article Center should run the SQL update number #19 which has the following lines of code:
Code: Select all
#
#
ALTER TABLE `phpwcms_article` ADD `article_priorize` INT( 5 ) NOT NULL DEFAULT '0';
ALTER TABLE `phpwcms_article` ADD INDEX ( `article_priorize` );
ALTER TABLE `phpwcms_article` ADD INDEX ( `article_sort` );
UPDATE `phpwcms_articlecontent` SET acontent_html='', acontent_tstamp=acontent_tstamp WHERE acontent_type=7;
ALTER TABLE `phpwcms_article` ADD `article_norss` INT( 1 ) NOT NULL DEFAULT '1';
ALTER TABLE `phpwcms_article` ADD `article_alias` VARCHAR(255) NOT NULL AFTER `article_title`;
ALTER TABLE `phpwcms_article` CHANGE `article_username` `article_username` VARCHAR(255) NOT NULL;
ALTER TABLE `phpwcms_article` ADD INDEX `article_alias` (`article_alias`);
It seems to have taken care of my issue. I am pretty certain I ran all the SQL updates when I did the upgrade, but the second time around, it is fixed!
Thanks again, guys!
Greg
Re: "Error while browsing related articles"
Posted: Mon 2. Feb 2009, 17:50
by jasminbx
...so how do I "run the SQL update number #19"???
Re: "Error while browsing related articles"
Posted: Mon 2. Feb 2009, 17:58
by jasminbx
...here the screenshot
The footer and the left side is also missing?! Any suggestions?
Re: "Error while browsing related articles"
Posted: Mon 2. Feb 2009, 18:04
by jasminbx
OK!!! ...Sorry, I am so stupid (and blonde...)
I copied the ## with the code. Sorry.
...it shows the articels now. But If I open it in the browser it says "error while reading article datas" ?