Arabic Language - Column not found

PHPMaker General Discussion (PHPMaker)
1

I am try to add records to the product Master feild using Arabic Lang , I got this internal error :/hermes/shopsystem/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php(69): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘٢٥’ in 'where clause’But in English Lang it’s work fine .
Thanx

2

You may enable Debug and check the full SQL.

3

Here the all file error log :

log.DEBUG: Slim Application Error Type: Doctrine\DBAL\Exception\InvalidFieldNameException Code: 1054 Message: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column '٢٦' in 'where clause' File: /hermes/shopsystem/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php Line: 69 Trace: 
#0 /hermesshopsystem/vendor/doctrine/dbal/src/Connection.php(1768): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) 
#1 /hermes/shopsystem/vendor/doctrine/dbal/src/Connection.php(1707): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query)) 
#2 /hermes/shopsystem/vendor/doctrine/dbal/src/Connection.php(1039): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'SELECT * FROM `...', Array, Array) 
#3 /hermes/shopsystem/models/Products.php(1788): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM `...') 
#4 /hermes/shopsystem/models/AnnouncementsAdd.php(1265): PHPMaker2022\shopsystem\Products->loadRs('`id`=\xD9\xA2\xD9\xA6') 
#5 /hermes/shopsystem/models/AnnouncementsAdd.php(590): PHPMaker2022\shopsystem\AnnouncementsAdd->addRow(NULL) 
...

any idea , Thanx

4

Do you have a numeric foreign key field (or field with unique index or field with “Check Duplicate” enabled) in the detail table and the field is not autoinc (i.e. inputted by user)? You may post your table schema of the relevant tables for discussion.

5 
-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 14, 2022 at 05:21 AM
-- Server version: 8.0.17
-- PHP Version: 7.4.22

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `shop`
--

-- --------------------------------------------------------

--
-- Table structure for table `announcements`
--

CREATE TABLE `announcements` (
  `id` int(11) NOT NULL,
  `prodect_id` int(11) NOT NULL,
  `baner_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `en-US_baner_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `de-CH_baner_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `ar-IQ_baner_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `tr-TR_baner_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `baner_ex_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `announcements`
--

INSERT INTO `announcements` (`id`, `prodect_id`, `baner_name`, `en-US_baner_image`, `de-CH_baner_image`, `ar-IQ_baner_image`, `tr-TR_baner_image`, `baner_ex_date`) VALUES
(1, 24, 'nutella', '00000000000000000000000465452121.jpg', '00000000000000000000000465452121.jpg', '00000000000000000000000465452121.jpg', '00000000000000000000000465452121.jpg', '2022-01-21');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `announcements`
--
ALTER TABLE `announcements`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `announcements`
--
ALTER TABLE `announcements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

here my table schema ,
The error cames from ‘prodect_id’ value which is token from the master Table 'prodects ’
Thanx

6

When I enter the “product_id” Value manually as English Number it’s successful add even when I use Arabic Lang
,But when token by it self from master Table as Arabic number the error come out

7

Then you need to replace Arabic numeric characters into standard English characters.

8

in database the carectors stored as English number ,
The system convert this the nomber by it self with Lang change by user
how can i stop it changed the number ,or how can i set this carectors to defulte as english nomber ?
in PHPMaket i use to use local folder it’s contain all Lang carectors ,But in PHPMaker 2022 i can’t found this files for Lang corectors in the “local” folder
Thanx

9

after Long day of searching and trying i fix the by just remove the FormatNumber() from the input element … I don’t know if that oky but it’s work
Thanks guys :slight_smile: