Import/Export issues with 1.3.2

Quote

Post by dbsanders » Sun Aug 23, 2009 4:05 am

I just did a new install of 1.3.2, and the import/export gives me all kinds of errors. I added the permission to Top Admin, which works fine. Then I click Export, and get many many errors.

Code: Select all

Unknown: Only variables should be assigned by reference in /var/www/www.xxxx.com/admin/model/tool/export.php on line 1105Unknown: Only variables should be assigned by reference in /var/www/www.xxxx.com/admin/model/tool/export.php on line 1106Unknown: Assigning the return value of new by reference is deprecated in /var/www/www.xxxx.com/admin/Spreadsheet/Excel/Writer/Workbook.php on line 191Unknown: Assigning the return value of new by reference is deprecated in /var/www/www.xxxx.com/admin/Spreadsheet/Excel/Writer/Workbook.php on line 200Warning: Cannot modify header information - headers already sent by (output started at /var/www/www.xxxx.com/admin/index.php:57) in /var/www/www.xxxx.com/admin/Spreadsheet/Excel/Writer.php on line 68Warning: Cannot modify header information - headers already sent by (output started at /var/www/www.xxxx.com/admin/index.php:57) in /var/www/www.xxxx.com/admin/Spreadsheet/Excel/Writer.php on line 69Warning: Cannot modify header information - headers already sent by (output started at /var/www/www.xxxx.com/admin/index.php:57) in /var/www/www.xxxx.com/admin/Spreadsheet/Excel/Writer.php on line 70Warning: Cannot modify header information - headers already sent by (output started at /var/www/www.xxxx.com/admin/index.php:57) in /var/www/www.xxxx.com/admin/Spreadsheet/Excel/Writer.php on line 71Warning: Cannot modify header information - headers already sent by (output started at /var/www/www.xxxx.com/admin/index.php:57) in /var/www/www.xxxx.com/admin/Spreadsheet/Excel/Writer.php on line 72Unknown: Non-static method OLE::Asc2Ucs() should not be called statically, assuming $this from incompatible context in /var/www/www.xxxx.com/admin/Spreadsheet/Excel/Writer/Workbook.php on line 591Unknown: is_a(): Deprecated. Please use the instanceof operator in /usr/share/php/PEAR.php on line 281Unknown: Non-static method OLE::Asc2Ucs() should not be called statically, assuming $this from incompatible context in /var/www/www.xxxx.com/admin/OLE/PPS/Root.php on line 52Unknown: Non-static method OLE::LocalDate2OLE() should not be called statically, assuming $this from incompatible context in /var/www/www.xxxx.com/admin/OLE/PPS.php on line 190Unknown: Non-static method OLE::LocalDate2OLE() should not be called statically, assuming $this from incompatible context in /var/www/www.xxxx.com/admin/OLE/PPS.php on line 191Unknown: Non-static method OLE::LocalDate2OLE() should not be called statically, assuming $this from incompatible context in /var/www/www.xxxx.com/admin/OLE/PPS.php on line 190Unknown: Non-static method OLE::LocalDate2OLE() should not be called statically, assuming $this from incompatible context in /var/www/www.xxxx.com/admin/OLE/PPS.php on line 191
dbsanders
Newbie
Posts
3
Joined
Thu Aug 06, 2009 2:34 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by sevenate » Sun Aug 23, 2009 6:18 am

On a new install of 1.3.2 (using a previously upgraded database from 1.3.0) I received the following error when attempting to Backup from the OC Admin interface...

Error: Access denied for user 'username'@'hostname' to database ''databasename'
Error No: 1044
SHOW TABLES FROM `'databasename`

However, a quick look at /admin/model/tool/backup.php revealed a single quote that simply needed to be removed, to make the Backup function work (for me). I changed Line 16 from...

Code: Select all

$table_query = $this->db->query("SHOW TABLES FROM `'" . DB_DATABASE . "`");
to...

Code: Select all

$table_query = $this->db->query("SHOW TABLES FROM `" . DB_DATABASE . "`");
Note the extra single quote just before " . DB_DATABASE

Not sure if this is causing your issue, or if this is the best fix to my own problem... but it may help you or someone else.
sevenate
Newbie
Posts
8
Joined
Sat Aug 01, 2009 9:08 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by JNeuhoff » Sun Aug 23, 2009 7:13 am

I just did a new install of 1.3.2, and the import/export gives me all kinds of errors. I added the permission to Top Admin, which works fine. Then I click Export, and get many many errors.
It looks you havn't installed to latest matching release of the Export/Import for 1.3.2 which now uses its own error handler. You are probably using a wrong version of the Export/Import module.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

User avatar
JNeuhoff
Guru Member
Posts
7488
Joined
Wed Dec 05, 2007 3:38 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by kornovec » Wed Aug 26, 2009 2:12 am

I did your changes in backup.php and BACKUP now fully working! .)
And what about with import/export tool?

Thanks!
K.
kornovec
New member
Posts
52
Joined
Mon Jun 15, 2009 5:02 pm
Top

Re: Import/Export issues with 1.3.2

Quote

Post by sevenate » Wed Aug 26, 2009 2:15 am

kornovec wrote:And what about with import/export tool?
Sorry, never used the Import/Export tool. Perhaps someone else can chime in here?
sevenate
Newbie
Posts
8
Joined
Sat Aug 01, 2009 9:08 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by Microsite Merchant » Wed Aug 26, 2009 5:22 pm

I had the same error with a backup, made the change to backup.php and it worked for me too.

The export/import module also works.

And I've just got SEO url's working as well. Yay. Off to the pub for a swift half me thinks O0
Posts
15
Joined
Wed Jun 03, 2009 10:57 pm
Top

Re: Import/Export issues with 1.3.2

Quote

Post by tilesupply » Sun Aug 30, 2009 5:57 am

Hi All

How can I transfer the Categories, manufactures and products from one website to another?

I have 2 websites that will be listing all the same items for sale.
There are about 10,000+ items, so it would be easy if I could use a back up of the list from one site for the other, or copy and paste the right files into the other site.

Can anyone help me with this or point me in the right direction.

This is the note i get back if i try the back up from another site.

Error: Table 'bathroom_supply.CubeCart_Coupons' doesn't exist
Error No: 1146
TRUNCATE TABLE `CubeCart_Coupons`

I am very new to all this.

Many Thanks

Paul
tilesupply
Active Member
Posts
107
Joined
Wed Aug 26, 2009 7:48 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by JNeuhoff » Sun Aug 30, 2009 6:58 pm

Error: Table 'bathroom_supply.CubeCart_Coupons' doesn't exist
Error No: 1146
TRUNCATE TABLE `CubeCart_Coupons`
Are you sure you are not using CubeCart? This forum is all about the OpenCart project. OpenCart uses its own set of DB tables which are different from those of CubeCart.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

User avatar
JNeuhoff
Guru Member
Posts
7488
Joined
Wed Dec 05, 2007 3:38 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by tilesupply » Mon Aug 31, 2009 3:42 am

I am using opencart 1.3.2.

When I do a back up it says cube cart all over it, don’t know why.
Also I have gone through all the files so I don’t know where its getting cube cart from.

I have done a full reinstall with a few mods of my own.
Its all working now, but this cube cart biz had myself and the programmer stumped.
tilesupply
Active Member
Posts
107
Joined
Wed Aug 26, 2009 7:48 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by sjmusic » Thu Sep 03, 2009 4:04 am

EXPORT ERROR - PLEASE HELP

Notice: Undefined index: warning in /home/southjer/public_html/cart/admin/controller/tool/export.php on line 29Notice: Undefined index: success in /home/southjer/public_html/cart/admin/controller/tool/export.php on line 46
sjmusic
Newbie
Posts
5
Joined
Tue Sep 01, 2009 5:12 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by JBaptista68 » Thu Sep 03, 2009 10:30 am

I also have a similar issue. I am testing open cart in the hopes that it can replace oscommerce and import/export is pretty much a show stopper.

I did a fresh installation of OPENCART and then installed the latest version of the Import/Export module.

When I click export this is the error that I get.


Unknown: Assigning the return value of new by reference is deprecated in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php on line 191Unknown: Assigning the return value of new by reference is deprecated in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php on line 200Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php:191) in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer.php on line 68Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php:191) in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer.php on line 69Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php:191) in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer.php on line 70Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php:191) in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer.php on line 71Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php:191) in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer.php on line 72ÐÏࡱá;þÿ ‚þÿÿÿƒ„ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ » ÌABä=¼%r8X"1ÈÿArial1ÈÿArial1ÈÿArial1ÈÿArial1ÈÿArial1È Arial¤ ######0.00 ¥##0.00¦@àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À àõÿ À à À à À à¤#À à@À à¥#À ঠÀ “€ÿ’â8ÿÿÿÿÿÿÿÿÿÿÿÿ€€€€€€€€€ÀÀÀ€€€™™ÿ™3fÿÿÌÌÿÿffÿ€€fÌÌÌÿ€ÿÿÿÿÿÿ€€€€€ÿÌÿÌÿÿÌÿÌÿÿ™™Ìÿÿ™ÌÌ™ÿÿÌ™3fÿ3ÌÌ™ÌÿÌÿ™ÿfff™–––3f3™f333™3™3f33™333…ãÐ Categories…­ÛProducts…ÜþOptionsü ªä category_id parent_idname sort_order image_name date_added date_modified language_id seo_keyword descriptionmetaDesktops2009-01-05 21:49:432009-08-07 14:04:42desktops
JBaptista68
Newbie
Posts
10
Joined
Thu Sep 03, 2009 10:27 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by tilesupply » Thu Sep 03, 2009 10:41 am

This part did work for me on my old server.
Change the top line to the bottom line.


Code: Select all
$table_query = $this->db->query("SHOW TABLES FROM `'" . DB_DATABASE . "`");


to...

Code: Select all
$table_query = $this->db->query("SHOW TABLES FROM `" . DB_DATABASE . "`");

Now i have a new problem with my new server.
I have asked did the server have pear on it, the ans is yes.
So why do i get this

Warning: require_once(PEAR.php) [function.require-once]: failed to open stream: No such file or directory in /home/linweb01/b/bathroom-supply.co.uk/user/htdocs/admin/Spreadsheet/Excel/Writer.php on line 35

I have put opencart onto 7 servers so far, they where with one.com.
But this new one with fasthost gives me this problem.

Any ideas how to fix this problem.
Have you seen this problem before Daniel.
tilesupply
Active Member
Posts
107
Joined
Wed Aug 26, 2009 7:48 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by JNeuhoff » Thu Sep 03, 2009 5:23 pm

Notice: Undefined index: warning in /home/southjer/public_html/cart/admin/controller/tool/export.php on line 29Notice: Undefined index: success in /home/southjer/public_html/cart/admin/controller/tool/export.php on line 46
There are no references to index nor success on lines 29 and 46. It seems you are using the wrong version of the Export/Import module. Please use the one which matches OpenCart 1.3.2.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

User avatar
JNeuhoff
Guru Member
Posts
7488
Joined
Wed Dec 05, 2007 3:38 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by JNeuhoff » Thu Sep 03, 2009 5:29 pm

When I click export this is the error that I get.


Unknown: Assigning the return value of new by reference is deprecated in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php on line 191
Are you sure you are really using this release of the Export/Import module? Your errors are caused by Opencart's new error handler, introduced in version 1.3.2. The latest Export/Import module uses its own error handler to avoid these messages.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

User avatar
JNeuhoff
Guru Member
Posts
7488
Joined
Wed Dec 05, 2007 3:38 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by JNeuhoff » Thu Sep 03, 2009 5:34 pm

I have put opencart onto 7 servers so far, they where with one.com.
But this new one with fasthost gives me this problem.

Any ideas how to fix this problem.
Kindly ask your new host to provide a PHP configuration which includes the pre-installed PHP PEAR library.

You can verify whether its there or not, by creating a phpinfo.php file with this:

Code: Select all

<?php phpinfo(); ?>
and then upload and execute it from your main Opencart directory. This tell you your PHP configuration.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

User avatar
JNeuhoff
Guru Member
Posts
7488
Joined
Wed Dec 05, 2007 3:38 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by JBaptista68 » Thu Sep 03, 2009 8:38 pm

JNeuhoff wrote:
When I click export this is the error that I get.


Unknown: Assigning the return value of new by reference is deprecated in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php on line 191
Are you sure you are really using this release of the Export/Import module? Your errors are caused by Opencart's new error handler, introduced in version 1.3.2. The latest Export/Import module uses its own error handler to avoid these messages.
Thank you for the super fast response! This was a brand new installation on a local server and the version of the export script is the same as the one in your link above.
JBaptista68
Newbie
Posts
10
Joined
Thu Sep 03, 2009 10:27 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by JNeuhoff » Thu Sep 03, 2009 10:07 pm

Try this then in the /admin/index.php, on line 68:

Code: Select all

set_error_handler('error_handler',E_ALL);

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

User avatar
JNeuhoff
Guru Member
Posts
7488
Joined
Wed Dec 05, 2007 3:38 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by JBaptista68 » Thu Sep 03, 2009 10:34 pm

JNeuhoff wrote:Try this then in the /admin/index.php, on line 68:

Code: Select all

set_error_handler('error_handler',E_ALL);
Thanks again for the super fast response!

I still get the same error. I've rechecked the versions of everything and they are correct.

Here is the output from the error log.

2009-09-03 10:27:56 - PHP Unknown: Assigning the return value of new by reference is deprecated in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php on line 191
2009-09-03 10:27:56 - PHP Unknown: Assigning the return value of new by reference is deprecated in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php on line 200
2009-09-03 10:27:57 - PHP Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php:191) in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer.php on line 68
2009-09-03 10:27:57 - PHP Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php:191) in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer.php on line 69
2009-09-03 10:27:57 - PHP Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php:191) in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer.php on line 70
2009-09-03 10:27:57 - PHP Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php:191) in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer.php on line 71
2009-09-03 10:27:57 - PHP Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer\Workbook.php:191) in C:\xampp\htdocs\opencart\admin\Spreadsheet\Excel\Writer.php on line 72
JBaptista68
Newbie
Posts
10
Joined
Thu Sep 03, 2009 10:27 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by JNeuhoff » Thu Sep 03, 2009 11:55 pm

That defeats me. The only other thing I can think of is to try it on a Linux or Unix system, or on a proper Linux server system of a good webhost.

Also, what's your PHP version?

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

User avatar
JNeuhoff
Guru Member
Posts
7488
Joined
Wed Dec 05, 2007 3:38 am
Top

Re: Import/Export issues with 1.3.2

Quote

Post by JBaptista68 » Fri Sep 04, 2009 2:26 am

I'm running an apache server using XAMPP 1.7.2

My version of PHP is 5.30.

I usually get everything running on a local machine and then upload to our hosted server but I may throw it up on one of my staging hosts to see what happens.

Thanks again for the support. Top notch. I really want to get this thing working as I've got 8 osCommerce stores that I want to upgrade and each has about 7000 products in it so I can't make it work without the import export function.
JBaptista68
Newbie
Posts
10
Joined
Thu Sep 03, 2009 10:27 am
Top
Post Reply
Return to “Extension Support”
Who is online

Users browsing this forum: No registered users and 1 guest