OpenCart Community

bryanling wrote: ↑

Sat Apr 15, 2017 12:41 am

Hi JNeuhoff, would you mind to share this ? Or I need to buy it ? Thank you.

Please send me a PM, modifications chargeable for a small fee.

So how if someone can integer the Filezilla module in the admin itself and when I click on the Filezilla it have permanent settings from admin and connect the Filezilla to the root.

Can anyone think it is a great idea and can be implement to make the life easy.

Hello Everybody
Everything worked well during installation
but I have nothing regarding this extension in System > Users > User Group > Edit Administrator

So I have this error:
Permission Denied! Home Permission Denied!
You do not have permission to access this page, please refer to your system administrator.

how can I do?

thank you very much
ciao ciao

dedoboss wrote: ↑

Tue Apr 18, 2017 9:44 pm

Hello Everybody
Everything worked well during installation
but I have nothing regarding this extension in System > Users > User Group > Edit Administrator

So I have this error:
Permission Denied! Home Permission Denied!
You do not have permission to access this page, please refer to your system administrator.

how can I do?

thank you very much
ciao ciao

You have most likely not followed the install instructions from the 'readme.txt'. In particular, it looks like your files were uploaded to the wrong place, due to mis-configured FTP settings, e.g. FTP root, for your OpenCart extension installer. See http://docs.opencart.com/extension/installer/ for more details.

The good news is that the upcoming new OpenCart 3.0.0.0 won't be using FTP any more for the extension installer, many users seem to have problems with the current OpenCart 2.3.0.2 installer configuration. I hope that in the future simple one-click installs will become the norm.

Hi,

I've installed on opencart 2.3.0.2 and I'm having some problems when trying to upload products:

The error I get is below, 2 things stand out to me but I'm not sure how to fix
1. I'm using a MySQL database, not a MariaDB
2. There's a double comma as a delimiter between the data for location and mpn (no commas are in the data itself)

Any pointers would be greatly appreciated!

Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''A590',11,'',1,380,0,NOW(),NOW(),NOW(),0,1,1,9,0,0,0,0,'1','1','0','1')' at line 1
Error No: 1064
INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (50,1000,'A590','','','','','A590','default',,'A590',11,'',1,380,0,NOW(),NOW(),NOW(),0,1,1,9,0,0,0,0,'1','1','0','1');

Missing stock_status_id, usually one of the following numeric values:
5 = Out Of Stock
6 = 2-3 Days
7 = In Stock
8 = Pre-Order

opencart 2.3.0.2 export import 3.11

I don´t know. Some Help me ? Thanks

On local XAMP is OK, but on my domain error.

log file:
Could not close zip file php://output.

2017-05-01 14:53:04 - PHP Warning: realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/home/ri020900:/usr/share/pear) in /home/ri020900/www_root/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 178
2017-05-01 14:53:04 - PHP Warning: tempnam(): open_basedir restriction in effect. File() is not within the allowed path(s): (/home/ri020900:/usr/share/pear) in /home/ri020900/www_root/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 190
2017-05-01 14:53:04 - PHP PHPExcel_Writer_Exception: Could not close zip file php://output. in /home/ri020900/www_root/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 389

See http://stackoverflow.com/questions/2143 ... php-output for more details on how to resolve it.

It seems like exported files are wrong with PHP 7.
On PHP 5 everything works well.

z2i wrote: ↑

Tue May 02, 2017 12:11 am

It seems like exported files are wrong with PHP 7.
On PHP 5 everything works well.

Send me a PM withn your OpenCart and FTP login details, and I can take a quick look at your site.

Hello,

I have a problem. I exported the Products from my old OpenCart V.1.5.1.3 and tried to import them in the new V.2.3.0.2 and I am getting this Message I have to mention that I am using JooCart it's a Jooma & OpenCart Integration
If I open up both worksheest from the new version as example and the old one, I can see there are diffrences in the columns and how many columns there are available I think thats the point but how should I fix it?

Thanks

The formats of the worksheets will be slightly different between OpenCart versions. Therefore its best to do an Export first from the new OpenCart-based site and then use the resulting spreadsheet to copy and paste the old data to the new one.

JNeuhoff wrote: ↑

Fri May 05, 2017 11:09 pm

The formats of the worksheets will be slightly different between OpenCart versions. Therefore its best to do an Export first from the new OpenCart-based site and then use the resulting spreadsheet to copy and paste the old data to the new one.

Is there an easy way to do it with microsoft excel? never did something like this before

This has nothing to do MS Excel. You need to install the new OpenCart, and a matching Export/Import tool. Then do an Export to see the new spreadsheet format which differs from older OpenCart versions.

Hi!

I have clean installed Opencart 2.3.0.2 and this extension version 3.11. And have one question and one trouble:

1. Why you add OpenCartWorks after install this extension?
2. Export not worked - new items not adding (but success message showed)

https://youtu.be/30xTILSKK7c

JNeuhoff wrote: ↑

Fri May 05, 2017 11:29 pm

This has nothing to do MS Excel. You need to install the new OpenCart, and a matching Export/Import tool. Then do an Export to see the new spreadsheet format which differs from older OpenCart versions.

I understand that and I exported it in the new Opencart to see the diffrence but how can I make the old spreasheet look like the new one so I can Import it back to the new one?

Thanks

Hi!
After removal of the module are not added to products.

Error:PHP Notice: Undefined index: product_id in /var/www/magazin/data/www/smarket74.ru/system/storage/modification/admin/view/template/catalog/product_form.tpl on line 136

What to do?

Error problem,

When I import my product it show this error message " Uploaded spreadsheet file has validation errors!
See also 'System > Tools > Error Logs' for more details.
No server data has been changed. "

I got errot php://output. Please help me.
OC 2.2.0.0

Can't help you, you are not providing enough details.