Rest API > filters and Category

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
fxm
Posts: 26
Joined: 01 Feb 2007, 09:42
Location: Namur (Belgium)

Rest API > filters and Category

Post by fxm »

Hi all,

I have a systematic error while I send a "filters" Rest request when I have a filter with Category selection in it.

Postman returns me a "http 500 Internal server error" and we can read in php error file
[07-Apr-2022 10:33:08 Europe/Brussels] PHP Fatal error: 1502 in D:\Mantis\Srv\htdocs\Athena\core\category_api.php on line 363

Do somebody else have this error ?

Thanks for your support.

MantisBT 2.25.1

François
fxm
Posts: 26
Joined: 01 Feb 2007, 09:42
Location: Namur (Belgium)

Re: Rest API > filters and Category

Post by fxm »

Hi all,

just to be complete, you will find enclosed the dump of my mantis_category_table.

François

-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Apr 08, 2022 at 06:02 AM
-- Server version: 5.7.12-log
-- PHP Version: 7.4.27

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: `mantis`
--

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

--
-- Table structure for table `mantis_category_table`
--

CREATE TABLE `mantis_category_table` (
`id` int(10) UNSIGNED NOT NULL,
`project_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
`user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
`name` varchar(128) NOT NULL DEFAULT '',
`status` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mantis_category_table`
--

INSERT INTO `mantis_category_table` (`id`, `project_id`, `user_id`, `name`, `status`) VALUES
(70, 0, 0, '800 Envir. SW', 0),
(69, 0, 0, '720 Maint.evol.', 0),
(7, 3, 1, 'Enhancement', 0),
(68, 0, 0, '700 Maint. corr.', 0),
(67, 0, 0, '502 Support WE', 0),
(66, 0, 0, '501 Support HH', 0),
(65, 0, 0, '500 Support HB', 0),
(64, 0, 0, '400 Assistance', 0),
(63, 0, 0, '130 Garde WE', 0),
(62, 0, 0, '120 Garde HH', 0),
(61, 0, 0, '110 Garde HB', 0),
(73, 0, 0, '999 Historique', 0),
(72, 0, 0, '900 Mini-forfait', 0),
(71, 0, 0, '850 ReDo Rel. Note', 0),
(90, 0, 0, '010 Tâche', 0),
(91, 0, 0, '000 Garantie', 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mantis_category_table`
--
ALTER TABLE `mantis_category_table`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `idx_category_project_name` (`project_id`,`name`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `mantis_category_table`
--
ALTER TABLE `mantis_category_table`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;
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 */;
Post Reply