Problem by UPGRADE to 1.4.6

Hallo,

i have a problem by upgrade from 1.4.4 to 1.4.6

I have first enter the following code in my DB manager ( PHP MyAdmin ):

ALTER TABLE `store` DROP `stock_status_id`;
ALTER TABLE `customer` ADD `store_id` INT( 11 ) NOT NULL DEFAULT '0' AFTER `customer_id`;
ALTER TABLE `order` ADD `invoice_id` INT( 11 ) NOT NULL DEFAULT '0' AFTER `order_id`;
ALTER TABLE `order` ADD `invoice_prefix` VARCHAR( 10 ) NOT NULL AFTER `invoice_id`;

THIS WAS SUCESSFULL

And then I enter the next code:

INSERT INTO `opencart_dev`.`setting` (
`setting_id` ,
`group` ,
`key` ,
`value`
)
VALUES (
NULL , 'config', 'config_language', 'en'
);

AND I BECOME A FOLLOWING ERROR:

#1142 - INSERT command denied to user 'lovac24'@'localhost' for table 'setting'

Can somebody help me? Thanks

I have the same problem.

Just try it as: If that doesn't work double-check that the user has permission to do database inserts.

rph wrote:Just try it as:

Code: Select all

INSERT INTO `setting` (
`setting_id` ,
`group` ,
`key` ,
`value` 
)
VALUES (
NULL , 'config', 'config_language', 'en'
);

If that doesn't work double-check that the user has permission to do database inserts.

That worked. Thanks!

I had the same problem, but used the code you supplied above and it worked fine.

I do have a recommendation. Most projects that I have used in the past have the config files re-named in the download so those upgrading can just upload the files without the risk of overwriting their config files (something like confignew.php that have to be renamed in an original install).

This is my first opencart upgrade and it is not quite a easy as I would have like, but I await patiently for any type of auto update feature.

Thanks for everyone contribution to this project.