On critical time shop down / no access to admin / string(3) "ccc"

[Waffa Margus Meigo]

No idea, if anyone did some updates or not, but


Admin gives just: string(3) "ccc"

---

When clicking on any product (front page loads)
We get:

 

[PrestaShopDatabaseException]

Table 'd50371sd94301.ps_product_comment_usefulness' doesn't exist

			SELECT pc.`id_product_comment`,
			(SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment` AND pcu.`usefulness` = 1) as total_useful,
			(SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment`) as total_advice, 
			IF(c.id_customer, CONCAT(c.`firstname`, ' ',  LEFT(c.`lastname`, 1)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title
			  FROM `ps_product_comment` pc
			LEFT JOIN `ps_customer` c ON c.`id_customer` = pc.`id_customer`
			WHERE pc.`id_product` = 7607 AND pc.`validate` = 1
			ORDER BY pc.`date_add` DESC
			


at line 646 in file classes/db/Db.php

641. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
642. 		}
643. 		elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
644. 		{
645. 			if ($sql)
646. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
647. 			throw new PrestaShopDatabaseException($this->getMsgError());
648. 		}
649. 	}
650. 
651. 	/**

    DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments]
    DbCore->query - [line 516 - classes/db/Db.php] - [1 Arguments]
    DbCore->executeS - [line 114 - modules/productcomments/ProductComment.php] - [1 Arguments]
    ProductComment::getByProduct - [line 747 - modules/productcomments/productcomments.php] - [1 Arguments]
    ProductComments->hookProductTab - [line 512 - classes/Hook.php] - [1 Arguments]
    HookCore::exec - [line 275 - controllers/front/ProductController.php] - [2 Arguments]
    ProductControllerCore->initContent - [line 180 - classes/controller/Controller.php]
    ControllerCore->run - [line 373 - classes/Dispatcher.php]
    DispatcherCore->dispatch - [line 28 - index.php]

[Daresh]

Table 'd50371sd94301.ps_product_comment_usefulness' doesn't exist

 

So maybe disable any comment-related module?

[Waffa Margus Meigo]

I got some moth old backup files, is it help to upload, update any?

[Waffa Margus Meigo]

Well, as i can not access to admin,
how can i disable, You can give technological instructions, i got one person with experience here

[Waffa Margus Meigo]

Only thing that was turned on / of was some Cachy / CCC  javascrip thing under performance i think, 
That was about it. Really paranormal.
 

[Daresh]

It should not cause a database table to disappear. I don't think anyone can help you without havinh access to the actual shop.

[Waffa Margus Meigo]

Is there service we can pay for all fixes?

[Daresh]

I can try to help if you send me some data to access the shop, contact me by private message or email [email protected]

[Waffa Margus Meigo]

is there some service we can pay for ?
// will do !

Life saver!

Skype: WaffaD

Maybe this what happens if to hire random people around the internet, with hyped profiles, but not directly From the community.
Okey, 

i was just before about to send one letter, in inner feeling to Presta people's who's emails i was harvesting kindly, (spiritual kind of feeling like that, top of  months of epic failures to find a people who would be honest about what they can do in presta, breaking my near 10 year old relationship with a client fatally and all that. So much trouble can come from looking help from wrong places. and this is what the letter was also about a bit, will send it later out still.

 

..)

Edited May 5, 2017 by Waffa Margus Meigo (see edit history)

[Waffa Margus Meigo]

OKey, to late now, client flipped out a bit rightfully and it will be reinstalled. Most likely something happened in purpose of someone doing it.
 

Daresh heroically helped to rescue front end, so for client side it seems okey, but basically my last few month's was kind of nullified as worked on basis "when all is done and good then pay as you feel" 
Feelings understandably was anything but sharing'ly right now.