A Database Error Occurred

[felisane123]

Error Number: 1054

Unknown column 'p.isdraft' in 'where clause'

SELECT p.*,(select pg.imagepath from productgallery pg where pg.IsDelete=0 and pg.IsFeatured=1 and pg.ProductId=p.productid limit 1)as FeaturedImage,pc.CatName as ProductCatname FROM product p join productcat pc on p.productcatid=pc.ProductCatId where p.saleenddate>=CURRENT_DATE() and p.isdraft=0 and p.isdelete=0 and p.isdirectaccess=0 order by p.createddate desc limit 12

Filename: models/admin/Product_model.php

Line Number: 270

[manigopal]

i have import SQL issue.,

SQL query:

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */

MySQL said: Documentation #1231 - Variable 'character_set_client' can't be set to the value of 'NULL'

[anassdox]

the floder assets not exist in project all script css and js not found

[sunjava11]

the floder assets not exist in project all script css and js not found

Not the issue for this. But necessary files are there.

[kandyjet]

Hi all, getting same error. no idea how to fix.

[sunjava11]

Hi all, getting same error. no idea how to fix.

@kandyjet what error are you getting?

[kandyjet]

This one

Error Number: 1054

Unknown column 'p.isdraft' in 'where clause'

SELECT p.*,(select pg.imagepath from productgallery pg where pg.IsDelete=0 and pg.IsFeatured=1 and pg.ProductId=p.productid limit 1)as FeaturedImage,pc.CatName as ProductCatname FROM product p join productcat pc on p.productcatid=pc.ProductCatId where p.saleenddate>=CURRENT_DATE() and p.isdraft=0 and p.isdelete=0 and p.isdirectaccess=0 order by p.createddate desc limit 12

Filename: models/admin/Product_model.php

Line Number: 270