Title: PHP errors in log
Last modified: August 21, 2016

---

# PHP errors in log

 *  Resolved [nancy68](https://wordpress.org/support/users/nancy68/)
 * (@nancy68)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/php-errors-in-log-1/)
 * We are using WP Business Intelligence Lite and we are getting php error in our
   log files. At this time we are not getting any decrease of functionality but 
   would still like to understand the cause and remove if possible.
 * I have included the full error below. Would you be able to correct this error?
 * Thank you,
 * Nancy
 * PHP message: WordPress database error Multiple primary key defined for query 
   ALTER TABLE wp_wpbi_charts ADD PRIMARY KEY (CHART_ID) made by require_once(‘wp-
   admin/admin.php’), require(‘wp-admin/menu.php’), require_once(‘wp-admin/includes/
   menu.php’), do_action(‘admin_menu’), call_user_func_array, wpbi_menu, apply_db_updates,
   dbDelta” while reading response header from upstream, client: 24.70.39.146, server:
   dev.guideadvisor.com, request: “POST /wp-admin/post.php HTTP/1.1”, upstream: “
   fastcgi://unix:/tmp/php5-fpm.sock:”, host: “dev.guideadvisor.com”, referrer: “
   [https://dev.guideadvisor.com/wp-admin/post.php?post=4305&action=edit&#8221](https://dev.guideadvisor.com/wp-admin/post.php?post=4305&action=edit&#8221);
   
   2014/01/03 09:07:08 [error] 23022#0: *1570 FastCGI sent in stderr: “PHP message:
   WordPress database error Table ‘wp_wpbi_charts’ already exists for query CREATE
   TABLE wp_wpbi_charts ( CHART_ID int(11) NOT NULL AUTO_INCREMENT, QUERY_ID int(
   11) NOT NULL, CHART_KEY varchar(32) NOT NULL, CHART_NAME varchar(64) NOT NULL,
   CHART_TYPE int(2) NOT NULL, CHART_TITLE varchar(64) NOT NULL, CHART_TITLE_SIZE
   int(11) NOT NULL, CHART_TITLE_COLOR varchar(7) NOT NULL, CHART_BG_COLOR varchar(
   7) NOT NULL, CHART_WIDTH int(11) NOT NULL, CHART_WIDTH_PERCENT int(1) NOT NULL,
   CHART_HEIGHT int(11) NOT NULL, CHART_HEIGHT_PERCENT int(1) NOT NULL, CHART_X_COLOR
   varchar(7) NOT NULL, CHART_X_PRECISION int(11) NOT NULL, CHART_X_THICKNESS int(
   11) NOT NULL, CHART_X_GRID_COLOR varchar(7) NOT NULL, CHART_X_GRID_LINES int(
   11) NOT NULL, CHART_X_LABELS_COLOR varchar(7) NOT NULL, CHART_X_LABELS_SIZE int(
   11) NOT NULL, CHART_X_LABELS_ROTATION int(11) NOT NULL, CHART_X_LEGEND varchar(
   64) NOT NULL, CHART_X_LEGEND_COLOR varchar(7) NOT NULL, CHART…
 * [http://wordpress.org/plugins/wp-business-intelligence-lite/](http://wordpress.org/plugins/wp-business-intelligence-lite/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [claudio](https://wordpress.org/support/users/calberti/)
 * (@calberti)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/php-errors-in-log-1/#post-4468173)
 * Dear Nancy,
    thank you for spotting this error. Actually this was related to 
   some inconsistency in the DB upgrade following the addition of a new column. 
   Now we just uploaded a fix for this (still version 1.0.6). Feel free to test 
   it and let me know if it works. If you don’t want to replace the entire plugin,
   you can simply replace these 2 files: wp-business-intelligence-lite.php and install/
   database.php
 * kind regards
    Claudio
 *  Thread Starter [nancy68](https://wordpress.org/support/users/nancy68/)
 * (@nancy68)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/php-errors-in-log-1/#post-4468194)
 * Hi Claudio,
 * Greatly appreciate the help! This solved my problem.
 * Regards,
 * Nancy
 *  [claudio](https://wordpress.org/support/users/calberti/)
 * (@calberti)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/php-errors-in-log-1/#post-4468227)
 * I’m glad it helped!
    cheers, Claudio

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘PHP errors in log’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-business-intelligence-lite_eae8f9.
   svg)
 * [WP Business Intelligence Lite](https://wordpress.org/plugins/wp-business-intelligence-lite/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-business-intelligence-lite/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-business-intelligence-lite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-business-intelligence-lite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-business-intelligence-lite/reviews/)

## Tags

 * [PHP errors](https://wordpress.org/support/topic-tag/php-errors/)

 * 3 replies
 * 2 participants
 * Last reply from: [claudio](https://wordpress.org/support/users/calberti/)
 * Last activity: [12 years, 4 months ago](https://wordpress.org/support/topic/php-errors-in-log-1/#post-4468227)
 * Status: resolved