-
Posts
409 -
Joined
-
Last visited
About IPCommerceFan

Recent Profile Visitors
8,062 profile views
IPCommerceFan's Achievements
-
IPCommerceFan reacted to a post in a topic: Form Node Input Issue
-
IPCommerceFan reacted to a post in a topic: React with IPS4
-
kmk reacted to a comment: Web push notifications, native sharing & offline support
-
IPCommerceFan reacted to a post in a topic: Access to furl controller on private board
-
LaCollision reacted to a comment: Web push notifications, native sharing & offline support
-
sobrenome reacted to a comment: Web push notifications, native sharing & offline support
-
DawPi reacted to a comment: Web push notifications, native sharing & offline support
-
Web push notifications, native sharing & offline support
IPCommerceFan commented on Rikki 's entry in Product Updates
Love love love this! Can you confirm whether Commerce support ticket replies will generate these push notifications?? -
AlexWebsites reacted to a comment: No-code automation with Zapier
-
No-code automation with Zapier
IPCommerceFan commented on Jordan Invision 's entry in Product Updates
We most likely won't use Zapier, but I really look forward to THIS reaching self-hosted customers! Its the only barrier for us to upgrade from 4.4.x to 4.5+! -
Hi, You can disable individual modules here: AdminCP -> System -> Applications Just click where it says "Enabled" to disable it.
-
flag \IPS\Db::SELECT_SQL_CALC_FOUND_ROWS not working
IPCommerceFan replied to sobrenome 's topic in Help & Support
What happens if you echo $select->query, and copy the query into phpmyadmin or some other mysql console? Does the query look like you think it should? Often times I've used this method to figure out a syntax error in the php version of the query. -
Combine ->first() and ->join() on database query
IPCommerceFan replied to sobrenome 's topic in Help & Support
Underflow exception would indicate there aren't any results for the query, I've seen. If it is normal for this query to sometimes not return a result, then you may need to try: {{ try { $select = \IPS\Db::i()->select( 'cms_custom_database_12.field_142 as preco, cms_custom_database_12.field_154 as link, cms_custom_database_12.record_updated as atualizado, cms_custom_database_13.field_143 as loja, cms_custom_database_13.record_image_thumb as logo, cms_custom_database_13.field_160 as cupom, cms_custom_database_13.field_161 as cupom_valor, cms_custom_database_13.primary_id_field as loja_ID', 'cms_custom_database_12', array( array( 'field_156=?', $row->primary_id_field ), array( 'field_141=?', 1 ) ), 'cms_custom_database_12.field_142 ASC')->join( 'cms_custom_database_13', 'cms_custom_database_13.primary_id_field=field_155', 'INNER' )->first(); } catch( \UnderflowException $e ) { $select = ''; } }} Do you get any results when you run this query in mysql directly? SET @field_156 ='yourdata'; SELECT cms_custom_database_12.field_142 as preco, cms_custom_database_12.field_154 as link, cms_custom_database_12.record_updated as atualizado, cms_custom_database_13.field_143 as loja, cms_custom_database_13.record_image_thumb as logo, cms_custom_database_13.field_160 as cupom, cms_custom_database_13.field_161 as cupom_valor, cms_custom_database_13.primary_id_field as loja_ID FROM cms_custom_database_12 INNER JOIN cms_custom_database_13 ON cms_custom_database_13.primary_id_field = cms_custom_database_12.field_155 WHERE field_156 = @field_156 AND field_141=1 ORDER BY cms_custom_database_12.field_142 ASC LIMIT 1; -
Combine ->first() and ->join() on database query
IPCommerceFan replied to sobrenome 's topic in Help & Support
I hope this isn't stating the obvious, but what happens when you try this? {{$select = \IPS\Db::i()->select( 'cms_custom_database_12.field_142 as preco, cms_custom_database_12.field_154 as link, cms_custom_database_12.record_updated as atualizado, cms_custom_database_13.field_143 as loja, cms_custom_database_13.record_image_thumb as logo, cms_custom_database_13.field_160 as cupom, cms_custom_database_13.field_161 as cupom_valor, cms_custom_database_13.primary_id_field as loja_ID', 'cms_custom_database_12', array( array( 'field_156=?', $row->primary_id_field ), array( 'field_141=?', 1 ) ), 'cms_custom_database_12.field_142 ASC')->join( 'cms_custom_database_13', 'cms_custom_database_13.primary_id_field=field_155', 'INNER' )->first();}} -
That should work, however I would verify by testing on a single post first. After REPLACE(), add WHERE pid = 1234; (post ID of a post that contains the emoji you're replacing)
-
StopForumSpam broke my forum - help with MYSQL query
IPCommerceFan replied to FabioPaz 's topic in Help & Support
^ This was indeed useful for me. I migrated my cpanel account to a new server yesterday, which also involved updating from MySQL 5.6 to 5.7 and PHP 7.2->7.3. No changes to IPS install (4.4.10) Everything went off without a hitch! Site back up and running without issue, except apparently nothing was being written to the nexus_customers table when a guest would check out. This did not affect registered members. I managed to repro the issue and see the error, which was exactly the above! IPS\Db\Exception: Field 'sfsMemInfo' doesn't have a default value (1364) Its really curious this didn't show itself until I moved the server and updated mysql and php. Its unclear which of those revealed the issue. In any case, this was a huge help. Thanks @FabioPaz and @Daniel F (I opted to just drop the columns) -
IPCommerceFan started following (SD) E-CommercePlus
-
IPCommerceFan started following Adrian A.
-
I would use a "pay what you want" feature for support requests. We often have customers so appreciative of our service that they ask us how they can send us a little extra something just for the after-sales support we deliver. Support Request departments have a "Submission Charge" option, so we would have the value be "pay what you want", in that use case.
- 27 replies
-
- Internal Review
- Commerce
-
(and 1 more)
Tagged with:
-
I want to use commerce for apparel, but feel stuck
IPCommerceFan replied to breatheheavy 's topic in Feature Suggestions
Just want to say a Printful integration would be amazing. Not saying it needs to be core functionality, however if an application/plugin were available in the market for such integration, it would be a godsend. -
Support notification and from front end
IPCommerceFan replied to kmk 's topic in Feature Suggestions
We use Callum's application as well. It does the trick for us. -
Love it!!
-
Wow, very different. Thank you for sharing!
-
Indeed, this requires 4.4.10. I tried to cut it down to use less of the source, but it failed if I didn't include it because its calling $paymentMethodOptions. What would be the proper way, if you don't mind?
-
Yup just install it as a plugin. I tested on my dev and live site, so it should be good.