Mohanjith

I used phpMyAdmin:

CREATE TABLE IF NOT EXISTS wp_web_invoice_log(

id bigint( 20 ) NOT NULL AUTO_INCREMENT ,

invoice_id int( 11 ) NOT NULL default ‘0’,

action_type varchar( 255 ) NOT NULL ,

value longtext NOT NULL ,

time_stamp timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,

PRIMARY KEY ( id )

)

and I got this error:

#1064 – 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 ‘CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

PRIMARY KEY (

I have done that in a number of combinations. I have even forced my host to upgrade my server (it was almost 10 years old, I was paying todays prices for 4GB of space!). Still no fix. My theory was that the other WP invoice plugin’s database was conflicting. I scoured the code, disabling CSS because the setting panel never displayed properly, I finally found the URL that would delete the twin cities tables.

I reinstalled your plugin, same message at top:

The plugin database tables are gone, deactivate and reactivate plugin to re-create them.

and on the bottom:

Log Table – Not Found

I’m about to give up.