Title: Database error after activation
Last modified: September 9, 2023

---

# Database error after activation

 *  Resolved [Envox d.o.o.](https://wordpress.org/support/users/envox/)
 * (@envox)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-error-after-activation-2/)
 * Hi, I installed the plugin because I am in the process of evaluating various 
   booking engines. During activation, the following error appeared in the _Dashboard_,
   with which I do not know what to do.
 * **WordPress database error:** [Unknown column ‘c.pic’ in ‘field list’]
   `SELECT``
   o`.`id` AS `idorder`, `o`.`custdata`, `o`.`status`, `o`.`days`, `o`.`checkin`,`
   o`.`checkout`, `o`.`totpaid`, `o`.`total`, `o`.`idorderota`, `o`.`channel`, `
   o`.`country`, `o`.`closure`, `c`.`pic`, ( SELECT CONCAT_WS(' ',`or`.`t_first_name`,`
   or`.`t_last_name`) FROM `wp_vikbooking_ordersrooms` AS `or` WHERE `or`.`idorder`
   =`o`.`id` LIMIT 1 ) AS `nominative` FROM `wp_vikbooking_orders` AS `o` LEFT JOIN`
   wp_vikbooking_customers_orders` AS `co` ON `co`.`idorder`=`o`.`id` LEFT JOIN `
   wp_vikbooking_customers` AS `c` ON `c`.`id`=`co`.`idcustomer` WHERE `o`.`id` 
   IN (2);

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

 *  Plugin Author [e4jvikwp](https://wordpress.org/support/users/e4jvikwp/)
 * (@e4jvikwp)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-error-after-activation-2/#post-17040515)
 * Hi,
 * Thanks for sharing the error message. It looks like the plugin is still active,
   but the database structure is outdated. This usually happens when you manually
   import outdated backups.
 * If you are using the latest version of our plugin Vik Booking, then updating 
   will not be allowed, and so the there is no task that would fix that database
   error by adding the missing column.
 * If you are still evaluating our plugin, then our suggestion is to delete it and
   to re-install it from scratch, so that the first activation will execute all 
   the necessary queries to restore the proper database tables and columns. Otherwise,
   in case you’ve got data you don’t want to lose, then the only solution is to 
   manually add that missing column to the mentioned database table.
 * The error message indicates that customers are unable to store their logo/picture.
   That’s what the missing column “pic” should contain for each customer. Please
   try to use the customers management page to see if you get the same database 
   error message or if it was a temporary error during the activation only.
 *  Thread Starter [Envox d.o.o.](https://wordpress.org/support/users/envox/)
 * (@envox)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-error-after-activation-2/#post-17040692)
 * Thanks for quick response. Reinstalling fixed the problem.

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

The topic ‘Database error after activation’ is closed to new replies.

 * ![](https://ps.w.org/vikbooking/assets/icon-256x256.png?rev=1855707)
 * [VikBooking Hotel Booking Engine & PMS](https://wordpress.org/plugins/vikbooking/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/vikbooking/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/vikbooking/)
 * [Active Topics](https://wordpress.org/support/plugin/vikbooking/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/vikbooking/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/vikbooking/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Envox d.o.o.](https://wordpress.org/support/users/envox/)
 * Last activity: [2 years, 9 months ago](https://wordpress.org/support/topic/database-error-after-activation-2/#post-17040692)
 * Status: resolved