Re: [campsite-support] ArticleOrder on "articles" table
  • As I said in a previous email I need the database to debug all three issues:
    user creation, article ordering and article lock. If you don't want to send
    the content duplicate the database and run the following query in the
    duplicated db:

    UDPATE X[article_type] SET F[body_field1] = '', F[body_field2] = '';
    UPDATE liveuser_users SET Password = '*';

    This way your article content will be erased. Then dump the database and
    send it to me together with the templates so I can debug.

    Mugur

    On Mon, Mar 8, 2010 at 7:45 PM, wrote:

    > Author: Terix
    > Link: http://code.campware.org/phorum/read.php?8,8221,8221#msg-8221
    >
    > --------------------------------------------------------------------------------
    >
    > I was examining my campsite database about a problem that i have. the
    > problem is that two of my sections add new articles at the end of the
    > article list instead of adding it as the first.
    > Examining the "articles" table,i found that the column "ArticleOrder" has a
    > weird numbering.... some of the articles have the right numbering, but at
    > certain point, the articles have the same value as the article number and as
    > the article order. In other word, if i show the articles ordered by number,
    > watching the articleorder i have something like
    > 30,29,28,27...2,1,0,308,315,332,340... and so on.
    > What could be the cause of this change of behaviour on articleorder
    > numbering?
    >
    > --
    > Sent from Campware Forums
    > http://code.campware.org/phorum
    >