vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Table not found problem (https://vborg.vbsupport.ru/showthread.php?t=120965)

RamiroS 07-12-2006 02:09 AM

Table not found problem
 
Hello. I'm building my own vB driven page and I'm getting a table doesn't exist error (error 1146) even though the table is there, is not broken, visible and editable through phpmyadmin.
Reading the forums I saw some people had this problem because broken files... I've updated to the latest vBulletin version (3.5.4) and the problem remains. What can be wrong with it? Thanks.

Here is the error:

Code:

Database error in vBulletin 3.5.4:

Invalid SQL:

        INSERT INTO mytable
                (pid,uid)
                        VALUES
                ('0', '0');

MySQL Error  : Table 'db.mytable' doesn't exist
Error Number : 1146
Date        : Wednesday, July 12th 2006 @ 12:05:06 AM
Script      : http://www.myhost.com/forum/myscript.php
Referrer    :
IP Address  : xxx.xxx.xxx.xxx
Username    : fdas
Classname    : vb_database

Here is my custom page:

PHP Code:

<?php
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS'1);
define('THIS_SCRIPT''agregar_noticias'); // change this depending on your filename

// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array(

);

// get special data templates from the datastore
$specialtemplates = array(
    
);

// pre-cache templates used by all actions
$globaltemplates = array(
    
'agregar_noticias',
);

// pre-cache templates used by specific actions
$actiontemplates = array(

);

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');

// #######################################################################
// ######################## START MAIN SCRIPT ############################
// #######################################################################
$uid=$vbulletin->input->clean_gpc('r''uid'TYPE_UINT);
$pid=$vbulletin->input->clean_gpc('r''pid'TYPE_UINT);

$db->query_write("
    INSERT INTO " 
TABLE_PREFIX "mytable
        (pid,uid) 
            VALUES
        ('
$pid', '$uid');
"
);


eval(
'print_output("' fetch_template('agregar_noticias') . '");');
?>


RamiroS 07-13-2006 03:09 PM

Anyone? please! should I submit this as a bug or am I missing something here?


All times are GMT. The time now is 02:13 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.01077 seconds
  • Memory Usage 1,725KB
  • 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
  • (1)bbcode_code_printable
  • (1)bbcode_php_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