wpuseronline
-
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 (“.
”timestampint(15) NOT NULL default ‘0’,”.
”usernamevarchar(50) NOT NULL default ”,”.
”ipvarchar(40) NOT NULL default ”,”.
”locationvarchar(255) NOT NULL default ”,”.
”urlvarchar(255) NOT NULL default ”,”.
” PRIMARY KEY (timestamp),”.
” KEYusername(username),”.
” KEYip(ip),”.
” KEYfile(location))”;Since running query’s is not yet a praticed skill i’m getting the following error:
SQL-query:
“CREATE TABLE useronline (“. ”
timestampint(15) NOT NULL default ‘0’,”. ”usernamevarchar(50) NOT NULL default ”,”. ”ipvarchar(40) NOT NULL default ”,”. ”locationvarchar(255) NOT NULL default ”,”. ”urlvarchar(255) NOT NULL default ”,”. ” PRIMARY KEY (timestamp),”. ” KEYusername(username),”. ” KEYip(ip),”. ” KEYfile(location))”
MySQL retourneerde:#1064 – You have an error in your SQL syntax near ‘”CREATE TABLE useronline (“.
”timestampint(15) NOT NULL default ‘0’,”.
‘ at line 1Can someone please explain what this means?? and how i can succesfully run the query?
THanks in advance people!
http://www.pimiento.nl
The topic ‘wpuseronline’ is closed to new replies.