nbs_212
Total posts: 94
17 Oct 2012 00:06

Need a help from the expert for the following issues:

  1. I'm trying to change articel author (user id) via front end/back end, when I choose select user it said "you are not allow to view this pages", I'm using user admin.

  1. What is this use for and how do I find the setting (in red)

  1. I have set to protect some field with subscription, and this is what we have for non subsc user, can we change it to a word like "Protected" with the links to subcription page.

  1. I have set filter in section to 'records of all section', so I can filter on root level, this works fine. but when I go to sub level and use the filter it show all articel from all level not only for a sub level.

For ex:

COMPANY at this level, filter working fine can show all articel - AGENT at this level, filter show all articel from COMPANY level, it

                    supposed to show only for AGENT level.

- BANK - SERVICE

Last Modified: 02 Mar 2014


Sergey
Total posts: 13,748
17 Oct 2012 07:53

1) only for super admins

2) You can set text to those values in Joomla langage override settings. Some text you want. Like greetings or something.

3) The text you see is editable. You can set protection message in parameters right where you set subscriptions.

4) Set filter "As record mode" and record mode as "Cats and subcats"


nbs_212
Total posts: 94
17 Oct 2012 10:53

Thank You Sergey,

1) The username I use is admin but its level is super users already, and still cannot work, or do I have to create username using "super admins" name?, the highest level in joomla is super users, I'm sorry I'm not quite understand.

3) I have 6 type of subscription plans and all protect the same field, the differences are each type of subsc plans set based on time period limitation and multi user limitation.There for, every one protected field show 6 subscriptions plans.

What I mean is could we have just show only one description such as "Protected" for one protected field rather than 6 subs plans? Then the descriptions of "Protected" is link to the Subscription Plan page. (I believe we have this options in Mighty Subscription)


nbs_212
Total posts: 94
18 Oct 2012 02:07

New issue:

This error shown up when I'm trying to sort base on ID

Unknown column 't.id' in 'order clause' SQL=SELECT f.,ag.title AS access_level,g.title AS group_field_title FROM wc7uo_js_res_fields AS f LEFT JOIN wc7uo_viewlevels AS ag ON ag.id = f.access LEFT JOIN wc7uo_js_res_fields_group AS g ON g.id = f.group_id WHERE (f.published IN (0, 1)) AND f.type_id = 1 ORDER BY g.ordering ASC,t.id asc Unknown column 't.id' in 'order clause' SQL=SELECT f.,ag.title AS access_level,g.title AS group_field_title FROM wc7uo_js_res_fields AS f LEFT JOIN wc7uo_viewlevels AS ag ON ag.id = f.access LEFT JOIN wc7uo_js_res_fields_group AS g ON g.id = f.group_id WHERE (f.published IN (0, 1)) AND f.type_id = 1 ORDER BY g.ordering ASC,t.id asc LIMIT 0, 20 Unknown column 't.id' in 'order clause' SQL=SELECT f.*,ag.title AS access_level,g.title AS group_field_title FROM wc7uo_js_res_fields AS f LEFT JOIN wc7uo_viewlevels AS ag ON ag.id = f.access LEFT JOIN wc7uo_js_res_fields_group AS g ON g.id = f.group_id WHERE (f.published IN (0, 1)) AND f.type_id = 1 ORDER BY g.ordering ASC,t.id asc

(Sorry cannot get rid that smilley off)


Sergey
Total posts: 13,748
18 Oct 2012 04:04

This error shown up when I'm trying to sort base on ID

This is fixed in update today.

3) AS I see it now you can only do it in template with custom code. Just to look into field value if it is protected and replace value.


nbs_212
Total posts: 94
18 Oct 2012 22:59

Sergey.

I have update Cobalt with the latest version, the error when I choose to sort Field base on ID (in backend) is gone, but the Field sorting was not changed, the Field list still sorted base on Group name.

issue no 1). I have use Super User level to login, but still cannot change the article Author. ("you are not allow to view this pages")

issue no .3) Could you explain it more detail, I don't have a good programming knowledge in Joomla Template. Perhaps you could show me which part in "default_record_default.php" need to be modified, I have tried to modified some part of this file, but it didn't has any changes to the page.

Thank you.


Sergey
Total posts: 13,748
19 Oct 2012 01:35

Field sorting was not changed, the Field list still sorted base on Group name.

Please open groups manager and make sure all groups are ordered and have ordering 1, 2, 3 but not 0, 0, 0

Field sorting was not changed, the Field list still sorted base on Group name.

1). I have use Super User level to login, but still cannot change the article Author. ("you are not allow to view this pages")

Make sure that in global Cobalt config this user is set as global moderator

Field sorting was not changed, the Field list still sorted base on Group name.

1). I have use Super User level to login, but still cannot change the article Author. ("you are not allow to view this pages")

issue no .3) Could you explain it more detail, I don't have a good programming knowledge in Joomla Template. Perhaps you could show me which part in "default_record_default.php" need to be modified, I have tried to modified some part of this file, but it didn't has any changes to the page.

You have to make sure this template set for record full view. If there is no effect it means you edit wrong file.


nbs_212
Total posts: 94
22 Oct 2012 04:22

Sergey,

No 1 & 2 issue solved, and for no 3, still try & error editing the template.

And I have another issues:

A. As issue No.2 above solved, there are other to follows,

a1. The Author name changed, but it was not update the last time checked out item name, so when I

try to edit and save the article using the new Author, it didn't work.

   "Check-in failed with the following error: The user checking in does not match the user who checked 

     out the item." 

a2. If I used user name Admin to edit and save, it show the following message:

     "You are not permitted to use that link to directly access that page (#1)." 

B. Below message came up when I use xampp 1.8.1 vc9 (my Zend server crashed many time)

          "Strict Standards: Only variables should be passed by reference in 

          d:\xampp\htdocs\joomla25c\libraries\joomla\filter\input.php on line 558 "

C. When I unpublished created Subsc. Plan, the plan are still show in the plan list of protected field.

D. "EM_SUBSCR_CREATED", what does it mean?, it show after user buy subsc plan.


Sergey
Total posts: 13,748
22 Oct 2012 05:11
  1. make global checkin

  2. Error - enable debug mode and see tracking where this error come from.

C. Delete this plan from parameters. It is because we do not want to run extra query to DB. So we take plan IDs from parameter.

D. This is success creation message. There should be language variable. You can add this key in Joomla language override section.


nbs_212
Total posts: 94
23 Oct 2012 02:09

Sergey,

  1. Solved by Global checkin

  2. Unsupported PHP version - solved by downgrade from php 5.5 to 5.2

C. The unpublished Plan show in user site - solved by delete it from the plan list, so when we creating new plan it will show directly to user, then what publish/unpublished feature for?

D. All Joomla language override solution has not been tested, but will do soon.

E. When about to edit article this error shown,

===============================================================================

I have transfer my database to one of our host provider for test purposes, (with > 30,000 records)

Could you kindly please to take over look and test it like the way you did previously?

I fell, It still quite slow to respond (compare to the previous one),

Hidden text

I would like also to say my appreciation to Cobalt, one thing that made me surprise is the "more search option", we can set filter to almost all field which is awesome,.. !!!, I play around with this feature and found out that it could very useful for my site,

Thank you for a very great extension.


Sergey
Total posts: 13,748
24 Oct 2012 08:23

E. May be you set some editor with canot be found. Try to switch to TineMCE.

Yes, your site is slow for sure. It took ages to load.

  1. network speed is very slow. I takes 5 minut to open Joomla core article. Looks liek this server is someone's home business.

Guest
24 Oct 2012 09:23

E. When about to edit article this error shown,

This error occur becuase you use editor that can`t be found in the system. Please check if you set up everywhere for example TinyMCE. I was tried to check if there is somewhere set up editor WFEditor but there are too much fields (58 only in one type).


nbs_212
Total posts: 94
24 Oct 2012 10:28

Sergey,

Yes, I was using my company website, just want to know how its performance, but have a plan to host it separately. In my local server, it is slightly faster.

May I have some advice what would be the best Apache server, PHP and MySql version you are recommend it?, so I can use it when choosing server hosting provider.

I guess the best option is to use a dedicated server, but I will start it with VPS option first, could you advice me the minimum processor speed and the bandwitdh requirement?

Another thing, when a visitor (non registered user) would like to submit an article (in section page), they can click the link " + Register or login to submit Business Directory", but there was nothing happened, no error, it is like a broken link.


Sergey
Total posts: 13,748
24 Oct 2012 21:28

PHP 5.3.*

MySQL 5.*

Memory 1Gb

CPU 1Ghz

100 Mb/s uplink

DO not forget PHP settings memory. You can calculate it easy. See in debug/profile how much memory is used by one run and how many seconds it takes. Then see how many hits a second you may have.

M = (HITSPERSECOND * SECONDSTOBUILDPAGE) * MEMMORYUSED

M = (5s * 1.256s) * 45mb

280M

This is required memory at pick of usage. Add some extra there.

Also goot is turn off everything you do not use of with is not important. Every new turned on parameter adds in server resources consumption.

This would be good conditions for project with 30 000+ records.


nbs_212
Total posts: 94
25 Oct 2012 11:59

Thank You for the advice Sergey,

That's very useful information.

How about this issue:

  1. "Another thing, when a visitor (non registered user) would like to submit an article (in section page), they can click the link " + Register or login to submit Business Directory", but there was nothing happened, no error, no respond, it is like a broken link. "

  2. I also found that, when I set "Empty Categories" (Categories parameter) to No and "Show Empty" (Sub Categories parameter) to No in Category Index Section (default template), at the main section page all root category was hidden and it show message "There are no articles here. Be first who post here.", is that normal?. Does it suppose to hide category without article (items) only?

  3. I've found by setting Section Home to "Show records submitted to section root" or "Do not show anything" could speed up the Section page loading and reduce memory used, but the Search (filter) feature cannot be use in here, I believe this is related to queries involved in loading the page. I hope there will be some improvement in Cobalt 8. :D


Sergey
Total posts: 13,748
26 Oct 2012 06:55

1) in there menu it is not a link. It is just alert that user could see what he could do if he is authorised. But may be that is good idea to make that links. We did тещ do that because there may be different registration extensions and then people would need to change that URL. In cobalt 8 with will be integrated with those extensions, to get registration link will be easier.

2) > Does it suppose to hide category without article (items) only?

Absolutely. I'll check it.

3) Search field and fileters are not shown on the page where they cannot return anything. So it means that after you disabled to show articles in section root filters will not fins anything in section root. Then you have to set filters mode to "Search through all section"


nbs_212
Total posts: 94
27 Oct 2012 02:27

1.) Strange (but I might be wrong), I believe previously it was a link, and it work as a link, if non registered user click it, it will go to user registration page. After I update to latest version (I forgot, cobalt or emerald), it is not working anymore. If we move cursor to it, it show a link behavior but when we click it, no response.

3.) I Agree with you, and I already implement "search all section", and that's fulfill my expectation, however it need an extra time and memory to load. Since my priority concern right now is loading speed, maybe I will not apply this setting.

Sergey, could you give me some advice in creating category structure, is there any differences between:

  1. creating cat at parent level first, then after that creating each sub cat.

Parent level

AA

BB

CC

Sub level

-AA01

-AA02

-BB01

-CC01

  1. creating one set complete parent cat with each sub cat first, then continue with next set parent cat.

complete set cat (parent + sub)

AA

-AA01

-AA02

BB

-BB01

CC

-CC01

The reason I ask this is because, each of them will create different data structure in table assets and js_res_category. I just thinking maybe it could effects how the query run.


Sergey
Total posts: 13,748
27 Oct 2012 07:05

3) Filter though all section is the quickest way to filter. because it does not add any category search subqueries.

4) There is not difference in what order you create categories.


nbs_212
Total posts: 94
27 Oct 2012 11:42

Sergey,

4) Yes you were right, after I went through understanding the Nested Set model, it doesn't make any difference. (in fact, that its the advantage of this hierarchy model).

3) You were right again, I tested it and it is faster, however the memory used still the same, 75mb and 45mb if I didn't use the filter, and I think it is understandable due to query operation.

Another thing came up, could we combine the filter?. In More Search Option, we can choose the filter parameter, but only one will be applied. I know this sound silly question, because it could slow down the query. But my company would like to know whether it could be possible.

And in record list template, category show only the sub category, could we have also its parent?

for ex:

Category: Service

Sub Category: Skin, Health

or just in one line like,

Category: Service/Skin, Service/Health.

Apologize for many request. :D


Sergey
Total posts: 13,748
28 Oct 2012 01:49

You can definitely combine filters in advanced search panel. If you have 10 of them there you may set all 10 and then click apply. 10 filters will be applied.

And yes you can show all path to category. But you wil need custom code in template.


nbs_212
Total posts: 94
29 Oct 2012 04:56

"You can definitely combine filters in advanced search panel. If you have 10 of them there you may set all 10 and then click apply. 10 filters will be applied. "

Where can I found the setting (the "advance search panel")?

Let say, I have 4 filter to show in "more search option", and how do I combine them?, Only one Filter can be applied, if I choose another filter, the first filter will be replace by the second filter. Only the second filter will be use in the query.

Powered by Cobalt