The MU forums have moved to WordPress.org

Database error! (5 posts)

  1. Robinray
    Inactive
    Posted 20 years ago #

    Hi,
    There's some problem with my installation....
    my wpmu is the 2005-08-06 version

    when my first time install:
    I got the message:

    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 1]
    INSERT INTO wp_site ( id, domain, path ) VALUES ( NULL, 'wpmu', '\' )

    WordPress database error: [Duplicate entry '1' for key 1]
    INSERT INTO wp_sitecategories VALUES (1, 'Uncategorized', 'uncategorized', '')

    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 1]
    SELECT blog_id FROM wp_blogs WHERE domain = 'wpmu' AND path = '\'

    does wpmu support win2000??

  2. Robinray
    Inactive
    Posted 20 years ago #

    Then I modify index.php and successfully install it~~~
    but when wpmu runs

    there's another message:
    WordPress database error: [Table storage engine for 'wp_1_referer_visitlog' doesn't have this option]
    insert delayed into wp_1_referer_visitLog (referingURL,visitURL,refpost, visitTimes, dayofmonth) values ('http://wpmu/2005/08/06/hello-world/','/','','1', '06')

    I didn't know how to slove this problem~~
    sorry,My English is not good~~

  3. donncha
    Key Master
    Posted 20 years ago #

    I'd have to reboot to go into Windows so, no, I don't support Windows, but it's strange that it uses \ instead of / .. may be something I can do about that.
    Are you using innodb? The referer table has to be myisam format because that's a limitation of MySQL. Do a Google search and you'll find more info on that.

  4. Robinray
    Inactive
    Posted 20 years ago #

    Thanks!The 2nd problem is sloved!!

    About the 1st one:
    I modify index.php
    line 382
    I change
    $base = dirname( $_SERVER["SCRIPT_NAME"] );
    into
    $base = str_replace('\\','/',dirname( $_SERVER["SCRIPT_NAME"] ));

    I use str_replace() to all the dirname()

    on my server the
    Operational Settings (These settings cannot be modified by blog owners)
    looks like:
    Banned Names:
    <b>Warning</b>: implode(): Bad arguments. in <b>C:\\\\root\\\\wpmu\\\\wp-inst\\\\wp-admin\\\\wpmu-options.php</b> on line <b>52</b>
    Limited Email Registrations:
    <b>Warning</b>: implode(): Bad arguments. in <b>C:\\\\root\\\\wpmu\\\\wp-inst\\\\wp-admin\\\\wpmu-options.php</b> on line <b>58</b>

    Is this a bug?
    sorry,I'm a new user of wordpress.

    BTW: I have another question:
    Where is the plugins manager in wpmu??

  5. donncha
    Key Master
    Posted 20 years ago #

    Thanks Robin - I'll add something similar to my code. Looks like filesystem code needs to be tested a bit more on Windows!
    Plugins page is disabled right now.

About this Topic

  • Started 20 years ago by Robinray
  • Latest reply from donncha