Database error after activation

  • Resolved Envox d.o.o.

    (@envox)


    2 years, 9 months ago

    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

    (@e4jvikwp)

    2 years, 8 months ago

    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.

    (@envox)

    2 years, 8 months ago

    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.