Installation probelms

  • Hi guys
    I downloaded the CVS last night (thanks to Cena’s help) and tried installing it this morning – a clean install on my test server – not an upgrade – but when I visit the pages I get a number of MySQL error being thrown up.
    [La table ‘wordpress_cvs.wp_post2cat’ n’existe pas]
    SELECT category_id FROM wp_categories, wp_post2cat WHERE wp_post2cat.category_id = cat_ID AND wp_post2cat.post_id = 1
    [Champ ‘comment_approved’ inconnu dans where clause]
    SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = 1 AND comment_approved = ‘1’
    ‘wordpress_cvs.wp_post2cat’ n’existe pas]
    SELECT cat_ID, cat_name, COUNT(wp_post2cat.post_id) AS cat_count, DAYOFMONTH(MAX(post_date)) AS lastday, MONTH(MAX(post_date)) AS lastmonth FROM wp_categories LEFT JOIN wp_post2cat ON (cat_ID = category_id) LEFT JOIN wp_posts ON (ID = post_id) WHERE cat_ID > 0 GROUP BY category_id HAVING cat_count > 0 ORDER BY cat_name asc, post_date DESC
    Forgive the french (i’m using EasyPHP)
    Also, If I upgrade my site and want to use the new mod_rewrite permalinks what will happen to my old links – will they be updated to?
    Furthermore if I allow comments on my posts will all comments need to be moderated? or is there a way to turn this off?
    Anyway – good work guys keep it up!
    McChris

Viewing 5 replies - 1 through 5 (of 5 total)

  • A) Try running wp-admin/upgrade-072-080
    B) Dunno…you might run it just to see.
    C) I think it’s either all or nothing when it comes to comments moderation. (Not sure what you’re asking…I’m assuming it’s ‘can I moderate some comments and not others’?)

    Thread Starter arthuc01

    (@arthuc01)

    Cena, Thanks love using the upgrade script worked a treat…obviously the install script hasn’t been updated yet.
    As for the COmments thing, I notice in the admin section it says “Comments waiting to be moderated” wheres for posts there is still only the two options allow/disallow comments which would suggest to me that all comments have to be moderated/approved first? Can anyone help?

    The ‘comments waiting to be moderated’ section is only used if you have comment moderation turned on in options->general blog settings->comment_moderation . In an individual post, you can set commenting on or off (which has nothing to do with moderation). It’s just telling the user whether they can comment or not.

    Thread Starter arthuc01

    (@arthuc01)

    Right, One problem down now some more…
    Have taken the step of using the CVS version on some real data (43post blog from 0.72) …once again on my testing server… this time when I call index.php I get
    SQL/DB Error:
    [Manque de mémoire. Redémarrez le démon et ré-essayez (65500 octets nécessaires)]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date <= ‘2003-12-27 22:47:50’ AND (post_status = “publish”) ORDER BY post_date DESC LIMIT 5
    And in my Apache Error Log I get
    [Sat Dec 27 22:47:50 2003] [error] PHP Notice: Undefined property: querycount in e:\www\wordpress_cvs\wp-includes\wp-db.php on line 155
    And I get the same error on the edit posts page
    Line 153 – 155 of wp-db.php read…
    153 // Perform the query via std mysql_query function..
    154 $this->result = mysql_query($query, $this->dbh);
    155 ++$this->querycount;

    Thread Starter arthuc01

    (@arthuc01)

    Thanks again Cena for the explanation

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Installation probelms’ is closed to new replies.