Jump to content

Dringend hulp nodig met een Error


Jeffreydracoon

Recommended Posts

Hoi allemaal, Het is nu 2 uur in de nacht en dacht morgen gaat het druk worden laat ik nu maar een update doen naar de nieuwste versie van prestashop. Vervolgens na de update kijk ik op mijn site en blijkt er van alles mis te zijn. Ik doe vervolgens een rollback naar de vorige versie en krijg een error 500. Ik heb false naar true aangepast en heb vervolgens de volgende error:

[PrestaShopDatabaseException]

Table 'md126907db528625.ps_shop_url' doesn't exist<br /><br /><pre>SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'www.dracoon.nl' OR su.domain_ssl = 'www.dracoon.nl') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC</pre>
at line 769 in file classes/db/Db.php

764. if ($webservice_call && $errno) { 765. $dbg = debug_backtrace(); 766. WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97); 767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 768. if ($sql) { 769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>'); 770. } 771. 772. throw new PrestaShopDatabaseException($this->getMsgError()); 773. } 774. }

DbCore->displayError - [line 385 - classes/db/Db.php] - [1 Arguments]

DbCore->query - [line 613 - classes/db/Db.php] - [1 Arguments]

DbCore->executeS - [line 1341 - classes/shop/Shop.php] - [1 Arguments]

ShopCore::findShopByHost - [line 337 - classes/shop/Shop.php] - [1 Arguments]

ShopCore::initialize - [line 118 - config/config.inc.php]

require - [line 40 - admin/index.php] - [1 Arguments]

Dit weekend is een heel belangrijk weekend voor mij aangezien ik veel bestellingen verwacht. Nou dat de webshop offline is verwacht ik grote problemen met mijn klanten. Ik hoop dat iemand mij spoedig kan helpen.

 

Met vriendelijke groet,

 

Jeffrey

Link to comment
Share on other sites

Dit probleem is verholpen, het betrof een fout gelopen Prestashop update

Tijdens de installatie van Prestashop 1.7.7.4 naar 1.7.7.5 kwam volgende foutmelding tevoorschijn:

prestashop Too Many Requests jqXHR 

Dit probleem is gerelateerd aan de domeinhosting en na het toevoegen van deze regel aan de .htaccess bestand konden wij de installatie overdoen.

# HTTPS redirect loop fix
SetEnvIf X_FORWARDED_PROTO https HTTPS=on
# opgelet werk mogelijks niet voor alle domeinen (Werkt wel zeker voor mijndomein.nl hosting)

Bijkomend door de mislukte update is volgende error naar boven gekomen:

Argument 4 passed to PrestaShop\PrestaShop\Core\Domain\Order\QueryResult\OrderCustomerForViewing::__construct()
must be of the type string, null given, called in ../src/Adapter/Order/QueryHandler/GetOrderForViewingHandler.php on line 236

Het probleem kort samengevat, er bevinden zich null elementen in uw database. Prestashop kan deze niet verwerken wat een error veroorzaakt.
Dit probleem kan je oplossen door null te veranderen naar een "lege waarde"

Je kan dit handmatig doen voor elke tabel of volgende Query uitvoeren:

UPDATE ps_address SET phone = '' WHERE phone IS NULL;
UPDATE ps_address SET phone_mobile = '' WHERE phone_mobile IS NULL;

UPDATE ps_order_detail SET id_order_invoice = '0' WHERE id_order_invoice IS NULL;
UPDATE ps_order_detail SET product_reference = '' WHERE product_reference IS NULL;
UPDATE ps_order_detail SET product_supplier_reference = '' WHERE product_supplier_reference IS NULL;
UPDATE ps_order_detail SET product_isbn = '' WHERE product_isbn IS NULL;
UPDATE ps_order_detail SET product_upc = '' WHERE product_upc IS NULL;
UPDATE ps_order_detail SET product_mpn = '' WHERE product_mpn IS NULL;
UPDATE ps_order_detail SET download_hash = '' WHERE download_hash IS NULL;
UPDATE ps_orders SET gift_message = '' WHERE gift_message IS NULL;

UPDATE ps_order_payment SET transaction_id = '' WHERE transaction_id IS NULL;
UPDATE ps_order_payment SET card_number = '' WHERE card_number IS NULL;
UPDATE ps_order_payment SET card_brand = '' WHERE card_brand IS NULL;
UPDATE ps_order_payment SET card_expiration = '' WHERE card_expiration IS NULL;
UPDATE ps_order_payment SET card_holder = '' WHERE card_holder IS NULL;

UPDATE ps_order_carrier SET tracking_number = '' WHERE tracking_number IS NULL;
UPDATE ps_order_carrier SET id_order_invoice = '0' WHERE id_order_invoice IS NULL;
UPDATE ps_order_carrier SET weight = '0' WHERE weight IS NULL;

UPDATE ps_product SET isbn = '' WHERE isbn IS NULL;
UPDATE ps_product SET upc = '' WHERE upc IS NULL;
UPDATE ps_product SET mpn = '' WHERE mpn IS NULL;
UPDATE ps_product SET unity = '' WHERE unity IS NULL;
UPDATE ps_product SET supplier_reference = '' WHERE supplier_reference IS NULL;
UPDATE ps_product SET location = '' WHERE location IS NULL;
UPDATE ps_product SET redirect_type = '301-category' WHERE redirect_type = '';
UPDATE ps_product SET available_date = '2020-12-01' WHERE available_date IS NULL;
UPDATE ps_product SET cache_default_attribute = '0' WHERE cache_default_attribute IS NULL;
UPDATE ps_product_shop SET unity = '' WHERE unity IS NULL;
UPDATE ps_product_shop SET redirect_type = '301-product' WHERE redirect_type = '';
UPDATE ps_product_shop SET available_date = '2020-12-01' WHERE available_date IS NULL;
UPDATE ps_product_shop SET cache_default_attribute = '0' WHERE cache_default_attribute IS NULL;

 

Ik post deze uitleg nog even hier voor de volledigheid.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...