•  ·  Standard
Add new...
Added a discussion


When I go to Manage Comments and select any app like 'Forum' for example, I get a 'Database error' email.

Any help to fix this would be appreciated.


SELECT COUNT(*) FROM ``sys_cmts_ids INNER JOIN bx_forum_cmts cmts ON cmts.cmt_id = sys_cmts_ids.cmt_id INNER JOIN sys_profiles ON INNER JOIN sys_accounts ON sys_profiles.account_id= WHERE sys_cmts_ids.system_id = 8

Mysql error:

Incorrect table name ''


The error was found in _getDataSqCounter function in the file /home/pollener/public_html/inc/classes/BxDolGrid.php at line 419.



  • 257
Added a discussion

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.

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'

  • 540
    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?

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

        • Many thanks Leonid. Notifications?! I would have never found it 🙂 

          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.

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

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

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

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

                    Not logged in users can't 'Comments Post'.
                    caldopollo Discussions

                    Grand Master

                    Total points: 1295.5

                    6904.7 point(s) to reach
                    Friends count:
                    Followers count: