All articles not showing when browsing by category or tag

[clarityproductions]

Click on the second category Naot at Leathersandals.com. Notice there should be over 30
it shows only 4 four articles. I have checked the other articles are active and should
be showing up but they are not. Can you advise what the problem is and how to fix it?

http://www.leatherbelts.com/faq/index.php?action=show

[Thorsten]

Hi,

can you please give me temporary access to your FAQ?

bye
Thorsten

[clarityproductions]

sure i just sent you a pm with the username and password. Please let me know what you find out.
Because I am clueless

[Thorsten]

Hi,

I made a copy of your data and will debug that on my system. Stay tuned!

bye
Thorsten

[Thorsten]

Hi,

please run these queries in phpMyAdmin:

Code: Select all

UPDATE faqdata SET date_start =10101000000;
UPDATE faqdata_revisions SET date_start =10101000000

You set a wrong start date for the FAQ records.

bye
Thorsten

[clarityproductions]

Thank you that did fix the problem. I did not set the dates on any of those articles though. Is it possible thre is something wrong during the ADD/INSERT of a new article?

[clarityproductions]

I just confirmed when I add a new article the date is set add 00 once it inserts. Does this happen on your end also?

Here is the code in my FAQ.php

Code: Select all

    function addRecord($data, $new_record = true)
    {
        if (!is_array($data)) {
            return false;
        }

        if ($new_record) {
            $record_id = $this->db->nextID(SQLPREFIX.'faqdata', 'id');
        } else {
            $record_id = $data['id'];
        }

        // Add new entry
        $query = sprintf(
            "INSERT INTO
                %sfaqdata
            VALUES
                (%d, '%s', %d, %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, '%s', '%s')",
            SQLPREFIX,
            $record_id,
            $data['lang'],
            $this->getSolutionId(),
            0,
            $data['active'],
            $data['keywords'],
            $data['thema'],
            $data['content'],
            $data['author'],
            $data['email'],
            $data['comment'],
            $data['date'],
            $data['linkState'],
            $data['linkDateCheck'],
            $data['dateStart'],
            $data['dateEnd'],
			$data['short_title']);

        $this->db->query($query);
        return $record_id;
    }

    /**
     * Updates a record
     *
     * @param    array    $data
     * @return   boolean
     * @access   public
     * @since    2006-06-18
     * @author   Thorsten Rinne <thorsten@phpmyfaq.de>
     */

Code: Select all

    function addNewRevision($record_id, $record_lang)
    {
        $query = sprintf("
            INSERT INTO
                %sfaqdata_revisions
            SELECT * FROM
                %sfaqdata
            WHERE
                id = %d
            AND
                lang = '%s'",
            SQLPREFIX,
            SQLPREFIX,
            $record_id,
            $record_lang);
        $this->db->query($query);

        return true;
    }


    /**
     * Returns the keywords of a FAQ record from the ID and language
     *
     * @param   integer     record id
     * @return  string
     * @since   2005-11-30
     * @author  Thorsten Rinne <thorsten@phpmyfaq.de>
     */

[Thorsten]

Hi,

no, that happened never before.

We changed that in version 2.5, so it shouldn't appear in the future.

bye
Thorsten

[clarityproductions]

Is there a way I can fix it in version 2.0.15?

[Thorsten]

Hi,

which browser do you use? It doesn't happen for other users...

bye
Thorsten

[clarityproductions]

IE8.