Rob Jones

Gender	Male
Age	49 years
Member since	April 10th, 2015
Last seen	7 years ago
Topics	16
Replies	51
Points	69

Robert Stones replied to the topic Total Reponses Figure (Number) Per Question.

July 26 at 10:44 am

Maverick wrote: If there is only one survey and you want to reset survey, just truncate that table and responses. If you want to know if there are any records exists for questions not in your survey and delete them using below sql. delete from xxx_survey_response_details where question_id not in (select id from xxx_survey_questions where survey_id = YOURSURVEYID) Hi Maverick, There is only one survey, although I do have a copy I keep and if the survey was ever updated in anyway, I delete the copy and make a fresh copy. I don't want to "Reset" the survey as that leads me to believe it will reset everything back to zero and I'd lose the 18 responses I actually need from tomorrow? I simply want to locate the orphan 'Total Responses' number which doesn't correlate properly as with every other area of the extension, since I did the above tweaks I did yesterday. Weirdly the very LAST 3 questions have the correct total responses figure of 18, as I know that I have 18 true survey submission responses. So it starts off at 30 for a few questions and then as the survey questions carry on through the survey, the total responses figure lessens till the last 3 end up with 18. You also mention in your above reply "If you want to know if there are any records exists for questions not in your survey and delete them using below sql." I'm pretty sure the remaining erroenous total response figures which are above the expected 18, are my previous test responses before I put the survey truly live for people to take and hence won't be about questions "not in my survey"? I look foward to hearing from you. Regards,

9 years ago

Robert Stones replied to the topic Total Reponses Figure (Number) Per Question.

July 25 at 5:02 pm

Mav, With regards to the survey_response_details table, I have 30 entries - which I know includes some orphans, as again there should only be currently 18 to match the actual response figure I know is correct, as I've been following them via email notifications when a new one comes in and keeping a record etc. How do I delete the relevant one's from survey_response_details, as I cannot see - unlike in the survey_response table that I utilised in the previous reply, any form of ability to check a select box and delete the particular records I need to, which would then again leave the correct 18? Regards,

9 years ago

Robert Stones replied to the topic Total Reponses Figure (Number) Per Question.

July 25 at 4:42 pm

Maverick wrote: I guess there are still some orphan rows remained in db tables. do you see any rows in xxx_survey_response_details or xxx_survey_respponses table? Maverick, It would seem there were. Before this though and before I put the survey live at the start of this week, I made sure to go into the survey responses from within your component in my Joomla backend and deleted all of the entries there, as I thought that would do just fine (Now I know it seems not and you need to be proficient enough in PHPMyadmin also - maybe you need to look into this for future users, who want to utilise your great extension but don't have the PHPMyAdmin ability or access etc) Anyway, today I noticed there were 32 responses in the xxx_survey_responses table with 00:00:00 etc, so I knew they were one's that were orphan and left over from my pre live launch testing of the survey etc. If you see the 'Survey_Response_Issues.PNG' attached screenshot, it shows the orphaned one's being counted inside the admin component. So, deleted these from the above-mentioned database table, leaving the 18 responses that have actual times and dates included - as I know these are the 18 that are TRUE and the one's I want. Then I go back to the Joomla admin component, I see in this attached screenshot 'Survey_Response_Issues2.PNG' - the numbers finally tally as I should be expecting - again 18 responses and the total responses has now gone from the original 50. However, I now have a black screen in the admin component 'Responses' screen where I'd be expecting to see the 18 responses, that I'm then able to download via CSV, PDF etc but it's blank, as you can see in the attached screenshot 'Survey_Response_Issues1.PNG' I can still gain access to the wanted responses in some way, by again going to the above named ''Survey_Response_Issues.PNG' zone of the admin component and then clicking in to either the latest responses as seen in the 'Survey_Response_Issues4.PNG'. However, this means I can't download the responses in PDF individually etc and I can only access the 10 latest responses when I need to be able to access any and all that are submitted? I also used the in-built Joomla Database 'Fix' which hasn't made the survey responses appear back in the component listing. Cleared both Joomla Cache and my Browser, again nothing. It's very weird as it's showing the right number of responses now as in 18 but it's STILL showing a high number throughout the consolidated report, that lessen in total responses as you go further through the consolidated results page. I hope I've explained the above as best as possible. I look forward to your response.

9 years ago

Robert Stones created new topic Total Reponses Figure (Number) Per Question.

July 24 at 8:08 pm

Hi Mav, I was looking through my surveys combined results just now, to see how it's all looking and I know I have 15 respondents in the actual Survey component in my admin. I made sure any previous test submissions I did before the survey went truly live, I deleted and the number went to 0. However, if you take a look through the Combined Results page here... You will note the first question and answers it says they'res 27 Total Responses and the number of Total Responses falls as the survey gets further in, ending up with the last question on 16 Total Responses. Yet I made all questions Mandatory, so it forces the user to answer them. I can only think my pre-launch test submissions are still being counted, even though I deleted those test submissions. Any ideas as I really need the total response numbers to tally on these graphs, or I can't use any of it in my university dissertation.? Thanks.

9 years ago

Robert Stones replied to the topic Google's Recaptcha Big issue.

July 21 at 5:02 pm

Maverick wrote: hmm.. thats where a test site will help as we both work in different timezones. clone the site to a subdomain and we can safely work on it instead of doing some mistake on live survey. tools like akeeba backup would be really helpful. Anyway, I can check out the issue now. But it would be good to have the admin details so that I can enable, test and disable it immediately and the survey won't be interrupted for long. Let me know. Mav, Yes I agree with you r.e. the test environment but personally at this point I just unfortunately don't have the time to carry that out too but will in future when things calm down a bit. I will send you the login information via your 'Contact Us' as previously done. I will wait to hear from you in due course. Regards,

9 years ago

Robert Stones replied to the topic Google's Recaptcha Big issue.

July 21 at 10:23 am

Maverick wrote: I don't see any error, is it disabled? Mav, I waited for as long as I could but then figured we'd both need to sleep no doubt lol, so I had no choice but to disable it for the period while I wasn't around to deal with any people trying to take the survey and wouldn't be able to. Let me know here as soon as you're ready to look and I will enable it and you can take a look and then I can disable it again temporarily until I can find the fix. :) Regards,

9 years ago

Robert Stones replied to the topic Google's Recaptcha Big issue.

July 21 at 12:43 am

Maverick wrote: The component do not implement any custom captcha solution, it simply use Joomla captcha API. So if you have any third party captcha plugin which uses Joomla API (and can be set as default in global configuration) it should work just fine. reCaptacha plugin also has older implementation which may work with old browsers, try that instead. Mav, Thanks for the reply and the clarification above. I indeed decided to purchase and download the small fee but compatible with both new and older browser captcha plugin and I've installed it. I now have it set in Global Config as the sites default captcha, it is showing in my sites Registration page, my contact script tabs but it won't show on my surveys intro page. I'm sure I had this problem before and I can't for the life of me think how I managed to get Joomla's in built Google recaptcha. It is here... and you will need to click the Continue button to see it's there but hidden and returns the "Invalid captcha entered. error Regards, Rob

9 years ago

Robert Stones created new topic Google's Recaptcha Big issue.

July 20 at 9:30 pm

Hi Mav, I have had a couple of respondents email me to say they are stuck at the start page, where the Google Recaptcha 'I'm not a robot' is just spinning round. They advised me they were using IE 8 and 9 (All of my respondents will be using workplace computers and unfortunately part of the security prob of the world and net at large, is that company's don't upgrade to latest versions quick enough. Therefore I can't ignore their disgruntledness to not being able to take the survey. I then ran the start page in IE 8 and 9 and confirmed it does indeed just spin and not load the pictures part and hence they can't move on. However, I really don't fancy NOT having a captcha present as I need to reduce any risks to the quality of this surveys data, from the like of spam bots etc. Therefore, I notice in CSurveys 'Options' you can turn off the recaptcha but cannot select another 3rd party installed one. I have found this one and asked if it's compatible with IE 8 and 9 and indeed it is: https://idealextensions.com/joomla-extensions/securimage-captcha-plugin.html So is there any quick hack I can do to your extension, that would enable me to place this developers plugin in place of the google recaptcha on your surveys first page. See it here... I look forward to hearing from you. Regards, Rob

9 years ago

Robert Stones replied to the topic Save & Back Buttons no longer working?.

July 20 at 9:23 pm

Maverick wrote: You are using Survey form module. These buttons are shown in the component only. Use menu item to point to the surveys home page. If you are using private survey, create external url menu item with unique survey url. If you recall, I had some big problems when I was initially setting up this extension to run from a menu item and whilst we've now fixed those errors that were being produced, the survey is now live and I don't want to change things again in this way midway through from people responding to the survey. I note your explanation though and it will help me go back to menu item form of survey link, when i run any future one's from my site. Thanks,

9 years ago

Robert Stones replied to the topic Show survey page names at the top of each page.

July 20 at 9:20 pm

Maverick wrote: The page name was designed only for a unique identifier on few users request but never considered for shown on front-end. But yes, its a good idea to show it on front-end. I will add this feature in next revision. However you still can get such behavior using the page header question. Page header question type simply display title and description, nothing else. Maverick, Sorted, I used the page header you mention above. Thanks. Regards,

9 years ago

Robert Stones created new topic Show survey page names at the top of each page.

July 19 at 11:08 pm

Hi, I have searched the forums and the documentation for this but can't see to find anything to be able to try. I'd like to show the survey page names, on the actual live frontend survey at the top of each survey page questions. If you look at the attached screenshot, you will note the highlighted are top right... the 'Organisational Structure' for e.g. is what I need to show, not the page number, is this possible Maverick please and if so how? Currently it just looks to a responder that it's multiple pages made up of same or similar things, when actually it's not and is divided over very specific pages, that are page named and hence I need to show the page names but can't find an aption for this. I look forward to hearing from you in due course. Regards,

9 years ago

Robert Stones created new topic Save & Back Buttons no longer working?.

July 19 at 11:02 pm

Hi There, I don't have the Save and Back buttons working in my survey anymore and can't understand the reason why they're no longer showing but I do have them enabled within CS admin section. Can anybody shed any light on this please, you can see by going Here... I look forward to hearing from you. Regards,

9 years ago

Robert Stones replied to the topic End of Survey Redirect URL?.

July 17 at 1:28 pm

Maverick wrote: Usually the text editor will strip out all scripts as it is dangerous to allow them. However you can exclude yourself as super admin. 1. make sure you are allowed to add anything in the text filters of your global configuration. 2. Then on your Joomla editor, collapse the editor buttons by switching the toggle editor mode. 3. Now add your content and save. You should be able to save the scripts. If you still unable to save the scripts, try to use some third party extensions, check them on JED. I'm using my templates in built editor but it's well known for not stripping anything out, it's called RokPad from RocketTheme which is why I was surprised to have it stripping the javascript link code. I've actually managed to get the end of survey message to save and no strip a normal html link to the evaluation form, this will do for now as I don't have the time remaining to faff. :) I had also setup my other editor JCE to not strip, text filters as super admin etc as you rightly allude to above. Not to worry, the above temp fix will do for now thanks. Regards,

9 years ago

Robert Stones created new topic End of Survey Redirect URL?.

July 17 at 12:40 pm

Hi Mav, I have tried to load a JotForm link to an evaluation form I need people to take after the main survey, I'm trying to enter this into the "end of survey message" but the following portion keeps getting stipped out and hence it won't show; <script type="text/javascript" src="http://form.jotformeu.com/jsform/51966"></script> (removed some portions to stop the form being filled in, you never know lol) Is there ANY way I can include the above javascript line to the end of survey message Maverick please? I look forward to hearing from you in due course. Regards,

9 years ago

Robert Stones replied to the topic Error 100.

July 15 at 8:38 pm

Maverick, OK, this issue now seems to be solved, as I was searching deeper in to this forum and came across this topic: https://www.corejoomla.com/forum/support/community-surveys/14638-an-error-occurred-while-processing-your-request.html I noticed I had a blank page with no question, so I deleted it from the survey, cleared cookies n cache and took my survey... I now get the custom completion message and got an admin email to say a response had been received. *phew* Thanks for the above, this item is now solved and on lol. Regards,

9 years ago

Robert Stones replied to the topic Error 100.

July 15 at 5:53 pm

Maverick wrote: Hi, Can you please check now. I filled the survey and it went good. Hi Again, I have just taken the survey fully myself again AFTER adding the other threads language column in the database, however, I'm still getting the Error 100 at the end of the Survey. See attached screenshot. I also note that when you come to the very last question to answer, you input that answer and then hit the "finish" button, it doesn't happen straight away, it reloads the finish button with no mention the first time around that the survey is complete. So I hit the "finish" button a 2nd time around and that's when I get the error 100 red message. I also have an 'End or Survey' custom message included in the survey via the editor but when the above happens with the "finish" button, it clearly isn't getting past the error 100 to load the end of survey custom message and this is confusing people, as they could think it's finished when it's not, as it will not submit the responses at this point in to the back end of the survey component, so i have no responses to collect until this error 100 is fixed?

9 years ago

Robert Stones replied to the topic RC 1: Survey not found or invalid id in request..

July 15 at 5:47 pm

Maverick wrote: Probably a quick hack to this is create a column "language" in your table XXX_survey ALTER TABLE `f740w_survey` ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT '*'; I've done the above in phpmyadmin and I now see a language column in the XXX_survey table as per the screenshot.

9 years ago

Robert Stones created new topic Error 100.

July 14 at 2:28 am

Hi Maverick, My survey is now coming along, that I'm able to access it from the modules and so on. I've just tested the survey by filling it in, I selected "Finish" button at the end but then it takes me to an Error: 100 as you will see in the attached screenshot, do you have any idea what this is. It's only on my survey page, nothing else. Maybe if you can take the survey here, you will replicate it at your end. I look forward to hearing from you. Regards,

9 years ago

Robert Stones replied to the topic RC 1: Survey not found or invalid id in request..

July 13 at 4:25 pm

OK Maverick, I have relented due to the time constraints I'm currently under and I have decided to use the Community Survey Form module with its own custom module position. I've made a survey article, placed community survey form module with its custom module position into the survey article and finally used this to where I needed it via a menu item and the survey is now showing again. I still maintain there's a problem with using your component's 3 built-in Menu Items Types directly in a menu, and why shouldn't we as that's what menu item types are for. If you read the error string in full; ERROR: 1054 - UNKNOWN COLUMN 'I.LANGUAGE' IN 'ON CLAUSE' SQL=SELECT C.ID, C.ASSET_ID, C.ACCESS, C.ALIAS, C.CHECKED_OUT, C.CHECKED_OUT_TIME, C.CREATED_TIME, C.CREATED_USER_ID, C.DESCRIPTION, C.EXTENSION, C.HITS, C.LANGUAGE, C.LEVEL, C.LFT, C.METADATA, C.METADESC, C.METAKEY, C.MODIFIED_TIME, C.NOTE, C.PARAMS, C.PARENT_ID, C.PATH, C.PUBLISHED, C.RGT, C.TITLE, C.MODIFIED_USER_ID, C.VERSION, CASE WHEN CHAR_LENGTH(C.ALIAS) != 0 THEN CONCAT_WS(':', C.ID, C.ALIAS) ELSE C.ID END AS SLUG,COUNT(I.`ID`) AS NUMITEMS FROM F740W_CATEGORIES AS C LEFT JOIN F740W_CATEGORIES AS S ON (S.LFT <= C.LFT AND S.RGT >= C.RGT) OR (S.LFT > C.LFT AND S.RGT < C.RGT) LEFT JOIN (SELECT CAT.ID AS ID FROM F740W_CATEGORIES AS CAT JOIN F740W_CATEGORIES AS PARENT ON CAT.LFT BETWEEN PARENT.LFT AND PARENT.RGT WHERE PARENT.EXTENSION = 'COM_COMMUNITYSURVEYS' AND PARENT.PUBLISHED != 1 GROUP BY CAT.ID) AS BADCATS ON BADCATS.ID = C.ID LEFT JOIN `F740W_SURVEY` AS I ON I.`CATID` = C.ID AND I.PUBLISHED = 1 AND (I.LANGUAGE = '*' OR I.LANGUAGE = 'EN-GB') WHERE (C.EXTENSION='COM_COMMUNITYSURVEYS' OR C.EXTENSION='SYSTEM') AND C.ACCESS IN (1,1) AND C.PUBLISHED = 1 AND S.ID=21 AND BADCATS.ID IS NULL GROUP BY C.ID, C.ASSET_ID, C.ACCESS, C.ALIAS, C.CHECKED_OUT, C.CHECKED_OUT_TIME, C.CREATED_TIME, C.CREATED_USER_ID, C.DESCRIPTION, C.EXTENSION, C.HITS, C.LANGUAGE, C.LEVEL, C.LFT, C.METADATA, C.METADESC, C.METAKEY, C.MODIFIED_TIME, C.NOTE, C.PARAMS, C.PARENT_ID, C.PATH, C.PUBLISHED, C.RGT, C.TITLE, C.MODIFIED_USER_ID, C.VERSION ORDER BY C.LFT You can clearly see the (C.EXTENSION='COM_COMMUNITYSURVEYS' bit is mentioned, so maybe you need to look at that for your future version. However, for now I have it working as outlined above in the new module way, so there's no need to change anything for now. Regards,

9 years ago

Robert Stones replied to the topic RC 1: Survey not found or invalid id in request..

July 13 at 11:28 am

Maverick wrote: I am not sure where that message coming from, that sql is not from community surveys. can you please send me your website and admin user details using contact us form so that I can check it? Maverick, I've sent you the admin details via your contact us page - I've also included a bit of a better explanation that may help matters whilst you're looking through things. Update me just as soon as you can please. Regards,

9 years ago

Login Form