Problems installing Featured Products mod

[Guest]

I am having problems adding the mySQL statement in the readme file of the Featured Products mod.

 

You are supposed to add the following code...

 

  create table featured (

 featured_id int(11) not null auto_increment,

 products_id int(11) default '0' not null ,

 featured_date_added datetime ,

 featured_last_modified datetime ,

 expires_date datetime ,

 date_status_change datetime ,

 status int(1) default '1' ,

 PRIMARY KEY (featured_id)

 );

 

I did so (using phpMyAdmin 2.2.0), but I get the following error.

 

Error  

SQL-query :  [Edit]  

 

create table featured (

 featured_id int(11) not null auto_increment,

 products_id int(11) default '0' not null ,

 featured_date_added datetime ,

 featured_last_modified datetime ,

 expires_date datetime ,

 date_status_change datetime ,

 status int(1) default '1' ,

 PRIMARY KEY (featured_id)

 );

 

 

MySQL said:  

 

 

You have an error in your SQL syntax near ''0' not null ,

 featured_date_added datetime ,

 featured_last_modified dat' at line 3

 

I have MySQL 3.23.41

 

Could anyone give me any help?

[Guest]

*bump*?

[Floob]

Remove all instances of

[Floob]

Actually I guess that was provided only in the output, so I guess you didnt add it anyway.

 

You could use Phpmyadmin to manually create the table instead of using the sql script.

[Guest]

That I was going to do, but I'm not sure how you add this...

 

status int(1) default '1'

[Guest]

  create table featured (

 featured_id int(11) not null auto_increment,

 products_id int(11) default '0' not null ,

 featured_date_added datetime ,

 featured_last_modified datetime ,

 expires_date datetime ,

 date_status_change datetime ,

 status int(1) default '1' ,

 PRIMARY KEY (featured_id)

 );

 

Try This

[Guest]

Same stuff...

 

create table featured (  

 featured_id int(11) not null auto_increment,  

 products_id int(11) default '0' not null ,  

 featured_date_added datetime ,  

 featured_last_modified datetime ,  

 expires_date datetime ,  

 date_status_change datetime ,  

 status int(1) default '1' ,  

 PRIMARY KEY (featured_id)  

 );

 

MySQL said:  

 

 

You have an error in your SQL syntax near ''0' not null ,  

 featured_date_added datetime ,  

 featured_last_modified d' at line 3

[Guest]

I'm still having problems with this. Anyone have any ideas to help me here?

[Guest]

No edit here, so I have to double post.. sorry.

 

I was able to get around this, but you have to have shell access and can't upload the code via phpMyAdmin for some reason.

 

Log into your server via SSH and become root.

 

su -

command lines as follows...

 

# mysql -u username -p oscommerce_table_name

Enter password: whatever_password

 

It will then bring up your mysql prompt

 

mysql>

 

Paste the code, hit enter and it creates the tables. Don't know why it's not doing it via phpMyAdmin, but it seems to work okay now.