"Error while browsing related articles"

[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

[update]

Did you try to delete your browser's cache? You should try this first of all

[ourpobox]

Hi Claus,

Yes, I definitely deleted the cache and even tried a couple of different browsers.... Any other suggestions anybody?

Thanks!

Greg

[Jensensen]

[x]

[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.

[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

[jasminbx]

...so how do I "run the SQL update number #19"???

[jasminbx]

...here the screenshot
The footer and the left side is also missing?! Any suggestions?

[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" ?