its still doing it. Tried on 2 different computers and 2 different browsers
Heres my error log
Heres my error log
Code: Select all
2011-01-07 14:59:12 - PHP Notice: Undefined index: message in /home/biketek/public_html/store/catalog/controller/product/product.php on line 489
2011-01-07 15:03:12 - PHP Notice: Undefined index: message in /home/biketek/public_html/store/catalog/controller/product/product.php on line 489
2011-01-07 15:03:56 - PHP Notice: Undefined index: message in /home/biketek/public_html/store/catalog/controller/product/product.php on line 489
2011-01-07 15:05:32 - PHP Notice: Undefined index: message in /home/biketek/public_html/store/catalog/controller/product/product.php on line 489
2011-01-07 15:15:22 - PHP Notice: Undefined index: message in /home/biketek/public_html/store/catalog/controller/product/product.php on line 489
2011-01-19 4:04:52 - PHP Notice: Use of undefined constant columns - assumed 'columns' in /home/biketek/public_html/store/admin/model/tool/csv.php on line 89
2011-01-19 4:10:24 - PHP Notice: Use of undefined constant columns - assumed 'columns' in /home/biketek/public_html/store/admin/model/tool/csv.php on line 89
2011-01-19 8:52:54 - PHP Notice: Use of undefined constant columns - assumed 'columns' in /home/biketek/public_html/store/admin/model/tool/csv.php on line 89
2011-01-19 8:56:41 - PHP Notice: Use of undefined constant columns - assumed 'columns' in /home/biketek/public_html/store/admin/model/tool/csv.php on line 89unrelated.. just a typo i made last night to debug it.. but I didnt see the problem so there was nothing to debug. I've fixed that typo.. but still don't see the error. Did this ever work for you? Maybe locale related or something
USA/Windows/latest firefox ...no error
USA/Windows/latest firefox ...no error
Ok I think I have finally worked this out!
How to Re-Create the error:
1. Export the file and save to computer
2. Do not open the file but try to import it back into Opencart
3. You will see the error that we have been experiencing
As a workround the below works for me.
Once you have exported the file to your computer, open it in Microsoft Excel and save it. Make sure you save it as a CSV file. It should now upload without a problem.
Qphoria: is this an issue with the export routine not formatting the file correctly?
How to Re-Create the error:
1. Export the file and save to computer
2. Do not open the file but try to import it back into Opencart
3. You will see the error that we have been experiencing
As a workround the below works for me.
Once you have exported the file to your computer, open it in Microsoft Excel and save it. Make sure you save it as a CSV file. It should now upload without a problem.
Qphoria: is this an issue with the export routine not formatting the file correctly?
Last edited by dry_flood on Wed Jan 26, 2011 7:24 am, edited 1 time in total.
For a FREE CSV editor that allows more flexibility than Excel or OpenOffice go here - http://csved.sjfrancke.nl/index.html
Not necessary, but can be useful in some situations.
Not necessary, but can be useful in some situations.
A Trusted Wholesale Dropshipper
Web Hosting Under $ 5.00 Month! FREE Shopping Carts!
25,000+ Real Wholesale & Dropship Sources!
Can you attach both files.dry_flood wrote:Ok I think I have finally worked this out!
How to Re-Create the error:
1. Export the file and save to computer
2. Do not open the file but try to import it back into Opencart
3. You will see the error that we have been experiencing
As a workround the below works for me.
Once you have exported the file to your computer, open it in Microsoft Excel and save it. Make sure you save it as a CSV file. It should now upload without a problem.
Qphoria: is this an issue with the export routine not formatting the file correctly?
Save the file but dont open it in excel
Save the file again but open it in excel and save it.
put them both in a zip and attach here so I can see.
I tried it with and without edit here and it works for me.
Hi i am having a few problems i am trying to import categories and am not entirely sure if i am doing ti right as it rights them to the database as i checked in phpmyadmin but it wont add to the categories in opencart backend or frontend.
This is what i have in my categories.csv and categories_description.csv
category csv:
category description csv:
As i cant see the problem as when io import tells me its been successful.
P.S hope someone can help
Regards,
Aaron
This is what i have in my categories.csv and categories_description.csv
category csv:
Code: Select all
category.category_id category.parent_id category.sort_order category.status
1 1 3 1
2 2 2 1
3 3 1 1
4 4 5 1
5 5 2 1
6 6 4 1
7 7 1 1
8 8 1 1
9 9 1 1
10 10 1 1
11 11 1 1
12 12 1 1
13 13 6 1
14 14 7 1
15 15 8 1
16 16 9 1Code: Select all
category_description.category_id category_description.name
1 Adult Fancy Dress Costumes
2 Animal Fancy Dress Costumes
3 Children's Fancy Dress
4 Cosmetics and Disguises
5 Fancy Footwear
6 Fever Range
7 Film and TV Fancy Dress
8 Halloween Fancy Dress
9 Hen & Stag Party Costumes
10 Historical Fancydress
11 Jokes and Novelties
12 Light Up and Party
13 Risque Fancy Dress
14 Seasonal Lines
15 Sheer Desires Hosiery
16 WigsP.S hope someone can help
Regards,
Aaron
Parent categories should have a parent id of 0aaron1988 wrote:Code: Select all
category.category_id category.parent_id category.sort_order category.status 1 1 3 1 2 2 2 1 3 3 1 1 4 4 5 1 5 5 2 1 6 6 4 1 7 7 1 1 8 8 1 1 9 9 1 1 10 10 1 1 11 11 1 1 12 12 1 1 13 13 6 1 14 14 7 1 15 15 8 1 16 16 9 1
If you set the parent id equal to itself it cancels itself out
I cannot seem to get this mod to work correctly. I tried uploading the CSV files, eventhough the message came back as the csv fils was successfully uploaded. No images and data information was added to the products, However, when I went to the front end I went to the category where I uploaded them to, The number of pages really increased like the products were there, after taking a look I got a error message. Then all the products I had uploaded one by one before trying the CSV mod, they just all disappeared, There was not one product on showing in the front end, after checking the admin for the products, there were none!!
Luckly I backup before trying the import, so I managed to restore the SQL file.
I have checked the error log, Ihave these error messages:
2011-02-03 7:54:04 - PHP Notice: Undefined index: reqd in /home/XXXXX/public_html/catalog/view/theme/default/template/product/product.tpl on line 79
2011-02-03 8:19:17 - PHP Notice: Undefined variable: text_error in /home/xxxxx/public_html/catalog/view/theme/default/template/product/category.tpl on line 22
Any advice and help would be greatly appreciated.
Thanks
I thought to add this to this post - Hoping to get a responce.
I had tried uploading the csv files again, all products now missing, I have the error messages. All date format in the CSV file is all set at 1970 etc...
Need help please, is this mod not okay to use? If not perhaps it should be removed for use, as I feel I may have wasted 3 days of work.
If you can help I would appreciate it. Thank you.
http://australianwebsitesolutions.com.au Australian Website Hosting for Opencart Shopping sites- Serious Hosting for Serious Aussie Shopping Sites!
Well you have a few things to note here...
first off, if you are getting success messages and you are seeing the product count but not the actual products, that means you didn't fill in some corresponding fields.
To add a new product you need to add it to
product
product_to_store
and preferrably:
product_description
product_to_category
But if you are getting upload errors or date issues.. that can be an error.
All I know is when I released it last it worked great for me. For months it worked great for people.. then all of a sudden it stopped working for people.. still works for me.. so I'm trying to figure out what the problem is.
first off, if you are getting success messages and you are seeing the product count but not the actual products, that means you didn't fill in some corresponding fields.
To add a new product you need to add it to
product
product_to_store
and preferrably:
product_description
product_to_category
But if you are getting upload errors or date issues.. that can be an error.
All I know is when I released it last it worked great for me. For months it worked great for people.. then all of a sudden it stopped working for people.. still works for me.. so I'm trying to figure out what the problem is.
Update is working perfectly for me. Thanks Qphoria.
If anyone is interested, attached is a VQMod Script for this Extension.
If anyone is interested, attached is a VQMod Script for this Extension.
Attachments
Q, just to know... is it possible this mod is working with older releases of OC? I mean 1.3.2.... Considering it works mainly on MySql DB I suppose it could work... couldn't it?
-----------------------------------------------------------------------
My last mods: Partita IVA e CF | Pro EU VAT Number | Sales Agents | Pricelist Pro
-----------------------------------------------------------------------
Is there a reason my database is full of html markup (like "á" instead of "á") everywhere when importing with this tool?
When I import a csv created with this tool using phpmyadmin with a utf8 charset everything looks fine... so it must be something about the import function and my database collation/browser/OS/whatever...
any ideas?
When I import a csv created with this tool using phpmyadmin with a utf8 charset everything looks fine... so it must be something about the import function and my database collation/browser/OS/whatever...
any ideas?
Who is online
Users browsing this forum: No registered users and 3 guests
