Help, get error (php5.5)

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
adjaya
Forum Newbie
Posts: 2
Joined: Tue Mar 24, 2015 7:52 pm

Help, get error (php5.5)

Post by adjaya »

I love the theme but get error,
pls advise my friend here:

Code: Select all

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: Select all

return $wpdb->get_var($wpdb->prepare($query));
and wp-db.php on line 1152,

Code: Select all

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: Select all

$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: Select all

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: Select all

$result = mysql_query('INSERT INTO '.$wpdb->prefix.'jobboard_stats (`postid`, `ip`, `date`) VALUES("'.$postid.'", "'.ip2long($this->clientip).'", "'. current_time('mysql').'")');
Last edited by requinix on Tue Mar 24, 2015 10:14 pm, edited 1 time in total.
Reason: [html] and [php] are broken, please use [syntax=html|php] instead
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: Help, get error (php5.5)

Post by requinix »

->prepare() is for prepared statements only, and it involves setting up a query with placeholders; you pass both the query template and the query values to the method.
If you want to execute a plain query then use ->query() instead.

For the last error, don't use the mysql_* functions directly. Use what WordPress provides.
adjaya
Forum Newbie
Posts: 2
Joined: Tue Mar 24, 2015 7:52 pm

Re: Help, get error (php5.5)

Post by adjaya »

Thank you for your advise.
Post Reply