I love the theme but get error,
pls advise my friend here:
[code=html]Warning: Missing argument 2 for wpdb::prepare(), called in /public_html/wp-content/themes/jobboard/plugin/includes/stats.php on line 24 and defined in /public_html/wp-includes/wp-db.php on line 1152
For reference, the script here:
stats.php on line 24,
[code=html]return $wpdb->get_var($wpdb->prepare($query));
and wp-db.php on line 1152,
[code=html]public function prepare( $query, $args ) {
if ( is_null( $query ) )
return;
Warning: Missing argument 2 for wpdb::prepare(), called in /public_html/wp-content/themes/jobboard/plugin/includes/ext/jb_stats.php on line 82 and defined in /public_html/wp-includes/wp-db.php on line 1152
jb_stats.php on line 82:
[code=html]$ret = $wpdb->get_var($wpdb->prepare(“SELECT id FROM “.$wpdb->prefix.”jobboard_stats WHERE postid = $this->post_id AND ip = INET_ATON(‘$this->clientip’) AND date >= ‘$date'”));
Warning: Missing argument 2 for wpdb::prepare(), called in /public_html/wp-content/themes/jobboard/plugin/includes/ext/jb_stats.php on line 149 and defined in /public_html/wp-includes/wp-db.php on line 1152
jb_stats.php on line 149:
[code=html]return $wpdb->get_var($wpdb->prepare(“SELECT id FROM “.$wpdb->prefix.”jobboard_stats WHERE ip = INET_ATON(‘$ip’) AND date >= ‘$date’;”));
Warning: mysql_query(): Access denied for user ‘root’@’localhost’ (using password: NO) in /public_html/wp-content/themes/jobboard/plugin/includes/ext/jb_stats.php on line 126
Warning: mysql_query(): A link to the server could not be established in /public_html/wp-content/themes/jobboard/plugin/includes/ext/jb_stats.php on line 126
jb_stats.php on line 126:
[code=html]$result = mysql_query(‘INSERT INTO ‘.$wpdb->prefix.’jobboard_stats (`postid`, `ip`, `date`) VALUES(“‘.$postid.'”, “‘.ip2long($this->clientip).'”, “‘. current_time(‘mysql’).'”)’);