All Activity

... not sure what you mean with " for a better version." but I basically need these queries: id_customer, id_shop_group, id_lang, firstname, lastname, email, newsletter, date_add

The SQL manager is heavily restricted in the operations it can do to limit exposure of the DB to bad actors. Give us the query you want to run so we can check for a better version.

Hello people, today, I tried to use SQL Manager in the Backoffice to do an SQL query for an email campaign, but as soon as I click to view the results, I get this error : "Db::getArrray method can be used for SELECT queries only." If I try to export the query instead, I get a "This site can’t be reached" page with this error: The webpage at https://www.xxxxxxxxxxxxxxx/index.php?controller=AdminRequestSql&token=xxxxxxxxxxxxxxxxxxxxxxxxxx&id_request_sql=2&exportrequest_sql=1 might be temporarily down or it may have moved permanently to a new web address. ERR_INVALID_RESPONSE Errors logs shows this: Stacktrace #0 controllers/admin/AdminRequestSqlController.php(511) #1 classes/db/Db.php(1100): () #2 controllers/admin/AdminRequestSqlController.php(511): DbCore->getArray() #3 controllers/admin/AdminRequestSqlController.php(343): AdminRequestSqlControllerCore->generateExport() #4 classes/controller/Controller.php(209): AdminRequestSqlControllerCore->initContent() #5 classes/Dispatcher.php(858): ControllerCore->run() #6 admin123/index.php(58): DispatcherCore->dispatch() I'm on Thirtybees 1.6.0 Any idea why I get this error? Any help would be appreciated Cheers,

Column `minute` was added to the module in version 2.1.0, see upgrade script for that version: https://github.com/thirtybees/cronjobs/blob/master/upgrade/upgrade-2.1.0.php Most likely the upgrade script was not correctly applied when you upgraded the module -- your cronjobs module is not working properly right now. You need to either apply the upgrade script manually, or uninstall and install it again

I think I have the latest cron module 2.3.0 from TB market place

@datakick Hi! I realised that. But how can I update the module. I have uninstalled it, which made your module to work but I would like a working cron module

That's not error from datakick module, but from cronjob module. Looks like you didn't updated that module correctly - column 'minute' is missing from ps_cronjobs table. I suggest you re-install that module to fix this problem, or manually add the column to db table. Then reinstall datakick module again

@datakick This is the decrypted 500 error. Where does it go wrong?

@the.rampage.rado @datakick Ok. I downloaded and installed. Got 500 error but it seems installed. When I try to configure it say missing control file

Yes, the best one https://www.getdatakick.com/ Bonus - you can use it for far more than that.

Are there any module to create a xml file for Google merchant center

Update: I turned off the datakick Bad Bot module and Varnish. Both shouldn't impact Googlebot but it looks like one of the two measures fixed the problem.

I see, thank you. I wonder what then is causing the Google issues of: 1) redirects with a 403 and 2) no desktop page available. These problems are inconsistent amongst all products.

There is no redirect. Javascript code simply changes the url (removing ?combination=xxx and replacing it with # hash parameters), but the page is not actually reloaded.

Thank you for the explanation. That means the feed is providing the correct URL, i.e. https://www.example.com/en/products/84/sample-product?combination=143 However, Google complains (at least, this is what the ad agency is saying) about the redirect that then happens to the URL with the # and is unable to index the page. I get a lot of errors saying that the page is not accessible to Googlebot. If this behaviour is standard, I don't understand how Google can be having problems because of the redirect from the URL with the ? to the one with the #. This would mean that all thirtybees/Prestashop users are having problems. Which would mean the ad agency is wrong in thinking that's the reason why Google can't index.

Parameters behind # are for client use only. Request to the server never contains those parameters, server never sees them and can't react to them. When you open urls https://www.example.com/en/products/84/sample-product#/72-size-large or https://www.example.com/en/products/84/sample-product#/whatever your server receive the very same request - https://www.example.com/en/products/84/sample-product It does not know what combination you are requesting. Javascript will later parse the hash parameters, and will modify the product page to display the wanted combination if it's found. This also means that initial page render shows different combination, and only a few milliseconds later the page is 'adjusted' When you provide ?combination=xxx parameter, server knows upfront what you want to display, and can returns page with combination already selected (if your theme supports this, of course). The page already contains correct pricing information, product name, reference code etc -- this is important for web crawlers. This means that you need to provide urls with standard query parameters (after ?) to google

Hi @papagino I have spoken to the team. Although it's not like a major 'game changer' module, we are willing to consider developing this for TB. We and others feel that it could cover a useful use-case and be useful for some shops in some scenarios. As you've probably seen from this - we are a small team, with limited resources. Our available resources go into running TB and making improvements where we can. We've also been working hard on new modules and marketing in order to bring in new users to help TB grow. Our capacity to do additional features for free is currently unfortunately limited. If you'd like us to create this, please consider either signing up for a Gold or Platinum Membership. Alternatively, you can purchase about 4 hours worth of development time, which should cover it. Then, if you want to be nice, you can donate it to TB for the community 😛 Either way, it's up to you. Let us know either way. Cheers

So, when we want to use Mollie, we have to carry on using the old module and TB1.4 :(

A different question: What URL do you provide to Google, the first (like it is for me) or the second: The feed outputs variant URLs such as: https://www.example.com/en/products/84/sample-product?combination=143 When this link is opened, the shop performs a 301 redirect to: https://www.example.com/en/products/84/sample-product#/72-size-large

Same as wakabayashi for us.

Put a pulse monitor result to keep server running ...

He did write that he's alone... and it can be a good solution for other circumstances, too.

Don't you have people working with you? That in itself is not the best solution.

I also think that's a good idea, even if it's not something you think about every day. The time until "standby mode" should be adjustable, because some people only need to log into the back office every 2-3 days, not daily... it really depends on the business. Do other shop systems have something similar? That would give thirtybees another small unique selling point.

@datakick