Ok I had to release another version after I found a massive bug in the specials and backup / restore system.
I recommend updating to this version.
You can download it here:
http://opencart.googlecode.com/files/op ... v1.3.2.zip
It also fixes a problem where new customer were not assigned a customer group id.
Great, thanks for the new one.
When I went from 1.3 to 1.3.1 or tried, I encountered quite a few errors.
Thanks for OpenCart!
When I went from 1.3 to 1.3.1 or tried, I encountered quite a few errors.
Thanks for OpenCart!
Thanks Daniel.
Just so you know, when using 1.3.1's upgrade instructions, you run into the same error when restoring the database:
I look forward to your 1.3.0 --> 1.3.2 upgrade instructions.
Cheers
Just so you know, when using 1.3.1's upgrade instructions, you run into the same error when restoring the database:
Code: Select all
Error: Unknown column 'discount' in 'field list'
Error No: 1054
INSERT INTO `order_product` (`order_product_id`, `order_id`, `product_id`, `name`, `model`, `price`, `discount`, `total`, `tax`, `quantity`) VALUES ('41', '33', '92', 'Dog Seat Belt Restraint', 'DSBR145', '4.9900', '0.0000', '124.7500', '0.0000', '25')Cheers
hello all, there is some way to use the protocol (sslv2) gmail google app
in this way so you can send messages across the google gmail app.
sslv2:// smtp.gmail.com
===================
host: smtp.gmail.com
Port: 465
Authentication: Yes
Username: #YOU#@gmail.com OR #YOU#@mydomaingoogleapp.com
Password: your_password # #
in this way so you can send messages across the google gmail app.
sslv2:// smtp.gmail.com
===================
host: smtp.gmail.com
Port: 465
Authentication: Yes
Username: #YOU#@gmail.com OR #YOU#@mydomaingoogleapp.com
Password: your_password # #
I am having problems with pagination on 1.3.0. Both with or without SEO urls it's not working past page 2.
With SEO on this is the url for every page:
With it off the link looks ok but after page 2 doesn't show the products:
I'll upgrade to this latest and see if it fixes it.
With SEO on this is the url for every page:
Code: Select all
/prints?page=%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20Code: Select all
/index.php?route=product/category&path=40&page=3Henry Weismann
877.44.MY.WEB (877.446.9932)
We can help with your Opencart Site - Opencart Web Developer
It will; it's a bug that was fixed in the latest version. The upgade process is a bit flakey at the minute.hcamelion wrote:I am having problems with pagination on 1.3.0. Both with or without SEO urls it's not working past page 2.
With SEO on this is the url for every page:With it off the link looks ok but after page 2 doesn't show the products:Code: Select all
/prints?page=%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20I'll upgrade to this latest and see if it fixes it.Code: Select all
/index.php?route=product/category&path=40&page=3
hi, i got this error whenever I try to import my previous database into 1.32 it show this error when i go to index.php
Error: Unknown column 'price' in 'field list'
Error No: 1054
SELECT price FROM product_discount WHERE product_id = '76' AND customer_group_id = '0' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1
http://echic.co.cc/shop/index.php
Error: Unknown column 'price' in 'field list'
Error No: 1054
SELECT price FROM product_discount WHERE product_id = '76' AND customer_group_id = '0' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1
http://echic.co.cc/shop/index.php
Ok here are my steps for a smooth upgrade from 1.3.0 to 1.3.2 with an attached sql file to run....
(Im not sure if this will work from 1.3.1 to 1.3.2 you will have to do a diff on the three schemas)
Let me know how it works for everyone.
PS: Yes the new version did fix the pagination issue.
(Im not sure if this will work from 1.3.1 to 1.3.2 you will have to do a diff on the three schemas)
Note: this assumes you do not have a database prefix. If you do you will have to add the prefix to the sql commands in the sql file.1.3.0 > 1.3.2
To Upgrade:
1. First off backup your site.
2. Goto your opencart's store admin and download a backup of your database.
3. Delete the files in your hosting directory. **SEE NOTE AFTER LAST STEP**
4. Upload the files from the download.
5. Go through the install as normal but use a new database while keeping the old intact.
6. Once the install is done run the attached file db_changes.sql in your database administrator on the old database.
7. Goto the image directory from the backup and copy all the image and upload to the image directory on your hosting.
8. Goto the download directory from the backup and copy all the downloads and upload to the download directory on your hosting.
9. Go to the administration and give Top Administrator access to customer groups and modify abilities.
10. Change to the old database in both the admin and catalog config files.
11. Load the site and test everything.
**If you have tons of large images and downloads you may choose not to delete the downloads and images folders**
Let me know how it works for everyone.
PS: Yes the new version did fix the pagination issue.
Attachments
Changes to the OpenCart database from 1.3.0 to 1.3.2
Last edited by hcamelion on Fri Aug 14, 2009 3:16 pm, edited 1 time in total.
Henry Weismann
877.44.MY.WEB (877.446.9932)
We can help with your Opencart Site - Opencart Web Developer
is there any errors? check your error log.uycarumba wrote:hi Qphoria protocol type or host that you used to use the smtp of gmail?
I set the smtp to the data in the image here.
but still can not work for me to send my messages
thanks
OpenCart®
Project Owner & Developer.
Hi Daniel, sslv2 to use this host: sslv2://smtp.gmail.com at SMTP_Host to send a message shows me this error:
Error: AUTH LOGIN command failed!
now I have configured the smtp mail in this way in the image:
any solution to this problem in order to use gmail google app I would appreciate very much.
thanks.
Error: AUTH LOGIN command failed!
now I have configured the smtp mail in this way in the image:
any solution to this problem in order to use gmail google app I would appreciate very much.
thanks.
I said above I didn't use the smtp. I just left it blank and used normal mail and put "mymail@gmail.com" into the store owner email fielduycarumba wrote:hi Qphoria protocol type or host that you used to use the smtp of gmail?
I set the smtp to the data in the image here.
but still can not work for me to send my messages
thanks
Who is online
Users browsing this forum: No registered users and 24 guests
