vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Forums arranged in columns on forumhome (https://vborg.vbsupport.ru/showthread.php?t=59958)

Mr. Brian 02-10-2004 02:32 PM

An error occurred while attempting to execute my query. The following information was returned.
error number: 1146

error desc: Table 'abc.forum' doesn't exist

That's werid! No mater how I tried still getting the same result..

No ideal what's the main causes of it..any bro here ever encountered such problem before?

Any help will be GREATLY APPRECIATED.

Many thanks in advance.

Xenon 02-10-2004 04:30 PM

do you use a table prefix?

if yes you have to manually change the query
[sql]ALTER TABLE forum ADD subforumcolumns TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL ;[/sql]

into
[sql]ALTER TABLE yourprefixhereforum ADD subforumcolumns TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL ;[/sql]

if you don't have a tableprefix set up, you have a serious problem on your board..

Mr. Brian 02-10-2004 06:53 PM

Is it possible to check whether there's any tableprefix'ed on my forum...?

Xenon 02-10-2004 06:57 PM

it's set up in your config.php

Mr. Brian 02-10-2004 07:12 PM

Looks something like this:- ?

Quote:

// Prefix that your vBulletin tables have in the database.
// For example: $tableprefix = '';
$tableprefix = 'mydatabasename';

// Prefix that all vBulletin cookies will have
// For example
$cookieprefix = 'bb';
am I right?

thanks

Xenon 02-10-2004 07:15 PM

exactly.

so you ahve to add this prefix before the 'forum' within that query

Mr. Brian 02-10-2004 07:43 PM

alright. thanks a lot bro..

I'm gonna install it right now!

Alien 02-10-2004 08:11 PM

Does the image add-on control custom on/off images per forum, or just add just an image for the forums there for eye candy? I definatly want to incorporate this into our new design but with custom on/off images for a particular category.

Thanks for any clarity you can provide. :D Nice job, btw!

Xenon 02-10-2004 09:49 PM

you can change that:
HTML Code:

<img src="$stylevar[imgdir_statusicon]/forum_$forum[statusicon].gif" alt="" border="0" />
into
HTML Code:

<img src="$stylevar[imgdir_statusicon]/forum_$forum[forumid]_$forum[statusicon].gif" alt="" border="0" />
and then create on of status icons within the statusicon folder containing the forumid :)

Alien 02-11-2004 02:20 AM

* Alien moans softly.

Thank you SO much. :D


All times are GMT. The time now is 10:51 AM.

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.01401 seconds
  • Memory Usage 1,735KB
  • 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
  • (2)bbcode_html_printable
  • (1)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
  • (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