[solved]Error 500 sorting Articles by article order pls help

gcprnet
Topic Author
Offline
Elite Member

13 years 2 months ago - 13 years 1 week ago #18831 by gcprnet

[solved]Error 500 sorting Articles by article order pls help was created by gcprnet

I have about 1400 articles in several nested categories like the following
cat1
|-cat1.1
|-cat1.2
|--cat1.2.1
|--cat1.2.2
|-cat1.3
article order was set to "newest first".
The categories that have subcategories are set to "display items from subcategories".
Now I wanted to switch the article order from "newest first" to "order", which I did for all categories.
I can work with the sort order of articles in any category and subcategory as expected: Change the order, use the arrow-icons to change the order and save it by klicking the little save-icon in the top of the column.
BUT working with the article-order in the very top category (cat1) I can't do any of the tasks described above. Clicking on the small save-icon in the top of the column results in an error message: "500 - An error occured!"
I really need to set the article order in all of my categories so any help is highly appreciated.

Last edit: 13 years 1 week ago by gcprnet.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

13 years 2 months ago #18836 by ggppdk

Replied by ggppdk on topic [solved]Error 500 sorting Articles by article order pls help

mmm, will try to reproduce this.

Regards

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

13 years 2 months ago #18838 by ggppdk

Replied by ggppdk on topic [solved]Error 500 sorting Articles by article order pls help

Please do this to help track down the error:

Go to file:
administrator\components\com_flexicontent\models\items.php

Find this (3 times)

Code:

$err = $this->_db->getErrorMsg();
JError::raiseError( 500, $err );

and replace with

Code:

$err = $this->_db->getErrorMsg();
echo "<br>POSITION-1<br>".$query."<br>";
echo $err;
exit();
JError::raiseError( 500, $err );

Please above put: POSITION-1, POSITION-2, POSITION-3

Post back the output here, and then undo the changes.

Regards

Please Log in or Create an account to join the conversation.

gcprnet
Topic Author
Offline
Elite Member

13 years 2 months ago #18845 by gcprnet

Replied by gcprnet on topic [solved]Error 500 sorting Articles by article order pls help

hmm... I'm afraid this didn't work:
I replaced the code as you described it but as soon as I hit the save icon in the order-column it gives me a blank page with the plain 500 - an error occured message:

...

this is, how items.php looks at the moment (line 993 ff):

Code:

if (!$this->_db->query())
                                {
                                        //$err = $this->_db->getErrorMsg();
                                        //JError::raiseError( 500, $err );
$err = $this->_db->getErrorMsg();
echo "<br>POSITION-1<br>".$query."<br>";
echo $err;
exit();
JError::raiseError( 500, $err );
                                }

                                $query = 'UPDATE #__flexicontent_cats_item_relations'
                                . ' SET ordering = '.(int) $origin->ordering
                                . ' WHERE itemid = '. (int) $row->itemid
                                . ' AND catid = ' . $filter_cats
                                ;
                                $this->_db->setQuery( $query );

                                if (!$this->_db->query())
                                {
                                        //$err = $this->_db->getErrorMsg();
                                        //JError::raiseError( 500, $err );
$err = $this->_db->getErrorMsg();
echo "<br>POSITION-2<br>".$query."<br>";
echo $err;
exit();
JError::raiseError( 500, $err );
                                }

                                $origin->ordering = $row->ordering;
                        }
                        else
                        {
                                $query = 'UPDATE #__flexicontent_cats_item_relations'
                                . ' SET ordering = '.(int) $origin->ordering
                                . ' WHERE itemid = '. (int) $origin->itemid
                                . ' AND catid = ' . $filter_cats
                                ;
                                $this->_db->setQuery( $query );

                                if (!$this->_db->query())
                                {
                                        //$err = $this->_db->getErrorMsg();
                                        //JError::raiseError( 500, $err );
$err = $this->_db->getErrorMsg();
echo "<br>POSITION-3<br>".$query."<br>";
echo $err;
exit();
JError::raiseError( 500, $err );
                                }
                        }

                return true;

Regards

Please Log in or Create an account to join the conversation.