[Resolved] SQL module and Cron job issues.

[Teja MajetyModeratorTopics: 12Replies: 204Total Posts: 216]

Hi,

I think that somehow working but I think, even if there is restriction we can still view saved queries and copy and paste them in the query interface.

I am actually customising some of the things here like profile, online application and change of address form etc, I want to change/redirect the index.router and myet.router to “custom-routers” folder. I tried changing it in “custom router plugin” but not successful.

Is there any way that I can change the router like person router is mentioned as  nae_router filter in the custom plugin, so what I couldn’t find the present filter name for index.router and myet.router.

I have attached some of the documents I have prepared, I am not sure they are gonna be useful. Can use some tips!!

 

• This reply was modified 4 years, 9 months ago by  Teja Majety.

Attachments:

You must be logged in to view attached files.

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 638Total Posts: 642]

Cron will not purge those logs unless they are more than 20 or 30 days old (can’t remember which at the moment). But keep an eye to see which screen generates that warning. I don’t have such errors, but my setup has been updated quite a bit.

Yes, you can upload your zipped docs here.

Open each of the files in app/views/sql and replace the tabs heading with this:

<?php if(function_exists('savedquery_module') && hasPermission('execute_saved_query')) : ?>
<!-- Tabs Heading -->
<div class="tabsbar">
 <ul>
 <li class="glyphicons database_lock"><a href="<?=get_base_url();?>sql/"><i></i> <?=_t( 'SQL Interface' );?></a></li>
 <li class="glyphicons disk_save active"><a href="<?=get_base_url();?>sql/saved-queries/add/" data-toggle="tab"><i></i> <?=_t( 'Create Saved Query' );?></a></li>
 <li class="glyphicons disk_saved tab-stacked"><a href="<?=get_base_url();?>sql/saved-queries/"><i></i> <?=_t( 'Saved Queries' );?></a></li>
 <li class="glyphicons send tab-stacked"><a href="<?=get_base_url();?>sql/saved-queries/csv-email/"><i></i> <span><?=_t( 'CSV to Email' );?></span></a></li>
 </ul>
</div>
<!-- // Tabs Heading END -->
<?php endif; ?>

I could have sworn this was fixed long ago, but it might have been mistakenly overwritten. Pay special attention to <li class="glyphicons disk_save active">, which determines which tab is active.

• This reply was modified 4 years, 9 months ago by  Joshua Parker. Reason: Updated info about active tabs

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Teja MajetyModeratorTopics: 12Replies: 204Total Posts: 216]

This reply has been marked as private.

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 638Total Posts: 642]

You can pass them along with any screenshots you have, and I will add them. In the meantime, I will come up with a list of ones that need added and/or enhanced.

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 638Total Posts: 642]

I will add that to a list of things that needs fixing. It was hard to read the error log, so I missed that one. Do you know what screen is generating that error. If the error is generating anytime a screen is accessed, then the issue is with a file that is always loaded. The _h() function is complaining about an array that is being passed to it when it should be a string.

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Teja MajetyModeratorTopics: 12Replies: 204Total Posts: 216]

This reply has been marked as private.

You need to login in order to like this post: click here

[Joshua ParkerKeymasterTopics: 4Replies: 638Total Posts: 642]

With regards to saved queries, you are missing the following permission execute_saved_query. With regards to db errors, is the installation you’re working on not connected to internet in someway, or you have internet issues? It seems as though it’s is having difficulty connecting to gravatar.

BTW, I haven’t forgotten about you helping with docs and forums. I am 95% finished with what I need to do.

Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaign

You need to login in order to like this post: click here

[Teja MajetyModeratorTopics: 12Replies: 204Total Posts: 216]

Hi,

Recently I have come across some strange issues with SQL module and Cron job handlers.

I can’t get into CSV-email report page, it always redirects to dashboard. I didn’t create any redirects for that but for some reason, it always redirects to dashboard.

Even in “SQL Interface” when a saved query is selected it supposed to show/load the code to run but when I select a saved query it gives me nothing. I mean it doesn’t load the saved query.

For the past few days, none of the Cron job handlers seems to be running, I checked with the master Cron job that seems to be fine, but it’s running empty none of the Cron jobs that I have created in eduTrac are not.

When I click on “run” on any Cron job it just gives me “cronjob already running”.

I tried to install SQL module again but that didn’t help, I rebooted the server and stopped the server and start again after few minutes none of them has worked.

I am not sure about this, but there are so many DB errors in “error_logs” around 3K and i could see mostly only 1 type of error “htmlspecialchars( )”.
<pre class=”lang:default decode:true” title=”error logs in system snapshot”>E_WARNING htmlspecialchars() expects parameter 1 to be string, array given /var/www/html/app/functions.php 24
E_WARNING getimagesize(http://www.gravatar.com/avatar/c2188717b11512d51b981df11132e3c1?s=200&amp;d=mm&amp;r=g): failed to open stream: HTTP request failed! HTTP/1.1 503 Backend fetch failed /var/www/html/app/functions/hook-function.php 1399

I would really appreciate if there is any way that I can solve these issues without reinstalling everything. I have backups anyway.

Thanks

You need to login in order to like this post: click here