vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Bad Query (https://vborg.vbsupport.ru/showthread.php?t=68571)

Osterling 08-20-2004 08:16 PM
Bad Query
 
I am not sure if this is allowed since I got this hack off another site, but I am just wondering if anyone could help me here...

The First Query Is:

PHP Code:
CREATE TABLE journal (
      'journalid' int(11) NOT NULL auto_increment,
      'title' text NOT NULL,
      'description' text NOT NULL,
      'imagename' text NOT NULL,
      'entries' int(11) NOT NULL default '0',
      'views' int(11) NOT NULL default '0',
      'enabled' smallint(6) default '0',
      'timestamp' int(11) NOT NULL default '0',
      'userid' int(11) NOT NULL default '0',
      'mood' text NOT NULL,
      'np' text NOT NULL,
      PRIMARY KEY  ('journalid')
    ) TYPE=MyISAM ; 
well I ran it and i got this error:

MySQL said:


#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''journalid'int( 11 ) NOT NULL AUTO_INCREMENT ,
'title'text


All times are GMT. The time now is 10:04 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.01917 seconds
  • Memory Usage 1,713KB
  • 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_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)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