Custom Changes – Afraid to update

ThemeBurn SupportForumsOpenCart ThemesShoppica OpenCart ThemeCustom Changes – Afraid to update

This topic has been marked as resolved.

Hello,

I’m a self taught person regarding coding but i don’t know much about it.
I downloaded the portuguese translation file for yout theme from the opencart site if i’m not mistaken.
I had to edit a few files afterwards to have it all like i want it.

I’m a bit reluctant to an update. Could you check my website: http://www.beleza21.com and tell me if everything’s ok with updating it ?

Also, i don’t know if this is doable:

How can one sort the products in the backend by date added ?
Is there a way to automatically fill the SEO Keywords when adding a product like WordPress does with titles? For every product i add, i have to go to the SEO Keywords area and add “product-name-bla-bla-bla”

Thanks, great theme! :)

JF

 evilfx
March 17, 2012 at 10:51 pm #7230

Hi,

1) Hope, you have made a list with the files and the changes, so you could easily transfer them in the new version :)

Generally, we don’t see any problems to update. Remember that the best practice is to always keep a backup copy of your current website (files and database).

2) Unfortunately, sorting products in the backend is not Shoppica related and we can’t be of much help here. We would suggest that you seek for help in the official Opencart forums.

3) Unfortunately, there is no way to automatically insert SEO urls with the default OpenCart functionality only. There is an extension however, can help you – http://www.opencart.com/index.php?route=extension/extension/info&extension_id=2430

Best,
ThemeBurn team

March 19, 2012 at 4:59 pm #7318

Hi,

Unfortunately, i didn’t keep track on the files i changed, but it was mainly language changes.
On the frontend there was also a link that pointed to a different section than the suggested text.
My main concern is the language actually. I downloaded a brasilian-portuguese translation of your theme, plus there’s the core opencart translation files.

If i download my site and upload it to a test site will it work or will i have database problems ?

Decisions decisions…

 evilfx
March 19, 2012 at 5:06 pm #7320

I am currently going through my site page by page and then through the actual files I can see I have changed and added everything to a document I’ve just called website log, I should have created it at first but it slipped my mind.

I too have changed several things and in certain cases renamed the original file with old at the end so I always had the file to revert to if anything went wrong with the changes, stupidly never did it with changes in the language files so hence the extra work.

There is an application called Winmerge if you use a PC or TextWrangler, which I use on my Mac that allows you to compare files, this I have found to be really useful in checking difference in files so you know what exactly is changed.

I hope this has helped a little, because like you I am a code as you go kind of person.

All the best.

March 20, 2012 at 1:43 am #7328

This is what i do, simple and fool proof..
get your self “Beyond Compare”
download your shoppica theme folder from your server to your desktop eg
catalog/view/theme/shoppica

download the latest version of shoppica also to your desktop
open Beyond Compare then choose “Folder Compare” you will see something like this here
http://screencast.com/t/8i3t4O2qrowr

choose the folders like in the screencast above, all your differences will show up in red, just double click on the file and press the arrow to copy your changes to your new themes folder

hope this helps

March 20, 2012 at 8:47 am #7333

@evilfx

There is no problem to duplicate your website on a testing server. You just need to keep the correct paths in:

_root/config.php
_root/admin/config.php

Generally, there is no difference between the Shoppica language file (catalog/language/english/module/shoppica.php) for OpenCart 1.5.1.x and the one for OpenCart 1.5.2.x.
This means you can keep your current language file and use it after the update.

Note however, that we haven’t modified the default OpenCart language files, so you will need to use some compare software as Klimskady and werepair have suggested.

@Klimskady
@werepair

Thanks for the tips, guys!

Best,
ThemeBurn team

March 21, 2012 at 11:14 am #7370

thanks, i’ll try to update on a test site without comparing files to see how it goes.
if it goes well i’ll update the live version.

one other question. lately i’ve been getting these errors on admin backend:

Warning: mysql_connect() [function.mysql-connect]: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in /home/battlefi/public_html/beleza21.com/system/database/mysql.php on line 6
Error: Could not make a database connection using battlefi_beleza2@localhost
Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /home/battlefi/public_html/beleza21.com/system/database/mysql.php on line 67

if i reload the page afterwards it works…

this is the error log from the last couple of days:

2012-03-20 6:20:10 – PHP Notice: Error: Lost connection to MySQL server during queryError No: 2013SELECT * FROM url_alias WHERE `query` = ‘category_id=71′ in /home/battlefi/public_html/beleza21.com/system/database/mysql.php on line 49
2012-03-20 7:00:44 – PHP Notice: Error: MySQL server has gone awayError No: 2006SELECT * FROM url_alias WHERE `query` = ‘category_id=74′ in /home/battlefi/public_html/beleza21.com/system/database/mysql.php on line 49
2012-03-20 8:57:10 – PHP Notice: Error: Lost connection to MySQL server during queryError No: 2013SELECT * FROM url_alias WHERE `query` = ‘category_id=66′ in /home/battlefi/public_html/beleza21.com/system/database/mysql.php on line 49
2012-03-20 8:58:28 – PHP Notice: Undefined index: name in /home/battlefi/public_html/beleza21.com/catalog/controller/product/shoppica.php on line 63
2012-03-20 8:58:28 – PHP Notice: Undefined index: name in /home/battlefi/public_html/beleza21.com/catalog/controller/product/shoppica.php on line 69
2012-03-20 8:58:28 – PHP Notice: Undefined index: image in /home/battlefi/public_html/beleza21.com/catalog/controller/product/shoppica.php on line 74
2012-03-20 8:58:28 – PHP Notice: Undefined index: name in /home/battlefi/public_html/beleza21.com/catalog/controller/product/shoppica.php on line 294
2012-03-20 13:12:37 – PHP Notice: Error: Lost connection to MySQL server during queryError No: 2013UPDATE user SET ip = ’188.250.14.60′ WHERE user_id = ’2′ in /home/battlefi/public_html/beleza21.com/system/database/mysql.php on line 49
2012-03-20 14:20:22 – PHP Notice: Error: Lost connection to MySQL server during queryError No: 2013SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = ’2′ AND p.status = ’1′ AND p.date_available <= NOW() AND p2s.store_id = '0' AND (p2c.category_id = '67') in /home/battlefi/public_html/beleza21.com/system/database/mysql.php on line 49
2012-03-20 20:56:54 – PHP Notice: Error: Lost connection to MySQL server during queryError No: 2013SELECT * FROM url_alias WHERE `query` = ‘category_id=66′ in /home/battlefi/public_html/beleza21.com/system/database/mysql.php on line 49
2012-03-20 21:38:20 – PHP Notice: Error: Lost connection to MySQL server during queryError No: 2013SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = ’2′ AND p.status = ’1′ AND p.date_available <= NOW() AND p2s.store_id = '0' AND (p2c.category_id = '81' OR p2c.category_id = '86' OR p2c.category_id = '87') in /home/battlefi/public_html/beleza21.com/system/database/mysql.php on line 49
2012-03-21 0:13:49 – PHP Notice: Error: Lost connection to MySQL server during queryError No: 2013UPDATE user SET ip = ’89.154.69.102′ WHERE user_id = ’1′ in /home/battlefi/public_html/beleza21.com/system/database/mysql.php on line 49
2012-03-21 2:00:29 – PHP Notice: Error: Lost connection to MySQL server during queryError No: 2013SELECT * FROM url_alias WHERE `query` = ‘category_id=71′ in /home/battlefi/public_html/beleza21.com/system/database/mysql.php on line 49
2012-03-21 5:42:33 – PHP Notice: Undefined index: name in /home/battlefi/public_html/beleza21.com/catalog/controller/product/shoppica.php on line 63
2012-03-21 5:42:33 – PHP Notice: Undefined index: name in /home/battlefi/public_html/beleza21.com/catalog/controller/product/shoppica.php on line 69
2012-03-21 5:42:33 – PHP Notice: Undefined index: image in /home/battlefi/public_html/beleza21.com/catalog/controller/product/shoppica.php on line 74
2012-03-21 5:42:33 – PHP Notice: Undefined index: name in /home/battlefi/public_html/beleza21.com/catalog/controller/product/shoppica.php on line 294
2012-03-21 6:15:20 – PHP Notice: Undefined index: name in /home/battlefi/public_html/beleza21.com/catalog/controller/product/shoppica.php on line 63
2012-03-21 6:15:20 – PHP Notice: Undefined index: name in /home/battlefi/public_html/beleza21.com/catalog/controller/product/shoppica.php on line 69
2012-03-21 7:50:02 – PHP Notice: Undefined index: name in /home/battlefi/public_html/beleza21.com/catalog/controller/product/shoppica.php on line 294

  • This reply was modified 4426 days ago by  evilfx.
 evilfx
March 21, 2012 at 1:25 pm #7373

try this http://www.opencart.com/index.php?route=extension/extension/info&extension_id=5058

regards

March 21, 2012 at 8:15 pm #7378

hi werepair, i’m assuming that has to do with the update and not the errors, correct ?

 evilfx
March 21, 2012 at 10:41 pm #7380

as for the sql error, i opened a ticket with my host as this is happening in other sites i own.

the other errors i don’t know what they are as it is not specified in the admin error log section

 evilfx
March 21, 2012 at 11:50 pm #7382

Hi,

the ‘Undefined index’ notices are related to the manufacturers. Either the field ‘name’ is missing from the manufacturers table or it is not returned by the getManufaturer function in catalog/model/catalog/manufacturer.php. This can also be related to custom modifications you made.

March 23, 2012 at 11:15 am #7431

Hi, i updated the theme.

Whenever i click an item from my store i get these errors:

Notice: Undefined index: count in /home/battlefi/public_html/beleza21.com/catalog/controller/module/category.php on line 44
Please help me.

 evilfx
March 24, 2012 at 3:00 pm #7461

nevermind, i was using content left

 evilfx
March 24, 2012 at 3:04 pm #7462

2012-03-25 5:37:19 – PHP Notice: Undefined index: HTTP_USER_AGENT in /home/battlefi/public_html/beleza21.com/catalog/model/shoppica/utils.php on line 66

can somebody help me with this error ? what is it and how can i fix it ?

i have a few of those on the error log

  • This reply was modified 4421 days ago by  evilfx.
 evilfx
March 26, 2012 at 12:39 am #7490

The error is harmless. It is generated by searching bots that do not identify themselves as valid browsers. We have added an additional check to prevent the error from appearing in the log. As this is non-significant minor bug, we are not going to update the official Shoppica release but we’ll provide the fix with a future release.

You can replace catalog/model/shoppica/utils.php with the attached one if you wish – it should fix this notice.

March 26, 2012 at 6:20 pm #7524
Viewing 15 posts - 1 through 15 (of 17 total)
  • You must be logged in to reply to this topic.