Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
  • #3424

    I had first tried to install Web Invoice and Billing by TwinCities Tech. Although I could set up a test invoice, I was unable to access the settings. The tabs were at the top but nothing below.

    So I installed Web Invoice by Mohanjith, which worked just as well, plus the settings showed up, yet but gave be an error on the top in red:

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

    Main Table – Good

    Meta Table – Good

    Log Table – Not Found

    Payment Table – Good

    Payment Meta Table – Good

    I noticed that the invoice post also didn’t show up.

    I contacted my Host and they told me to add this to my .htaccess:

    AddHandler application/x-httpd-php5 .php

    This fixed the invoice post so now it shows the invoice, but the log table error is still there. I’m not what info is on this table but I’m sure it is there for a reason.

    I have a feeling that the other WP plugin tables are affecting this one, yet I’m not quite sure how to delete them, since the setting panel is blank and I don’t do Mysql.

    Any suggestions would be great.

    FYI: I have also tried deactivating and reactivating and uninstalling and reinstalling.


    Log table is where the “audit” logs are maintained. Have you tried disabling and enabling the plugin. If it doesn’t help try “Remove All Web Invoice Databases” and then disable and enable the


    Please post here how it goes.


    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.


    Only other option is to manually create the table. Run the following SQL (using MySQL client or phpMyAdmin).

    CREATE TABLE IF NOT EXISTS _table_prefix_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)

    Replace _table_prefix_ with your table prefix and escape value field with backticks (backtics are automatically converted to <code> tags by bbpress :( )


    Ok, thanks.

    What would my table prefix be?


    Look for $table_prefix in wordpress/wp-config.php .


    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 ,


    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,



    I believe you are running MySQL 4.0 or bellow. I have added compatibility for versions bellow MySQL 4.1 in Web Invoice 1.9.4.

    Please remove all Web Invoice tables and upgrade to the latest Web Invoice version.

    Thanks for your help to triangulate this bug, much appreciated.

Viewing 8 posts - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.