vb.org Archive
Page 17 of 23 « First 71516 17 1819 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Forum Home Enhancements - Track Guest Visits (https://vborg.vbsupport.ru/showthread.php?t=131314)

Paul M 09-19-2007 02:42 PM
Quote:
Originally Posted by GateKeper (Post 1342432)
Not sure but we were getting a lot of these message's yesterday



I think it was because in those few moments I did not setup the permissions in the user group manager, but I cannot confirm this was the reason, as one of the other Admins, did a restore of a previous backup, and the messages went away, this did not affect the installation of this hack, as it's still on and running, however no one is reporting the above error messages anymore, current version of hack is running, user group permissions are all done....

so not sure still as to why...

any thoughts ?
The first test version (V1.18, R1.23) had a primary key on the guestviews table, it was removed in the next test version. If you upgraded from the first test version direct to 1.19 then you would get those errors. Uninstalling and then reinstalling the modification would fix it.

Paul M 09-19-2007 02:45 PM
Quote:
Originally Posted by jluerken (Post 1342288)
Hi PaulM,

with version 1.19 I get a MySQL Error when clicking on a Spider link
(misc.php?do=guestlist&type=Visitors)

Database error in vBulletin 3.6.8:

PHP Code:
Invalid SQL:

        SELECT COUNT(dateline) AS count, guest.* 
        FROM vb3_guest AS guest
        LEFT JOIN vb3_guestviews as guestviews
        ON (guest.guestid = guestviews.guestid AND guestviews.dateline > 1190098883)
        WHERE lastactive > 1190098883 AND spider = ''
        GROUP BY guestid 
        ORDER BY lastactive DESC 
        LIMIT 1000;

MySQL Error  : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
Error Number : 1267 

That's an issue with your tables. Mysql has created them with different collations, you need to edit one to match the other (in phpmyadmin).

djbaxter 09-19-2007 03:42 PM
Quote:
Originally Posted by Paul M (Post 1342461)
If your XML says 1.17 then you have the wrong version, the XML uploaded says 1.19.
The xml indicates 1.19 as the version:

Code:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- $Header: d:\cvs/3.6/Track-guests.xml,v 1.19 2007/09/01 14:38:57 pem Exp $ -->
<product productid="paulm_20061109" active="1">
        <title>Guest Tracking</title>
        <description>Track Guest Visits</description>
        <version>1.17</version>       
                <url/>
        <versioncheckurl/>
        <cvs><![CDATA[$Revision: 1.19 $]]></cvs>
        <dependencies>
                <dependency dependencytype="vbulletin" minversion="3.6.0" maxversion="3.6.99" />
        </dependencies>
        <codes>
                <code version="*">
                        <installcode><![CDATA[
// Start v1.13 //
Addendum:

Never mind. That must have been the beta version. I apparently downloaded but didn't unip the 1.19 release version. :o

Paul M 09-19-2007 04:11 PM
Ignore the Revision number - that's just my local CVS tracking - the Version is what's important - so the example above was Version 1.17. :)

djbaxter 09-19-2007 04:38 PM
OK. See my Addendum above. I had downloaded but neglected to unpack the latest version. I've now corrected that, uninstalled the o0ld version and installed the new version, and everything is as it should be. :)

GateKeper 09-19-2007 05:49 PM
Quote:
Originally Posted by Paul M (Post 1342467)
The first test version (V1.18, R1.23) had a primary key on the guestviews table, it was removed in the next test version. If you upgraded from the first test version direct to 1.19 then you would get those errors. Uninstalling and then reinstalling the modification would fix it.
I have completely redone the work, un-installed and reinstalled, will let you guys know if anymore error messages are sent....

Thanks

DieselMinded 09-19-2007 10:30 PM
Mr. M

How Do I Get the Most Ever Visitors Online Thing Likes in the Screen Shot?

Thanks

Paul M 09-19-2007 11:36 PM
You look in my profile ....... and suddenly notice this ;)

Most ever Members, Posters, Guests and Chatters

DieselMinded 09-20-2007 01:43 AM
Thanks
/me Clicks installed 2 times today
Members Rejoice

GateKeper 09-20-2007 03:47 AM
Quote:
Originally Posted by GateKeper (Post 1342577)
I have completely redone the work, un-installed and reinstalled, will let you guys know if anymore error messages are sent....

Thanks
Still problems, still getting error email's like the one below

Quote:
Database error in vBulletin 3.6.5:

Invalid SQL:

INSERT INTO guestviews
(guestid, forumid, threadid, dateline, ipaddress)
VALUES
('c4007f4e8d7ec5f39552297f33487eed', 0, 0, 1190219076, 'xx.xx.xx.xx');

MySQL Error : Duplicate entry 'c4007f4e8d7ec5f39552297f33487eed-0-0' for key 1 Error Number : 1062
Date : Wednesday, September 19th 2007 @ 04:24:36 PM
Script : http://www.ftaview.com/index.php
Referrer :
IP Address : xx.xx.xx.xx
Username : Unregistered
Classname : vb_database
I did an uninstall of the hack, I installed the latest version, and I get the errors, I once again removed it, and tried to go back to an older version, ended up with even more errors in the user group manager area, it had the guest tracking permissions, with just the radio buttons but no descriptions, so I removed everything again, installed the latest again and have disabled the hack to see if I get anymore messages, if none, I will enable the hack tomorrow and see if errors come in again....

.

rjmjr69 09-20-2007 04:44 AM
I do not see any product file in the zip?

Paul M 09-20-2007 11:12 AM
Quote:
Originally Posted by GateKeper (Post 1342868)
I did an uninstall of the hack, I installed the latest version, and I get the errors, I once again removed it, and tried to go back to an older version, ended up with even more errors in the user group manager area, it had the guest tracking permissions, with just the radio buttons but no descriptions, so I removed everything again, installed the latest again and have disabled the hack to see if I get anymore messages, if none, I will enable the hack tomorrow and see if errors come in again....

Uninstalling it should have dropped the old table, I can't see why it wouldn't have. I guess you could uninstall it and then check, dropping the tables manually if necessary.

You are obviously not going to get any errors if it's disabled, so I'm not really sure what your objective is there.


Quote:
Originally Posted by rjmjr69 (Post 1342892)
I do not see any product file in the zip?

There are only two files in the zip, since one is the bitfields file that doesn't really leave a lot to choose from - so I don't see how you cannot see it :confused:

GateKeper 09-20-2007 07:48 PM
Quote:
Originally Posted by Paul M (Post 1343071)
Uninstalling it should have dropped the old table, I can't see why it wouldn't have. I guess you could uninstall it and then check, dropping the tables manually if necessary.

You are obviously not going to get any errors if it's disabled, so I'm not really sure what your objective is there.
Well no errors, since the hack has been disabled, did it this way to make sure it was not something else. (something I might have done :D)

I will now enable once again tonight and see if errors come back if so, I will be confident its the hack ?, not saying anything bad about the hack, just that it is giving us errors, and I am not sure why, will need to investigate further.

Paul M you mention dropping the tables manually,,,,,how do I do this ? please advise if possible, still learning, and trying....

thanks for the time...
:up:

DieselMinded 09-20-2007 08:01 PM
phpmyadmin and delete the tables for this mod if there still there after the uninstall

Redlee 09-20-2007 08:41 PM
Ok I'm a newbie, I installed this last night works fine I believe. Only thing I need to know is my CMPS page is what I want to track. It is tracking my forumhome but thats not my home page. :confused: Do I need to change the page name thats being tracked? Where do I find that? :)

asw 09-20-2007 10:20 PM
Update installed and working perfectly on 3.6.8

Many thanks - :up:

Coleccromos 09-21-2007 09:52 PM
Is it possible that this modification of problems with the database of this type?

Database error in vBulletin :

mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: User athletic already has more than 'max_user_connections' active connections
/hermes/web10/b758/pow.cromosdefutbol/htdocs/forum/includes/class_core.php on line 273

Paul M 09-21-2007 10:29 PM
Nope, that's general server/mysql problem - specifically, you have too many connections to mysql.

Mrdby 09-22-2007 01:48 AM
Works Fine For Me

DPtheGod 09-22-2007 05:02 PM
Hello, I downloaded this and put it on my forum, but nothing shows up. I have the Master Enable set to yes, and have made all admins and super moderators able to see it, yet none of us can see anything. I have done everything correctly accordingly as per instructions, but still nothing. Could this be an issuewith the templates and other mods on the forum?

Paul M 09-22-2007 05:12 PM
Yes, looking at your site, it's an issue with your custom style.

Go into the modification settings, you will see a setting for the comment searched for in the forumhome template ;

Change yours to <!-- end what's going on box -->

BadgerDog 09-22-2007 09:04 PM
Hi Paul ... :)

I've been running v1.17 without any problems....

I've just upgraded to v1.19 and I no longer see the guest display at the bottom as previously under v1.17. I checked the AdminCP options and it is ON and I never touched any of the defaults that were there from v1.17.

The install went fine (overwrite with no errors) and it is active, as is all of the plugins for it .....

Any idea why it would stop working?

Thanks

Regards,
Badger

Paul M 09-22-2007 09:17 PM
Did you follow the install instructions ?

BadgerDog 09-22-2007 10:00 PM
Quote:
Originally Posted by Paul M (Post 1344822)
Did you follow the install instructions ?
Well, as I said, I've been running v1.1.7 just fine...

I downloaded the Zip file ...
I unzipped the zip file which contained two XML's.
I uploaded the bitfields file to my ../includes/xml folder.
I imported the product XML (using overwrote) into vB using the ACP Product Manager.

I missed this one ... :o "check permissions in the usergroup manager".....

Running now... thanks for the enhancements.... :up:

Regards,
Badger

KURTZ 09-23-2007 07:27 PM
updated!

wizardan 09-23-2007 10:05 PM
Updated.
Flawless.

Makc666 09-24-2007 11:36 AM
Quote:
Originally Posted by BadgerDog (Post 1344815)
Hi Paul ... :)

I've been running v1.17 without any problems....

I've just upgraded to v1.19 and I no longer see the guest display at the bottom as previously under v1.17. I checked the AdminCP options and it is ON and I never touched any of the defaults that were there from v1.17.

The install went fine (overwrite with no errors) and it is active, as is all of the plugins for it .....

Any idea why it would stop working?

Thanks

Regards,
Badger
Quote:
Originally Posted by Paul M (Post 1344822)
Did you follow the install instructions ?
I also didn't see guest display after I have updated from 1.16 to 1.20.
To fix this one I had to go to "Usergroup Manager" and to resave information of the needed gropus. I didn't touch "Can View the Guests Visited Display". Just resaved.

A little note fot the next version.

I think we didn't need dot(s) after these phrases:
Code:
trg_display
Can View the Guests Visited Display.

trg_list
View Guest Visits List.

trg_permissions
Tracking Permissions

trg_track
Can View Guest Tracking Data.

trg_viewip
Can View Guest IP Addresses.
And a liittle question:
What does it meen:
Code:
Viewing Who Posted in <a href='showthread.php?t={1}'>{2}</a>
Where does that "Who Posted" situated? Can you give an example URL?

Thanks
Maxim

Paul M 09-24-2007 12:10 PM
Quote:
Originally Posted by Makc666 (Post 1345911)
To fix this one I had to go to "Usergroup Manager" and to resave information of the needed gropus. I didn't touch "Can View the Guests Visited Display". Just resaved.

Yep, that seems to be a vb issue, it doesn't pick up the permissions properly until you edit one. For the next release, no permissions will be set on install, forcing you to set some.

Quote:
Originally Posted by Makc666 (Post 1345911)
I think we didn't need dot(s) after these phrases

Well you're free to edit them if you want, I see no real issue with full stops. :)

Quote:
Originally Posted by Makc666 (Post 1345911)
What does it meen:
Code:
Viewing Who Posted in <a href='showthread.php?t={1}'>{2}</a>
Where does that "Who Posted" situated? Can you give an example URL?

https://vborg.vbsupport.ru/misc.php?...osted&t=131314

GateKeper 09-25-2007 02:18 AM
Quote:
Originally Posted by GateKeper (Post 1343353)
Well no errors, since the hack has been disabled, did it this way to make sure it was not something else. (something I might have done :D)

I will now enable once again tonight and see if errors come back if so, I will be confident its the hack ?, not saying anything bad about the hack, just that it is giving us errors, and I am not sure why, will need to investigate further.

Paul M you mention dropping the tables manually,,,,,how do I do this ? please advise if possible, still learning, and trying....

thanks for the time...
:up:
Well it crapped out our site, so I disabled it, not going to run it anymore, also if I try to remove it, I get other errors, so for now it will stay installed but not enabled.

I wish I could figure out why I have the issues, but I am not that great with the VB stuff so for now it will remain n the background, and disabled

Thanks

Paul M 09-25-2007 06:58 AM
Clearly you have some issue local to you. Without appropriate access I cannot help you further.

BadgerDog 09-25-2007 11:57 AM
Hi Paul.... :)

Just for clarity...

Quote:
You can get an improved Spiders Definition file, that recognises many more spiders, from this post.

Note: For Spider detection to work you must set Enable Spider Display to 'Yes' in vBulletin Options > Who's Online Options.

If I simply turn ON the "Enable Spider Display" option and then IMPORT the XML file shown in your external link that has the extended spider indentification list, will that get this extra capability going?

Thanks ...

Regards,
Badger

Paul M 09-25-2007 07:52 PM
You have to replace the vbulletin supplied spiders definition file with the one in that post (the vb file is called spiders_vbulletin.xml and is located in the ../includes/xml folder). You can either copy/paste the contents, or just rename the extended file and overwrite the vb file.

BadgerDog 09-25-2007 09:39 PM
Thanks Paul ... :up:

Did that and it's now running fine with the additional reporting....

Regards,
Badger

msalman 09-27-2007 04:54 PM
there seem to be problem with bitfields, i installed it and i don't see any permission fields in each user group?

Paul M 09-28-2007 07:01 PM
Did you upload the file, to the correct place (first) ?

msalman 09-30-2007 02:44 PM
^sorry, for some reasons, the hack was disabled. It is working now, thanks!

Jay-MOB 10-03-2007 10:37 AM
Hello,

I have a custom style on my forum, my vbulletin is 3.6.8

I have tried to change the custom code in the adminoptions to something else as well, however it was still not showing it.

Any help?

Paul M 10-03-2007 12:05 PM
Without access to your forum there is nothing I can do to help you.

Jay-MOB 10-03-2007 05:43 PM
<a href="http://www.internationalmedics.org" target="_blank">www.internationalmedics.org</a>

here you go mate!

Jay-MOB 10-03-2007 06:30 PM
Ah never mind turned cybernetec off, and then track visits on, and then cybernetec on and voila it was working!!!


All times are GMT. The time now is 07:10 PM.
Page 17 of 23 « First 71516 17 1819 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02183 seconds
  • Memory Usage 1,852KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (1)bbcode_php_printable
  • (17)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete