WordPress.org

1. gospelmusicpodcast
   Member
   Posted 7 years ago #

   I have no idea what's wrong with my site ->

   http://www.gospelmusicpodcast.com

   The only thing I've done recently was post a new article. There are gobs of errors on the page, so it'd be best to check out the site, but the first one is:

   WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ',,)' at line 4]
   SELECT DISTINCT ID, category_id, cat_name, category_nicename, category_description, category_parent FROM wp_categories, wp_post2cat, wp_posts WHERE category_id = cat_ID AND post_id = ID AND post_id IN (,,,)

   Any ideas?

2. gospelmusicpodcast
   Member
   Posted 7 years ago #

   I haven't done any strange edits in the .php files that keep showing up currently as errors, and I haven't changed any of the settings in the wp-config file lately either. Everything was working a few hours ago, and then all of a sudden... madness!

3. vkaryl
   Member
   Posted 7 years ago #

   Did you check with your host to see if they did something funky with the php version on the server?

4. gospelmusicpodcast
   Member
   Posted 7 years ago #

   The server was down for a while earlier today and I couldn't access any of my databases on any sites, but I don't know for certain what they did to remedy the situation. They probably screwed something else up to fix that problem...

5. vkaryl
   Member
   Posted 7 years ago #

   You might like to start with your host, explain your difficulty, and see what they tell you. Without changes on your end, it's most likely they did something on their end. Upgrading to new versions of things like php, perl, even apache can produce "undesirable results" on the user's end....

6. gospelmusicpodcast
   Member
   Posted 7 years ago #

   Thanks for the tip vkaryl. I'll see what I can find out and hopefully get this problem fixed.

7. gospelmusicpodcast
   Member
   Posted 7 years ago #

   are there particular versions of PHP / MySQL / Apache etc. that don't work with WP 1.5?

8. vkaryl
   Member
   Posted 7 years ago #

   I don't know the answer to that. I can give you what my host has installed, and tell you that (except for the plugin problem I'm having on my localhost install), WP works fine as well on Apache 1.4.9 and on php 5.0.2.2:

   Apache version 1.3.33 (Unix)
   PERL version 5.8.0
   PHP version 4.3.10
   MySQL version 4.0.22-standard

9. dawg
   Member
   Posted 7 years ago #

   Vkaryl did you get a chance to implement that updated zip? When I checked it was still the same.

10. vkaryl
    Member
    Posted 7 years ago #

    Working on it now dawg - just got sidetracked by my plugin problem *sigh*.

11. gospelmusicpodcast
    Member
    Posted 7 years ago #

    i tried reinstalling WP 1.5 on one of my other sites that crapped out same as the other, and no dice. Still 50 billion error messages.

12. gospelmusicpodcast
    Member
    Posted 7 years ago #

    It will still let me log into my admin account in WP, but I've got all sorts of errors:

    WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4]
    SELECT DISTINCT ID, category_id, cat_name, category_nicename, category_description, category_parent FROM wp_categories, wp_post2cat, wp_posts WHERE category_id = cat_ID AND post_id = ID AND post_id IN ()

    Warning: call_user_func_array(): First argumented is expected to be a valid callback, 'Array' was given in /home/blesseda/public_html/wp-includes/functions.php on line 893

    And those show up a whole bunch of times. I still have no clue.

13. vkaryl
    Member
    Posted 7 years ago #

    It may take a while to hear from your host....

14. gospelmusicpodcast
    Member
    Posted 7 years ago #

    i put up a temporary index page at http://www.gospelmusicpodcast.com for now, just so visitors don't have to see all those error messages. Anyone who wants to see the errors, I renamed the page:

    http://www.gospelmusicpodcast.com/index7.php

15. gospelmusicpodcast
    Member
    Posted 7 years ago #

    fyi: still no news on the situation from my host

16. gospelmusicpodcast
    Member
    Posted 7 years ago #

    i decided just to switch my stuff over to pmachine 2.3 pro for now (for the weblog stuff) and just do my rss2 feed manually. I'm pretty sure it was the host updating/changing some stuff to fix some other problem. I just hope I can eventually get back to using WP 1.5 for my stuff, cuz it's so much easier...

17. gospelmusicpodcast
    Member
    Posted 7 years ago #

    still no new info on this one, but I did find out something interesting. Whatever happened has created some sort of problem with the way PHP is handling arrays. I'm no code expert, but I wondered if anyone could thing of why this would be happening.

18. chaz7979
    Member
    Posted 6 years ago #

    I just had my site produce a lot of the same errors. The key seems to be SELECT DISTINCT and I have no idea why. I havent even logged in or posted in weeks and my site is down.

    Anyone learn anything new about this?

Topic Closed

This topic has been closed to new replies.