vb.org Archive
Page 19 of 53 « First 91718 19 202129 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-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'


All times are GMT. The time now is 03:14 PM.
Page 19 of 53 « First 91718 19 202129 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.01969 seconds
  • Memory Usage 1,747KB
  • 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
  • (6)bbcode_code_printable
  • (2)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