All Activity

A short time ago you wrote that you used the Prestashop module. It left me a bit puzzled as you mentioned version number 4.5.4. But when I checked the Mollie Github the 4.x versions (the last supporting PS 1.6) didn't go further than 4.4.3 from december 2021. What are your experiences with this version and why are looking for a TB version anyway?

As I said in the SQL manager, you are using there are forbidden statements or nested queries, etc. The export functionality in Customers is prepared query that does not run through thirty bees' SQL manager. As DRMasterChief said - if you have tool at hosting level similar to phpMyAdmin and you're confortable using it - do so but always keep a fresh copy of your db so not to end in a bad situation (only one deleted column in this table can brick your shop). You want a list containing those columns? SELECT c.id_customer, c.id_shop_group, c.id_lang, c.firstname, c.lastname, c.email, c.newsletter, c.date_add FROM ps_customer c; Of course edit the table prefix to match yours.

If I go in "Customers" in Backoffice and use "EXPORT TO SQL MANAGER" button, then it is working fine, I am able to see or export in CSV. So the problem seems to be only when you use the "Add new SQL query" inside the SQL Manager in Backoffice to create a new query from the "List of MySQL Tables" that I get the errors. Not sure if it is a bug...

I highly recommend using hosting-based SQL management for this kind of thing. You probably have access via cPanel or something similar. It offers extensive SQL functions and full access to everything. Don't forget to back up your data beforehand 😉

... 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 ...