OpenCart Community

odi2000 wrote:Thanks SebastianJu. I restored the previous store back on the server, which is a good thing. As you said, I started working on localhost. I had to get the store on localhost. I see product categories and customer information BUT 'Products' list and information is empty. As a result, the store front doesn't show product listing and pricing. I do not know why the database restore on the localhost doesn't restore products information. Based on your suggestion, my idea was then to setup well the existing store on the localhost and then work on the upgrade process from there. If I can't find out the reason, I had to yet to decide whether I have to manually reenter all products information, which would take a good piece of time.
I appreciated your presence and comments.

Did you edit the config.php? (1 in maindir and one in admin)
The products will be still there if you have the database copied into localhost too.

SebastianJu wrote: Did you edit the config.php? (1 in maindir and one in admin)
The products will be still there if you have the database copied into localhost too.

Yes, I did. The products are there but they do not show up when I open the main page. I can see product list ONLY if I click on the 'Brand' link of the footer section. The 'Home' link doesn't do anything. I do not see the top menu, etc. Also, I have issues with banner ID, which I do not see any or can't add something on it.

I tired to do Modules setup somehow similar to the demo of Opencart but without any success. I am wondering if it has to do with the Modules setup

OK with the banner and the products show up with Latest module.

I am almost on the finishing line but still struggling to know why I can't see the top menu. I would appreciate if anyone can drop me an idea from which module I should work on? I have categories and products showing on the home page.

I have the same problem. Compared to a new installed shop with examples in it i only have the header up to Home|Wish List and so on but the menu is missing and everything down to Information Customer Services and so on...
Ill check the differences with the newly installed shop but i already went through all settings in the updated shop and didnt found a problem.

I think i found something. If you want a featuread-part on the homepage you need to go to modules-featured and add a module at layout home. Then add products above. After saving these products should be shown at homepage.

I wonder if its much work to make it look like the previous shops template.

SebastianJu, thanks a lot. I played around that way and put things in order. The response to the menu stuff was also just around. I think someone upgrading to a distant new version needs to get familiarized with the interface compared to directly building the store from the current version. When we build, we have to pass through each item information. When we upgrade, we may think that things are uploaded but in fact there are points hidden there. Without proper documentation, it is not always straight forward. But, anyway, the tool is user friendly.

Problem with the Cart module of 1.5.4.1. I see that this module is installed by default. When I tired to 'Edit', the link goes to empty page. No error, no message. Just empty.

Can anyone comment on that if that can be fixed? It would be nice to bring the cart to a column-right position.

blighter wrote:Get an error

Code: Select all

The following errors occured:

Could not execute this query: INSERT INTO `oc_option` (`option_id`, `type`, `sort_order`)SELECT `product_option_id`, "select", `sort_order` FROM `oc_product_option`; Duplicate entry '345' for key 1

Could not execute this query: INSERT INTO `oc_option_description` (`option_id`, `language_id`, `name`)SELECT `product_option_id`, `language_id`, `name` FROM `oc_product_option_description`; Table 'blighter_ecomdemo1.oc_product_option_description' doesn't exist

Could not execute this query: INSERT INTO `oc_option_value` (`option_value_id`, `option_id`, `sort_order`)SELECT `product_option_value_id`, `product_option_id`, `sort_order` FROM `oc_product_option_value`; Duplicate entry '699' for key 1

Could not execute this query: INSERT INTO `oc_option_value_description` (`option_value_id`, `language_id`, `option_id`, `name`)SELECT `pov`.`product_option_value_id` , `language_id` , `pov`.`product_option_id` , `name`FROM `oc_product_option_value_description` AS `povd` INNER JOIN `oc_product_option_value` AS `pov` ON `pov`.`product_option_value_id` = `povd`.`product_option_value_id`; Table 'blighter_ecomdemo1.oc_product_option_value_description' doesn't exist

The above errors occurred because the script could not properly determine the existing state of those db elements. Your store may not need those changes. Please post any errors on the forums to ensure that they can be addressed in future versions!

Usually happens if you run it twice. Ignore it and try to move on to the next step

I tried BETA3 and everything worked perfectly with the exception of it seems to only show the default products and categories and not my own.

Jamie.ds wrote:I tried BETA3 and everything worked perfectly with the exception of it seems to only show the default products and categories and not my own.

Then You missed the steps that said "restore your original config.php and admin/config.php files back"
Start over.

I thought I restored it XD Got it thank you ^^

Thanks Qphoria for this nice script..

I have to ask here..

I got this error, Please Say how i fixed this, so i new to open cart

"Notice: Undefined index: bottom in C:\wamp\www\opencart\catalog\controller\common\footer.php on line 26Notice: Undefined index: bottom in C:\wamp\www\opencart\catalog\controller\common\footer.php on line 26Notice: Undefined index: bottom in C:\wamp\www\opencart\catalog\controller\common\footer.php on line 26Notice: Error: Table 'opencart.tax_rule' doesn't exist
Error No: 1146
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '8' AND z2gz.country_id = '222' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3563') ORDER BY tr1.priority ASC in C:\wamp\www\opencart\system\database\mysql.php on line 49"

Thank You !

Evening,

I have found this thread whilst deciding if I should start again with 1.5x or stick with 1.4x . Anyway, I thought I would give it a try to see how easy it is....

Well....

After an inital install and subsequent white screen

Back up restore and re-install I finally got the "sucessful" screen :-)

But, when I go to admin I get the follow error -

Notice: Use of undefined constant HTTP_SERVER - assumed 'HTTP_SERVER' in /home/a26dewh/public_html/product_pages/admin/index.php on line 68

Notice: Use of undefined constant HTTPS_SERVER - assumed 'HTTPS_SERVER' in /home/a26dewh/public_html/product_pages/admin/index.php on line 69
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/a26dewh/public_html/product_pages/admin/index.php:68) in /home/a26dewh/public_html/product_pages/system/library/session.php on line 11Warning: Cannot modify header information - headers already sent by (output started at /home/a26dewh/public_html/product_pages/admin/index.php:68) in /home/a26dewh/public_html/product_pages/admin/index.php on line 175Warning: Cannot modify header information - headers already sent by (output started at /home/a26dewh/public_html/product_pages/admin/index.php:68) in /home/a26dewh/public_html/product_pages/system/library/currency.php on line 45Notice: Use of undefined constant HTTP_SERVER - assumed 'HTTP_SERVER' in /home/a26dewh/public_html/product_pages/admin/controller/common/header.php on line 9
Fatal error: Call to a member function isLogged() on a non-object in /home/a26dewh/public_html/product_pages/admin/controller/common/header.php on line 106

The front end shows the following error -

Notice: Error: Could not load controller common/column_left! in /home/a26dewh/public_html/product_pages/system/engine/controller.php on line 47

I use the default template, apart from removing the right column (as you look at the screen), but my code is a little messy from trying different mod over the years :-P

Any ideas?

Mal

using 1.4.9.6 trying to go to 1.5.5.1 Is that a step too far? Should I use 1.5.4.1?

Evening again... Just been playing with my config files.. If I rename them I get the fresh install screen, if I rename them back I get an internal server error.

If I then try to navigate to admin or the front end I get the errors shown above. Are my problems config file related?

Mal

I upgrade from version 1.4.7 to 1.5.4 using Upgrade script and then running the installation of 1.5.4.

I logged in to Admin site and reconfigured everything as per the upgrade.txt.
I can not see my store.
I can login to admin and see all my products are there.
I am getting the error msg:
'Fatal error: Call to a member function link() on a non-object in /home2/wwwbest/public_html/catalog/controller/common/footer.php on line 29'

Okay - so thankfully I'm doing this on a copy of the system on a test server, because I'm having no luck! I am upgrading from 1.4.8.

I disabled all of the extensions that I had added (because from reading this thread that seemed like what some folks were having trouble with), and

The following errors occured:

Could not execute this query: INSERT INTO `option` (`option_id`, `type`, `sort_order`)SELECT `product_option_id`, "select", `sort_order` FROM `product_option`; Duplicate entry '401' for key 1

Could not execute this query: INSERT INTO `option_description` (`option_id`, `language_id`, `name`)SELECT `product_option_id`, `language_id`, `name` FROM `product_option_description`; Duplicate entry '377-1' for key 1

Could not execute this query: INSERT INTO `option_value` (`option_value_id`, `option_id`, `sort_order`)SELECT `product_option_value_id`, `product_option_id`, `sort_order` FROM `product_option_value`; Duplicate entry '800' for key 1

Could not execute this query: INSERT INTO `option_value_description` (`option_value_id`, `language_id`, `option_id`, `name`)SELECT `pov`.`product_option_value_id` , `language_id` , `pov`.`product_option_id` , `name`FROM `product_option_value_description` AS `povd` INNER JOIN `product_option_value` AS `pov` ON `pov`.`product_option_value_id` = `povd`.`product_option_value_id`; Duplicate entry '800-1' for key 1

The above errors occurred because the script could not properly determine the existing state of those db elements. Your store may not need those changes. Please post any errors on the forums to ensure that they can be addressed in future versions!

Those all look related to product options of course, and I'm no mysql expert so I don't really know what to "fix" in the database itself.

Then if I try to login after running the script, I get this:

Error: Unknown column 'o.currency' in 'field list'
Error No: 1054
SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS name, (SELECT os.name FROM order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '1') AS status, o.date_added, o.total, o.currency, o.value FROM `order` o WHERE o.order_status_id > '0' ORDER BY o.date_added DESC LIMIT 0,10

I actually tried disabling all extensions in at least one of my attempts to run this script, and I still end up with different errors, like this - and I have NO idea why these fields think they are read-only unless it's because I disabled all of the extensions, because I only get these errors when I do that:

The following errors occured:

Could not execute this query: ALTER TABLE coupon_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Table 'coupon_description' is read only

Could not execute this query: ALTER TABLE product_option_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Table 'product_option_description' is read only

Could not execute this query: ALTER TABLE product_option_value_description DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Table 'product_option_value_description' is read only

Could not execute this query: INSERT INTO `option` (`option_id`, `type`, `sort_order`)SELECT `product_option_id`, "select", `sort_order` FROM `product_option`; Duplicate entry '401' for key 1

Could not execute this query: INSERT INTO `option_description` (`option_id`, `language_id`, `name`)SELECT `product_option_id`, `language_id`, `name` FROM `product_option_description`; Duplicate entry '377-1' for key 1

Could not execute this query: INSERT INTO `option_value` (`option_value_id`, `option_id`, `sort_order`)SELECT `product_option_value_id`, `product_option_id`, `sort_order` FROM `product_option_value`; Duplicate entry '800' for key 1

Could not execute this query: INSERT INTO `option_value_description` (`option_value_id`, `language_id`, `option_id`, `name`)SELECT `pov`.`product_option_value_id` , `language_id` , `pov`.`product_option_id` , `name`FROM `product_option_value_description` AS `povd` INNER JOIN `product_option_value` AS `pov` ON `pov`.`product_option_value_id` = `povd`.`product_option_value_id`; Duplicate entry '800-1' for key 1

The above errors occurred because the script could not properly determine the existing state of those db elements. Your store may not need those changes. Please post any errors on the forums to ensure that they can be addressed in future versions!

Any ideas? I'd love to upgrade this cart - it's been awhile (I don't upgrade every time because of the modifications I've made), but it's time!

Thanks.

Hi - I realise this is a little late but we are looking to upgrade from version 1.4.8 to the latest version. I was very pleased to see this post with the Script to upgade form 1.4 to 1.5 - along with the comments about success.

I downloaded the link on the header post - Beta3-upgrade-14x-to-15x-YES-OPTv4.zip - but when I open the files they seem to be Beta 2 files. The text file and the php file say Beta 2 inside and the sql file says "not preserved" options version.

Should I be looking somewhere else for the Beta 3 files? Thank you.

Also - any uptodate comments and guidance on this process would be appreciated, thanks.

Hi!

After completing the upgrade I have the following problem when trying to go to the admin panel and introducing the user and password. Now I cannot access to my admin panel...

Could someone help me please?

Notice: Error: Unknown column 'salt' in 'where clause'
Error No: 1054
SELECT * FROM user WHERE username = 'admin' AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('Pekin2008'))))) OR password = '24eb59f2813ecf2dbd192254bd13fb14') AND status = '1' in /var/www/vhosts/almacenesgaribay.com/httpdocs/system/database/mysql.php on line 50

arki wrote:Hi!

After completing the upgrade I have the following problem when trying to go to the admin panel and introducing the user and password. Now I cannot access to my admin panel...

Could someone help me please?

Notice: Error: Unknown column 'salt' in 'where clause'
Error No: 1054
SELECT * FROM user WHERE username = 'admin' AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('Pekin2008'))))) OR password = '24eb59f2813ecf2dbd192254bd13fb14') AND status = '1' in /var/www/vhosts/almacenesgaribay.com/httpdocs/system/database/mysql.php on line 50

Did you run the upgrade script that comes with the latest version of opencart after you ran the beta upgrade?

Charles006 wrote:Hi - I realise this is a little late but we are looking to upgrade from version 1.4.8 to the latest version. I was very pleased to see this post with the Script to upgade form 1.4 to 1.5 - along with the comments about success.

I downloaded the link on the header post - Beta3-upgrade-14x-to-15x-YES-OPTv4.zip - but when I open the files they seem to be Beta 2 files. The text file and the php file say Beta 2 inside and the sql file says "not preserved" options version.

Should I be looking somewhere else for the Beta 3 files? Thank you.

Also - any uptodate comments and guidance on this process would be appreciated, thanks.

You'd be the first to have problem with the files.. maybe the readme is off or something but this zip is certainly beta3