Hello
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.
Query:
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 cmts.cmt_author_id=sys_profiles.id INNER JOIN sys_accounts ON sys_profiles.account_id= sys_accounts.id WHERE sys_cmts_ids.system_id = 8
Mysql error:
Incorrect table name ''
Location:
The error was found in _getDataSqCounter function in the file /home/pollener/public_html/inc/classes/BxDolGrid.php at line 419.
collation_connection:
utf8mb4_unicode_ci
- 257
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'
- 540
-
- · caldopollo
- ·
Apparently there is a column missing in database. That is the thing that needs to be fixed.
-
-
·
LeonidS
- ·
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.
-
·
LeonidS
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
-
-
·
LeonidS
- ·
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.
-
·
LeonidS
-
Many thanks Leonid. Notifications?! I would have never found it 🙂
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
-
-
·
LeonidS
- ·
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.
-
·
LeonidS
-
Thanks Leonid. Changing the duration of the plan by one day could be a solution.
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".
| |||
| |||
Grand Master
Total points: 1295.5
https://stackoverflow.com/questions/31530801/stored-procedure-collation-connection-is-utf8mb4-general-ci-instead-of-utf8mb4-u
C
Thanks for the information
Your welcome! :)