Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Error adding product

 
Reply
   X-Cart forums > X-Cart 5 > Modifying the design and features (X-Cart 5)
 
Thread Tools Search this Thread
  #1  
Old 08-31-2014, 12:57 PM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Error adding product

I have just tried to add a prodict but getting this err

Code:
ERROR: "23000" (code N/A) SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'path' cannot be null SQL query: INSERT INTO xc_product_images (orderby, alt, s3icons, width, height, hash, path, fileName, mime, storageType, size, date, product_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SQL query parameters: array ( 1 => '10', 2 => '', 3 => array ( ), 4 => 0, 5 => 0, 6 => NULL, 7 => NULL, 8 => '', 9 => 'application/octet-stream', 10 => 'r', 11 => 0, 12 => 1409518381, 13 => 269, )

Any idea please
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #2  
Old 08-31-2014, 01:11 PM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: Error adding product

ok seemed to be caused by the Amazon S3 module ... disabled for now...................

could do with possibly better understanding of that... thought I had done it right
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #3  
Old 08-31-2014, 01:22 PM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: Error adding product

Did the message appear after you configured Amazon S3 module? Or did you enable the module, but not configured it?
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote
  #4  
Old 08-31-2014, 10:14 PM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: Error adding product

Hi
I Enabled and configured the module but had not migrated any images over at that point.
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #5  
Old 09-01-2014, 01:20 AM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: Error adding product

It may be a bug in the module. Was the full error message stored in a log file in the [xc5]/var/log/ directory? If so, please could you upload the log file there?
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote
  #6  
Old 09-01-2014, 09:13 AM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: Error adding product

it looks like it could have been the key . copying from webbrowser to the fields may have caused it ... Exported to csv and copied the text in from there ...

Its Migrating now so will give it a try when finished and let you know the outcome...


Taking some time but files are going over but keep getting this error in the top of the page "Event task runner internal error"


thanks
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #7  
Old 09-01-2014, 09:49 AM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: Error adding product

ok it seems to be stuck at 99% and wont move on and complaining about the key again even though it has been loading fine

This is repeating in the log file

Code:
Sep 01 10:36:16 XLite [error] Exception: S3::getObject(usawemakeanyshirt001, images/product/Pink_1.png): [NoSuchKey] The specified key does not exist. in /home/content/52/10720952/html/classes/XLite/Module/CDev/AmazonS3Images/lib/S3.php on line 566 Server API: cgi-fcgi; Request method: GET; URI: /shadow_flag.html; Backtrace: file <compiled classes repository>/classes/XLite/Module/CDev/AmazonS3Images/Core/S3.php : 148 file <compiled classes repository>/classes/XLite/Module/CDev/AmazonS3Images/Model/Base/Image.php : 91 file <compiled classes repository>/classes/XLite/Core/ImageOperator/GD.php : 85 file <compiled classes repository>/classes/XLite/Core/ImageOperator.php : 130 file <compiled classes repository>/classes/XLite/Core/ImageOperator.php : 115 file <compiled classes repository>/classes/XLite/Module/CDev/AmazonS3Images/Model/Base/Image.php : 430 file <compiled classes repository>/classes/XLite/Module/CDev/AmazonS3Images/Model/Base/Image.php : 430 file <compiled classes repository>/classes/XLite/Model/Base/ImageAbstract.php : 230 file <compiled classes repository>/classes/XLite/View/ImageAbstract.php : 322 file <compiled classes repository>/classes/XLite/View/ImageAbstract.php : 242 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 249 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 263 file <compiled classes repository>/skins/default/en/items_list/product/parts/common.product-thumbnail.tpl.php : 4 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 285 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 950 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 964 file <compiled classes repository>/skins/default/en/items_list/product/parts/grid.photo.tpl.php : 2 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 285 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 950 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 977 file <compiled classes repository>/skins/default/en/items_list/product/center/grid/body-css-layout.tpl.php : 9 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 285 file <compiled classes repository>/skins/default/en/items_list/body.tpl.php : 8 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 285 file <compiled classes repository>/skins/default/en/common/dialog.tpl.php : 3 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 285 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 950 file <compiled classes repository>/skins/default/en/center.tpl.php : 5 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 285 file <compiled classes repository>/classes/XLite/View/ContentAbstract.php : 73 file <compiled classes repository>/skins/default/en/layout/main.center.center.tpl.php : 7 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 285 file <compiled classes repository>/classes/XLite/View/ContentAbstract.php : 73 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 950 file <compiled classes repository>/skins/default/en/layout/main.center.tpl.php : 8 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 285 file <compiled classes repository>/classes/XLite/View/ContentAbstract.php : 73 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 950 file <compiled classes repository>/skins/default/en/main.tpl.php : 5 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 285 file <compiled classes repository>/classes/XLite/View/ContentAbstract.php : 73 file <compiled classes repository>/classes/XLite/View/AViewAbstract.php : 306 file <compiled classes repository>/classes/XLite/View/ControllerAbstract.php : 296 file <compiled classes repository>/classes/XLite/View/ControllerAbstract.php : 325 file <compiled classes repository>/classes/XLite/View/ControllerAbstract.php : 71 file <compiled classes repository>/classes/XLite/Controller/AControllerAbstract.php : 535 file <compiled classes repository>/classes/XLite.php : 476 file <X-Cart root>/cart.php : 35 Sep 01 10:54:44 XLite [warning] Warning: str_repeat(): Second argument has to be greater than or equal to 0 in /home/content/52/10720952/html/var/run/classes/XLite/View/ItemsList/Model/Order/Admin/Search.php on line 210 Server API: cgi-fcgi; Request method: GET; URI: /admin.php?target=main; Sep 01 10:54:44 XLite [warning] Warning: str_repeat(): Second argument has to be greater than or equal to 0 in /home/content/52/10720952/html/var/run/classes/XLite/View/ItemsList/Model/Order/Admin/Search.php on line 210 Server API: cgi-fcgi; Request method: GET; URI: /admin.php?target=main; Sep 01 10:54:44 XLite [warning] Warning: str_repeat(): Second argument has to be greater than or equal to 0 in /home/content/52/10720952/html/var/run/classes/XLite/View/ItemsList/Model/Order/Admin/Search.php on line 210 Server API: cgi-fcgi; Request method: GET; URI: /admin.php?target=main; Sep 01 10:54:44 XLite [warning] Warning: str_repeat(): Second argument has to be greater than or equal to 0 in /home/content/52/10720952/html/var/run/classes/XLite/View/ItemsList/Model/Order/Admin/Search.php on line 210 Server API: cgi-fcgi; Request method: GET; URI: /admin.php?target=main; Sep 01 10:54:44 XLite [warning] Warning: str_repeat(): Second argument has to be greater than or equal to 0 in /home/content/52/10720952/html/var/run/classes/XLite/View/ItemsList/Model/Order/Admin/Search.php on line 210 Server API: cgi-fcgi; Request method: GET; URI: /admin.php?target=main;

Im now worried that if I disable the module I will loose all the image links that have already loaded
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #8  
Old 09-02-2014, 04:08 AM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: Error adding product

The module is still sat at 99% migrating and does not seem to complete ? this is over 12 hours now


What will happen if I re cache the site at this stage ?

Thanks
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #9  
Old 09-02-2014, 12:07 PM
 
xanadude xanadude is offline
 

eXpert
  
Join Date: Jun 2006
Posts: 247
 

Default Re: Error adding product

JUst disabled the module and lost all images

Re-enabled it and they returned but still stuck as 99% and now cannot add any more images to the site

hellllllppppppp
__________________
Xanadude

http://wemakeanyshirt.com X5 with x-Cart Mobile in build
Reply With Quote
  #10  
Old 09-03-2014, 03:42 AM
  tony_sologubov's Avatar 
tony_sologubov tony_sologubov is offline
 

X-Cart team
  
Join Date: Jan 2009
Posts: 2,430
 

Default Re: Error adding product

Roger, I will contact you via email on this matter.

Tony.
__________________
Found a bug in X-Cart? Post it to our bug tracker!
Know how to make X-Cart better? Suggest an idea!
Reply With Quote
Reply
   X-Cart forums > X-Cart 5 > Modifying the design and features (X-Cart 5)


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 09:48 PM.

   

 
X-Cart forums © 2001-2020