WordPress.org

Forums

Linux + WP database error (16 posts)

  1. davidsopas
    Member
    Posted 10 years ago #

    Hi, i was trying to install wordpress but i got lot's of database errors, eg:

    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 '/blog_categories ( cat_ID bigint(20) NOT NULL auto_increment,]
    CREATE TABLE wp/blog_categories ( cat_ID bigint(20) NOT NULL auto_increment, cat_name varchar(55) NOT NULL default '', category_nicename varchar(200) NOT NULL default '', category_description longtext NOT NULL, category_parent int(4) NOT NULL default '0', PRIMARY KEY (cat_ID), KEY category_nicename (category_nicename) )

    I have all the requirements for this system, so I need some help if you guys dont mind.

    Thanks in advance

  2. Mark (podz)
    Support Maven
    Posted 10 years ago #

    Try deleting the files and reuploading, being sure to upload as ASCII files, not binary.
    Do delete first though - overwriting is totally guaranteed to screw things up.

  3. davidsopas
    Member
    Posted 10 years ago #

    after reuploading all in ascii mode, it has the same errors on the database. any other solution please? why it can't create the tables?

  4. Mark (podz)
    Support Maven
    Posted 10 years ago #

    In your wp-config.php, what is your table_prefix ?

  5. davidsopas
    Member
    Posted 10 years ago #

    wp_

    is it right?

  6. Mark (podz)
    Support Maven
    Posted 10 years ago #

    This line puzzles me
    "CREATE TABLE wp/blog_categories"

    wp_ is indeed fine, but in that bit above, the / might be breaking things.

  7. davidsopas
    Member
    Posted 10 years ago #

    Yeh, all the database errors are seems to be breaking in that part of the sql statement... what do u think i can do to solve the problem?

  8. Mark (podz)
    Support Maven
    Posted 10 years ago #

    Which host are you with ?
    Using phpmyadmin, can you see if there are any created tables and if so what names they have ?

  9. davidsopas
    Member
    Posted 10 years ago #

    im using localhost, and show tables from database dont show me any created tables, its empty...

  10. Mark (podz)
    Support Maven
    Posted 10 years ago #

    Hmm.......

    "CREATE TABLE wp/blog_categories"

    WP creates a table called "categories" and to distinguish that from any other tables, it asks for a table_prefix. So anything before the "categories" is user-supplied - and in this case it looks like the table_prefix is "wp/blog_"

    You are certain that this is not the case ?

  11. davidsopas
    Member
    Posted 10 years ago #

    if i put the table_prefix to "wp/blog_"

    its errors with this...
    CREATE TABLE wp/blog_/blog_categories

  12. Mark (podz)
    Support Maven
    Posted 10 years ago #

    It gets odder :)

    Hmm ... you are installing onto 'localhost'
    This is your machine ?
    If so, what is the OS / php / mysql setup ? Xampp ?

  13. davidsopas
    Member
    Posted 10 years ago #

    Yes it's my server.

    Linux Mandrake 10.1
    php version PHP Version 4.3.8
    mysql version 4.0.20
    Apache 2.0

    databasename for the script is "blog"

  14. Mark (podz)
    Support Maven
    Posted 10 years ago #

    I'm a hardcore WinXP guy myself :)

    It looks like the database name is being dragged into the equation somewhere, and as i have no knowledge of Linux, I'm at a loss.
    (I'll edit the thread title to hopefully attract an answer)

  15. davidsopas
    Member
    Posted 10 years ago #

    thank u very much podz ;-)

    any help is welcome!!

  16. davidsopas
    Member
    Posted 10 years ago #

    if no one can help me, someone can give me the sql stucture so i can create the database manually...

    thanks in advance

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.