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

data base is incomplete. missing some columns in it #17

Closed
Engbilal opened this issue Jun 10, 2023 · 9 comments
Closed

data base is incomplete. missing some columns in it #17

Engbilal opened this issue Jun 10, 2023 · 9 comments

Comments

@Engbilal
Copy link

Hey i run your project but the column is in complete in it.

@Engbilal
Copy link
Author

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tags' in 'field list' (SQL: insert into products (image, folder, category_id, quantity, order_position, link_to, tags, hidden, url) values (images/lgMVdzyK22dMzC7DagJIDCOrGkVhtH49NMFG9iHK.png, 1686384732, 2, 21, 12, HTTPS://WWW.COM, 2, 1, aSADASDASD-2))

@Engbilal
Copy link
Author

after adding column in the database. i got the error

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'tags' in where clause is ambiguous (SQL: select products.*, products_translations.name, products_translations.description, products_translations.price from products inner join products_translations on products_translations.for_id = products.id where tags LIKE %promo% and hidden = 0 and locale = en limit 8)

@dassudip2001
Copy link

can i fix it

@kirilkirkov
Copy link
Owner

@dassudip2001
you are welcome to make a pull request with the fix

@dassudip2001
Copy link

dassudip2001 commented Jun 12, 2023

Package fruitcake/laravel-cors is abandoned, you should avoid using it. No replacement was suggested.
Package swiftmailer/swiftmailer is abandoned, you should avoid using it. Use symfony/mailer instead.

some packages are abandoned and can you check it ??

my PHP version 8.2

also

Generating optimized autoload files

Illuminate\Foundation\ComposerScripts::postAutoloadDump

problem

@kirilkirkov
Copy link
Owner

@Engbilal
@dassudip2001

Into the 2022_11_07_075654_create_products_table.php file , the tags column is present so i am not sure why you do not have it.
I have tested everything and it works. Please run your migrations from "zero" and try again, the tags field present into the migrations so it working.

With version php@8.0 is working ok.

@kirilkirkov
Copy link
Owner

@Engbilal
in which page you are getting this error? i can not reproduce it

@dassudip2001
Copy link

@kirilkirkov ok

@kirilkirkov
Copy link
Owner

@Engbilal
if you need further assistance i am available

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

3 participants