Checkbox field (TINYINT)

yaaryvp · October 31, 2024, 7:46am

When defining checkbox on field (TINYINT) system returns: An internal error has occurred while processing your request when clicking table with the checkbox. (v2025)

arbei · October 31, 2024, 1:05pm

What is your database type?
What is the length of the TINYINT field?

If it is supposed to be a boolean field, make sure you use TINYINT(1) and set the user values as 1 (true) and 0 (false).

yaaryvp · October 31, 2024, 1:17pm

Database is MySQL

CREATE TABLE `Maps` (
  `MapID` int NOT NULL AUTO_INCREMENT,
  `MapName` varchar(255) NOT NULL,
  `Latitude` decimal(10,8) NOT NULL,
  `Longitude` decimal(11,8) NOT NULL,
  `ZoomLevel` int DEFAULT '8',
  `DateCreated` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `Default` tinyint DEFAULT '0',
  `Active` tinyint DEFAULT '1',
  `SidepanelColor` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`MapID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

arbei · October 31, 2024, 2:33pm

If you want to use the fields as boolean fields, you need to use enum(1/0) or enum(y/n). If you want to use tinyint, as said:

make sure you use TINYINT(1) and set the User Values as 1 (true) and 0 (false).

yaaryvp · October 31, 2024, 3:00pm

tried it on test, same results:
An internal error has occurred while processing your request.
also tried enum(‘y’,‘n’)
when phpmaker2025 refreshed db, make the field into radio buttons.
same result:
An internal error has occurred while processing your request.
all other tables work fine.

CREATE TABLE `Maps` (
  `MapID` int NOT NULL AUTO_INCREMENT,
  `MapName` varchar(255) NOT NULL,
  `Latitude` decimal(10,8) NOT NULL,
  `Longitude` decimal(11,8) NOT NULL,
  `ZoomLevel` int DEFAULT '8',
  `DateCreated` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `Default` tinyint DEFAULT '0',
  `Active` tinyint DEFAULT '1',
  `SidepanelColor` varchar(45) DEFAULT NULL,
  `test` enum('1','0') DEFAULT NULL,
  PRIMARY KEY (`MapID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

arbei · October 31, 2024, 3:05pm

You may enable Debug and post the complete stack trace.

yaaryvp · October 31, 2024, 3:11pm

table:

CREATE TABLE `Maps` (
  `MapID` int NOT NULL AUTO_INCREMENT,
  `MapName` varchar(255) NOT NULL,
  `Longitude` decimal(11,8) NOT NULL,
  `Latitude` decimal(10,8) NOT NULL,
  `ZoomLevel` int DEFAULT '8',
  `DateCreated` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `Default` tinyint DEFAULT '0',
  `Active` tinyint DEFAULT '1',
  `SidepanelColor` varchar(45) DEFAULT NULL,
  `test` enum('1','0') DEFAULT '1',
  PRIMARY KEY (`MapID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

Error

/var/www/pinpoint.komodocodes.com/public_html/cms/src/Lookup.php(106): PHPMaker2025\PinPoint\Lookup::getSqlAsQueryBuilder(): Return value must be of type ?Doctrine\DBAL\Query\QueryBuilder, string returned

debug:

PHPMaker2025\PinPoint\Lookup::getSqlAsQueryBuilder(): Return value must be of type ?Doctrine\DBAL\Query\QueryBuilder, string returnedvar/www/pinpoint.komodocodes.com/public_html/cms/src/Lookup.php#106 TypeError

        if ($lookupFilter != "") { // Add lookup filter as part of user filter
            AddFilter($this->UserFilter, $lookupFilter);
        }
        return $this->getSqlPart("", true, $useParentFilter, $skipFilterFields);
    }
    /**
     * Get lookup SQL (as string) based on current filter/lookup filter, call Lookup_Selecting if necessary

#0 /var/www/pinpoint.komodocodes.com/public_html/cms/models/MapsList.php(2505): PHPMaker2025\PinPoint\Lookup->getSqlAsQueryBuilder()

#1 /var/www/pinpoint.komodocodes.com/public_html/cms/models/MapsList.php(678): PHPMaker2025\PinPoint\MapsList->setupLookupOptions()

#2 /var/www/pinpoint.komodocodes.com/public_html/cms/controllers/ControllerBase.php(31): PHPMaker2025\PinPoint\MapsList->run()

#3 /var/www/pinpoint.komodocodes.com/public_html/cms/controllers/MapsController.php(16): PHPMaker2025\PinPoint\ControllerBase->runPage()

#4 /var/www/pinpoint.komodocodes.com/public_html/cms/src/RequestResponseStrategy.php(33): PHPMaker2025\PinPoint\MapsController->list()

#5 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/Routing/Route.php(363): PHPMaker2025\PinPoint\RequestResponseStrategy->__invoke()

#6 /var/www/pinpoint.komodocodes.com/public_html/cms/src/PermissionMiddleware.php(112): Slim\Routing\Route->handle()

#7 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/MiddlewareDispatcher.php(280): PHPMaker2025\PinPoint\PermissionMiddleware->__invoke()

#8 /var/www/pinpoint.komodocodes.com/public_html/cms/src/AuthenticationMiddleware.php(68): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()

#9 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/MiddlewareDispatcher.php(280): PHPMaker2025\PinPoint\AuthenticationMiddleware->__invoke()

#10 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/MiddlewareDispatcher.php(73): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()

#11 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/MiddlewareDispatcher.php(73): Slim\MiddlewareDispatcher->handle()

#12 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/Routing/Route.php(321): Slim\MiddlewareDispatcher->handle()

#13 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/Routing/RouteRunner.php(74): Slim\Routing\Route->run()

#14 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/Middleware/BodyParsingMiddleware.php(65): Slim\Routing\RouteRunner->handle()

#15 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/MiddlewareDispatcher.php(129): Slim\Middleware\BodyParsingMiddleware->process()

#16 /var/www/pinpoint.komodocodes.com/public_html/cms/src/CspMiddleware.php(64): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()

#17 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/MiddlewareDispatcher.php(129): PHPMaker2025\PinPoint\CspMiddleware->process()

#18 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/tuupola/cors-middleware/src/CorsMiddleware.php(155): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()

#19 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/MiddlewareDispatcher.php(129): Tuupola\Middleware\CorsMiddleware->process()

#20 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/Middleware/RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()

#21 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/MiddlewareDispatcher.php(129): Slim\Middleware\RoutingMiddleware->process()

#22 /var/www/pinpoint.komodocodes.com/public_html/cms/src/SessionMiddleware.php(39): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()

#23 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/MiddlewareDispatcher.php(129): PHPMaker2025\PinPoint\SessionMiddleware->process()

#24 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/Middleware/ErrorMiddleware.php(77): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()

#25 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/MiddlewareDispatcher.php(129): Slim\Middleware\ErrorMiddleware->process()

#26 /var/www/pinpoint.komodocodes.com/public_html/cms/src/PhpDebugBarMiddleware.php(41): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()

#27 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/MiddlewareDispatcher.php(129): PHPMaker2025\PinPoint\PhpDebugBarMiddleware->process()

#28 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/MiddlewareDispatcher.php(73): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()

#29 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/App.php(209): Slim\MiddlewareDispatcher->handle()

#30 /var/www/pinpoint.komodocodes.com/public_html/cms/vendor/slim/slim/Slim/App.php(193): Slim\App->handle()

#31 /var/www/pinpoint.komodocodes.com/public_html/cms/index.php(132): Slim\App->run()

#32 {main}

yaaryvp · October 31, 2024, 6:09pm

UPDATE: I created a table:

CREATE TABLE `Bool` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `Value` tinyint DEFAULT NULL,
  `Name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

with one record: Value: 1 Name: Active

Set it as Lookup table for Table: Maps, Field: Active | checkbox
and checkbox was rendered correctly.

arbei · November 1, 2024, 1:09am

You are not using most updated template, you better delete C:\Users\user\AppData\Roaming\phpmaker2025, re-open PHPMaker and generate scripts again.