Invalid Request - Githubissues

jan-vandenberg / cruddiy

No-code Bootstrap PHP CRUD generator

http://cruddiy.com

GNU Affero General Public License v3.0

239 stars 80 forks source link

Invalid Request #135

Open MOLJane opened 2 months ago

MOLJane commented 2 months ago

I downloaded the latest version and cruddiy is no longer working for me. They are displaying properly but I am unable to create or edit records I keep getting Invalid Request. Sorry, you've made and invalid request. Please go back and try again.

In another issue it said it was because of the Primary Key.....so here is my create table script CREATE TABLE bd_province ( id smallint(6) NOT NULL, code char(2) NOT NULL, name char(30) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

And below are the images from create and edit.

Thank you Jane

germain-italic commented 2 months ago

Hello, what's your PHP version and would you mind sharing your database schema (WITHOUT data)?

MOLJane commented 2 months ago

PHP 7.4.33 I created a new database with just that table and I get the same error. Here is the script. Is this ok? Thanks Jane

-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/

-- Host: localhost:8889 -- Generation Time: Apr 25, 2024 at 06:03 PM -- Server version: 5.7.39 -- PHP Version: 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00";

/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8mb4 /;

-- -- Database: `scvtjumy_test`

CREATE DATABASE IF NOT EXISTS scvtjumy_test DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE scvtjumy_test;

-- -- Table structure for table `bd_province`

CREATE TABLE bd_province ( id smallint(6) NOT NULL, code char(2) NOT NULL, name char(30) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- -- Dumping data for table `bd_province`

INSERT INTO bd_province (id, code, name) VALUES (1, 'AB', 'Alberta'), (2, 'BC', 'British Colombia'), (3, 'MB', 'Manitoba'), (4, 'NB', 'New Brunswick'), (5, 'NL', 'Newfoundland and Labrador'), (6, 'NS', 'Nova Scotia'), (7, 'NT', 'Northwest Territories'), (8, 'NU', 'Nunavut'), (9, 'ON', 'Ontario'), (10, 'PE', 'Prince Edward Island'), (11, 'QC', 'Quebec'), (12, 'SK', 'Saskatchewan'), (13, 'YT', 'Yukon');

-- -- Indexes for dumped tables

-- -- Indexes for table `bd_province`

ALTER TABLE bd_province ADD PRIMARY KEY (id); COMMIT;

/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /; /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /; /!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;

germain-italic commented 2 months ago

Could you try with PHP 8.x for a quick debug? I know it's been tested thoroughly with 8.1

On Thu, Apr 25, 2024, 22:09 MOLJane @.***> wrote:

PHP 7.4.33 I created a new database with just that table and I get the same error. Here is the script. Is this ok? Thanks Jane -- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/

-- Host: localhost:8889 -- Generation Time: Apr 25, 2024 at 06:03 PM -- Server version: 5.7.39 -- PHP Version: 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00";

/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8mb4 /;

-- Database: scvtjumy_test

CREATE DATABASE IF NOT EXISTS scvtjumy_test DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE scvtjumy_test;

-- -- Table structure for table bd_province

CREATE TABLE bd_province ( id smallint(6) NOT NULL, code char(2) NOT NULL, name char(30) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table bd_province

INSERT INTO bd_province (id, code, name) VALUES (1, 'AB', 'Alberta'), (2, 'BC', 'British Colombia'), (3, 'MB', 'Manitoba'), (4, 'NB', 'New Brunswick'), (5, 'NL', 'Newfoundland and Labrador'), (6, 'NS', 'Nova Scotia'), (7, 'NT', 'Northwest Territories'), (8, 'NU', 'Nunavut'), (9, 'ON', 'Ontario'), (10, 'PE', 'Prince Edward Island'), (11, 'QC', 'Quebec'), (12, 'SK', 'Saskatchewan'), (13, 'YT', 'Yukon');

-- Indexes for dumped tables -- -- Indexes for table bd_province

ALTER TABLE bd_province ADD PRIMARY KEY (id); COMMIT;

/*!40101 SET @._CHARACTER_SET_CLIENT /; /!40101 SET @._CHARACTER_SET_RESULTS /; /!40101 SET @.**_COLLATION_CONNECTION /;

— Reply to this email directly, view it on GitHub https://github.com/jan-vandenberg/cruddiy/issues/135#issuecomment-2077869164, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEFSA6CZN7PRC3VEWUPN4K3Y7FBETAVCNFSM6AAAAABGZGR662VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANZXHA3DSMJWGQ . You are receiving this because you commented.Message ID: @.***>

MOLJane commented 2 months ago

I’m not near my computer right now I will do that later today and let know. Thank youJane Sent from my iPhoneOn Apr 25, 2024, at 4:02 PM, Germain Italic @.***> wrote: Could you try with PHP 8.x for a quick debug? I know it's been tested

thoroughly with 8.1

On Thu, Apr 25, 2024, 22:09 MOLJane @.***> wrote:

PHP 7.4.33

I created a new database with just that table and I get the same error.

Here is the script. Is this ok?

Thanks

Jane

-- phpMyAdmin SQL Dump

-- version 5.2.0

-- https://www.phpmyadmin.net/

-- Host: localhost:8889

-- Generation Time: Apr 25, 2024 at 06:03 PM

-- Server version: 5.7.39

-- PHP Version: 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

START TRANSACTION;

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT

/; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS

/; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION

/; /!40101 SET NAMES utf8mb4 */;

--

-- Database: scvtjumy_test

CREATE DATABASE IF NOT EXISTS scvtjumy_test DEFAULT CHARACTER SET utf8

COLLATE utf8_general_ci;

USE scvtjumy_test;

--

-- Table structure for table bd_province

CREATE TABLE bd_province (

id smallint(6) NOT NULL,

code char(2) NOT NULL,

name char(30) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--

-- Dumping data for table bd_province

INSERT INTO bd_province (id, code, name) VALUES

(1, 'AB', 'Alberta'),

(2, 'BC', 'British Colombia'),

(3, 'MB', 'Manitoba'),

(4, 'NB', 'New Brunswick'),

(5, 'NL', 'Newfoundland and Labrador'),

(6, 'NS', 'Nova Scotia'),

(7, 'NT', 'Northwest Territories'),

(8, 'NU', 'Nunavut'),

(9, 'ON', 'Ontario'),

(10, 'PE', 'Prince Edward Island'),

(11, 'QC', 'Quebec'),

(12, 'SK', 'Saskatchewan'),

(13, 'YT', 'Yukon');

--

-- Indexes for dumped tables --

-- Indexes for table bd_province

ALTER TABLE bd_province

ADD PRIMARY KEY (id);

COMMIT;

/*!40101 SET @.***_CHARACTER_SET_CLIENT

/; /!40101 SET @.***_CHARACTER_SET_RESULTS

/; /!40101 SET @.**_COLLATION_CONNECTION /;

—

Reply to this email directly, view it on GitHub

https://github.com/jan-vandenberg/cruddiy/issues/135#issuecomment-2077869164,

or unsubscribe

https://github.com/notifications/unsubscribe-auth/AEFSA6CZN7PRC3VEWUPN4K3Y7FBETAVCNFSM6AAAAABGZGR662VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANZXHA3DSMJWGQ

.

You are receiving this because you commented.Message ID:

@.***>

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you were assigned.Message ID: @.***>

MOLJane commented 2 months ago

Sorry about the delay, I tried php 8.2 that is what I had on my computer. If you want me to try a lower version I can, just let me know.

The icons are all displaying differently (see below)….. I am able add a record successfully but I still get the error Invalid Request - Sorry, you made an invalid request. Please go back and try again. The update seems to work without errors.

While I was at it I tried a table with a foreign key to bd_province. CREATE TABLE bd_profile ( id int(11) NOT NULL, name varchar(60) NOT NULL, primary1 varchar(35) NOT NULL, primary1_dob date NOT NULL, primary2 varchar(35) DEFAULT NULL, primary2_dob date DEFAULT NULL, from_year smallint(6) NOT NULL, to_year smallint(6) NOT NULL, prov_id smallint(6) NOT NULL, profile_type_id smallint(6) NOT NULL, PRIMARY KEY (id), KEY bd_profile_bd_province_FK (prov_id), KEY bd_profile_bd_profile_type_FK (profile_type_id), CONSTRAINT bd_profile_bd_profile_type_FK FOREIGN KEY (profile_type_id) REFERENCES bd_profile_type (id), CONSTRAINT bd_profile_bd_province_FK FOREIGN KEY (prov_id) REFERENCES bd_province (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; and I got these errors

When I select the record for update it just puts the last value in the foreign key fields

It's very strange because, you application has always worked perfectly for me before.

Thank you Jane

On Apr 25, 2024, at 4:02 PM, Germain Italic @.***> wrote:

Could you try with PHP 8.x for a quick debug? I know it's been tested thoroughly with 8.1

On Thu, Apr 25, 2024, 22:09 MOLJane @.***> wrote:

PHP 7.4.33 I created a new database with just that table and I get the same error. Here is the script. Is this ok? Thanks Jane -- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/

-- Host: localhost:8889 -- Generation Time: Apr 25, 2024 at 06:03 PM -- Server version: 5.7.39 -- PHP Version: 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00";

/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8mb4 /; -- -- Database: scvtjumy_test

CREATE DATABASE IF NOT EXISTS scvtjumy_test DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE scvtjumy_test;

-- -- Table structure for table bd_province

CREATE TABLE bd_province ( id smallint(6) NOT NULL, code char(2) NOT NULL, name char(30) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table bd_province

INSERT INTO bd_province (id, code, name) VALUES (1, 'AB', 'Alberta'), (2, 'BC', 'British Colombia'), (3, 'MB', 'Manitoba'), (4, 'NB', 'New Brunswick'), (5, 'NL', 'Newfoundland and Labrador'), (6, 'NS', 'Nova Scotia'), (7, 'NT', 'Northwest Territories'), (8, 'NU', 'Nunavut'), (9, 'ON', 'Ontario'), (10, 'PE', 'Prince Edward Island'), (11, 'QC', 'Quebec'), (12, 'SK', 'Saskatchewan'), (13, 'YT', 'Yukon'); -- -- Indexes for dumped tables -- -- Indexes for table bd_province

ALTER TABLE bd_province ADD PRIMARY KEY (id); COMMIT;

/*!40101 SET @._CHARACTER_SET_CLIENT /; /!40101 SET @._CHARACTER_SET_RESULTS /; /!40101 SET @.**_COLLATION_CONNECTION /;

— Reply to this email directly, view it on GitHub https://github.com/jan-vandenberg/cruddiy/issues/135#issuecomment-2077869164, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEFSA6CZN7PRC3VEWUPN4K3Y7FBETAVCNFSM6AAAAABGZGR662VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANZXHA3DSMJWGQ . You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub https://github.com/jan-vandenberg/cruddiy/issues/135#issuecomment-2077914326, or unsubscribe https://github.com/notifications/unsubscribe-auth/AY6HFKBI2FNACV6Q2NZ2DLLY7FD2JAVCNFSM6AAAAABGZGR662VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANZXHEYTIMZSGY. You are receiving this because you were assigned.

MOLJane commented 2 months ago

I removed everything, rebooted my computer and reinstalled cruddy. The first error with Invalid request is resolved, however none of the foreign keys are working properly. I checked all of the keys and they all seem fine. The error below I identified with bd_profile and bd_province is the example in the test database I created and it is still giving the errors. BTW - I am using PHP 8 now, the version seems to have been the problem. Thank you Jane

On Apr 25, 2024, at 6:02 PM, Jane Moore @.***> wrote:

Sorry about the delay, I tried php 8.2 that is what I had on my computer. If you want me to try a lower version I can, just let me know.

The icons are all displaying differently (see below)….. I am able add a record successfully but I still get the error Invalid Request - Sorry, you made an invalid request. Please go back and try again. The update seems to work without errors.
While I was at it I tried a table with a foreign key to bd_province. CREATE TABLE `bd_profile` ( `id` int(11) NOT NULL, `name` varchar(60) NOT NULL, `primary1` varchar(35) NOT NULL, `primary1_dob` date NOT NULL, `primary2` varchar(35) DEFAULT NULL, `primary2_dob` date DEFAULT NULL, `from_year` smallint(6) NOT NULL, `to_year` smallint(6) NOT NULL, `prov_id` smallint(6) NOT NULL, `profile_type_id` smallint(6) NOT NULL, PRIMARY KEY (`id`), KEY `bd_profile_bd_province_FK` (`prov_id`), KEY `bd_profile_bd_profile_type_FK` (`profile_type_id`), CONSTRAINT `bd_profile_bd_profile_type_FK` FOREIGN KEY (`profile_type_id`) REFERENCES `bd_profile_type` (`id`), CONSTRAINT `bd_profile_bd_province_FK` FOREIGN KEY (`prov_id`) REFERENCES `bd_province` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; and I got these errors When I select the record for update it just puts the last value in the foreign key fields It's very strange because, you application has always worked perfectly for me before. Thank you Jane > On Apr 25, 2024, at 4:02 PM, Germain Italic ***@***.***> wrote: > > > Could you try with PHP 8.x for a quick debug? I know it's been tested > thoroughly with 8.1 > > On Thu, Apr 25, 2024, 22:09 MOLJane ***@***.***> wrote: > > > PHP 7.4.33 > > I created a new database with just that table and I get the same error. > > Here is the script. Is this ok? > > Thanks > > Jane > > -- phpMyAdmin SQL Dump > > -- version 5.2.0 > > -- https://www.phpmyadmin.net/ > > > > -- Host: localhost:8889 > > -- Generation Time: Apr 25, 2024 at 06:03 PM > > -- Server version: 5.7.39 > > -- PHP Version: 7.4.33 > > > > SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; > > START TRANSACTION; > > SET time_zone = "+00:00"; > > > > /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT > > */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS > > */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION > > */; /*!40101 SET NAMES utf8mb4 */; > > -- > > -- Database: scvtjumy_test > > > > CREATE DATABASE IF NOT EXISTS scvtjumy_test DEFAULT CHARACTER SET utf8 > > COLLATE utf8_general_ci; > > USE scvtjumy_test; > > ------------------------------ > > -- > > -- Table structure for table bd_province > > > > CREATE TABLE bd_province ( > > id smallint(6) NOT NULL, > > code char(2) NOT NULL, > > name char(30) NOT NULL > > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; > > -- > > -- Dumping data for table bd_province > > > > INSERT INTO bd_province (id, code, name) VALUES > > (1, 'AB', 'Alberta'), > > (2, 'BC', 'British Colombia'), > > (3, 'MB', 'Manitoba'), > > (4, 'NB', 'New Brunswick'), > > (5, 'NL', 'Newfoundland and Labrador'), > > (6, 'NS', 'Nova Scotia'), > > (7, 'NT', 'Northwest Territories'), > > (8, 'NU', 'Nunavut'), > > (9, 'ON', 'Ontario'), > > (10, 'PE', 'Prince Edward Island'), > > (11, 'QC', 'Quebec'), > > (12, 'SK', 'Saskatchewan'), > > (13, 'YT', 'Yukon'); > > -- > > -- Indexes for dumped tables -- > > -- Indexes for table bd_province > > > > ALTER TABLE bd_province > > ADD PRIMARY KEY (id); > > COMMIT; > > > > /*!40101 SET ***@***.***_CHARACTER_SET_CLIENT > > */; /*!40101 SET ***@***.***_CHARACTER_SET_RESULTS > > */; /*!40101 SET ***@***.***_COLLATION_CONNECTION */; > > > > — > > Reply to this email directly, view it on GitHub > > , > > or unsubscribe > > > > . > > You are receiving this because you commented.Message ID: > > ***@***.***> > > > — > Reply to this email directly, view it on GitHub , or unsubscribe . > You are receiving this because you were assigned. >

MOLJane commented 2 months ago

After looking at it again, the foreign key problem seems to be when a table has more than one foreign key. Everything else seems to be working since I changed the version of php. Thank youJaneSent from my iPhoneOn Apr 25, 2024, at 9:49 PM, Jane Moore @.> wrote:I removed everything, rebooted my computer and reinstalled cruddy. The first error with Invalid request is resolved, however none of the foreign keys are working properly. I checked all of the keys and they all seem fine. The error below I identified with bd_profile and bd_province is the example in the test database I created and it is still giving the errors.BTW - I am using PHP 8 now, the version seems to have been the problem.Thank youJaneOn Apr 25, 2024, at 6:02 PM, Jane Moore @.> wrote:Sorry about the delay, I tried php 8.2 that is what I had on my computer. If you want me to try a lower version I can, just let me know.The icons are all displaying differently (see below)….. I am able add a record successfully but I still get the error Invalid Request - Sorry, you made an invalid request. Please go back and try again. The update seems to work without errors.While I was at it I tried a table with a foreign key to bd_province. CREATE TABLE bd_profile ( id int(11) NOT NULL, name varchar(60) NOT NULL, primary1 varchar(35) NOT NULL, primary1_dob date NOT NULL, primary2 varchar(35) DEFAULT NULL, primary2_dob date DEFAULT NULL, from_year smallint(6) NOT NULL, to_year smallint(6) NOT NULL, prov_id smallint(6) NOT NULL, profile_type_id smallint(6) NOT NULL, PRIMARY KEY (id), KEY bd_profile_bd_province_FK (prov_id), KEY bd_profile_bd_profile_type_FK (profile_type_id), CONSTRAINT bd_profile_bd_profile_type_FK FOREIGN KEY (profile_type_id) REFERENCES bd_profile_type (id), CONSTRAINT bd_profile_bd_province_FK FOREIGN KEY (prov_id) REFERENCES bd_province (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;and I got these errorsWhen I select the record for update it just puts the last value in the foreign key fieldsIt's very strange because, you application has always worked perfectly for me before.Thank youJaneOn Apr 25, 2024, at 4:02 PM, Germain Italic @.***> wrote: Could you try with PHP 8.x for a quick debug? I know it's been tested

thoroughly with 8.1

On Thu, Apr 25, 2024, 22:09 MOLJane @.***> wrote:

PHP 7.4.33

I created a new database with just that table and I get the same error.

Here is the script. Is this ok?

Thanks

Jane

-- phpMyAdmin SQL Dump

-- version 5.2.0

-- https://www.phpmyadmin.net/

-- Host: localhost:8889

-- Generation Time: Apr 25, 2024 at 06:03 PM

-- Server version: 5.7.39

-- PHP Version: 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

START TRANSACTION;

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT

/; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS

/; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION

/; /!40101 SET NAMES utf8mb4 */;

--

-- Database: scvtjumy_test

CREATE DATABASE IF NOT EXISTS scvtjumy_test DEFAULT CHARACTER SET utf8

COLLATE utf8_general_ci;

USE scvtjumy_test;

--

-- Table structure for table bd_province

CREATE TABLE bd_province (

id smallint(6) NOT NULL,

code char(2) NOT NULL,

name char(30) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--

-- Dumping data for table bd_province

INSERT INTO bd_province (id, code, name) VALUES

(1, 'AB', 'Alberta'),

(2, 'BC', 'British Colombia'),

(3, 'MB', 'Manitoba'),

(4, 'NB', 'New Brunswick'),

(5, 'NL', 'Newfoundland and Labrador'),

(6, 'NS', 'Nova Scotia'),

(7, 'NT', 'Northwest Territories'),

(8, 'NU', 'Nunavut'),

(9, 'ON', 'Ontario'),

(10, 'PE', 'Prince Edward Island'),

(11, 'QC', 'Quebec'),

(12, 'SK', 'Saskatchewan'),

(13, 'YT', 'Yukon');

--

-- Indexes for dumped tables --

-- Indexes for table bd_province

ALTER TABLE bd_province

ADD PRIMARY KEY (id);

COMMIT;

/*!40101 SET @.***_CHARACTER_SET_CLIENT

/; /!40101 SET @.***_CHARACTER_SET_RESULTS

/; /!40101 SET @.**_COLLATION_CONNECTION /;

—

Reply to this email directly, view it on GitHub

https://github.com/jan-vandenberg/cruddiy/issues/135#issuecomment-2077869164,

or unsubscribe

https://github.com/notifications/unsubscribe-auth/AEFSA6CZN7PRC3VEWUPN4K3Y7FBETAVCNFSM6AAAAABGZGR662VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANZXHA3DSMJWGQ

.

You are receiving this because you commented.Message ID:

@.***>

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you were assigned.Message ID: @.***>

MOLJane commented 2 months ago

I just wanted to let you know that I resolved my problem. A form needs to be created for each foreign key or you get an error, I wasn’t generating a form for one of my tables….hence the fk errors. Thanks Jane

On Apr 25, 2024, at 4:02 PM, Germain Italic @.***> wrote:

Could you try with PHP 8.x for a quick debug? I know it's been tested thoroughly with 8.1

On Thu, Apr 25, 2024, 22:09 MOLJane @.***> wrote:

PHP 7.4.33 I created a new database with just that table and I get the same error. Here is the script. Is this ok? Thanks Jane -- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/

-- Host: localhost:8889 -- Generation Time: Apr 25, 2024 at 06:03 PM -- Server version: 5.7.39 -- PHP Version: 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00";

/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8mb4 /; -- -- Database: scvtjumy_test

CREATE DATABASE IF NOT EXISTS scvtjumy_test DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE scvtjumy_test;

-- -- Table structure for table bd_province

CREATE TABLE bd_province ( id smallint(6) NOT NULL, code char(2) NOT NULL, name char(30) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table bd_province

INSERT INTO bd_province (id, code, name) VALUES (1, 'AB', 'Alberta'), (2, 'BC', 'British Colombia'), (3, 'MB', 'Manitoba'), (4, 'NB', 'New Brunswick'), (5, 'NL', 'Newfoundland and Labrador'), (6, 'NS', 'Nova Scotia'), (7, 'NT', 'Northwest Territories'), (8, 'NU', 'Nunavut'), (9, 'ON', 'Ontario'), (10, 'PE', 'Prince Edward Island'), (11, 'QC', 'Quebec'), (12, 'SK', 'Saskatchewan'), (13, 'YT', 'Yukon'); -- -- Indexes for dumped tables -- -- Indexes for table bd_province

ALTER TABLE bd_province ADD PRIMARY KEY (id); COMMIT;

/*!40101 SET @._CHARACTER_SET_CLIENT /; /!40101 SET @._CHARACTER_SET_RESULTS /; /!40101 SET @.**_COLLATION_CONNECTION /;

— Reply to this email directly, view it on GitHub https://github.com/jan-vandenberg/cruddiy/issues/135#issuecomment-2077869164, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEFSA6CZN7PRC3VEWUPN4K3Y7FBETAVCNFSM6AAAAABGZGR662VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANZXHA3DSMJWGQ . You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub https://github.com/jan-vandenberg/cruddiy/issues/135#issuecomment-2077914326, or unsubscribe https://github.com/notifications/unsubscribe-auth/AY6HFKBI2FNACV6Q2NZ2DLLY7FD2JAVCNFSM6AAAAABGZGR662VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANZXHEYTIMZSGY. You are receiving this because you were assigned.

germain-italic commented 2 months ago

Glad it worked! This case should be added to tests, and documentation should be improved.

jan-vandenberg / cruddiy

Invalid Request #135

-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/

-- -- Database: scvtjumy_test

-- -- Table structure for table bd_province

-- -- Dumping data for table bd_province

-- -- Indexes for dumped tables

-- -- Indexes for table bd_province

/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8mb4 /;

CREATE DATABASE IF NOT EXISTS scvtjumy_test DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE scvtjumy_test;

CREATE TABLE bd_province ( id smallint(6) NOT NULL, code char(2) NOT NULL, name char(30) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- -- Database: `scvtjumy_test`

-- -- Table structure for table `bd_province`

-- -- Dumping data for table `bd_province`

-- -- Indexes for table `bd_province`