vb.org Archive - Executing queries

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Executing queries (https://vborg.vbsupport.ru/showthread.php?t=93349)

Abaweet69

08-01-2005 11:46 AM

Executing queries

Hi,

Whenever i try to execute a SQL query, whether it's through my ACP or phpMyAdmin, I always get this error...

Quote:

error number: 1146
error desc: Table 'pbvidsco_forum.user' doesn't exist

For example, i want to try to execute

Quote:

ALTER TABLE user ADD mood varchar(15) NOT NULL

But it just gives me the error above ^

i'm missing something. any ideas?

Thanks

Andreas

08-01-2005 11:49 AM

Are you using a Table Prefic?
Then this must be put in front of every Tablename in SQL Queries, eg. in front of user in this one.

All times are GMT. The time now is 01:47 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01023 seconds Memory Usage 1,708KB 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_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: