Bug Report: Pos System Is Not Functioning

Pos System Is Not Functioning

i cant post sales and delete orders in pos sales, and sales dont show up in dasboard. i have downloaded and uploaded the update, but i am still have error in the pos sale, also i can not delete an or...

DG

daniel godwill

Reported

i cant post sales and delete orders in pos sales, and sales dont show up in dasboard. i have downloaded and uploaded the update, but i am still have error in the pos sale, also i can not delete an order. please see screen recording https://share.zight.com/E0uv1Nro . i need a fix this is urgent

  • MS

    Mian Saleem

    Answered

    Hello,

    Column company_id has been removed from all tables. Please try run the following queries after selecting you database

    -- allow long concatenated statements
    SET SESSION group_concat_max_len = 8192;
    
    -- drop foreign keys that involve company_id
    SET @drop_fk := (
      SELECT GROUP_CONCAT(
               CONCAT('ALTER TABLE `', TABLE_SCHEMA, '`.`', TABLE_NAME,
                      '` DROP FOREIGN KEY `', CONSTRAINT_NAME, '`;')
               SEPARATOR ' '
             )
      FROM information_schema.KEY_COLUMN_USAGE
      WHERE COLUMN_NAME = 'company_id'
        AND CONSTRAINT_SCHEMA = DATABASE()
        AND REFERENCED_TABLE_NAME IS NOT NULL
    );
    SELECT @drop_fk;          -- inspect before running
    PREPARE fk_stmt FROM @drop_fk;
    EXECUTE fk_stmt;
    DEALLOCATE PREPARE fk_stmt;
    
    -- drop secondary indexes that still reference company_id
    SET @drop_idx := (
      SELECT GROUP_CONCAT(
               CONCAT('ALTER TABLE `', TABLE_SCHEMA, '`.`', TABLE_NAME,
                      '` DROP INDEX `', INDEX_NAME, '`;')
               SEPARATOR ' '
             )
      FROM information_schema.STATISTICS
      WHERE COLUMN_NAME = 'company_id'
        AND TABLE_SCHEMA = DATABASE()
        AND INDEX_NAME  'PRIMARY'
    );
    SELECT @drop_idx;
    PREPARE idx_stmt FROM @drop_idx;
    EXECUTE idx_stmt;
    DEALLOCATE PREPARE idx_stmt;
    
    -- drop the company_id column wherever it exists
    SET @drop_col := (
      SELECT GROUP_CONCAT(
               CONCAT('ALTER TABLE `', TABLE_SCHEMA, '`.`', TABLE_NAME,
                      '` DROP COLUMN `company_id`;')
               SEPARATOR ' '
             )
      FROM information_schema.COLUMNS
      WHERE COLUMN_NAME = 'company_id'
        AND TABLE_SCHEMA = DATABASE()
    );
    SELECT @drop_col;
    PREPARE col_stmt FROM @drop_col;
    EXECUTE col_stmt;
    DEALLOCATE PREPARE col_stmt;
    
    -- finally drop the companies table if present
    DROP TABLE IF EXISTS `companies`;
    

    If you still have issues, please let me know your server details in private reply.

    Thank you

  • Login to Reply