Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error: When Clicking Submit on Qoute page. #5

Open
offternet opened this issue Oct 21, 2024 · 0 comments
Open

Error: When Clicking Submit on Qoute page. #5

offternet opened this issue Oct 21, 2024 · 0 comments

Comments

@offternet
Copy link

offternet commented Oct 21, 2024

==========================
UPDATE 3: New Install of currenct code:
(A.) Create Customer - worked
(B.) Customer not searchable in Quotes Page (typed full name: Bobby)

==========================

UPDATE 2: Changed utf8mb4_0900_ai_ci to utf8mb4_general_ci in quotes_items table and stock-db.sql insertion worked successfully.

==========================

UPDATE 1: RESOLVED by UPDATE 2 above:
Test Database sql insertion of current stock-db.sql resulted in this error:
Error
SQL query: Copy


--
-- Table structure for table quote_items

CREATE TABLE quote_items (
id int NOT NULL,
quote_id int NOT NULL,
product_name varchar(255) NOT NULL,
quantity int NOT NULL,
unit_price decimal(10,2) NOT NULL,
total_price decimal(10,2) NOT NULL,
created_at timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
MySQL said: Documentation

#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'

==============================

Only Customer in Quote & Click Submit button:

Fatal error: Uncaught mysqli_sql_exception: Unknown column 'created_by' in 'field list' in /home4/yadgui36/jacksbackyardsales.com/inventory-oem/quote.php:85 Stack trace: #0 /home4/yadgui36/jacksbackyardsales.com/inventory-oem/quote.php(85): mysqli->query('INSERT INTO quo...') #1 {main} thrown in /home4/yadgui36/jacksbackyardsales.com/inventory-oem/quote.php on line 85
Resulting Error:

With both Customer & Producted in Quote & Click Submit Button:

Fatal error: Uncaught mysqli_sql_exception: Unknown column 'created_by' in 'field list' in /home4/yadgui36/jacksbackyardsales.com/inventory-oem/quote.php:85 Stack trace: #0 /home4/yadgui36/jacksbackyardsales.com/inventory-oem/quote.php(85): mysqli->query('INSERT INTO quo...') #1 {main} thrown in /home4/yadgui36/jacksbackyardsales.com/inventory-oem/quote.php on line 85

No data added to tables:
quotes
quote_items

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant