vb.org Archive
Page 25 of 55 « First 152324 25 262735 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)
-   -   vB Statistic version 3.0.0 (directors Cut *g*) (https://vborg.vbsupport.ru/showthread.php?t=74603)

S@NL - BlackBik 02-21-2005 06:25 PM
Quote:
Originally Posted by Delphiprogrammi
hi,

this piece of php code is causing the error i get

PHP Code:
$pm_speicher_groesse = $DB_site->query("
        SHOW TABLE STATUS
        FROM $dbname
        LIKE '" . TABLE_PREFIX . "pm'
         "); 
but that query seems correct to me ?????? and i can't find anything in the MySQL manual about this just a "syntax" example on my old host this worked fine now it refuses to work on my new host ... i dropped my old host because they forced people to go dedicated if you want crontab support :devious:

if i comment that code out it works fine
Well, this doen't seem to be a problem with the vB Statistics but with your own host or configuration.
What you could do is open the database with e.g. MySQL Front and edit the field, in wich the name of your domain should be, manualy. That should do the trick.

S@NL - BlackBik 02-21-2005 06:27 PM
Quote:
Originally Posted by shadiguy1
need unsinstall for this. please advise.
You could start by reading this whole thread. I even think it's on this page.
Don't just ask questions, but first read if the question is allready delt with :(

TruthElixirX 02-21-2005 06:45 PM
okay...whoa. I just downloaded the english version and everything was english except the installer. The installer is Dutch(I think?) and so..am I going to have ot uninstall it or will the dutch install be okay?

Delphiprogrammi 02-21-2005 06:51 PM
Quote:
Originally Posted by Punktek.com
okay...whoa. I just downloaded the english version and everything was english except the installer. The installer is Dutch(I think?) and so..am I going to have ot uninstall it or will the dutch install be okay?

installer that's german

Delphiprogrammi 02-21-2005 06:54 PM
Quote:
Originally Posted by S@NL - BlackBik
Well, this doen't seem to be a problem with the vB Statistics but with your own host or configuration.
What you could do is open the database with e.g. MySQL Front and edit the field, in wich the name of your domain should be, manualy. That should do the trick.
yeah i contacted the tech support from my host they didn't answered yet but i think the same there is something with there config ...

updated

i found a solution .for people who get this MySQL error

Code:
Database error in vBulletin 3.0.7:

Invalid SQL:
    SHOW TABLE STATUS
    FROM
    LIKE 'testvb_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 'LIKE 'testvb_pm'' at line 3

mysql error number: 1064

Date: Monday 21st of February 2005 10:25:35 PM
Script:**************
Referer:
Username: **********
IP Address:**********
open op "statistick/sides/forum.php"

PHP Code:
// find this code 
$pm_speicher_groesse = $DB_site->query("
        SHOW TABLE STATUS
        FROM $dbname
        LIKE '" . TABLE_PREFIX . "pm'
         ");
//replace that with
$pm_speicher_groesse =  $DB_site->query("
        SHOW TABLE STATUS
        LIKE '" . TABLE_PREFIX . "pm'
         "); 
you are done don't ask me why but for some reason MySQL is crashing if you add $dbname i don't know why

any cheers working now

S@NL - BlackBik 02-21-2005 09:30 PM
For the record, PcFreak has confirmed the bug I posted here and is working on a sollution :)

MissKalunji 02-22-2005 01:35 AM
Quote:
Originally Posted by Lizard King
Check out this thread

thx a million every upgrade i usually just redo everythin...

sv1cec 02-23-2005 06:56 AM
Gentlemen,

I am receiving the following error, several times lately:

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT counter
FROM statistic_searchengine_keywords
WHERE keywords = 'crimp, pressure, reload\'

mysql error: You have an error in your SQL syntax near ''crimp, pressure, reload\'
' at line 4

mysql error number: 1064

Date: Tuesday 15th of February 2005 02:31:56 PM
Script: http://forum.m1911.org/showthread.php?t=1379&page=3
Referer: http://www.google.com/search?q=crimp...&start=10&sa=N
Username: Unregistered

I checked the code, and can't find anything wrong with it. The common thing I noticed in all the errors I received, is the \ at the end of the search words. Any idea on how to stop these error messages?

Rgds

Freezerator 02-23-2005 07:07 AM
I get the same errors, but i think the reason is the \ in the query. As you can see when people search on google, their \ is above the enter button. When referrring to your site, the procedure to store the referrer goes wrong because of the \. Maybe a suggestion to strip \ from beeing inserted?

sv1cec 02-23-2005 07:44 AM
Yes, I think you are right. I'll try to come up with some sort of patch, to strip that last \ from the string.

Since the backslash character is not used in normal word typing, and since I didn't want to spend too much time coming up with an elaborate solution, here is a simple patch.

Open your statistic_searchengines.php file and find:

PHP Code:
$keywords_known = $DB_site->query("
        SELECT counter 
        FROM " . TABLE_PREFIX . "statistic_searchengine_keywords
        WHERE keywords = '$keyword_found'
        "); 
Right above that, add:

PHP Code:
$keyword_found=str_replace("\","",$keyword_found); 
That would strip any \ character from the query string.

Rgds


All times are GMT. The time now is 08:15 AM.
Page 25 of 55 « First 152324 25 262735 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.01780 seconds
  • Memory Usage 1,759KB
  • 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
  • (1)bbcode_code_printable
  • (4)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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