WordPress.org

Forums

Only first page of blog showing, no archive/categories/previous pages working (9 posts)

  1. giovanealex
    Member
    Posted 8 years ago #

    Hi there

    I've moved my wordpress blog from one hosting to another today, and I've experienced some serious problems for the first time to restore MySQL database backup on the new server. I'd to call for help with the hosting support - a guy there restored the DB for me. Weel, everyone seemed to work pretty good, until a visitor of my blog pointed out to me that the internal links for categories, archives and previous are not working at all - when you click them, the page is not found at all - only the first page is showing up. I tried to update the permalinks options, it's all absolutely the same there, as it was on the previous hosting DB that I made a backup. What is the problem?? Please, can someone help me? I am copying here the message the support guy sent me after he solved the problem to restore the database, if this will help:

    "DB imported, the error when you're executing the process of importing it was because of the following code:

    // Wrong //
    CREATE TABLE wp_categories (
    cat_ID bigint( 20 ) NOT NULL AUTO_INCREMENT ,
    cat_name varchar( 55 ) CHARACTER SET latin1 NOT NULL default '',
    category_nicename varchar( 200 ) CHARACTER SET latin1 NOT NULL default '',
    category_description longtext CHARACTER SET latin1 NOT NULL ,
    category_parent bigint( 20 ) NOT NULL default '0',
    category_count bigint( 20 ) NOT NULL default '0',
    PRIMARY KEY ( cat_ID ) ,
    KEY category_nicename ( category_nicename )
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci AUTO_INCREMENT =10;

    // Correct //
    CREATE TABLE wp_categories (
    cat_ID bigint( 20 ) NOT NULL AUTO_INCREMENT ,
    cat_name varchar( 55 ) CHARACTER SET latin1 NOT NULL default '',
    category_nicename varchar( 200 ) CHARACTER SET latin1 NOT NULL default '',
    category_description longtext CHARACTER SET latin1 NOT NULL ,
    category_parent bigint( 20 ) NOT NULL default '0',
    category_count bigint( 20 ) NOT NULL default '0',
    PRIMARY KEY ( cat_ID ) ,
    KEY category_nicename ( category_nicename )
    ) ENGINE = MYISAM;

    Obs: only the "Engine" line must be changed.

    I hope it can help to find some solution to the links' problem.
    thanks in advance!
    giovanealex.

  2. Chris_K
    Member
    Posted 8 years ago #

    Have you tried rebuilding your permalinks?

    Go to Options -> Permalinks. Set to default and see if stuff works as expected. Assuming it does, change it back to whatever you were at before and try again.

  3. giovanealex
    Member
    Posted 8 years ago #

    I've set to default and it works as it should but when I try to put my own definitions and I try to access any of the links it shows this error:

    "Not Found
    The requested URL /archives/categories/videos/ was not found on this server.

    Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
    Apache/1.3.34 Server at http://www.seteventos.org Port 80"

    Will I be able to set my own permalinks ever again?

  4. Chris_K
    Member
    Posted 8 years ago #

    Confirm with your host that they not only have mod_rewrite but also have enabled AllowOverrides.

    While you wait for a reply, check out some of the other Troubleshooting ideas on the Permalinks documentation page.

  5. Chris_K
    Member
    Posted 8 years ago #

    ... and make sure that WP generated an .htaccess file when you changed from the default permalinks.

  6. wbhamilton
    Member
    Posted 8 years ago #

    What should be in the .htaccess file? I'm having the exact same problem. None of my links (Pages, Archives, Links, etc) are working.

  7. wbhamilton
    Member
    Posted 8 years ago #

    I've rebuilt my permalinks and the links all seem to work now. But now when I access the same links it prompts me for a id and password. My site is password protected through .htaccess. It's wanting this id and pw.

    I'm stumped. And I didn't intend to hijack the thread so if you feel I should start a new one I will.

    Thanks.
    Brad

  8. Chris_K
    Member
    Posted 8 years ago #

    Start a new thread and be clear on why being prompted for a username/password is surprising when you used htaccess to password protect your site.

  9. wbhamilton
    Member
    Posted 8 years ago #

    Thanks. Will do.

Topic Closed

This topic has been closed to new replies.

About this Topic