Time-----------: 2024-06-20 09:18:13
Subject-------: U5sysMsg UNDEFINED::FATAL: Error in U5DB: U5err: Unknown column name 'sales_price_x_1000_i4'
From----------: sm_sysadm@u5.com,
Add. headers: U5_Mailer 2.8

=-=-=-=-=-=-=-=-= 24-06-20 09:18:13 =-=-=-=-=-=-=-=-=
U5err: Unknown column name 'sales_price_x_1000_i4'
### ERROR: Unfetched column name 'sales_price_x_1000_i4'  Does it exist? Was is SELECTed? Did you check if ANYTHING at all was selected? 
U5dBQueryResult->u5getColValByName , called from line no 341 
$colName--: sales_price_x_1000_i4
$returnVal: 'NO SETTING OF RETURNVAL IN FUNTION u5db::u5getColValByName'
Original query:
SELECT * FROM stock_1 WHERE   classification_s30 NOT LIKE '%-%' AND  category_path_s255 ~ '(Wine.*)|(Champagne.*)'  AND (1=0   OR category_path_s255  ILIKE '%Italy%' ) ORDER BY category_path_s255, product_name_s80

File(s) claiming use of dB object, latest user first:
- - -
Server-----: localhost
dB username: u5_usr1
dB type----: PostgreSQL

Some kind of error has occured in this page.
When this happens the creators of the page are automatically notified and will look at the problem as soon as possible. Until it is fixed, please use the back-button and try another link.

We would still like to hear from you if rapid solving of this issue is particularly urgent to you.
If so, please mail to mail Service and Management Support at sm_support@u5.com and put "Page Error 05230930A" in the subject.

Please be as specific as possible. What you did to get this error-message and how you reached the previous page. What you would like to do. If you are an authenticated user please state your username in the mail. (not your password).

Again, sorry for the problem - we will do our best!