SQL Error : 1146

Support for the IM Portal Project

Moderator: Integra Moderator

SQL Error : 1146

PostAuthor: ross » Tue Jan 23, 2007 11:22 am

Your phpBB Version: 2.0.
phpBB Type: Standard phpBB
MODs: Yes
Your knowledge: Basic Knowledge
Board URL:

PHP Version:
MySQL Version:



What was done before the problem appeared?



What was done to try to solve the problem?




De.scription and Message

Hi,

I have just installed 1.2.0 version of the Portal on my phpBB 2.0.22 forum.

I ran the sql as indicated and now I am getting this message.

phpBB : Critical Error

Could not query portal config table

DEBUG MODE

SQL Error : 1146 Table 'newforum170107.PORTAL_CONFIG_TABLE' doesn't exist

SELECT * FROM PORTAL_CONFIG_TABLE

Line : 47
File : functions_portal.php


Any ideas on what I have done wrong?

Apologise if this is in the wrong section,

Ross :lol: :o :o', 'c', 3, 1, '', 0, 2, 0, 0, '7e13fbbacc', 1, 1, 0, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (17, 'Sample 4', 'Without background only :idea: :arrow:', 'c', 5, 1, '', 0, 2, 0, 0, 'ed31156971', 1, 0, 1, 1, 0, '');
INSERT INTO phpbb_blocks VALUES (19, 'Sample 7', 'Take note that pages and blocks can have different permissions. There are 2 kinds of permissions to set, per user level and per usergroups. It is allowed to mix permissions but it is wise to set the user level to registered when usergroups are used (e.g. making a page only accessible for a specific usergroup) :shock: <img>', 'c', 3, 1, '', 0, 3, 0, 0, '48d2dd24ac', 1, 0, 1, 0, 0, '');

DROP TABLE IF EXISTS phpbb_layout;
CREATE TABLE phpbb_layout (
lid int(10) unsigned NOT NULL auto_increment,
name varchar(100) NOT NULL default '',
template varchar(100) NOT NULL default '',
forum_wide tinyint(1) NOT NULL default '1',
view tinyint(1) NOT NULL default '0',
groups tinytext NOT NULL,
PRIMARY KEY (lid)
) TYPE=MyISAM;

INSERT INTO phpbb_layout VALUES (1, 'IM Portal Default', 'portal_body.tpl', 1, 0, '');
INSERT INTO phpbb_layout VALUES (2, 'Sample 1', 'layout1.tpl', 1, 0, '');
INSERT INTO phpbb_layout VALUES (3, 'Sample 2', 'layout1.tpl', 0, 0, '');

DROP TABLE IF EXISTS phpbb_portal_config;
CREATE TABLE phpbb_portal_config (
id int(10) unsigned NOT NULL auto_increment,
config_name varchar(255) NOT NULL default '',
config_value varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

INSERT INTO phpbb_portal_config VALUES (1, 'default_portal', '1');
INSERT INTO phpbb_portal_config VALUES (2, 'portal_header', '1');
INSERT INTO phpbb_portal_config VALUES (3, 'portal_tail', '0');
INSERT INTO phpbb_portal_config VALUES (4, 'cache_enabled', '1');
INSERT INTO phpbb_portal_config VALUES (5, 'md_news_length', '250');
INSERT INTO phpbb_portal_config VALUES (6, 'md_news_forum_id', '1');
INSERT INTO phpbb_portal_config VALUES (7, 'md_num_news', '5');
INSERT INTO phpbb_portal_config VALUES (8, 'md_search_option_text', 'IM Portal');
INSERT INTO phpbb_portal_config VALUES (9, 'md_num_recent_topics', '10');
INSERT INTO phpbb_portal_config VALUES (10, 'md_approve_mod_installed', '0');
INSERT INTO phpbb_portal_config VALUES (11, 'md_recent_topics_style', '0');
INSERT INTO phpbb_portal_config VALUES (12, 'md_poll_bar_length', '40');
INSERT INTO phpbb_portal_config VALUES (13, 'md_poll_forum_id', '1');
INSERT INTO phpbb_portal_config VALUES (14, 'header_width', '150');
INSERT INTO phpbb_portal_config VALUES (15, 'footer_width', '');
INSERT INTO phpbb_portal_config VALUES (16, 'md_cache_file_locking', '1');
INSERT INTO phpbb_portal_config VALUES (17, 'md_cache_write_control', '1');
INSERT INTO phpbb_portal_config VALUES (18, 'md_cache_read_control', '1');
INSERT INTO phpbb_portal_config VALUES (19, 'md_cache_read_type', 'md5');
INSERT INTO phpbb_portal_config VALUES (20, 'md_cache_filename_protect', '0');
INSERT INTO phpbb_portal_config VALUES (21, 'md_cache_serialize', '1');
Last edited by ross on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

ross
Newbie
Newbie
 
Posts: 4
Likes: 0 post
Liked in: 0 post
Joined: Tue Jan 23, 2007 11:10 am
Cash on hand: 0.00

PostAuthor: ross » Tue Jan 23, 2007 12:47 pm

Just checked, in the ACP I am getting errors on everything bar delete cached files

blocks management

SQL Error : 1146 Table 'newforum170107.LAYOUT_TABLE' doesn't exist

SELECT lid, name FROM LAYOUT_TABLE ORDER BY lid

Line : 989
File : admin_blocks.php

Blocks viarable

phpBB : Critical Error

Could not query blocks variables information

DEBUG MODE

SQL Error : 1146 Table 'newforum170107.BLOCK_VARIABLE_TABLE' doesn't exist

SELECT * FROM BLOCK_VARIABLE_TABLE ORDER BY block, bvid

Line : 338
File : admin_blocks_var.php

blocks position tag

phpBB : Critical Error

Could not query layout information

DEBUG MODE

SQL Error : 1146 Table 'newforum170107.LAYOUT_TABLE' doesn't exist

SELECT lid, name FROM LAYOUT_TABLE

Line : 261
File : admin_blocks_pos.php

Page Management

phpBB : Critical Error

Could not query portal config table

DEBUG MODE

SQL Error : 1146 Table 'newforum170107.PORTAL_CONFIG_TABLE' doesn't exist

SELECT config_value FROM PORTAL_CONFIG_TABLE WHERE config_name = 'default_portal'

Line : 81
File : admin_layout.php

portal configuration

phpBB : Critical Error

Could not query portal config information

DEBUG MODE

SQL Error : 1146 Table 'newforum170107.BLOCK_VARIABLE_TABLE' doesn't exist

SELECT * FROM BLOCK_VARIABLE_TABLE ORDER BY bvid

Line : 49
File : admin_portal.php
Last edited by ross on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

ross
Newbie
Newbie
 
Posts: 4
Likes: 0 post
Liked in: 0 post
Joined: Tue Jan 23, 2007 11:10 am
Cash on hand: 0.00

Re: SQL Error : 1146

PostAuthor: Helter » Tue Jan 23, 2007 3:29 pm

check phpmyadmin to see if the tables were actually written. If they were, what is your php/mysql version?
Last edited by Helter on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
Always use Protection
Image


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4168
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 3:46 pm
Cash on hand: 187.60
Location: Seattle Wa
IntegraMOD version: IM 3

Re: SQL Error : 1146

PostAuthor: ross » Wed Jan 24, 2007 3:38 am

Hi, I am not entirely sure about the php version, its either 4 or 5 my MSQL Version is 5 definately.

My tables I have are as follows


phpbb_auth_access
phpbb_banlist
phpbb_block_position
phpbb_block_variable
phpbb_blocks
phpbb_categories
phpbb_config
phpbb_confirm
phpbb_disallow
phpbb_easymod
phpbb_easymod_processed_files
phpbb_forum_prune
phpbb_forums
phpbb_groups
phpbb_ina_at_scores
phpbb_ina_banned
phpbb_ina_cat
phpbb_ina_comment
phpbb_ina_data
phpbb_ina_fav
phpbb_ina_games
phpbb_ina_highscore
phpbb_ina_log
phpbb_ina_pms
phpbb_ina_rate
phpbb_ina_scores
phpbb_ina_sessions
phpbb_ina_tour
phpbb_ina_tour_data
phpbb_ina_tour_play
phpbb_ina_user_data
phpbb_layout
phpbb_portal_config
phpbb_posts
phpbb_posts_text
phpbb_privmsgs
phpbb_privmsgs_text
phpbb_ranks
phpbb_search_results
phpbb_search_wordlist
phpbb_search_wordmatch
phpbb_sessions
phpbb_sessions_keys
phpbb_smilies
phpbb_themes
phpbb_themes_name
phpbb_topics
phpbb_topics_watch
phpbb_user_group
phpbb_users
phpbb_vote_desc
phpbb_vote_results
phpbb_vote_voters
phpbb_words

I personally can't see anything missing :S

Thanks in advance,

Ross
Last edited by ross on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

ross
Newbie
Newbie
 
Posts: 4
Likes: 0 post
Liked in: 0 post
Joined: Tue Jan 23, 2007 11:10 am
Cash on hand: 0.00

Re: SQL Error : 1146

PostAuthor: Teelk » Thu Jan 25, 2007 6:15 pm

The most common cause of this error message is missing table information in includes/constants.php. I'd check the install to see if any file edits are missing from this file.
Last edited by Teelk on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
User avatar
Teelk
Dev Team
Dev Team
 
Posts: 1309
Likes: 0 post
Liked in: 0 post
Joined: Tue Mar 14, 2006 5:25 pm
Cash on hand: 0.00
Location: Canada

Re: SQL Error : 1146

PostAuthor: ross » Fri Jan 26, 2007 2:08 am

Thank you :grin:
Last edited by ross on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

ross
Newbie
Newbie
 
Posts: 4
Likes: 0 post
Liked in: 0 post
Joined: Tue Jan 23, 2007 11:10 am
Cash on hand: 0.00


Return to IM Portal Support Forum

Who is online

Registered users: Bing [Bot], Vendethiel