Search

Upgraded now get errors

Marc

Last weekend upgraded to 19.3 (10-05 build) and now cant add/edit suppliers, customers, employees.  Can still add/edit items.  I have been all through new settings and dont see anything to stop that.  I just get a red "Error can't add/edit" box now.  Please help!  This functionality is critical.

 

As a secondary, employees are also telling me that for years when an item had a popup notice at sales and they answered it, it stopped.  Now they say it comes back every scan. (example. Item has a "limit 3" popup. Employee scans first item and message pops up. They answer it. They could then scan other 2 items without popup. Now it pops up on all 3 scans.)  I cant see any controls for this?

Comments

7 comments

Date Votes
  • Comment author
    Chris Muench

    Run this code on your database to fix 1st issue

     

    DELIMITER ;;
    CREATE FUNCTION `alphanumplus`( str CHAR(255) ) RETURNS char(255) CHARSET utf8
        DETERMINISTIC
    BEGIN 
     DECLARE i, len SMALLINT DEFAULT 1; 
     DECLARE ret CHAR(255) DEFAULT ''; 
     DECLARE c CHAR(1);
     IF str IS NOT NULL THEN 
       SET len = CHAR_LENGTH( str ); 
       REPEAT 
         BEGIN 
           SET c = MID( str, i, 1 ); 
           IF c REGEXP '[[:alnum:]\+]' THEN 
             SET ret=CONCAT(ret,c); 
           END IF; 
           SET i = i + 1; 
         END; 
       UNTIL i > len END REPEAT; 
     ELSE
       SET ret='';
     END IF;
     RETURN ret; 
    END ;;
    DELIMITER ;

     

    for the 2nd issue are your items grouping? Can you try 19.4? (just released today). upgrade AFTER you fix 1st issue

    0
  • Comment author
    Marc

    Thank you. As soon as I get back to the server tomorrow I will run the sql on it and let you know.

    I tried both with grouping on and off and it does the same thing regardless. It will be a bit before I can upgrade again to 19.4 as I have to do a bunch of customization each time for our industry. Unless 19.4 only touches a couple files compared to 19.3 a week prior?  I did do an install and restore database clean on another system and both grouped and non-grouped also brings up popup each scan.

    0
  • Comment author
    Marc
    • Edited

    Ran the sql. No change. Still red error on add/edit supplier, customer, employee

     

    Also upgraded to 19.4 and item scan popup thing is still happening. Not sure if they are connected or not..

    0
  • Comment author
    Chris Muench

    Can you open ticket at help.phppos.com and send me your database?

    0
  • Comment author
    Marc

    Database is 4.5g

     

    0
  • Comment author
    Chris Muench

    Can you send just the schema and no data

    0
  • Comment author
    Marc

    Ok I think I sent what you need.

     

    1

Please sign in to leave a comment.