Post by hcamelion » Mon Aug 17, 2009 9:34 am

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.

Henry Weismann
877.44.MY.WEB (877.446.9932)
We can help with your Opencart Site - Opencart Web Developer

Image


User avatar
New member

Posts

Joined
Mon Jul 27, 2009 3:14 am
Location - Albany, NY, USA

Post by topgun » Mon Aug 17, 2009 9:38 am

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?

Newbie

Posts

Joined
Wed Aug 12, 2009 10:24 am

Post by topgun » Mon Aug 17, 2009 9:55 am

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.

Newbie

Posts

Joined
Wed Aug 12, 2009 10:24 am

Post by topgun » Mon Aug 17, 2009 10:32 am

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.

Newbie

Posts

Joined
Wed Aug 12, 2009 10:24 am

Post by DannyMacD » Tue Aug 18, 2009 3:49 am

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

Active Member

Posts

Joined
Fri Jun 26, 2009 6:39 am

Post by topgun » Tue Aug 18, 2009 4:08 am

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!

Newbie

Posts

Joined
Wed Aug 12, 2009 10:24 am

Post by chiefk » Tue Aug 18, 2009 7:09 am

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?

New member

Posts

Joined
Fri May 22, 2009 7:52 pm

Post by jules_nz » Tue Aug 18, 2009 9:29 am

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

Active Member

Posts

Joined
Tue Aug 11, 2009 12:58 pm

Post by Qphoria » Tue Aug 18, 2009 9:47 am

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

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by jules_nz » Tue Aug 18, 2009 10:05 am

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

Active Member

Posts

Joined
Tue Aug 11, 2009 12:58 pm

Post by Qphoria » Tue Aug 18, 2009 10:40 am

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.

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by jules_nz » Tue Aug 18, 2009 10:46 am

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?

Active Member

Posts

Joined
Tue Aug 11, 2009 12:58 pm

Post by hcamelion » Tue Aug 18, 2009 10:49 am

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.

Henry Weismann
877.44.MY.WEB (877.446.9932)
We can help with your Opencart Site - Opencart Web Developer

Image


User avatar
New member

Posts

Joined
Mon Jul 27, 2009 3:14 am
Location - Albany, NY, USA

Post by jules_nz » Tue Aug 18, 2009 10:55 am

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

Active Member

Posts

Joined
Tue Aug 11, 2009 12:58 pm

Post by kornovec » Tue Aug 18, 2009 3:14 pm

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.

New member

Posts

Joined
Mon Jun 15, 2009 5:02 pm

Post by Daniel » Tue Aug 18, 2009 8:07 pm

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

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by chiefk » Wed Aug 19, 2009 6:45 am

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!

New member

Posts

Joined
Fri May 22, 2009 7:52 pm

Post by jules_nz » Wed Aug 19, 2009 8:26 am

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', '');

Active Member

Posts

Joined
Tue Aug 11, 2009 12:58 pm

Post by smallpox » Wed Aug 19, 2009 3:09 pm

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

New member

Posts

Joined
Sun Mar 29, 2009 2:12 pm

Post by chiefk » Wed Aug 19, 2009 6:06 pm

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!

New member

Posts

Joined
Fri May 22, 2009 7:52 pm
Who is online

Users browsing this forum: No registered users and 7 guests