Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Weird problem, please help asap!


Guest

Recommended Posts

I don't what I did but I think it had to do when I was trying to add the short description contribution. When I try to upload my spreadsheets using easypopulate, I get this weird error. I'll paste it below.

 

Easy Populate 2.75-MS2 - Default Language : English(1)

 

Filename: EP2006May29-2210.txt

| MILDSC06BK | MILDSC06BK | 6mm Black | | | | 6mm Black | 6mm Black | Chinese Mi | | | | | | | | | | | | | | | 0.5 | 0.5 | 0.45 | 0.4 | 0 | 1 | 3 | 5 | 0 | 1 | 1 | 0000-00-00 | 0000-00-00 | 50 | Chinese Gl | Chinese Mi | Discs | 6mm | | | | | --none-- | Active Updated

1054 - Unknown column 'products_short_desc' in 'field list'

 

UPDATE products_description SET products_name = '6mm Black Disc Millefiori', products_description = '', products_short_desc = '', products_url = '', products_head_title_tag = '6mm Black Disc Millefiori Beads', products_head_desc_tag = '6mm Black Disc Millefiori Beads', products_head_keywords_tag = 'Chinese Millefiori Flower Beads' WHERE products_id = '360' AND language_id = '1'

 

[TEP STOP]

 

That is what I get in it's entirety. Can someone shed some light on what I need to change/fix?

 

Thanks.

Link to comment
Share on other sites

EP has had a lot of updates, some to add functionality that you might not need. It is likely that this is the source of your problem. Find the code in easypopulate.php that says "products_short_desc" and remove it.

 

For example, it probably says something like: tep_db_query("UPDATE ' . TABLE_PRODUCTS_DESCRIPTION . ' SET products_name = <something>, products_description = <something else>, products_short_desc = <yet something else>, . . . ."

 

Take out the products_short_desc = <yet something else> part. You may have to do this in multiple locations, or for multiple fields that are intended for contributions that you do not have installed.

 

-jared

Link to comment
Share on other sites

Thanks Jared.....that solved the 1054 error. Now I am getting this....

 

Easy Populate 2.75-MS2 - Default Language : English(1)

 

Filename: EP2006May29-2210

 

Warning: file(/home/******/public_html/temp/EP2006May29-2210): failed to open stream: No such file or directory in /home/******/public_html/admin/easypopulate.php on line 675

 

Warning: Invalid argument supplied for foreach() in /home/******/public_html/admin/easypopulate.php on line 680

________________________________________

 

Those lines in EP are:

 

$readed = file(DIR_FS_DOCUMENT_ROOT . $tempdir . $localfile);

________________________________________

and.......

 

foreach ($readed as $read){

 

________________________________________

 

Hate to sound like a dummy, but, now what?

 

Thanks again.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...