caldopollo

Added a discussion 

Hello
I'm trying to add a product (subscription) with a monthly recurring payment and I'm getting the error message below.
Any feedback to help me solve this issue would be greatly appreciated.

Query:
SELECT `bx_market_cmts`.*, `sys_cmts_ids`.`id` AS `cmt_unique_id` FROM `bx_market_cmts` LEFT JOIN `sys_cmts_ids` ON (`bx_market_cmts`.`cmt_id` = `sys_cmts_ids`.`cmt_id` AND `sys_cmts_ids`.`system_id` = :system_id) WHERE `bx_market_cmts`.`cmt_object_id` = :cmt_object_id AND `bx_market_cmts`.`cmt_vparent_id` = :cmt_vparent_id ORDER BY `bx_market_cmts`.`cmt_pinned` DESC, `bx_market_cmts`.`cmt_time` ASC LIMIT 0, 0

Mysql error:
Unknown column 'bx_market_cmts.cmt_pinned' in 'order clause'

  • 225
    • Apparently there is a column missing in database. That is the thing that needs to be fixed.

      πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
      • Hello caldopollo !

        This trouble means that the Market module hasn't been updated to the right version to work properly with the core and other apps.

        πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
        Not logged in users can't 'Comments Post'.
        Added a discussion 

        Hello everybody:
        When I want to edit a page from my website in Studio, it's always hard to find the page I'm looking for. For example, now I want to change the order of the menu below on an Organization account page, and I can't find it in Studio>Navigation.
        The menu is 'Dash, Profile, Settings, Add…, Shopping Cart, Messenger, Sign out, Friends'.

        Is there a way to easily identify your Website pages in Studio?

        • 255
          • Hello caldopollo !

            This menu is placed on the Studio->Naviagation->System->Notifications area. The strange name is historic now :-) How to find the exact menu - always choose the proper module (System, Persons, Orgs..). With the found proper module the search will be simpler as it doesn't contain many items within.

            πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
            • Many thanks Leonid. Notifications?! I would have never found itΒ πŸ™‚Β 

              πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
              Not logged in users can't 'Comments Post'.
              Added a discussion 

              How can I have three monthly pricing plans in one paid level? Β  Now the problem with Paid Levels is that each Paid Level only accepts one monthly Pricing Plan.

              Actually, currently there is no way to manage (add or rename) Paid Levels.

              Please help.

              • 331
                • Hello caldopollo !

                  As you have the answers here https://una.io/page/view-discussion?id=8098 that it's impossible to do in UNA (I guess in other systems too), you'd better change the purchasable timeframe for all 3 different cases like 29, 30, 31 days, smth like that.

                  πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
                  • Thanks Leonid. Changing the duration of the plan by one day could be a solution.

                    πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
                    Not logged in users can't 'Comments Post'.
                    Added a discussion 

                    I would like to offer 3 different Subscription plans on my site. All plans are monthly but with different price each.

                    When I try to add a second monthly plan, the system tells me 'Similar pricing plan is already exists.' How can I solve this?

                    I don't really care for Premium or Start. My plans are intended for every member regardless of membership level.

                    Thanks for your help.

                    • 322
                      • Hello. You are welcome.

                        I wonder, why do you need the following?

                        to be able to sell several things with the same duration to the same membership level

                        Do you want to be able to sell 1 month of a Premium membership for $10 and for $100? I cannot see the purpose of selling exactly the same 'product' but with different prices.

                        πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
                        • The thing is that I’m not really interested in selling membership levels, but for example if I want to charge a $5 monthly subscription fee to members (any membership level) for joining a Group and a member wants to join two Groups. How can he/she pay for that?

                          So in this case the product would be Group monthly subscription, not a Membership level.

                          πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
                          • Hello. Current version of Groups app allows to use Paid Join. Group creator/admin may add pricing options for his group and users would need to pay before join. Each group may have its own pricing options, for example, Group 1 may sell monthly subscription for $10 while Group 2 will sell monthly subscription for $5. In this situation we have different groups with the same durations and it's not the same as "to sell 1 month of a Premium membership for $10 and for $100".

                            πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
                            Not logged in users can't 'Comments Post'.
                            Added a discussion 

                            Are any of you using the newΒ version of Stripe? Please let me know how to set it up.

                            Someone who is helping me configure the new Stripe version on my page got the following error message from Logs in Stripe dashboard:
                            resource_missing - line_items[0][price]

                            The value you passed into the price field does not look like a price token. Are you sure you passed in a valid token for a price you created?

                            If you are trying to reference a price object please visit our guide on creating prices to learn more.

                            Otherwise, if you are trying to pass a raw amount you can use the price_data field to create prices inline.

                            Any information would be greatly appreciated.

                            • 450
                              • No, it should be fine.

                                πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
                                • When I add it, I get a 500 server error when I try to access Studio.

                                  πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
                                  • Thanks for checking my server, LeonidS. So far we know, that I have to talk to my server host, since I run UNA on a shared virtual server environment, that might prevent modules from functioning as expected.

                                    πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
                                    Not logged in users can't 'Comments Post'.

                                    UNA - Network Infrastructure for Communities

                                    Close