Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Mega tags problem


Kasper.S

Recommended Posts

Hello,

 

I am installing meta tags 3.0a to OSC MS1. I have a default mega tags sql-script which should create the needed table. When I tried to execute it from shell and from mysql-adminstrator I got these:

 

From shell:

 

ERROR 1064 (42000): 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 '/home/magicshroom/mega_tags.sql' at line 1

 

From mysql-adminstrator (Server: MySQL 4.0.20-standard-log, Client: MySQL Client Version 5.0.15):

 

Error executing SQL commands to create table.

MySQL Error Nr. 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 'NOT NULL DEFAULT '',

`description` VARCHAR NOT NULL DEFAULT

 

The script:

 

CREATE TABLE meta_tags (

meta_id int(11) NOT NULL auto_increment,

categories_id int(11) NOT NULL default '0',

manufacturers_id int(11) NOT NULL default '0',

keywords varchar(255) NOT NULL default '',

description varchar(255) NOT NULL default '',

title varchar(255) NOT NULL default '',

PRIMARY KEY (meta_id)

) TYPE=MyISAM;

 

 

What could be wrong in syntax or what a hell? I am quite newbie with these.

 

 

- Cheers Kasper.S

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...