Jump to content
Latest News: (loading..)
Sign in to follow this  
tgely

osC3 Simple Content Manager forum

Recommended Posts

This contribution forum here

:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Share this post


Link to post
Share on other sites

This contribution forum here

 

 

Hi box25!

 

I tried install but...

 

I think something missed. In admin panel works fine :thumbsup:, but I cant displayed CMS box at frontend. :blink:

Edited by Gergely

:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Share this post


Link to post
Share on other sites

Hi box25!

 

I tried install but...

 

I think something missed. In admin panel works fine :thumbsup:, but I cant displayed CMS box at frontend. :blink:

 

well,

 

1. I inserted in admin/includes/templates/default.php new line into $data = array() rows

 

 'cms' => array('*', 'left', '1200'),

 

2. reinstall default template

3. redefinial all box and contents in default templates

4. The CMS box disappeared in left colum!

 

Works fine!

 

I find some mistake

 

1. In box box_cms_heading language variable not definiated, so missed.

2. After I pressed continue button found this messages

 

Notice: Use of undefined constant MAX_DISPLAY_ARTICLES - assumed 'MAX_DISPLAY_ARTICLES' in C:\wamp\www\osc3\templates\default\content\cms\cms.php on line 14

 

Notice: Use of undefined constant MAX_DISPLAY_ARTICLES - assumed 'MAX_DISPLAY_ARTICLES' in C:\wamp\www\osc3\templates\default\content\cms\cms.php on line 41

 

Warning: Division by zero in C:\wamp\www\osc3\includes\classes\database.php on line 781

 

 

No problem I hope it will be OK later! :thumbsup:


:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Share this post


Link to post
Share on other sites

Thanks box25, this is great work!

 

1.2 version works fine for me.

 

I have some idea, but this alfa version not the best at this moment. :blush:


:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Share this post


Link to post
Share on other sites

Simple Content Manager V 1.31 is the latest version

 

got this one:

Notice: Use of undefined constant TABLE_CMS - assumed 'TABLE_CMS' in C:\wamp\www\admin\includes\applications\cms\pages\main.php on line 61

Warning: [MYSQL] Table 'sigma.table_cms' doesn't exist (1146): [QUERY] select cms_id, active, cms_name, cms_short_text from TABLE_CMS where language_id = 1 order by cms_id DESC limit 0, 20 in C:\wamp\www\includes\classes\database.php on line 60

Warning: [MYSQL] Table 'sigma.table_cms' doesn't exist (1146): [QUERY] select count(*) as total from TABLE_CMS where language_id = 1 in C:\wamp\www\includes\classes\database.php on line 60

 

seems in db osc_cms is missing "table_cms"

 

or there something must be changed as im using sigma_cms in db instead of osc_cms?

Edited by Goaul

Share this post


Link to post
Share on other sites

ah playing with all modifications was missing

 

Add this in database_tables.php before the end '?>'


   define('TABLE_CMS', DB_TABLE_PREFIX . 'cms');

Add this in filenames.php before the end '?>'

   define('FILENAME_CMS', 'cms.php');

Share this post


Link to post
Share on other sites

ah playing with all modifications was missing

 

Add this in database_tables.php before the end '?>'


define('TABLE_CMS', DB_TABLE_PREFIX . 'cms');

Add this in filenames.php before the end '?>'

define('FILENAME_CMS', 'cms.php');

 

Hi,

 

Thanks for test!

 

I think will be better to use without 'DB_TABLE_PREFIX' or use other constant.

 

like this:

define('TABLE_CMS', 'osc_' . 'cms');

 

This will be fix next version.


:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Share this post


Link to post
Share on other sites

****************************************************************************

Step 4

****************************************************************************

 

In admin Templates->Modules->Boxes

 

Install Articles box

 

****************************************************************************

Step 5

****************************************************************************

 

Templates->Modules Layout->Boxes Insert button

 

Select Articles and fill in the information for the new template layout module

 

****************************************************************************

Step 6

****************************************************************************

 

Configuration->Languages->Only add new records import

 

****************************************************************************

Step 7

****************************************************************************

 

Log off admin and log in again. You can find the CMS in modules.

 

****************************************************************************

Step 8

****************************************************************************

 

If you want to use Articles sitemap go to

Templates->Modules->Content

 

Install CMS sitemap

 

after

Templates->Modules Layout->Content Insert button.

 

Insert CMS sitemap module after info/sitemap page.

 

 

 

End of Install

*******************************************************************************

 

I dont get it the stept? Where and what code i need to copy to get it working?

 

I executed the sql file copied all the files.

Share this post


Link to post
Share on other sites

What the heck is do you mean by this :

 

In admin Templates->Modules->Boxes

 

Install Articles box? And the other steps, I don't really get this. please be quick..

Share this post


Link to post
Share on other sites

What the heck is do you mean by this :

 

In admin Templates->Modules->Boxes

 

Install Articles box? And the other steps, I don't really get this. please be quick..

 

open db and check if the injection rly happened.

Share this post


Link to post
Share on other sites

What addon you recommend me than?

 

Hi,

 

See here

 

 

I ended the Xsell module and I'm testing at this moment. :thumbsup: It's look like works fine. I fixed the products_to_category problem for the osC3.

Edited by Gergely

:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Share this post


Link to post
Share on other sites

Hi!

 

I try to install this CMS. But when i come to step 4 "In admin Templates->Modules->Boxes

 

Install Articles box " I can not find Articles box in Templates->Modules->Boxes. I have uploaded the catalog directory with an temp. directory called install with the install files. Then run the install.php and deleted the install files angain. There dos it go wrong for me????

 

Regards

Tommas H. Kristensen

Share this post


Link to post
Share on other sites

Thank you for this addon, install was super easy and it works great.

 

One change I made was to the database table "osc_cms" to make the "cms_short_text" longer. When you add the articles from the admin there is no check to make sure you haven't entered in a value too long and if you do it will throw a database error and you will lose the article you were working on. I think the default value was 128 char which was too short for my needs.

 

Looking forward to future versions, it would be nice to add a sort value to the articles so you can re-arrange them.

 

This addon shows exactly how easy adding modules should be in v3!

Share this post


Link to post
Share on other sites

Hi!

 

I try to install this CMS. But when i come to step 4 "In admin Templates->Modules->Boxes

 

Install Articles box " I can not find Articles box in Templates->Modules->Boxes. I have uploaded the catalog directory with an temp. directory called install with the install files. Then run the install.php and deleted the install files angain. There dos it go wrong for me????

 

Regards

Tommas H. Kristensen

 

The install directory not the best, because the original osC3 install.php found here. It would be better to use other temp directory.

Try to use by hand install process. If you do steps right you have to find articles box.


:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Share this post


Link to post
Share on other sites

Thank you for this addon, install was super easy and it works great.

 

One change I made was to the database table "osc_cms" to make the "cms_short_text" longer. When you add the articles from the admin there is no check to make sure you haven't entered in a value too long and if you do it will throw a database error and you will lose the article you were working on. I think the default value was 128 char which was too short for my needs.

 

Looking forward to future versions, it would be nice to add a sort value to the articles so you can re-arrange them.

 

This addon shows exactly how easy adding modules should be in v3!

 

Yes this is a bug at now and I dont like the search methods too. This will replace later.


:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Share this post


Link to post
Share on other sites

Yes this is a bug at now and I dont like the search methods too. This will replace later.

 

Also, I just noticed that when viewing an article the breadcrumb link for that article is not complete (missing the ',#' after the view) and so it goes to a blank page. I will look for a resolution but any tips if you know what is causing this would be welcome.

 

Thanks!

Share this post


Link to post
Share on other sites

Also, I just noticed that when viewing an article the breadcrumb link for that article is not complete (missing the ',#' after the view) and so it goes to a blank page. I will look for a resolution but any tips if you know what is causing this would be welcome.

 

Thanks!

 

 

Found it, this bug can be fixed in: \includes\content\cms\view.php @ line 40

 

replace:

if ($osC_Services->isStarted('breadcrumb')) {

$osC_Breadcrumb->add($QcmsDetails->value("cms_name"), osc_href_link(FILENAME_CMS, $this->_module));

}

 

with:

if ($osC_Services->isStarted('breadcrumb')) {

$osC_Breadcrumb->add($QcmsDetails->value("cms_name"), osc_href_link(FILENAME_CMS, "view=" . $QcmsDetails->value("cms_id"), "NONSSL"));

}

 

Thanks!

Share this post


Link to post
Share on other sites

Found it, this bug can be fixed in: \includes\content\cms\view.php @ line 40

 

replace:

if ($osC_Services->isStarted('breadcrumb')) {

$osC_Breadcrumb->add($QcmsDetails->value("cms_name"), osc_href_link(FILENAME_CMS, $this->_module));

}

 

with:

if ($osC_Services->isStarted('breadcrumb')) {

$osC_Breadcrumb->add($QcmsDetails->value("cms_name"), osc_href_link(FILENAME_CMS, "view=" . $QcmsDetails->value("cms_id"), "NONSSL"));

}

 

Thanks!

 

 

Thanks! :) I was too short as dr. House :D

Edited by Gergely

:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Share this post


Link to post
Share on other sites

Thank you for this addon, install was super easy and it works great.

 

One change I made was to the database table "osc_cms" to make the "cms_short_text" longer. When you add the articles from the admin there is no check to make sure you haven't entered in a value too long and if you do it will throw a database error and you will lose the article you were working on. I think the default value was 128 char which was too short for my needs.

 

Looking forward to future versions, it would be nice to add a sort value to the articles so you can re-arrange them.

 

This addon shows exactly how easy adding modules should be in v3!

 

Regarding the Short Text limit in the database... I also switched the format of cell "cms_short_text" of table osc_cms from VARCAR to TEXT.... opting to restrict the number of characters to 180 characters at the form field layer of the stack via a simple JavaScript I found....

 

Results: Pop-Up Alert on 180 + 1 char key-up event, with auto truncation of text group within the Form's textarea field.

 

changed file.../admin/includes/applications/cms/pages/edit.php

 

lines 141 down

 

<!-- additional for short text description -->

<tr>

<td valign="top"><?php echo $osC_Language->get('field_short_text'); ?></td>

<td><script language="javascript" type="application/javascript" >

function textLimit(field, maxlen) { if (field.value.length > maxlen + 1) alert('Sorry, Description is limited to 180 characters!'); if (field.value.length > maxlen)

field.value = field.value.substring(0, maxlen); } </script>

<?php echo osc_draw_textarea_field('cms_short_text[' . $l['id'] . ']', (isset($osC_ObjectInfo) && isset($cms_short_text[$l['id']]) ? $cms_short_text[$l['id']] : null), 70, 5, 'style="width: 100%;" id="pds' . $l['id'] . '" onkeyup="textLimit(this, 180);" '); ?>

 

</td>

</tr>

 

<!-- end of additional short text description -->

 

End of Solution Hope this helps...

 

 

Another Problem I Found, Cross_Sell (for me at least). -- Did find some out of the box problems that I fixed on my own...

 

Link Failure: (products.php?[product_name]) should be (products.php?[product_keyword])

 

The Links weren't working due to the product_name being used within the product call link... I modified the query to get the product_keyword value and modified the concatenated mark-up to use the product_keyword instead of the product_name. Also, the default set-up has a bug where it shows products that are in a disabled state. This really should be fix for the next iteration. p.products_status = 1

 

Also was getting duplicate listing for product that have more than one image attached to the product.. pip.default_flag = 1

 

here is what I did... Not sure if this is to the conventional best practice standards, as I'm new to osC3

 

MY EDIT of osc3 file includes/modules/content/cross_sell.php

Circa Line 50 .... I updated the query

 

$cross_sell_query = $osC_Database->query("SELECT DISTINCT xp.xsell_id, xp.products_id, pd.products_name, pd.products_keyword, p.products_price, p.products_status, pip.image, pip.default_flag

FROM products_xsell AS xp, osc_products AS p, osc_products_description AS pd, osc_products_images AS pip

WHERE xp.products_id = $products_id

AND pd.products_id = xp.xsell_id

AND pip.products_id = xp.xsell_id

AND p.products_id = xp.xsell_id

AND p.products_status >= 1

AND pip.default_flag = 1");

 

 

Made two mods from circa line 181 to the end of file.

/// mod 20100304 OhTrinity Substituded product_keyword for product_name **********************************

 

// $info_box_contents = array();// start around line 73 ************************************

// $info_box_contents[] = array('align' => 'left', 'text' => TEXT_CROSS_SELL_PRODUCTS);

// new contentBoxHeading($info_box_contents);

//$this->_content =

$row = 0;

$col = 0;

 

//$this->_content = '<ol style="list-style: none;">';

while ($product=$cross_sell_query->next()) {

$num= $cross_sell_query->numberOfRows();

//if($num%3==0)

// {

/// mod 20100304 OhTrinity Substituted product_keyword for product_name : centered contents and reduced the icon size // around line 86 ******************

$this->_content .= '<td valign="top" align="center" style="border:none">'.'<a href="'.(osc_href_link(FILENAME_PRODUCTS,$product['products_keyword'])).'"><img src=images/products/thumbnails/'.$product['image'].' border="0" alt="" width="33" height="33"></a><br>' .'<a href="'.(osc_href_link(FILENAME_PRODUCTS,$product['products_keyword'])).'">'.$product['products_name'].'</a> <br> Reg. <b>$'.$product['products_price'].'</b> </td>';

// $col ++;

//echo $row;

// if ($col > 2) {

// $col = 0;

$row ++;

// }

if($row%3==0)

{

$this->_content .= '</tr><tr>';

}

}

 

 

$this->_content .= ' </tr>' .

'</table>';

// new contentBox($info_box_contents);

?>

<!-- cross_sell_products_eof //-->

<?php

}

//}

 

$this->_content .= '<table><tr><td> </td></tr>' . //OhTrinity hack ADDED "<table><tr><td>" ... was having a conflict with other div layer placements due to an unclosed table ; not sure if this is the proper long term solution.

'</table>';

}

}

?>

 

 

End of Solution...

 

 

One other issue I found in the set-up files.

 

In the file "products_xsell.sql"

 

line 1 ... we need to add "osc_" to table name "configuration".

 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Cross Sell', 'MAX_DISPLAY_XSELL', '6', 'Maximum number of products to display in the \'Cross Sell\' box', '3', '16', now());

 

Should be ...

 

INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Cross Sell', 'MAX_DISPLAY_XSELL', '6', 'Maximum number of products to display in the \'Cross Sell\' box', '3', '16', now());

 

Hope this is also helpful to others... since I think it caused my initial install problems, was getting errors until I re-did installed by-hand.

 

Another problem that I haven't yet figured out how to fix.... Some one else might know...

 

I want to hide the module result box; when it has empty results. Another words, if there are no cross sell products assigned or articles available for the product... I don't want an empty table with the table heading visible when there are no results.

Edited by OhTrinity

Share this post


Link to post
Share on other sites

 

Another problem that I haven't yet figured out how to fix.... Some one else might know...

 

I want to hide the module result box; when it has empty results. Another words, if there are no cross sell products assigned or articles available for the product... I don't want an empty table with the table heading visible when there are no results.

 

Funny you should mention this, I wanted the same thing. I didn't have a graceful way to do it because I was in a hurry but here is my hack to get you in the right area:

 

In /templates/default/modules/content/cms_xsell.php (this one is for the product listing, there is another one for the articles listing)

 

I added an if to check for content like this:

 

<?

if (strlen(trim($osC_Box->getContent())) > 50) {

?>

<!-- module cms_sitemap start //-->

<div class="moduleBox">

 

<h6><?php echo $osC_Box->getTitle(); ?></h6>

<div class="content"><?php echo $osC_Box->getContent(); ?></div>

 

</div>

 

<?

}

?>

 

The 50 is because there is some content even in an empty box. This works for me but it's messy... maybe you can clean it up for everyone else :)

 

thanks

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×