rgwhitaker

Hello. Are there any modules (paid is fine) for auction type websites? Actually, my site would be more like etsy. I'd need to have the following functionality: 1. allow sellers to create their own shops 2. sellers can then list items that they want to sell in their shops 3. buyers can then come to the site, create a login, then purchase items from sellers 4. buyers and sellers can rate each other 5. buyers can favorite items, as well as put items in wishlists 6. sellers can list items as Buy Now, not necessarily auction only 7. I, as the site admin, can set listing prices for sellers when they list an item (for example, $.20 to list an item) 8. I would also want to be able to set the final percentage amount that is paid to me when an item sells (for example, 5% final selling price comes to me when items sell) 9. module would need to allow users to set their shipping options (UPS, FedEx, USPS) and more! Is there a module out there (or modules) that can accomplish this? Thank you.

That worked. Thank you.

Today I noticed that I don't have the CSV sample files for PS 1.5.6.2. When I go into the PS backoffice > Advanced Parameters > CSV Import, then when I click on the "Click to view our sample import csv files" link, if I click on any of the sample links, I receive a 403 error. Apparently, those files should be in the /docs/csv_import folder. I don't have a /csv_folder. Is there any way to download those csv files for 1.5.6.2?

I'm wondering what the consensus is on this topic? I'm finally ready to go live and have a bunch of test orders in the PS backoffice. I'd like to delete them just to get rid of them and have a clean Orders page. El Patron, in a previous thread, recommended NOT deleting test orders. I also read that Vekia has created a module here. Will Vekia's module actually remove the orders from the PS backoffice, as well as the database, without damaging the database or affecting actual customer orders as they come in? Thank you.

I'd like to get a quote to modify an existing module. I have the Dropship module by Module Bazaar. I've been going back and forth with them for about the last 5-6 months. Bottom line: they're just not getting it! The last thing I need is for someone to add the functionality so that when a customer orders more than one item from a single vendor, the module will produce a parent-child label from either UPS or FedEX. I don't know how big of a deal that is, but I need someone who knows Prestashop and who thoroughly understands UPS and FedEX. This has been going on for several months and I'm tired of it. Unfortuntely, they don't seem to understand how UPS and FedEX functions here in the U.S. Thank you.

I just updated the Newsletter for Prestashop module to v5.5 today. I then tried to send a test email and it FAILED. The error at the top of the page is: exception 'Swift_ConnectionException' with message 'Authentication failed using username <email>' and password '********'' in <mysite>/public_html/tools/swift/Swift/Connection/SMTP.php:414 Stack trace: #0 <mysite>/public_html/tools/swift/Swift/Connection/SMTP.php(331): Swift_Connection_SMTP->runAuthenticators(<email>', '***', Object(Swift)) #1 <mysite>/public_html/tools/swift/Swift.php(264): Swift_Connection_SMTP->postConnect(Object(Swift)) #2 <mysite>/public_html/tools/swift/Swift.php(220): Swift->handshake(Object(Swift_Events_ResponseEvent)) #3 <mysite>/public_html/tools/swift/Swift.php(101): Swift->connect() #4 <mysite>/public_html/modules/newsletteradmin/classes/NewsMail.php(77): Swift->__construct(Object(Swift_Connection_SMTP), '<URL>') #5 <mysite>/public_html/modules/newsletteradmin/controllers/admin/AdminNewsletter.php(1116): NewsMail::Send(NULL, 'newsletter', 'Newsletter of S...', Array, '<email>', NULL, '[email protected]...', 'PRIMZIE', NULL, NULL, '<mysite>/p...', false, 1, NULL, NULL) #6 <mysite>/public_html/classes/controller/Controller.php(158): AdminNewsletterController->postProcess() #7 <mysite>/public_html/classes/Dispatcher.php(348): ControllerCore->run() #8 <mysite>/public_html/adminx0109a/index.php(53): DispatcherCore->dispatch() #9 {main} Any ideas why this is occurring? Thank you.

I'm running PS 1.5.6.2 and it the frontend and backend are both running very slow. I turned define('_PS_DEBUG_PROFILING_', false) to define('_PS_DEBUG_PROFILING_', true). I then went into the backoffice and copied the following below. Also, should I be getting a report at the bottom of each page in the frontend as well? Because if I go to my site (primzie.com), there's nothing at the bottom of the pages. Thanks. Ron ___________________________________________________________________ Load time: 1.12s You'd better run your shop on a toasterconfig: 178ms constructor: 0ms init: 14ms checkAccess: 0ms setMedia: 0ms postProcess: 0ms initHeader: 0ms initContent: 920ms initFooter: 0ms display: 8ms Hook processing: 12ms / 0.25 MbmoduleRoutes: 12ms / 0.25 Mb actionDispatcher: 0ms / 0 Mb displayBackOfficeTop: 0ms / 0 Mb Memory peak usage: 14.7 Mbconfig: 11.85 Mb (14.1 Mb) constructor: 0 Mb (14.1 Mb) init: 0.33 Mb (14.1 Mb) checkAccess: 0 Mb (14.1 Mb) setMedia: 0 Mb (14.1 Mb) postProcess: 0 Mb (14.1 Mb) initHeader: 0 Mb (14.1 Mb) initContent: 1.29 Mb (14.1 Mb) initFooter: 0 Mb (14.1 Mb) display: 0.47 Mb (14.7 Mb) Total cache size (in Cache class): 0.28 Mb DB type: DbPDO SQL Queries: 24 queries Time spent querying: 19ms Included files: 66 Size of included files: 1.41 Mb Globals (> 1 Ko only): 1167 Ko_LANGADM ≈ 1122.2 Ko HTTP_SERVER_VARS ≈ 8.8 Ko _SERVER ≈ 8.8 Ko _ENV ≈ 7.5 Ko HTTP_ENV_VARS ≈ 7.5 Ko _REQUEST ≈ 2.9 Ko HTTP_COOKIE_VARS ≈ 2.6 Ko _COOKIE ≈ 2.3 Ko Go to Stopwatch Go to Doubles Go to Tables Go to ObjectModels Display queries table Stopwatch (with SQL_NO_CACHE) (total = 24)3.779 ms SELECT SQL_NO_CACHE module FROM ps_tab_module_preference WHERE `id_tab` = 6 AND `id_employee` = 0 in /home/dellas5/public_html/classes/Tab.php:534 1 row browsed3.457 ms SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.id_configuration = cl.id_configuration) in /home/dellas5/public_html/classes/Configuration.php:116 538 rows browsed1.874 ms SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` WHERE ((SELECT COUNT(*) FROM ps_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) ORDER BY hm.`position` in /home/dellas5/public_html/classes/Hook.php:339 USING FILESORT - 87 rows browsed1.782 ms SELECT SQL_NO_CACHE * FROM `ps_quick_access` qa LEFT JOIN `ps_quick_access_lang` qal ON (qa.`id_quick_access` = qal.`id_quick_access` AND qal.`id_lang` = 1) ORDER BY `name` ASC in /home/dellas5/public_html/classes/QuickAccess.php:65 USING FILESORT - 25 rows browsed0.747 ms SELECT SQL_NO_CACHE * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1) ORDER BY t.`position` ASC in /home/dellas5/public_html/classes/Tab.php:246 USING FILESORT - 106 rows browsed0.735 ms SELECT SQL_NO_CACHE * FROM `ps_access` a LEFT JOIN `ps_tab` t ON t.id_tab = a.id_tab WHERE `id_profile` = 0 in /home/dellas5/public_html/classes/Profile.php:143 1 row browsed0.67 ms SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC in /home/dellas5/public_html/classes/Dispatcher.php:426 USING FILESORT - 26 rows browsed0.567 ms SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name in /home/dellas5/public_html/classes/shop/Shop.php:622 USING FILESORT - 1 row browsed0.474 ms SELECT SQL_NO_CACHE `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminlogin' LIMIT 1 in /home/dellas5/public_html/classes/Tab.php:178 106 rows browsed0.45 ms SELECT SQL_NO_CACHE * FROM `ps_tab_lang` WHERE `id_tab` = 6 in /home/dellas5/public_html/classes/ObjectModel.php:219 1 row browsed0.436 ms SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1 in /home/dellas5/public_html/classes/Language.php:805 1 row browsed0.424 ms SELECT SQL_NO_CACHE * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1 WHERE (a.id_lang = 1) LIMIT 1 in /home/dellas5/public_html/classes/ObjectModel.php:212 1 row browsed0.401 ms SELECT SQL_NO_CACHE * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1 WHERE (a.id_currency = 1) LIMIT 1 in /home/dellas5/public_html/classes/ObjectModel.php:212 1 row browsed0.37 ms SELECT SQL_NO_CACHE t.`class_name`, t.`module` FROM `ps_tab` t WHERE t.`module` IS NOT NULL AND t.`module` != "" in /home/dellas5/public_html/classes/Tab.php:222 106 rows browsed0.352 ms SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang) in /home/dellas5/public_html/classes/Language.php:698 1 row browsed0.33 ms SELECT SQL_NO_CACHE 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.primzie.com' OR su.domain_ssl = 'www.primzie.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC in /home/dellas5/public_html/classes/shop/Shop.php:320 USING FILESORT - 1 row browsed0.326 ms SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab` in /home/dellas5/public_html/classes/Tab.php:276 106 rows browsed0.296 ms SELECT SQL_NO_CACHE value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1 in /home/dellas5/public_html/classes/cache/CacheFs.php:36 1 row browsed0.27 ms SELECT SQL_NO_CACHE domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 in /home/dellas5/public_html/classes/shop/ShopUrl.php:154 1 row browsed0.258 ms SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 1 LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 21) LIMIT 1 in /home/dellas5/public_html/classes/ObjectModel.php:212 1 row browsed0.253 ms SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1 in /home/dellas5/public_html/classes/shop/Shop.php:199 1 row browsed0.245 ms SELECT SQL_NO_CACHE * FROM `ps_hook_alias` in /home/dellas5/public_html/classes/Hook.php:182 86 rows browsed0.189 ms SELECT SQL_NO_CACHE * FROM `ps_tab` a WHERE (a.id_tab = 6) LIMIT 1 in /home/dellas5/public_html/classes/ObjectModel.php:212 1 row browsed0.187 ms SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.id_shop = 1) LIMIT 1 in /home/dellas5/public_html/classes/ObjectModel.php:212 1 row browsed Tables stress6 tab4 shop_url4 shop3 lang3 lang_shop2 tab_lang2 configuration1 access1 meta_lang1 quick_access1 tab_module_preference1 quick_access_lang1 meta1 currency_shop1 currency1 hook_module1 country_lang1 country1 configuration_lang1 theme1 country_shop1 shop_group1 module_shop1 hook1 module1 hook_alias ObjectModel instances2 Tab1 Currency1 Language1 Employee1 Country1 Shop Included files1 adminx0109a/index.php 2 adminx0109a/../config/config.inc.php 3 config/config.inc.php 4 config/defines.inc.php 5 config/settings.inc.php 6 config/autoload.php 7 config/alias.php 8 classes/Autoload.php 9 cache/class_index.php 10 tools/profiling/Controller.php 11 classes/controller/Controller.php 12 tools/profiling/ObjectModel.php 13 classes/ObjectModel.php 14 tools/profiling/Hook.php 15 classes/Hook.php 16 tools/profiling/Db.php 17 classes/db/Db.php 18 tools/profiling/Tools.php 19 classes/Tools.php 20 classes/Context.php 21 classes/shop/Shop.php 22 classes/db/DbPDO.php 23 classes/cache/Cache.php 24 classes/cache/CacheFs.php 25 classes/Validate.php 26 classes/db/DbQuery.php 27 config/defines_uri.inc.php 28 classes/Configuration.php 29 classes/Language.php 30 classes/Country.php 31 classes/Collection.php 32 classes/Cookie.php 33 classes/Rijndael.php 34 classes/Employee.php 35 classes/Link.php 36 classes/shop/ShopUrl.php 37 config/smarty.config.inc.php 38 tools/smarty/Smarty.class.php 39 tools/smarty/sysplugins/smarty_internal_data.php 40 tools/smarty/sysplugins/smarty_internal_templatebase.php 41 tools/smarty/sysplugins/smarty_internal_template.php 42 tools/smarty/sysplugins/smarty_resource.php 43 tools/smarty/sysplugins/smarty_internal_resource_file.php 44 tools/smarty/sysplugins/smarty_cacheresource.php 45 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php 46 config/smartyadmin.config.inc.php 47 adminx0109a/functions.php 48 ./images.inc.php 49 classes/Dispatcher.php 50 classes/Tab.php 51 controllers/admin/AdminLoginController.php 52 classes/controller/AdminController.php 53 classes/Translate.php 54 translations/en/admin.php 55 classes/Profile.php 56 classes/Currency.php 57 classes/Media.php 58 classes/QuickAccess.php 59 classes/module/Module.php 60 cache/smarty/compile/ab/14/75/ab1475920163a6deacc3167978595c4f5191956e.file.content.tpl.php 61 tools/smarty/plugins/modifier.escape.php 62 tools/smarty/plugins/modifier.date_format.php 63 tools/smarty/plugins/shared.make_timestamp.php 64 cache/smarty/compile/ed/f6/a7/edf6a73267dec527214ca90474017f648d79392f.file.layout.tpl.php 65 cache/smarty/compile/de/ac/e7/deace7a9465a4ac913a81b6197a900e6e4b5eea4.file.header.tpl.php 66 cache/smarty/compile/55/fb/78/55fb78bc523eff1937408c8ffed4bbdc81e33359.file.footer.tpl.php

I have no idea.

Yes. I turned on dev mode in the defines.inc.php file. It stayed blank. But if I exited out, then came back into my browser I was able to go to the website, but there was nothing but a HUGE error on the screen. Is there a way to attach a file. I have an image of the error.

In PS 1.5.6.2 I'm trying to put an item in the Cart. I've turned error checking to on in the defines.inc.php file. The following error appears when I try to put an item in the Cart. Any idea why this is happening? _________________________________________________________________________ Impossible to add the product to the cart. textStatus: 'error' errorThrown: 'Internal Server Error' responseText: <style> #psException{font-family: Verdana; font-size: 14px} #psException h2{color: #F20000} #psException p{padding-left: 20px} #psException ul li{margin-bottom: 10px} #psException a{font-size: 12px; color: #000000} #psException .psTrace, #psException .psArgs{display: none} #psException pre{border: 1px solid #236B04; background-color: #EAFEE1; padding: 5px; font-family: Courier; width: 99%; overflow-x: auto; margin-bottom: 30px;} #psException .psArgs pre{background-color: #F1FDFE;} #psException pre .selected{color: #F20000; font-weight: bold;} </style><div id="psException"><h2>[PrestaShopDatabaseException]</h2><p><b>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 '> 0 and ( select cost from eds_geo_cost g where g.id_supplier = d.id_s' at line 36<br /><br /><pre> SELECT id_supplier,id_product,shipmethod, (linkcost + qwacost + IFNULL(add_cost,0)) AS cost, address1,address2,city,state,country,pincode,email,phone,avl,delivery_service,width,height,depth,weight from ( select id_supplier,id_product, qwa,zipgeo,shipmethod,linkcost, case when shipmethod = 0 then 0 else 1 end as avl, case when shipmethod = 1 then ( select c.cost from eds_cost_setting c where c.id_supplier=d.id_supplier and ( (qwa=1 and cfrom<=wt and cto>=wt) or (qwa=2 and cfrom<=amt and cto>=amt) or (qwa=3 and cfrom<=qty and cto>=qty) ) ) else 0 end as qwacost, case when shipmethod = 1 and zipgeo = 1 then ( select cost from eds_cost_pincode z where z.id_supplier=d.id_supplier and z.pincode like '%%' limit 0,1 ) when shipmethod = 1 and zipgeo = 2 and 0>0 and ( select cost from eds_geo_cost g where g.id_supplier = d.id_supplier and id_county = 0 ) > 0 then ( select cost from eds_geo_cost g where g.id_supplier = d.id_supplier and id_county = 0 ) when shipmethod = 1 and zipgeo = 2 and > 0 and ( select cost from eds_geo_cost g where g.id_supplier = d.id_supplier and id_state = ) > 0 then ( select cost from eds_geo_cost g where g.id_supplier = d.id_supplier and id_state = ) when shipmethod = 1 and zipgeo = 2 and > 0 and ( select cost from eds_geo_cost g where g.id_supplier = d.id_supplier and id_country = ) > 0 then ( select cost from eds_geo_cost g where g.id_supplier = d.id_supplier and id_country = ) else 0 end as add_cost, qty,wt as weight,amt,address1,address2,city,state,country,pincode,email,phone,delivery_service,width,height,depth from ( select p.id_supplier,p.id_product, sum(cp.quantity) as qty, sum((p.weight+IFNULL(a.weight,0))*cp.quantity) as wt, sum((p.price +IFNULL(a.price,0))*cp.quantity) as amt, address1,address2,city,state,country,sp.pincode,email,phone, method as qwa,add_type as zipgeo,ifnull(id_method,0) as shipmethod,l.cost as linkcost,delivery_service, IFNULL(sum(width),0) as width, IFNULL(max(height),0) as height, IFNULL(max(depth),0) as depth from ps_cart c inner join ps_cart_product cp on c.id_cart = cp.id_cart inner join ps_product p on cp.id_product=p.id_product left join eds_supplier_profile sp on p.id_supplier = sp.id_supplier left join ps_product_attribute a on a.id_product_attribute = cp.id_product_attribute left join eds_carrier_link l on l.id_supplier = p.id_supplier and l.id_carrier = 139 where c.id_cart = 148 and p.id_supplier>0 group by p.id_supplier ) as d ) as s</pre></b><br /><i>at line </i><b>613</b><i> in file </i><b>classes/db/Db.php</b></p><div class="psTrace" id="psTrace_" style="display: block"><pre>607. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 608. } 609. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 610. { 611. if ($sql) <span class="selected">612. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); </span>613. throw new PrestaShopDatabaseException($this->getMsgError()); 614. } 615. } 616. 617. /** </pre></div><ul><li><b>DbCore->displayError</b> - <a href="#" style="font-size: 12px; color: #000000" onclick="document.getElementById('psTrace_0').style.display = (document.getElementById('psTrace_0').style.display != 'block') ? 'block' : 'none'; return false">[line 313 - classes/db/Db.php]</a> - <a href="#" onclick="document.getElementById('psArgs_0').style.display = (document.getElementById('psArgs_0').style.display != 'block') ? 'block' : 'none'; return false">[1 Arguments]</a><div class="psTrace" id="psTrace_0" ><pre>307. if ($sql instanceof DbQuery) 308. $sql = $sql->build(); 309. 310. $this->result = $this->_query($sql); 311. if (_PS_DEBUG_SQL_) <span class="selected">312. $this->displayError($sql); </span>313. return $this->result; 314. } 315. 316. /** 317. * Execute an INSERT query </pre></div><div class="psArgs" id="psArgs_0"><pre><b>Argument [0]</b> SELECT id_supplier,id_product,shipmethod, (linkcost + qwacost + IFNULL(add_cost,0)) AS cost, address1,address2,city,state,country,pincode,email,phone,avl,delivery_service,width,height,depth,weight from ( select id_supplier,id_product, qwa,zipgeo,shipmethod,linkcost, case when shipmethod = 0 then 0 else 1 end as avl, case when shipmethod = 1 then ( select c.cost from eds_cost_setting c where c.id_supplier=d.id_supplier and ( (qwa=1 and cfrom<=wt and cto>=wt) or (qwa=2 and cfrom<=amt and cto>=amt) or (qwa=3 and cfrom<=qty and cto>=qty) ) ) else 0 end as qwacost, case when shipmethod = 1 and zipgeo = 1 then ( select cost from eds_cost_pincode z where z.id_supplier=d.id_supplier and z.pincode like '%%' limit 0,1 ) when shipmethod = 1 and zipgeo = 2 and 0>0 and ( select cost from eds_geo_cost g where g.id_supplier = d.id_supplier and id_county = 0 ) > 0 then ( select cost from eds_geo_cost g where g.id_supplier = d.id_supplier and id_county = 0 ) when shipmethod = 1 and zipgeo = 2 and > 0 and ( select cost from eds_geo_cost g where g.id_supplier = d.id_supplier and id_state = ) > 0 then ( select cost from eds_geo_cost g where g.id_supplier = d.id_supplier and id_state = ) when shipmethod = 1 and zipgeo = 2 and > 0 and ( select cost from eds_geo_cost g where g.id_supplier = d.id_supplier and id_country = ) > 0 then ( select cost from eds_geo_cost g where g.id_supplier = d.id_supplier and id_country = ) else 0 end as add_cost, qty,wt as weight,amt,address1,address2,city,state,country,pincode,email,phone,delivery_service,width,height,depth from ( select p.id_supplier,p.id_product, sum(cp.quantity) as qty, sum((p.weight+IFNULL(a.weight,0))*cp.quantity) as wt, sum((p.price +IFNULL(a.price,0))*cp.quantity) as amt, address1,address2,city,state,country,sp.pincode,email,phone, method as qwa,add_type as zipgeo,ifnull(id_method,0) as shipmethod,l.cost as linkcost,delivery_service, IFNULL(sum(width),0) as width, IFNULL(max(height),0) as height, IFNULL(max(depth),0) as depth from ps_cart c inner join ps_cart_product cp on c.id_cart = cp.id_cart inner join ps_product p on cp.id_product=p.id_product left join eds_supplier_profile sp on p.id_supplier = sp.id_supplier left join ps_product_attribute a on a.id_product_attribute = cp.id_product_attribute left join eds_carrier_link l on l.id_supplier = p.id_supplier and l.id_carrier = 139 where c.id_cart = 148 and p.id_supplier>0 group by p.id_supplier ) as d ) as s </pre></li><li><b>DbCore->query</b> - <a href="#" style="font-size: 12px; color: #000000" onclick="document.getElementById('psTrace_1').style.display = (document.getElementById('psTrace_1').style.display != 'block') ? 'block' : 'none'; return false">[line 488 - classes/db/Db.php]</a> - <a href="#" onclick="document.getElementById('psArgs_1').style.display = (document.getElementById('psArgs_1').style.display != 'block') ? 'block' : 'none'; return false">[1 Arguments]</a><div class="psTrace" id="psTrace_1" ><pre>482. { 483. $this->last_cached = true; 484. return $result; 485. } 486. <span class="selected">487. $this->result = $this->query($sql); </span>488. if (!$this->result) 489. return false; 490. 491. $this->last_cached = false; 492. if (!$array) </pre></div><div class="psArgs" id="psArgs_1"><pre><b>Argument [0]</b> SELECT id_supplier,id_product,shipmethod, (linkcost + qwacost + IFNULL(add_cost,0)) AS cost, address1,address2,city,state,country,pincode,email,phone,avl,delivery_service,width,height,depth,weight from ( select id_supplier,id_product, qwa,zipgeo,shipmethod,linkcost, case when shipmethod = 0 then 0 else 1 end as avl, case when shipmethod = 1 then ( select c.cost from eds_cost_setting c where c.id_supplier=d.id_supplier and ( (qwa=1 and cfrom<=wt and cto>=wt) or (qwa=2 and cfrom<=amt and cto>=amt) or (qwa=3 and cfrom<=qty and cto>=qty) ) ) else 0 end as qwacost, case when shipmethod = 1 and zipgeo = 1 then ( select cost from eds_cost_pincode z where z.id_supplier=

Running PS 1.5.6.2. I've been having some developers at ModuleBazaar add functionality with their Dropship module so that there will be FedEx label printing functionality. Now, all of a sudden, when I try to log in as a test user, the screen simply goes blank and I can no longer see the website. Any ideas why this would happen? The developers told me to contact my hosting service, which I did. My hosting service said it's a developer issue. So, which is it? I'm siding on the fact that it's the developers.

dpurcell: I'm using the PayPal Payments Pro module that I purchased from ModuleBazaar. Here it is: http://www.modulebazaar.com/en/prestashop-paypal-pro-plus-module.html It's a great module and ModuleBazaar is very helpful if you need help.

Thank you for your response. Sounds like a big mess! I guess I won't be using PayPal Express until/unless they get their act together. In the meantime, I'll just stick with PayPal Payments Pro.

Anyone have any ideas?

I'm trying to get the PayPal USA module to work properly and have a couple of questions. 1. How can I change the logo that appears? I'm only wanting to use the PayPal Express Checkout. I went into the /modules/paypalusa/views/templates/hooks/express-checkout.tpl file and tried to change the URL to the logo image I want to use, but it doesn't work. 2. I thought that Express Checkout was supposed to stay on your website? It doesn't. It takes me to a PayPal website. I'm using PS 1.5.6.2. I've also got a PayPal Payments Pro account, which accepts credit cards, but I'd like to have customers be able to use their PayPal accounts as well. Thanks for any assistance.