Deanos Tools Support - part 2

error instalation in d7.1

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--SET @iExtCat = (SELECT `id` FROM `sys_menu_admin` WHERE `name`='extensions' OR' at line 1

I am surprized no one has mentioned this yet.

That line is commented out in the install.sql file. But the syntax is wrong.

You can either remove those lines yourself from the install.sql file. There are 2 of them in the admin section of the install.sql that begin with --SET that have no SPACE after the two dashes. The missing space is whats causing the error.

Or you can just download a new copy of the tools from the market. I uploaded a fixed copy there.

Hello Deano,

I have recently been using your tool to log in as my members in order to assist with member profile corrections and the likes. I was asked to upload some pics for a member as they just cant quite understand how to do it himself.

When I logged on as him, I was not allowed to upload pics to his profile. Is this something that is not allowed when using your tools, or do I have an issue that i need to track down?

Thank in advance,

Mel

 Have to add some here. I've never tried that with his tool but I'm sure that it will not work.

I do suggest you read this topic, it cleared up most of my problems with members not knowing how to..

http://www.boonex.com/forums/topic/Encouraging-Members-to-Upload-Photos-on-a-Dating-site-.htm

There are some things that do not work. Mostly javascript related as the site while logged in as a user runs in a frame.

I was able to upload photos with no problems using the flash uploader. I had to refresh the page by hand after the upload was complete to see it. The regular uploader did not work at all.

But at no time did i receive a message stating i was not allowed to upload.

In cases where things don't work properly while logged in with the tools that way you will need to get the password from the member and log in normally.

Hi deano,

thank you for your effort making this tools, unfortunately when i try your tools its not working properly.. i m currently using 7.1.. 

thank you

The tools are running on hundreds of sites. And has been tested on 7.1. They work.

Make sure you have uploaded the proper version for 7.1 and that you properly uploaded it and all files were uploaded successfully.

Also. the words "Not working properly" does not tell me whats wrong. I need more details.

Thank you Deano for the advise. I had the "flash" loader disabled because until recently I didnt have an RMS installed and it didnt work right. I have been ableto upload the pics I needed uploaded and all is good in my world again.

As far as the uploader, I will look into it. It may just be something I can use, but who knows.

Mel

Server: CentOS 6, Nginx 1.2.0, PHP-FPM

I get the following two warnings.  Do you know if it is a PHP-FPM misconfiguration or do I need to make adjustments in the Tools script? Can you please advise me?

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /var/www/public_html/dolphin_site/modules/deano/deanos_tools/classes/BxDeanosToolsDb.php on line 185

Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /var/www/public_html/dolphin_site/modules/deano/deanos_tools/classes/BxDeanosToolsDb.php on line 186

That is not specific to the tools. Dolphin will return that error as well. Or at least it should be. May be in your logs somewhere. In any case. It's documented here in the forums. http://www.boonex.com/forums/topic/date-warning-after-upgrade-dolphin-7-0-8-to-7-0-9.htm or here http://www.boonex.com/forums/topic/Time-Zone-2012-10-13.htm

You need to set a time zone in your php configuration. Older versions of php never required this as it normally used what your operating system was set to. New versions of php require it be specifically set in the php configuration.

In /etc/php.ini add this.

date.timezone = "America/New_York"

Replace America/New_York with your proper time zone per this list. http://php.net/manual/en/timezones.php

Sorry to have bothered you on this.  Yes, I figured it out after posting here.  It is the difference from moving from shared hosting to a dedicated server where I am responsible for setting all the configuration in all the processes; a lot of this was done by the admins for the shared hosting account.  I am learning though and I do thank you for answering.

 I would like to make a comment to a post from previous page, created by:

richmanfl

 I've used richmanfl's ARIN page but it is not what I want or what I've expected to get.

I want more detailed IP address specifications like the one from whois.domain.com so I have alterd a code a bit (same line number as mention above and here it is:

$sCode .= ' <td><a href=" http://whois.domaintools.com/' . $sData['ip_address'] . ' " target="_blank">' . $sData['ip_address'] . '</a></td>';

Thanks to Deano for great mod and thanks to all the other kind people who are willing to spend the time to help others.

Regards

Mayki

I created a new page with Deanos Tools and added a php block with code in it. Everything is working fine but i only have a design question. When called from the profile menu, new pages by default use (or dolphin assigns it)

<table class="subMenuInfoKeeper" cellspacing="0" cellpadding="0">
<tr>
<td>
<img class="img_submenu" src="http://www.yoursite.com/templates/base/images/icons/bx_profile.png" alt="" />
</td>

instead of

<table class="subMenuInfoKeeper" cellspacing="0" cellpadding="0">
<tr>
<td>
<div class="thumbnail_block" style="float:left;width:70px;height:70px;">
<div class="thumbnail_image" style="width:68px;height:68px;">
.........

So switching between the profile menus items looks strange because on all standard ones the profile picture can be seen and on the created page it disappears and it only shows the bx_profile.png with the users name beside it.

Is it possible to inject some code somewhere to change this behaviour? I searched and searched but within the code of new php page blocks it is already to late to achieve this, because the page design code is already created by dolphin.

Sorry. Your question is beyond support for the tools.

The tools deals with blocks.

Your question is related to the page builder or menu builder in dolphin. This has nothing to do with the tools.

And nothing you put in the block will be able to change that.

You will need to start a topic in the forum for your version of dolphin describing your problem. And show screen shots.

Ooops you are right, custom pages are not created in your tool. It's from page builder. My mistake, too long time ago when i did this, sorry for that.

deano, is it compatible with 7.1.1 ?

Yes. The module has a 7.1.0 version included. It's not labeled specifically for 7.1.1 but it is compatible.

Something happened. I am using 7.1.x (latest version of dolphin) and have installed 1.8.4 folders pointing to 7.1 installs. I've had this mod for a long time with 1.8.3 and my host recently had some big server issues. Since the restore your module no longer works. Not sure if its related but here is the error message.

Warning: opendir(/home/www/mysite.com/tmp): failed to open dir: No such file or directory in /home/www/mysite.com/modules/deano/deanos_tools/classes/BxDeanosToolsModule.php on line 1178

Warning: readdir() expects parameter 1 to be resource, boolean given in /home/www/mysite.com/modules/deano/deanos_tools/classes/BxDeanosToolsModule.php on line 1180

Not sure if its helpful or not but I use PHP  5.4.0. So for this seems to be the only module that is not working anymore. I have went to the database to make sure the sql tables were created. I uninstalled 1.8.3 (in a broken state) and installed 1.8.4. and still the same thing.

 
Based on that error, your sites tmp folder is missing.

Server file restore did not bring that folder and .htaccess file.  Thanks. Its fixed now.  I swear a dedicated server is in my future. I use semi-dedicated right now.

Great mod but I have come across a couple of issues in IP Address Log.

The name and link in 'Nickname' came up as 'First Name' (so link didn't work) when I had First Name selected in Advanced Settings > Member display-name.

The IP link seems to go to a general DNS stuff page.

ie:
http://www.dnsstuff.com/tools/whois/?tool_id=66&token=&toolhandler_redirect=0&ip=98.160.217.19

Enter a couple of IPs and they show a sign-up page.

This one might be better:

http://www.infosniper.net/index.php?ip_address=98.160.217.19

 
I will look into the first issue.

As for the second one. That doesn't surprise me. I use free IP lookup sites, and every now and then they change how they work. I have had to change which one is used 3 times already in the past.

When using your tool to log in as a user, can it mess things up if I used it to try to do things like post to a timeline?

I can't seem to post from my timeline and I remember logging in as myself from your tool and trying to post to the timeline...I'm really frustrated and trying to think of anything I may have done to mess things up.

No.

There are some things that simply don't work due to being logged in through a iframe, such as uploads because the javascript redirect that occurs after the upload does not work in a iframe. But it cannot cause any damage. So the answer would be no.

My site has been upgraded from .9 to 7.1.4 and has been running for weeks, today I log in and get this Deano.

Fatal error: Call to a member function saveIP() on a non-object in /home/gaymenon/public_html/modules/deano/deanos_tools/classes/BxDeanosToolsAlerts.php on line 52

Thing is; the "Tools" module was uninstalled before I upgraded the site, it's still in the uninstalled list.

Only way that could happen is if one of the alerts for the tools is still present in the sys_alerts table.

Best to try installing and uninstalling again to make sure the alerts get removed.

But the 7.0.9 is a different version, so before reinstalling you need to download the latest version and upload the tools for the 7.1 version of dolphin.

 As I knew you would say that, I did, and problem is gone. Just strange I've been running .4 since release.

Was that in my cache somehow and in the database? 

Could have been in either.

If it was in the database but not in the cache, then that could have caused the delayed reaction as it would not have showed up in the cache until the proper cache file for the alerts got cleared and rebuilt.

 Understood; thanks for the super quick response as usual!

Hi I have a problem with Deano Tools 1.8.4 module wanted to copy block Quick Search of homepage in Wordmap page and displays only the head block can not copy this block?

Also tested calendar and displayed but I click above disappears?

thanks

 
Not sure what your doing to copy this blocks. You have me confused as Deanos Tools does not have a block copy feature, but my Block tools mod does. In any case, only about 5% of all of dolphins blocks can be copied and still work. So not sure what you expect me to do about it. It's not a malfunction of the mod. It's just the way it is with dolphins blocks.

Anyhow. The quick search on the home page is designed specifically for the home page. It does not even have php code that can be copied. Even my Block tools mod cannot copy it. So i don't even know how you could have done it.

As for the calender, if it don't work then it is page specific as well. Blocks from one page quite often do not work on other pages if they are expecting to find data only the original page has.

In any case, this is not a problem with the module so is out of the realm of support for the mod.

As always thanks Deano for their dedicated efforts and of course the free module.
looking for a way  *Quick Search* to copy it to other sites may be new page
built new pages but so far without success.
Any ideas would be appreciated.
Over time if I find a way to copy it put a forum topic.

Page Width: I can confirm that putting 100% actually works. Thank you Deanos!

Deano,

Issue: I can't use your tool to log in as a user. When I try, I get a white screen with the break frame header. I can click the link and go back to the admin panel.

Any thoughts?

Thanks,

Ace

A white screen as with any other place/page in dolphin means a php error is occurring and you have php on your server set to log errors instead of display them.

I cannot diagnose the problem without knowing the error that is occurring. So you either need to enable the php setting for display_errors in your servers php.ini file, or check your servers php logs for the error that occurs at the time you attempt to log in as a user.

Files for the tools could also be damaged. You could try re-uploading all of the tools files ensuring your FTP client uploads them in binary mode. Some FTP clients such as filezilla are junk and have been known to damage files.

Not much more i can do at the moment. The tools are a free module and is under development only when time permits.

I just install this great mod I two having problem with the IP link. But I made changes on the file under /modules/deano/deanos_tools/classes/BxDeanosToolsModule.php under line 1293 I change  this http://www.dnsstuff.com/tools/whois/?tool_id=66&token=&toolhandler_redirect=0&ip= to http://www.dnsstuff.com/tools#ipInformation|type=ipv4&&value=

and also add target="_blank" . see attach screenshot. This one works for me hope will work with others.

My boonex version is 7.1.4

Just a reminder to all the users who are updating to version 1.8.5.

Backup dbcs_ip_adress table or you will lose all the IP  visitors history . Not very kewl.

Or did I made some mistake whwn I upgraded from ver. 1.8.4 to 1.8.5?

Regards

Mayki

Perhaps your not aware that logging of guest ip addresses puts a strain of the server and database and slows down the website. And the bigger that table gets the slower it will also get. So removing it from time to time is actually a good thing.

Logging of guests was intended to be used for short periods of time when needed as a debugging tool. Not for continuous use.

It will actually be removed from future versions as it is no longer required. The current versions of dolphin has ip logging built in.

Thank you deano, I have edited my previous post.(Or did I made some mistake whwn I upgraded from ver. 1.8.4 to 1.8.5?)

(Gusest logging was set to off in my settings...)

It was something I did wrong because your tool did not return any IP logs. I will go thru the procedure once again later tonight.

Thanks for now.

Mayki

No. It will delete any logs when a module is uninstalled and reinstalled. Removal of table entries is part of uninstalling a module.

So yea, you can backup and restore the table if you need to keep them. I am just point out that your should not. The table needs to be cleared from time to time for performance reasons. Also dolphin now logs ip addresses itself, so mine is redundant and and waste of resources so will be removed from future versions.

Hello daeno,

I have tryed and installed v.1.8.5 again.

I partly agree with you. If I would know how to do it, I would do "dbcs_ip_address" table cleaning thru cron job = delete entries from table "dbcs_ip_address that older than x days/months...

You are saying: "Also dolphin now logs ip addresses itself" but does your tool uses this stored entries?

Regard

Mayki

No. My tools does not use dolphins list. The tools feature was added at time when dolphin was not recording them.

For current versions of dolphin, IP addresses are logged by dolphin as part of the ip-blacklist system. Located here. yoursite.com/administration/ip_blacklist.php?mode=list

Hi daeno,

thanks for your quick reply. I know where I can see IP addresses stored by Dolphin.

The size of dbcs_ip_address is aprox. 2M  (30,219 lines)

How would one manualy do the SQL query to delete IP entries from dbcs_ip_address older the lets say 30 days?

Kind regards

Mayki

This query will delete records older than 30 days.

DELETE FROM `dbcs_ip_address` WHERE `time_stamp` < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 DAY))

Thank you very much daeno!

I've changed 30 to 180 that is a query respond:

16205 rows deleted. (Query took 0.1055 sec)

dbcs_ip_address dropped from 2MB in size,  30,219 lines to 910.6 KB in size,  14,036 lines .

I have a suggestion to change the code in your tool so that when in "IP Address Log" the nickname of member is

clicked it opens in new window not in the same one like it is now.

I've changed the file

line 1286 from:

$sCode .= ' <td><a href="' . BX_DOL_URL_ROOT . $sData['nick_name'] . '">' . $sData['nick_name'] . '</a></td>';

to:

$sCode .= ' <td><a href="' . BX_DOL_URL_ROOT . $sData['nick_name'] . ' " target="_blank">' . $sData['nick_name'] . '</a></td>';

just a suggestion.

Kind regards

Mayki

 Correct me if I'm wrong so I just copy "DELETE FROM `dbcs_ip_address` WHERE `time_stamp` < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 DAY))" without the quote  and paste to Deanos Tools > SQL Query Tool? I'm using 1.8.5

Not working with 7.2.0 got this error message :

Fatal error: Call to undefined method BxDeanosToolsInstaller::addExceptionsFields() in public_html/Dolphin/modules/deano/deanos_tools/install/installer.php on line 27

Regards,

Ferry

 
I will check into it as soon as i can. Free modules are at the bottom of my test list.

Free modules = everyone has them, so they shouldn't be at the bottom? I can't even uninstall the one that's on my site now that's not working.