HTTP error when altering view

PHPMaker General Discussion (PHPMaker)
1

When trying to alter a view I get the following error:cannot establish HTTP connectionAnother project accessing the same db can do this without problem, so there must be a setting error in this project.tia
/Poul

2

You may post sufficent information so other users can try to reproduce, including:

  1. What is your database type and connection type (DIRECT/URL)?
  2. Post table schema of the tables,
  3. Post the old and new SQL of the view.
3
  1. Database type: MySql, InnoDB - connection type: URL
  2. Schema of the single table used:
CREATE TABLE `sr_catlog` (
  `id` int(11) NOT NULL,
  `dato` date NOT NULL,
  `klokken` time NOT NULL,
  `obs` longtext DEFAULT NULL,
  `selskaber` longtext DEFAULT NULL,
  `se_post` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

Indeks for tabel sr_catlog

ALTER TABLE `sr_catlog`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

AUTO_INCREMENT i tabel `sr_catlog`
ALTER TABLE `sr_catlog`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
COMMIT;
  1. SQL of view:
    The HTTP connection error is shown any time I am accessing the view. When I right click and select click menu item “Alter view” or when I try to generate source.
    The SQL for the view:
select `sr_catlog`.`dato` AS `dato`,`sr_catlog`.`klokken` AS `klokken`,`sr_catlog`.`obs` AS `obs`,`sr_catlog`.`selskaber` AS `selskaber` from `sr_catlog` order by `sr_catlog`.`dato` desc,`sr_catlog`.`klokken`
4

I have tested your table and view, but I cannot reproduce the problem. The view can be altered fine.You better check the CREATE VIEW statement and make sure the database user you entered in PHPMaker project has the database’s permission to alter the view.