Posted by:
janamdo
(---.cm-3-4b.dynamic.ziggo.nl)
oh no ...error report
Error occured at:2011-01-17 12:07:22
Line no.:24955
Error Code: 1170 - BLOB/TEXT column 'products_description' used in key specification without a key length
Query:
create table products_description (
products_id int(11) not null auto_increment,
language_id int(11) default '1' not null ,
products_name varchar(200) not null ,
products_description text ,
products_url varchar(255) ,
products_viewed int(5) default '0' ,
shipping_description text ,
extra_value_id1 int(10) unsigned default '0' not null ,
extra_value_id4 int(10) unsigned default '0' not null ,
PRIMARY KEY (products_id, language_id),
KEY products_name (products_name),
KEY products_description (products_description),
KEY products_name_2 (products_name)
)
---------------------------------------------------------------
i look at to handle this in sqlyog (that's why it stopped also with the import via phpmyadmin directly?)
solution: i chanced in teh database: text in varchar(255) ..hopes this will work
products_description varchar(255) latin1_swedish_ci ..............
This is not the right solution ..on my shop..the productdescription is not complete anymore, but now on th e localserver?
I do have a productdecsription on my shop larger than varchar(255) and TEXT is not accepted by sqlyog?
Must i use the blob format ? for the productdescription?
At the end of the import a again a error..probabaly a ' ..no clue to solve this?
Error occured at:2011-01-17 13:44:33
Line no.:1702212
Error Code: 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 '<br />
<b>Warning</b>: unlink(/home/jdouma/domains/zerospec.com/public_html/adm' at line 1
Strange enough my shopdatabase accepts large productsdescriptions, but when expoerting they are too big?..it is not fair ..
i amstucked with this : no phpmyadmin tweaks and via php script import webshop sql file ..error in de sql file
.. i must go to another forum for mysql ..thanks for here
Edited 5 time(s). Last edit at 01/18/2011 11:19AM by janamdo.