Post by ScottBohler » Wed Aug 26, 2009 2:02 am

First, OpenCart is WONDERFUL! Thank you for a great project/product!

Bug:
After upgrading to 1.3.2, updating anything on the Settings admin page breaks the cart causing an error that says it cannot open the template. The problem is with the template selector portion. "default" is neither selected by default nor available. In my case I updated my home page text and then saved. This deleted the template value in the mySql database.

Workaround after saving Settings (for users that know how to work with mySql)

In the mySql database, in the "setting" table, insert a new row:

Field.......... Value
---------------- ----------------------
setting_id...: 10113
group........: config
group_key...: config_template
value.........: default/template/

This fixes what the Settings/Save function broke.

Thanks in advance for the solution update.

Peace,
Scott

Attachments

ScreenShot006.jpg

ScreenShot006.jpg (7.66 KiB) Viewed 2366 times


- Scott


User avatar
New member

Posts

Joined
Wed Aug 26, 2009 1:45 am

Post by Qphoria » Wed Aug 26, 2009 3:44 am

There are new entries that are required in the config.php and admin/config.php.
You likely kept your existing config file not realizing that.

If you want to add them manually, you need to add the following entries, being sure that you carefully make them match the same path as the other entries:

in config.php
define('DIR_LOGS', '/home/xxxx/public_html/xxxxxx/system/logs/');

in admin/config.php
define('DIR_LOGS', '/home/xxxxx/public_html/xxxx/system/logs/');
define('DIR_CATALOG', '/home/xxxxx/public_html/xxxx/catalog/');

That will fix that selector problem.

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by ScottBohler » Wed Aug 26, 2009 11:33 pm

Thank you Qphoria. I made the changes as you noted, logged out and back in, and saved my settings page - same problem. The template selector is still blank and the error was re-generated.

"Error: Could not load template /home/xxxxx/public_html/shops/xxxxx/catalog/view/theme/common/home.tpl!"
(where xxxxx=my values)

Thoughts? ???

Scott

- Scott


User avatar
New member

Posts

Joined
Wed Aug 26, 2009 1:45 am

Post by Qphoria » Wed Aug 26, 2009 11:49 pm

You sure you matched them up with the other values in your config?

PM your whole admin/config file (xxxx out the password part only)

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by ScottBohler » Thu Aug 27, 2009 4:54 am

I'm pretty sure.
-----------------------------------------------------
<?php
// HTTP
define('HTTP_SERVER', 'http://www.stbohler.com/shops/whisperandfriends/admin/');
define('HTTP_CATALOG', 'http://www.stbohler.com/shops/whisperandfriends/');
define('HTTP_IMAGE', 'http://www.stbohler.com/shops/whisperandfriends/image/');

// HTTPS
define('HTTPS_SERVER', '');
define('HTTPS_IMAGE', '');

// DIR
define('DIR_APPLICATION', '/home/stbohl2/public_html/shops/whisperandfriends/admin/');
define('DIR_SYSTEM', '/home/stbohl2/public_html/shops/whisperandfriends/system/');
define('DIR_DATABASE', '/home/stbohl2/public_html/shops/whisperandfriends/system/database/');
define('DIR_LANGUAGE', '/home/stbohl2/public_html/shops/whisperandfriends/admin/language/');
define('DIR_TEMPLATE', '/home/stbohl2/public_html/shops/whisperandfriends/admin/view/template/');
define('DIR_CONFIG', '/home/stbohl2/public_html/shops/whisperandfriends/system/config/');
define('DIR_IMAGE', '/home/stbohl2/public_html/shops/whisperandfriends/image/');
define('DIR_CACHE', '/home/stbohl2/public_html/shops/whisperandfriends/cache/');
define('DIR_DOWNLOAD', '/home/stbohl2/public_html/shops/whisperandfriends/download/');
define('DIR_LOGS', '/home/stbohl2/public_html/shops/whisperandfriends/system/logs/');
define('DIR_CATALOG', '/home/stbohl2/public_html/shops/whisperandfriends/catalog/');

// DB
define('DB_DRIVER', 'mysql');
define('DB_HOSTNAME', 'localhost');
define('DB_USERNAME', 'stbohl2_whisper');
define('DB_PASSWORD', 'xxxxxxxxxx');
define('DB_DATABASE', 'stbohl2_whisperandfriends');
define('DB_PREFIX', '');
?>
-----------------------------------------------------

Thanks,
Scott

- Scott


User avatar
New member

Posts

Joined
Wed Aug 26, 2009 1:45 am

Post by Qphoria » Thu Aug 27, 2009 5:59 am

Looks right.
its GOTTA work then
You still see no templates in the selector?

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by ScottBohler » Thu Aug 27, 2009 7:29 am

Nope. I still see no templates. :(

Waddaya think?

- Scott


User avatar
New member

Posts

Joined
Wed Aug 26, 2009 1:45 am

Post by Qphoria » Thu Aug 27, 2009 9:21 am

can you create a temp FTP account and temp opencart admin (with access to the settings page)
I will take a look

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by ScottBohler » Sat Aug 29, 2009 2:09 am

Problem solved with Qphoria's help! ;D

For some unknown reason my upgrade file copy did not update all intended files. This has nothing to to with OpenCart. As my affected store was not yet "online" and minimally populated, I opted to delete everything and re-install OpenCart from scratch. Problem solved - there is nothing wrong with the template selector.

Thanks Qphoria, and thanks again to OpenCart for a great store!
Scott

- Scott


User avatar
New member

Posts

Joined
Wed Aug 26, 2009 1:45 am
Who is online

Users browsing this forum: No registered users and 16 guests