OpenCart Community

topgun wrote: Thanks.

Also, how do I go about running that file in phpmyadmin? Is it through the query section?

Yes you can open the sql file and copy and paste into your sql query section or you can upload the sql file in the import section of phpmyadmin. Make sure you back everything up first.

hcamelion wrote:

topgun wrote: Thanks.

Also, how do I go about running that file in phpmyadmin? Is it through the query section?

Yes you can open the sql file and copy and paste into your sql query section or you can upload the sql file in the import section of phpmyadmin. Make sure you back everything up first.

Sorry I am new to this and just learning. How do I back up the database in phpmyadmin?

Now I am getting this error when I import the sql file.

Error
SQL query:

--
-- Dumping data for table `measurement_rule`
--
/*changes to customer table*/ ALTER TABLE `customer` ADD COLUMN `customer_group_id` int( 11 ) NOT NULL AFTER `status` ;



MySQL said:

#1060 - Duplicate column name 'customer_group_id'


Any ideas?

I don't even see that name in my column list.

I have no idea what I'm doing wrong. This is frustrating.

I can't even do step 9 because in the admin panel it doesn't even have the options for me to do what you are instructing and for step 10 I have an admin config file but no catalog config file.

would someone be willing to do this for me ? lol

every time i upgrade a current store to a new one it gets messed up...

feedback:

i think you should get some sort of auto upgrade. a feature that i know zencart and wordpress uses. its good for idiots like me that cant do these updates without messing things up


many thanks

DannyMacD wrote:would someone be willing to do this for me ? lol

every time i upgrade a current store to a new one it gets messed up...

feedback:

i think you should get some sort of auto upgrade. a feature that i know zencart and wordpress uses. its good for idiots like me that cant do these updates without messing things up


many thanks

I agree. I just followed those steps to a "T" and ruined my store royally. I had to redo everything again.

By the way Daniel, thanks for displaying the multiple taxes in the Order Totals section!

Hi.I am trying but it gives me this message Error: Unknown column 'keyword' in 'field list'
Error No: 1054
INSERT INTO `category` (`category_id`, `keyword`, `image`, `parent_id`, `sort_order`, `date_added`, `date_modified`) VALUES ('45', '', '', '0', '7', '2009-05-16 11:54:17', '2009-06-02 22:58:20')
I am upgrading from 1.3.0 to 1.3.2.
Any ideas?

For those that are upgrading is it possible to have a download zip that only has the files that have been edited?
Rather than having to upload all the files again and then have to redo any customization

Or at least just a list of the files that were changed between versions
That would help alot

That becomes a major maintenance nightmare.
See my thoughts on it here:
http://forum.opencart.com/viewtopic.php ... ba0#p27379

But that is talking about the database
I have no issues with that, that was easy to update thanks to hcamelion

I am referring to the actual files themselves (such as the stylesheet for example)
If I knew that the stylesheet didn't have any changes made to it in the new version then I could just put my customized stylesheet back up and know that I wouldn't be overwriting anything added with the new versions file

right but that means more work to separate... I dunno. I've not tried it because I've heard its hellish making sure you didn't forget a file.

I do see what you mean, that it would put a lot of ownership on Daniel to ensure the list is complete

Perhaps windows Modified Date on the file could be used to generate the list of edited files?

This is what I use: http://winmerge.org/

It's not an exact science but it will be helpful. But I agree...it should be on the website developer to figure it out. The more overhead the project developer(s) have to do on each release the less new features.

Thanks for the link Henry
I still have 2 shops left to upgrade
So I will have a play with this tool
Thanks

Hello,

emails through opencart not working, anybody can help me please?
Tried left only MAIL or SMTP with many option even my 100% working host and still no chance to send email to customer when order changes.

Thank for advice!
K.

are u sure your hosting has not diasbled the php mail function?

I'm not getting anywhere with upgrade from 1.3.0-1.3.2.When i run the db changes in phpmyadmin it gives me this: Error

SQL query:
--
-- Dumping data for table `measurement_rule`
--
/*changes to customer table*/ ALTER TABLE `customer` ADD COLUMN `customer_group_id` int( 11 ) NOT NULL AFTER `status` ;

MySQL said: Documentation
#1060 - Duplicate column name 'customer_group_id'
What does this mean??

Also in the instructions, it says '10. Change to the old database in both the admin and catalog config files.'
Now,(1) how? (2) why create a new d/base the revert to old one? so what happens to the new one???
HEEELPP!

Hi ChiefK

Make sure you are running the database changes on the old database files and not the new one you just created

Once you have run that on the old database you can then adjust the config.php and admin/config.php files to show the original database details

thanks, worked great...

but as far as changes, i never thought of this but as opencart updates, new things are being added to the database, for example:

(15612, 'config', 'config_image_additional_height', '150'),
(15611, 'config', 'config_image_additional_width', '150'),

and what not, i noticed this when my images wouldn't show and diff'd 1.3.0's against 1.3.2 (product.php) and noticed that there is something that took over imageresize.

what are your suggestions to stay up to date with version changes through the database?

i just thought as i was typing this that i could maybe diff every single install sql file and just add them manually?

thanks

setting_id's dont even match.

(9250, 'config', 'config_logo', 'logo.png'), = 1.3.0
6892 config config_logo logo.png = what was originally from a 1.2.5 or something up to 1.2.8 i had it

jules_nz wrote:Hi ChiefK

Make sure you are running the database changes on the old database files and not the new one you just created

Once you have run that on the old database you can then adjust the config.php and admin/config.php files to show the original database details

Code: Select all

define('DB_DRIVER', 'mysql');
define('DB_HOSTNAME', '??');
define('DB_USERNAME', '??');
define('DB_PASSWORD', '??');
define('DB_DATABASE', '??');
define('DB_PREFIX', '');

The error i got was when running the db changes on the old database!
So, do i run on old DB, adjust the config files( of the new DB?).. sorry i'm lost here!