vb.org Archive - Statistics Modifications

Page 4 of 13

« First

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)

- - Statistics Modifications - Forum Search Stats 1.0 (https://vborg.vbsupport.ru/showthread.php?t=139829)

AMG021

02-20-2007 09:43 PM

Code:

Database error in vBulletin 3.6.4:



Invalid SQL:

SELECT MAX(`count`) AS m FROM coder_searchstats;



MySQL Error  : Table 'amg209_forum.coder_searchstats' doesn't exist

Error Number : 1146

Date         : Tuesday, February 20th 2007 @ 03:34:50 PM

i got this error WHY ?

coderphp

02-20-2007 09:47 PM

Quote:

Originally Posted by AMG021 (Post 1187017)

Code:

Database error in vBulletin 3.6.4:

 

Invalid SQL:

SELECT MAX(`count`) AS m FROM coder_searchstats;

 

MySQL Error  : Table 'vastatic_forum.coder_searchstats' doesn't exist

Error Number : 1146

Date         : Tuesday, February 20th 2007 @ 03:34:50 PM

i got this error WHY ?

it tells that the hack table doesnt exist..

Please re-install the product again..

If for any reason the problem presists execute this query manually from the admincp:

Code:

CREATE TABLE `coder_searchstats` ( `id` int(10) unsigned NOT NULL auto_increment, `query` varchar(200) NOT NULL default '', `dateline` int(10) unsigned NOT NULL default '0', `count` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM

AMG021

02-20-2007 09:49 PM

ok

let me try again

this is wat i got

Code:

An error occurred while attempting to execute your query. The following information was returned.

error number: 1064

error desc: 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 'ENGINE=MyISAM' at line 1

coderphp

02-20-2007 10:05 PM

Quote:

Originally Posted by AMG021 (Post 1187025)

ok

let me try again

this is wat i got

Code:

An error occurred while attempting to execute your query. The following information was returned.

error number: 1064

error desc: 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 'ENGINE=MyISAM' at line 1

ok now it is clear for me

do the following:
1- reinstall the product.
2- execute this new query:

Code:

CREATE TABLE `coder_searchstats` ( `id` int(10) unsigned NOT NULL auto_increment, `query` varchar(200) NOT NULL default '', `dateline` int(10) unsigned NOT NULL default '0', `count` int(11) NOT NULL default '0', PRIMARY KEY (`id`) )

AMG021

02-20-2007 11:03 PM

Quote:

Originally Posted by coderphp (Post 1187042)

ok now it is clear for me

do the following:
1- reinstall the product.
2- execute this new query:

Code:

CREATE TABLE `coder_searchstats` ( `id` int(10) unsigned NOT NULL auto_increment, `query` varchar(200) NOT NULL default '', `dateline` int(10) unsigned NOT NULL default '0', `count` int(11) NOT NULL default '0', PRIMARY KEY (`id`) )

Thank you sooo much! It worked

coderphp

02-20-2007 11:11 PM

Quote:

Originally Posted by AMG021 (Post 1187076)

Thank you sooo much! It worked

ok good

rwilkins108

02-21-2007 01:38 AM

Works great, any chance of getting a way to remove 1 search term from the box, like the way Zoints Tags works (which looks similar) is that if you're an admin, there's an x next to each tag (or search term in this case) which will remove it. Also, it might be good to have a list of words that would be ignored, i've already got a swear word up on mine :)

Great work!
Thanks!!

HMBeaty

02-21-2007 03:05 AM

I'm getting the following error on my forums after product upload....

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT MAX(`count`) AS m FROM vb_coder_searchstats;

MySQL Error : Table 'Redline.vb_coder_searchstats' doesn't exist
Error Number : 1146
Date : Tuesday, February 20th 2007 @ 09:54:06 PM
Script : http://www.mysite.org/forum/index.php
Referrer : http://www.mysite.org/forum/admincp/index.php?do=head
IP Address : xx.xx.xx.xx
Username : xxxxxxx
Classname : vb_database

I tried the fix above but it didn't work for me

HMBeaty

02-21-2007 03:43 AM

Nevermind, I went in and manually edited the database. The problem is that your product is not creating the "TABLE_PREFIX" because its not in the product to include it. So you might want to fix that as well. Also, the "expand / collapse" doesn't work. It expands / collapses my "upcoming events"

EDIT: and that would be because you're USING the "upcoming events" module for it. As shown in your FORUMHOME template edit here:

HTML Code:

onclick="return toggle_collapse('forumhome_events')

So you should fix that as well

HMBeaty

02-21-2007 03:53 AM

/me uninstalled until fixes are made

All times are GMT. The time now is 04:23 PM.

Page 4 of 13

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01173 seconds Memory Usage 1,745KB 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 (7)bbcode_code_printable (1)bbcode_html_printable (4)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 (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
Messages: