wysiwyg 20 cmsadmin error

[dodgerz]

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))
{
}
}

[Pablo]

if the columns already exist then the query should silently fail.
There is no error generated by the script.

I have recent update this in the software and it work for me.
What error do you see?

[luishmpaulo]

Same problem (I think)...

[23-Mar-2026 12:48:57 America/Sao_Paulo] PHP Fatal error: Uncaught mysqli_sql_exception: Duplicate column name 'title' in /mnt/DADOS/sites-dominio/www.ophicina.net.br/public_html/teste/cmsadmin.php:421
Stack trace:
#0 /mnt/DADOS/sites-dominio/www.ophicina.net.br/public_html/teste/cmsadmin.php(421): mysqli_query()
#1 {main}
thrown in /mnt/DADOS/sites-dominio/www.ophicina.net.br/public_html/teste/cmsadmin.php on line 421

[Pablo]

This is not the same issue, because the previous reported issue has already been solved.
So, if you have the latest update then that should not be the problem.

If you need help with this then I need to see the configuration. I need some context to know where the error is related to.