Hoi
When I try to import my video.instell file through mySQL to create tables, I got this error raport.I use MySQL - 4.1.19 and my drupal 4.7.1.
Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 1
STR: <?
SQL: <?php
// $Id: video.install,v 1.2 2006/05/25 00:46:11 fax8 Exp $
function video_install() {
switch ($GLOBALS['db_type']) {
case 'mysql':
case 'mysqli':
db_query("CREATE TABLE {video} (
vid int(10) unsigned NOT NULL default '0',
nid int(10) unsigned NOT NULL default '0',
vidfile text NOT NULL default '',
videox smallint(4) unsigned NOT NULL default '0',
videoy smallint(4) unsigned NOT NULL default '0',
size bigint(13) unsigned default NULL,
download_counter int(10) unsigned NOT NULL default '0',
play_counter int(10) unsigned NOT NULL default '0',
video_bitrate int(10) unsigned default NULL,
audio_bitrate int(10) unsigned default NULL,
audio_sampling_rate int(10) unsigned default NULL,
audio_channels enum('','5.1','stereo','mono') default NULL,
playtime_seconds int(10) unsigned default NULL,
download_folder varchar(255) NULL default NULL,
disable_multidownload tinyint(1) unsigned NOT NULL default '0',
use_play_folder tinyint(1) unsigned NOT NULL default '0',
custom_field_1 varchar(255) NULL default NULL,
custom_field_2 varchar(255) NULL default NULL,
custom_field_3 varchar(255) NULL default NULL,
custom_field_4 varchar(255) NULL default NULL,
custom_field_5 text NULL default NULL,
custom_field_6 text NULL default NULL,
serialized_data text NULL default NULL,
PRIMARY KEY (vid)
) TYPE=MyISAM COMMENT='size is in bytes' /*!40100 DEFAULT CHARACTER SET utf8 */;");
SQL query:
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 '<?php
// $Id: video.install,v 1.2 2006/05/25 00:46:11 fax8 Exp $
function video' at line 1
I use MySQL - 4.1.19 and my drupal 4.7.1
Comments
Comment #1
fax8 commentedyou don't need to import the video.install file.
this is automatically used by drupal to create your database tables
when you activate the module. (this from drupal 4.7 on)
Comment #2
fax8 commented