Database error with cjtoolbox plugin

I looked at my scripts without any changes made but got this message in APACHE error.log. This might point to the problem I have?

[Sun May 29 13:32:46.340604 2016] [:error] [pid 8013] [client ….] WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’
for query INSERT INTO wp_posts (post_author, post_date, post_date_gmt, post_content, post_content_filtered, post_title, `post_exce
rpt,post_status,post_type,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modi
fied_gmt,post_parent,menu_order,post_mime_type,guid`) VALUES (7, ‘2016-05-29 14:32:46’, ‘0000-00-00 00:00:00’, ”, ”, ‘Auto Draft’,
”, ‘auto-draft’, ‘post’, ‘closed’, ‘closed’, ”, ”, ”, ”, ‘2016-05-29 14:32:46’, ‘0000-00-00 00:00:00’, 0, 0, ”, ”) made by wp_dashboard, d
o_meta_boxes, call_user_func, wp_dashboard_quick_press, get_default_post_to_edit, wp_insert_post, referer: https://www.MYWEBSITE.com/wp-admin/admin.php?page=cjtoolbox

Hi petejs,

Thanks for reporting these errors to us.
We are absolutely flat out at the moment with development of the new-look CJT.
We will look further into this when we get a chance.

Regards,
Damian Baker

Thanks Damian.

One quick question, can I delete all records in wp_cjtoolbox* tables and reenter my scripts without messing things up?
I think/hope that would solve the problem, maybe I broke something while developing.

brgds
-peter

Hi Peter,

You have a few options.
You can start afresh by going into ‘General plugin settings’ (i.e. cog icon) and clicking the Wipe out data! checkbox, then deactivate and uninstall the CJT plugin. This will erase all code block data in the CJT tables. Then you will get a clean slate once you reinstall and activate the plugin.

Else you could:
Go into phpMyAdmin in your cPanel and in your database, look for a table that says something like this: your-prefix_cjtoolbox_blocks

You should see your code block data in the entries, where you should be able to edit or copy the data out of there and paste into a text editor, etc.

Of course it carries risks working in phpMyAdmin if one does not know what they are doing.
Hope this helps.

Regards,
Damian Baker

Thanks Damian.