cancel
Showing results for 
Search instead for 
Did you mean: 

SQLSTATE[42S02]: Base table or view not found: 1146 Table

SOLVED

SQLSTATE[42S02]: Base table or view not found: 1146 Table

Hi there.. 

when I try to add new products I got error message like this;

 

"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bulldum_mg1.mg_magegiant_dailydeal' doesn't exist, query was: SELECT `main_table`.* FROM `mg_magegiant_dailydeal` AS `main_table` WHERE (`status` = '3') AND ((close_time ";i:1;s:6840:"#0 /home/bulldum/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)

I dont know why and how fix this issue...  my site is working find if I dont try add new products. Only product sections broken I think. Im not a programmer and I m not well english language skills Smiley Sad  Any one explain me how can I fix this issue... ( please describe like an idiot to tell. For example somewhere , someone wrote "check your db files" ; maybe he is right but I dont know where is the db locate Smiley Happy )

 

Thank you for your endure

1 REPLY

Re: SQLSTATE[42S02]: Base table or view not found: 1146 Table

Hi Axoy,
 
> Table 'bulldum_mg1.mg_magegiant_dailydeal' doesn't exist
 
this error means you do not have a required table in the database. Looks like an extension was not installed properly. Probably this one : Daily Deal extension - M a g e g i a n t (looks like they pissed off a lot of people already because i can not even post that name in my reply)
You can disable that extension of pay extension provider to reinstall it properly.
hope this helps.

Anton Pachkine @ magento2.hosting : Magento Managed Package. Get your e-commerce health checkup at http://ecommerce.fitness