Ruben E
Link to this post
Subject: Error Number: 1146 Table 'yahualic_agbook2.y' doesn't exist
**********************************************************
When I go to my guestbooks index.php page I get the following error:
**********************************************************
MySQL Error : Query Error
Error Number: 1146 Table 'yahualic_agbook2.y' doesn't exist
Date : Tue, February 14, 2006 12:23:41
IP : 12.25.210.61
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Referer :
PHP Version : 4.4.2
OS : Linux
Server : Apache/1.3.33 (Unix) mod_auth_passthrough/1.8 mod_tsunami/2.0 mod_log_bytes/1.2 PHP/4.4.2 FrontPage/5.0.2.2635 mod_ssl/2.8.22 OpenSSL/0.9.6b
Server Name : www.yahualica.net
******************************************************
I CHECK THE config.inc.php AND IT DISPLAYS THE FOLLOWING:
*******************************************************
<?php
/*
* ----------------------------------------------
* Lazarus Guestbook
* by Stewart Souter
* URL: www.carbonize.co.uk
* Based on Advanced Guestbook 2.3.x (PHP/MySQL)
* Copyright (c)2001 Chi Kien Uong
* URL: http://www.proxy2.de
* Last Modified: 20th October 2005
* ----------------------------------------------
*/
/* database settings */
$GB_DB['dbName'] = 'yahualic_agbook2'; // The name of your MySQL Database
$GB_DB['host'] = 'localhost'; // The server your database is on. Localhost is usualy correct
$GB_DB['user'] = '<username>'; // Your MySQL username
$GB_DB['pass'] = '<password>'; // Your MySQL password
/* misc */
// This is used to make sure that the images and links work correctly
// It is the url of the guestbook folder with no trailing slash
// e.g http://www.yahualica.com/COMENTARIOS2
// If you are using this book as a module in PHP Nuke or similar then leave off the guestbooks folder
// e.g http://www.yahualica.net
$GB_PG['base_url'] = '';
// If you are using the guestbook as a module in POST-Nuke 0.x or PHP-Nuke 5.x or later set this to true
define('IS_MODULE', false);
// You can change this if some of the database table names are already used
// or if you want to host more than one guestbook on one database
$table_prefix = 'book';
// Put your email address here to receive email reports of any errors
$TEC_MAIL = '[email protected]';
//
// Do not edit below this line unless you know what you are doing
//
$DB_CLASS = 'mysql.class.php';
$GB_UPLOAD = 'public';
$GB_TMP = 'tmp';
/* tables */
$GB_TBL['data'] = $table_prefix.'_data';
$GB_TBL['auth'] = $table_prefix.'_auth';
$GB_TBL['cfg'] = $table_prefix.'_config';
$GB_TBL['com'] = $table_prefix.'_com';
$GB_TBL['ip'] = $table_prefix.'_ip';
$GB_TBL['words'] = $table_prefix.'_words';
$GB_TBL['ban'] = $table_prefix.'_ban';
$GB_TBL['priv'] = $table_prefix.'_private';
$GB_TBL['smile'] = $table_prefix.'_smilies';
/* guestbook pages */
$GB_PG['index'] = 'index.php';
$GB_PG['admin'] = 'admin.php';
$GB_PG['comment'] = 'comment.php';
$GB_PG['addentry'] = 'addentry.php';
if ($GB_PG['base_url'] == '') {
$inter_type = php_sapi_name();
if ($inter_type == 'cgi') {
if (isset($_SERVER['PATH_INFO']) && !empty($_SERVER['PATH_INFO'])) {
$GB_PG['base_url'] = dirname($_SERVER['PATH_INFO']);
} elseif (isset($_SERVER['REQUEST_URI']) && !empty($_SERVER['REQUEST_URI'])) {
$GB_PG['base_url'] = dirname($_SERVER['REQUEST_URI']);
} else {
$GB_PG['base_url'] = dirname($_SERVER['SCRIPT_NAME']);
}
} else {
$GB_PG['base_url'] = dirname($_SERVER['PHP_SELF']);
}
}
?>
************************************************************
BUT I DO NOT SEEM TO FIND WHY IT LOOKS FOR A TABLE CALLED "y". THAT TABLE DOES NOT EXIST ON MY DATABASE, NOR ON THE CONFIG FILE, BUT IT SEEMS TO STILL LOOK FOR IT.
************************************************************
WHAT ACTIONS SHOULD I TAKE TO MAKE MY GUESTBOOK WORK?
When I go to my guestbooks index.php page I get the following error:
**********************************************************
MySQL Error : Query Error
Error Number: 1146 Table 'yahualic_agbook2.y' doesn't exist
Date : Tue, February 14, 2006 12:23:41
IP : 12.25.210.61
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Referer :
PHP Version : 4.4.2
OS : Linux
Server : Apache/1.3.33 (Unix) mod_auth_passthrough/1.8 mod_tsunami/2.0 mod_log_bytes/1.2 PHP/4.4.2 FrontPage/5.0.2.2635 mod_ssl/2.8.22 OpenSSL/0.9.6b
Server Name : www.yahualica.net
******************************************************
I CHECK THE config.inc.php AND IT DISPLAYS THE FOLLOWING:
*******************************************************
<?php
/*
* ----------------------------------------------
* Lazarus Guestbook
* by Stewart Souter
* URL: www.carbonize.co.uk
* Based on Advanced Guestbook 2.3.x (PHP/MySQL)
* Copyright (c)2001 Chi Kien Uong
* URL: http://www.proxy2.de
* Last Modified: 20th October 2005
* ----------------------------------------------
*/
/* database settings */
$GB_DB['dbName'] = 'yahualic_agbook2'; // The name of your MySQL Database
$GB_DB['host'] = 'localhost'; // The server your database is on. Localhost is usualy correct
$GB_DB['user'] = '<username>'; // Your MySQL username
$GB_DB['pass'] = '<password>'; // Your MySQL password
/* misc */
// This is used to make sure that the images and links work correctly
// It is the url of the guestbook folder with no trailing slash
// e.g http://www.yahualica.com/COMENTARIOS2
// If you are using this book as a module in PHP Nuke or similar then leave off the guestbooks folder
// e.g http://www.yahualica.net
$GB_PG['base_url'] = '';
// If you are using the guestbook as a module in POST-Nuke 0.x or PHP-Nuke 5.x or later set this to true
define('IS_MODULE', false);
// You can change this if some of the database table names are already used
// or if you want to host more than one guestbook on one database
$table_prefix = 'book';
// Put your email address here to receive email reports of any errors
$TEC_MAIL = '[email protected]';
//
// Do not edit below this line unless you know what you are doing
//
$DB_CLASS = 'mysql.class.php';
$GB_UPLOAD = 'public';
$GB_TMP = 'tmp';
/* tables */
$GB_TBL['data'] = $table_prefix.'_data';
$GB_TBL['auth'] = $table_prefix.'_auth';
$GB_TBL['cfg'] = $table_prefix.'_config';
$GB_TBL['com'] = $table_prefix.'_com';
$GB_TBL['ip'] = $table_prefix.'_ip';
$GB_TBL['words'] = $table_prefix.'_words';
$GB_TBL['ban'] = $table_prefix.'_ban';
$GB_TBL['priv'] = $table_prefix.'_private';
$GB_TBL['smile'] = $table_prefix.'_smilies';
/* guestbook pages */
$GB_PG['index'] = 'index.php';
$GB_PG['admin'] = 'admin.php';
$GB_PG['comment'] = 'comment.php';
$GB_PG['addentry'] = 'addentry.php';
if ($GB_PG['base_url'] == '') {
$inter_type = php_sapi_name();
if ($inter_type == 'cgi') {
if (isset($_SERVER['PATH_INFO']) && !empty($_SERVER['PATH_INFO'])) {
$GB_PG['base_url'] = dirname($_SERVER['PATH_INFO']);
} elseif (isset($_SERVER['REQUEST_URI']) && !empty($_SERVER['REQUEST_URI'])) {
$GB_PG['base_url'] = dirname($_SERVER['REQUEST_URI']);
} else {
$GB_PG['base_url'] = dirname($_SERVER['SCRIPT_NAME']);
}
} else {
$GB_PG['base_url'] = dirname($_SERVER['PHP_SELF']);
}
}
?>
************************************************************
BUT I DO NOT SEEM TO FIND WHY IT LOOKS FOR A TABLE CALLED "y". THAT TABLE DOES NOT EXIST ON MY DATABASE, NOR ON THE CONFIG FILE, BUT IT SEEMS TO STILL LOOK FOR IT.
************************************************************
WHAT ACTIONS SHOULD I TAKE TO MAKE MY GUESTBOOK WORK?
Show profile