wysiwyg 20 cmsadmin error
Posted: Wed Mar 11, 2026 6:54 pm
March 11 2026
-Initial added the standard cmsadmin control to a php page.
-published.
-Trying to login to the php page causes an error log similar to the previous noted issues.
-The script tries to add columns already existing.
-Issue seems to be here: (commenting out this section lets the cmsadmin at least display on the page).
$columns = array(
"title VARCHAR(100)",
"description VARCHAR(255)",
"keywords VARCHAR(255)",
"seo_friendly_url VARCHAR(100)",
"parent_id INT DEFAULT NULL",
"search_index TINYINT(1) NOT NULL DEFAULT 1"
);
foreach ($columns as $colDef)
{
$sql = "ALTER TABLE `CMS_PAGES` ADD COLUMN $colDef";
if (!mysqli_query($db, $sql))
{
}
}
-Initial added the standard cmsadmin control to a php page.
-published.
-Trying to login to the php page causes an error log similar to the previous noted issues.
-The script tries to add columns already existing.
-Issue seems to be here: (commenting out this section lets the cmsadmin at least display on the page).
$columns = array(
"title VARCHAR(100)",
"description VARCHAR(255)",
"keywords VARCHAR(255)",
"seo_friendly_url VARCHAR(100)",
"parent_id INT DEFAULT NULL",
"search_index TINYINT(1) NOT NULL DEFAULT 1"
);
foreach ($columns as $colDef)
{
$sql = "ALTER TABLE `CMS_PAGES` ADD COLUMN $colDef";
if (!mysqli_query($db, $sql))
{
}
}