vb.org Archive
Page 5 of 14 « First 34 5 67 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vB3 Boardstatistic Version 2 (https://vborg.vbsupport.ru/showthread.php?t=66783)

oldfan 08-10-2004 03:47 PM
Quote:
Originally Posted by oldfan
vB3statistik_browser_os
vB3statistik_domain
vB3statistik_einstellungen
vB3statistik_laender
vB3statistik_log
vB3statistik_referer
vB3statistik_spider
vB3statistik_zaehler

are installed. if that helps

bump

JBB 08-10-2004 05:39 PM
Ive just installed the hack but I cant find anywhere in the admincp, a link to administer this hack? Anyone know why please?

Smitty 08-10-2004 06:03 PM
Quote:
Originally Posted by oldfan
bump
Sorry - I don't get by here that often. Ummm, I looked and in your error it has a table prefix of "bbs." Your script is calling tables with that prefix.

As for your tables list, it has the correct 8 tables installed by this 'hack'.

I can't remember the details - I'm jut an old guy keeping my forum online - I'm not php and mysql savvy - but that is the issue, or so it appears. I know this issue came up with some other folks and I thought it came up in this thread earlier.

As I remember there's a 'switch' or something for those installing with and without the table prefix.

If you look at the post I made just below this one there is an attachment which shows the tables on the far left. Note: none have the bbs. prefix.

Smitty 08-10-2004 06:06 PM
Quote:
Originally Posted by JBB
Ive just installed the hack but I cant find anywhere in the admincp, a link to administer this hack? Anyone know why please?
Did you edit the admincp file? I can't remember which frame it is in, but you have to put the code in that file for it to list in the adminCP.

turbidblue 08-11-2004 02:24 AM
I am getting this error:

Database error in vBulletin 3.0.3:

Invalid SQL:
SHOW TABLE STATUS
FROM turbidblue_com_-_1
LIKE 'pm'

mysql error: You have an error in your SQL syntax near '-_1
LIKE 'pm'
' at line 3

mysql error number: 1064

any help??

turbidblue 08-11-2004 10:57 PM
booost in hopes someone can help me out! i really need this for my forum!

thanks in advance ;)

oldfan 08-11-2004 11:16 PM
I've remove this script for the 2nd time now :(
I wish someone would rewrite it, because its a awesome addon :)

turbidblue 08-11-2004 11:49 PM
I tried to manually run the query in PhpMyAdmin and I got this error:

SQL-query :

SHOW TABLE STATUS FROM $dbname LIKE 'pm'

MySQL said:

Can't read dir of './$dbname/' (Errcode: 2)

???

please help!

we_are_borg 08-13-2004 06:50 AM
I have a little problem with the script.

I have Vb 3.0.3 installing was no problem i encountered one small problem with the prhases but that is solved by reading this thread.
I have done everything in the readme file but the statistic will not show, but http://forum.ffdungeon.info/statistik.php is working well. I have made the change to phpinclude_start but it still not work, all edits are checked but i can't get it to work.

Razz 08-14-2004 01:30 AM
Has anyone managed to cure the width issue yet? I use a fixed width site and this hack breaks the layout :(

Even on a full screen style, this hack throws up scrollbars.

Any clues?

Blam Forumz 08-16-2004 05:01 AM
/me installs this uber hack

Dennis01 08-16-2004 04:05 PM
Installed with alle mentioned problems and more.. but sure worth the trouble.
However I have a few problems with browser/os, country's and referer/domains they all do display correctly but all stay empty, it seems the database doesnt get any input about these.

Does anyone have a clue where to start looking whats wrong?

tia

ogden2k 08-16-2004 09:05 PM
Not bad of a hack. I only want to OS and browser option. Is ther a hack that shows just that type of information?

oldfan 08-16-2004 09:30 PM
I see the zip file was updated, this mean the mysql was corrected?

Nitesh 08-17-2004 10:50 AM
Hack looks really good but I just need to know how it affects serverload? Has anyone installed it on big boards (1 million posts+)?

Thank you :)

oldfan 08-19-2004 02:32 PM
ARrrrr...
Ok I've this is my third attemped at this install :(
I've followed the install word for word..

When run the install, I get this error
Quote:
Database error in vBulletin 3.0.3:

Invalid SQL:
INSERT INTO statistik_einstellungen VALUES (0, 900, '', 10, 10, 10, 5, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10)

mysql error: Table 'bbs.statistik_einstellungen' doesn't exist

mysql error number: 1146

Date: Thursday 19th of August 2004 08:30:29 AM
Script: http://xxxxxxxxxxx/admincp/install_s...ik_english.php
Referer: http://xxxxxxxxxx/admincp/install_statistik_english.php
can someone help me get this addon running :)

Smitty 08-20-2004 08:39 AM
Note that the error is:

mysql error: Table 'bbs.statistik_einstellungen' doesn't exist

Note the bbs. prefix on the database table that is being called. I'm not sure where in this thread, and it's late so I'm not prepared to read back through, but I'm sure this is addressed somewhere in the thread. I think it was addressed a page back as well.

oldfan 08-20-2004 02:42 PM
the tables I have install are;
vB3statistik_browser_os
vB3statistik_domain
vB3statistik_einstellungen
vB3statistik_laender
vB3statistik_log
vB3statistik_referer
vB3statistik_spider
vB3statistik_zaehler

I've search this thread high and low, I cannot find a fix for the table errors :ermm:

Maybe the author of this mod can shed some light on this problem

Quote:
Originally Posted by Smitty
Note that the error is:

mysql error: Table 'bbs.statistik_einstellungen' doesn't exist

Note the bbs. prefix on the database table that is being called. I'm not sure where in this thread, and it's late so I'm not prepared to read back through, but I'm sure this is addressed somewhere in the thread. I think it was addressed a page back as well.

oldfan 08-20-2004 02:47 PM
Is this the fix your talking about?
I don't understand
* you should change "vB3_" with your table prefix
Would I have to change all other prefixs for my other mods?
sorry, its abotu confussing to me.
thanks for your help

Quote:
Originally Posted by aHMET
Brian here is the final step (3) you should manually do it from a MySQL Manager

* you should change "vB3_" with your table prefix
* you should change "statistik_zaehler" to "tableprefix + statistik_zaehler"

and there is a fixed statistik.php
I just fixed the problems that I faced
If you have much problems please inform

* this is a very good script but author was drunken while coding hehe :)

oldfan 08-20-2004 10:41 PM
i got it running, but I still have to database errors :(
http://bbs.metallifukinca.com/statistik.php

oldfan 08-21-2004 12:21 AM
jesus murphy...
nothing but database errors, I've run 100's of installs and never had this many problems
/me clicks un-install again

integra99 08-21-2004 06:30 AM
I installed this hack the first time, no problems.

oldfan 08-21-2004 03:08 PM
I've found out its not working for me because my prefix is vB3 not vB3_, the installer doesn't recognize other prefixes. :(

Onkel_Tom 08-21-2004 07:51 PM
Okay, here we go....

I'm using this hack also on my Forum and do some bugfixing in the german vBulletin Forum for this hack. I saw this thread here in at vBulletin.com yesterday night and found a lot of questions, problems and db errors, so I decided today to do a complete rework of this hack from my installed german version to a new english Version.
I worked now 8 hours on this hack and hope that most of the bugs are fixed ;)

All changes from this forum and also from the german one are implemented in my new version.
So I also will give further support for this hack if using my new files for install.

Please read the installation instruction to see what is changed and work carefully through it to get this hack work.

have fun

@ oldfan
the name of the tableprefix is defined in the file config.php with $tableprefix, so the install script only reads the prefix name from there and installs your tables like that name.


After additional 6 hours with installing this hack in a new Testboard I found again several bad translations and also again some german words ;)
Also 2 db queries has wrong syntax for prefixed tables again !

If you found misspelling or bugs please let me know that I can fix the download.

for a updated zip file please look some posts later ;)

iceman-x 08-22-2004 01:58 PM
I keep geting the same problem over and over.

Code:
Database error in vBulletin 3.0.3:

Invalid SQL:
INSERT INTO statistik_einstellungen VALUES (0, 900, '', 10, 10, 10, 5, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10)

mysql error: Table 'xxxxxx_xxxxx.statistik_einstellungen' doesn't exist

mysql error number: 1146

Date: Sunday 22nd of August 2004 07:54:20 AM
Script: http://www.xxxxxxx.xxxxxxxxxx.com/admincp/install_statistik_english.php
Referer:
mysql error: Table 'xxxxxxx_xxxxx.statistik_einstellungen' doesn't exist

Yes i have downloaded the new versjon of the Onkel_tom fix.

thanks for any help.

Ian Emu-UK 08-22-2004 02:04 PM
Quote:
Originally Posted by Onkel_Tom
Okay, here we go....

I'm using this hack also on my Forum and do some bugfixing in the german vBulletin Forum for this hack. I saw this thread here in at vBulletin.com yesterday night and found a lot of questions, problems and db errors, so I decided today to do a complete rework of this hack from my installed german version to a new english Version.
I worked now 8 hours on this hack and hope that most of the bugs are fixed ;)

All changes from this forum and also from the german one are implemented in my new version.
So I also will give further support for this hack if using my new files for install.

Please read the installation instruction to see what is changed and work carefully through it to get this hack work.
Thanks Onkel_Tom, used your fixed version and it's fine.

I still get a problem with the bit "like 'pm'" saying invalid SQL, but it works fine if I comment that bit out.

Onkel_Tom 08-22-2004 04:43 PM
@ Ian Emu-UK

Which PHP Version do you have ? < 3.23 ?
The Show Table syntax is working from V 3.23 and higher:
SHOW TABLE STATUS [FROM db_name] [LIKE 'pattern']

You can also have a look at http://dev.mysql.com/doc/mysql/en/SH...LE_STATUS.html to read the documentation of MySQL


@ iceman-x

You are right ! There was again a table prefix missing in the install script "install_statistik_english.php"
Search for:
Code:
INSERT INTO statistik_einstellungen VALUES (0, 900, '', 10, 10, 10, 5, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10)
and replace it with:
Code:
INSERT INTO " . TABLE_PREFIX . "statistik_einstellungen VALUES (0, 900, '', 10, 10, 10, 5, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10)
or just download the updated zip file 3 posts before ;)

Ian Emu-UK 08-22-2004 05:45 PM
Quote:
Originally Posted by Onkel_Tom
@ Ian Emu-UK

Which PHP Version do you have ? < 3.23 ?
The Show Table syntax is working from V 3.23 and higher:
SHOW TABLE STATUS [FROM db_name] [LIKE 'pattern']

You can also have a look at http://dev.mysql.com/doc/mysql/en/SH...LE_STATUS.html to read the documentation of MySQL
PHP is 4.3.2 on the server.

Looking at the error message, it might be because the host has put an - in the database name. (In truth I have no idea though as I know very little about SQL)

Code:
Invalid SQL:
        SHOW TABLE STATUS
        FROM total-em_forum
        LIKE 'pm'
 
mysql error: 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 '-em_forum
        LIKE 'pm'' at line 2
I'm sure I can live without it though ;)

One translation hasn't been done that I've spotted so far:

The last 10 Searchwords (Big Brother ist watching you)

Should be (Big Brother is watching you) but I kinda like it the way it is so I'll be keeping it that way on my forum :)

oldfan 08-22-2004 06:32 PM
whoo thank Onkel_Tom!!!
I'll give it a test run later night, I'll let you know how things turned out

Thanks!! :)

Onkel_Tom 08-22-2004 07:03 PM
Sorry, it's not the PHP version !
We need the MySQL Version ;)

I've never tried to name a database with "-", mine are always with "_" in the name and it works.

Do you use also table prefixes for your tables ?
You can try this:

find in statistik.php:
Code:
LIKE 'pm'
and replace it with:
Code:
LIKE " . TABLE_PREFIX . "'pm'

Ian Emu-UK 08-22-2004 08:00 PM
Quote:
Originally Posted by Onkel_Tom
Sorry, it's not the PHP version !
We need the MySQL Version ;)

I've never tried to name a database with "-", mine are always with "_" in the name and it works.

Do you use also table prefixes for your tables ?
You can try this:

find in statistik.php:
Code:
LIKE 'pm'
and replace it with:
Code:
LIKE " . TABLE_PREFIX . "'pm'
MySQL on my test home server is the latest, and on my site server it's 4.0.16.

It still said the same after I altered the part you said to, but I removed the "FROM $dbname" bit from the query and now it works and gives the size for the PM table.

Is that part un-needed or will I run into problems having removed it at some point?

Thanks for your help Onkel_Tom :)

Onkel_Tom 08-22-2004 08:21 PM
Quote:
Originally Posted by Ian Emu-UK
... I removed the "FROM $dbname" bit from the query and now it works and gives the size for the PM table.

Is that part un-needed or will I run into problems having removed it at some point?
This is not a problem because we are still in this database. The MySQL syntax mentioned to give the database with this command but if we are not outside this db it's not a problem ;)
I will fixed this also in the next release !

Thanks for your help to get this hack working :)

Hope more people will install this hack and give a click in the "hack of the month August " section for this very nice work from PcFreak.

iceman-x 08-22-2004 09:40 PM
Code:
Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT Summe as Datum
FROM statistik_zaehler
WHERE Zaehler_fuer = 'Statistik_Aktiv'
       
mysql error: Table 'elitesat_elite.statistik_zaehler' doesn't exist

mysql error number: 1146

Date: Sunday 22nd of August 2004 03:33:14 PM
The table fix workt perfekt.;) but now i goth a new problem. it keep looking for the old tabel. I tryed to deleted alle the tabel. and reinstalled. but dident work.

It look like the statistik work. the error apers when i am trying to enter the admin opitons. "statistikadmin.php?do=statistik_general"

iceman-x 08-22-2004 10:18 PM
Found the ansvare to the problem. In the "statistikadmin.php"

i canged this..

Find this
Code:
        $statistikaktiv = $DB_site->query("
                SELECT Summe as Datum
                FROM statistik_zaehler
                WHERE Zaehler_fuer = 'Statistik_Aktiv'
        ");
and replaced whit this.
Code:
        $statistikaktiv = $DB_site->query("
                SELECT Summe as Datum
                FROM " . TABLE_PREFIX . "statistik_zaehler
                WHERE Zaehler_fuer = 'Statistik_Aktiv'
        ");
and then it works fine. :)

thanks for all the help.

Wential 08-22-2004 10:32 PM
I took a few hours and worked through all the MySQL errors and it seems to work except for Browser & Operating System Stats. See my attachment. I know not EVERYONE is using "Other" for a browser. Did I miss something on the install?

Onkel_Tom 08-22-2004 11:23 PM
@ Iceman-X
https://vborg.vbsupport.ru/external/2004/08/1.gif
thanks for the hint of another missing table_prefix

@ Wential
Browsers and OS are identified from the file /includes/functions_statistik.php so please check if this file is in that directory.
In that file the the Browsers are identified by getenv("HTTP_USER_AGENT") and a listing with the Browsernames.

Is only Browsertyp and OS version not identified by the statistics ?

Wential 08-23-2004 12:08 AM
Ah, I missed replacing the " . TABLE_PREFIX . " with vb3_ in that file. Hopefully it will start showing up now. And yes, that was the only part that wasn't filling in with data. You're assistance is much appreciated.

Onkel_Tom 08-23-2004 12:30 AM
Your welcome ;)

If the script still not identify the browsers and OS try this.

open file functions_statistik.php from Directory /includes and find:
Code:
$agent = getenv("HTTP_USER_AGENT");
replace it with this syntax:
Code:
$agent = $_SERVER['HTTP_USER_AGENT'];
for the $_SERVER Syntax you must have at least php 4.1.0 installed on your server

Wential 08-23-2004 01:18 AM
The first solution didn't work after waiting an hour. I'm trying your second $_SERVER fix now. I'm running MYSQL 4.0.18 and PHP 4.3.6 so hopefully it will work. I hope it's not a problem that I run my own local Windows 2003 servers on a dedicated T-3 line. You wouldn't believe how many things (VB related) are designed around Apache. Yuck!

Wential 08-23-2004 01:19 AM
Darn that was fast. It works perfectly now! Onkel Tom, you're a genius!


All times are GMT. The time now is 07:40 PM.
Page 5 of 14 « First 34 5 67 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.01694 seconds
  • Memory Usage 1,847KB
  • 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
  • (13)bbcode_code_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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