kumarei

This sounds like the same problem as https://www.ads-software.com/support/topic/319092. I think it’s related to MySQL version.

Can you check your database to see if the wp_now_reading table has been created?

The problem seems to be the ‘default’ on the datetime lines. I solved this by entering the SQL manually without the ‘default’ on those three lines. I have not tested it, but I suspect that you could also change 118-120 of now-reading.php to:

b_added datetime,
	b_started datetime,
	b_finished datetime,

and then re-activate the plugin. I don’t know whether this is a desirable solution; I don’t know that much about MySQL types, so I’m not sure if this alters the behavior. It does, however, allow the plugin to work.

I’ve spent some time tracking this one down, since there was no real info about it. In my case, this is being caused by an error during database creation. For some reason, the wp_now_reading CREATE script is giving the error:

[01-Jan-2010 19:40:21] 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 '
	b_started datetime default,
	b_finished datetime default,
	b_title VARCHAR(100' at line 3 for query
	CREATE TABLE wp_now_reading (
	b_id bigint(20) NOT NULL auto_increment,
	b_added datetime default,
	b_started datetime default,
	b_finished datetime default,
	b_title VARCHAR(100) NOT NULL,
	b_nice_title VARCHAR(100) NOT NULL,
	b_author VARCHAR(100) NOT NULL,
	b_nice_author VARCHAR(100) NOT NULL,
	b_image text ,
	b_asin varchar(12) NOT NULL default '',
	b_status VARCHAR(8) NOT NULL default 'read',
	b_rating tinyint(4) default '0',
	b_review text,
	b_post bigint(20) default '0',
	b_reader tinyint(4) NOT NULL default '1',
	PRIMARY KEY  (b_id),
	INDEX permalink (b_nice_author, b_nice_title),
	INDEX title (b_title),
	INDEX author (b_author)
	) made by activate_plugin, do_action, call_user_func_array, nr_install, dbDelta

Not sure exactly what the problem is, since I’m not really familiar with MySQL syntax.

EDIT: For reference, my MySQL version is 5.0