After going through the entire install process, my homepage is blank with nothing but a "
Featured Products" text.
I tried to import the design again and am getting the following error:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') or (main_table.page_id IS NULL))' at line 1, query was: SELECT `main_table`.* FROM `mgs_theme_home_blocks` AS `main_table` WHERE ((main_table.page_id=) or (main_table.page_id IS NULL))
After going through the entire install process, my homepage is blank with nothing but a " Featured Products" text.
I tried to import the design again and am getting the following error:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') or (main_table.page_id IS NULL))' at line 1, query was: SELECT `main_table`.* FROM `mgs_theme_home_blocks` AS `main_table` WHERE ((main_table.page_id=) or (main_table.page_id IS NULL))
Please help me as I have unable to fix it.
Dear Alejandro Lancaster,
Thanks for your ticket,
Could you please provide your site info ( site url, admin account and ftp access detail ) I will help to check for you
Hello,
Thanks but I can't access to ftp, please check again
Hello,
I have fixed for you
Thanks a lot!
Could you tell me how it was fixed?
Hello,
Sorry for this inconvenience, this is theme bug, I have fixed and this is the files that I modified:
app/code/MGS/Mpanel/view/frontend/templates/products/attribute/list.phtml
app/code/MGS/Mpanel/Block/Panel/AbstractPanel.php
app/code/MGS/Mpanel/Block/Panel/Toppanel.php
Hello Alejandro,
You can access to your server and find the following files
app/code/MGS/Mpanel/view/frontend/templates/products/attribute/list.phtml
app/code/MGS/Mpanel/Block/Panel/AbstractPanel.php
app/code/MGS/Mpanel/Block/Panel/Toppanel.php
I think that it is simple with you, you only need to access to ftp
IP: 178.128.64.97
User: arrow
Pass: ArrowTech2018
then download above files
I would normally agree but it seems that someone on the team clicked on Install theme again and that seems to have brought the problem back.
Hello,
Ok, I have attached them