Page 1 of 1

wysiwyg 20 cmsadmin error

Posted: Wed Mar 11, 2026 6:54 pm
by 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))
{
}
}

Re: wysiwyg 20 cmsadmin error

Posted: Wed Mar 11, 2026 7:00 pm
by 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?

Re: wysiwyg 21 cmsadmin error

Posted: Mon Mar 23, 2026 6:55 pm
by 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

Re: wysiwyg 20 cmsadmin error

Posted: Mon Mar 23, 2026 8:36 pm
by 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.