• Hi all, installed everything concerning the wp useronline plugin and still left is creating the useronline table.
    So , in the read me file it says i should run the sql as mentioned below:

    // Create Useronline Table
    $sql[] = “CREATE TABLE $wpdb->useronline (“.
    timestamp int(15) NOT NULL default ‘0’,”.
    username varchar(50) NOT NULL default ”,”.
    ip varchar(40) NOT NULL default ”,”.
    location varchar(255) NOT NULL default ”,”.
    url varchar(255) NOT NULL default ”,”.
    ” PRIMARY KEY (timestamp),”.
    ” KEY username (username),”.
    ” KEY ip (ip),”.
    ” KEY file (location))”;

    Since running query’s is not yet a praticed skill i’m getting the following error:

    SQL-query:

    “CREATE TABLE useronline (“. ” timestamp int(15) NOT NULL default ‘0’,”. ” username varchar(50) NOT NULL default ”,”. ” ip varchar(40) NOT NULL default ”,”. ” location varchar(255) NOT NULL default ”,”. ” url varchar(255) NOT NULL default ”,”. ” PRIMARY KEY (timestamp),”. ” KEY username (username),”. ” KEY ip (ip),”. ” KEY file (location))”
    MySQL retourneerde:

    #1064 – You have an error in your SQL syntax near ‘”CREATE TABLE useronline (“.
    timestamp int(15) NOT NULL default ‘0’,”.
    ‘ at line 1

    Can someone please explain what this means?? and how i can succesfully run the query?

    THanks in advance people!
    http://www.pimiento.nl

Viewing 4 replies - 1 through 4 (of 4 total)
  • looks like you are trying to post PHP-code when i see those DOTs between the SQl-statements. hope you are trying this on a backup-database?!

    Thread Starter linusdepinus

    (@linusdepinus)

    I am sorry fht i don’t know what the things you are saying mean? Can anyone explain this in simple language?

    If you’re just running this query, the variable wpdb is not being resolved. In the original useronline-install.php file, you also had the declaration
    require_once('../wp-config.php');
    which supplied the database name. Why are you trying to run this query alone instead of running the useronline-install.php file?

    Hi I have updated it to be compatible with WP 2.0 and it has much better installer.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘wpuseronline’ is closed to new replies.