PersonalMode

On 4/6/2023 at 11:23 AM, Nathan Explosion said:

@PersonalMode

Which specific language string would you like to change at the database level only?

In fact, I have a database about magazines.
Often, the communicated release date contains only the month and year (not the day). I would have liked to be able to display only the date in MM/YYYY format
That's when the idea of changing a language string was suggested, but that would affect other databases.

If I do this, is it to change everywhere in Pages?
I would like to change this only for a single database in Pages.

Hello everyone.
Is it possible in the Pages app to display a date in MM/YYYY format? (instead of DD/MM/YYYY)
In my memory, it seems to me that it was possible in an older version.
THANKS

On 3/26/2023 at 3:09 PM, beats23 said:

I also use the commerce app to sell services where someone can upload a file to be edited. My contact us bottom is run by the commerce help support feature. IPS taking away these two important feature will affect my website negatively.

What more can be said ? I've also been using the support in the Commerce app, and especially selling physical items for years (IP.Nexus).
Removing these features is very damaging to my community. I'm not interested in using third-party services. The advantage of the Commerce app was the integration into the community without updating problems.
The result is that IPS will lose money because I will remove the Commerce app from my suite.

Hello everyone

I made a database few years ago for magazines  (see here : https://www.depeche-mode.be/magazines/ )

I made a terrible mistake back then. I did not check the option to create a thumbnail of the magazine cover.

The display is long in the list of magazines, since the images are loaded at actual size.

I enabled the option for future records in the database. But how to force the creation of this thumbnail on the old recordings without having to modify them one by one?

We almost 2000 registered magazines... I can't see myself modifying them one by one...

Do you have a solution for me?

Thanks a lot

It was so simple 😆🤪

Thanks a lot @opentype 👌

Sorry, it's not always easy to express yourself well on technical details in a foreign language.

"Category" template is the same template for "Category" and for "Sub-Category" (Children Category if you prefer)

But When I change something in the template, I can see changes in "Category", but not in "Sub-Category"

Here is my test code. As you can see, I hide the HTML Code for the profil photo and informations about last post.

{{$RecordsClass = $category::$contentItemClass;}}
{{if $category->can('view')}}
{{$lastPost = $category->lastPost();}}
	<li class="ipsDataItem ipsDataItem_responsivePhoto {{if $RecordsClass::containerUnread( $category )}}ipsDataItem_unread{{endif}} ipsClearfix" data-categoryID="{$category->_id}">
		<div class="ipsDataItem_icon ipsDataItem_category">
			{{if \IPS\Member::loggedIn()->member_id}}<a href="{$category->url()->setQueryString( array( 'do' => 'markRead', 'c' => $category->_id ) )->csrf()}" data-action='markAsRead'>{{endif}}
				<span class='ipsItemStatus ipsItemStatus_large {{if !$RecordsClass::containerUnread( $category )}}ipsItemStatus_read{{endif}}'>
					<i class="fa fa-comments"></i>
				</span>
			{{if \IPS\Member::loggedIn()->member_id}}</a>{{endif}}
		</div>
		<div class="ipsDataItem_main ipsPos_middle">
			<h4 class="ipsDataItem_title">
				<a href="{$category->url()}">{$category->_title}</a>
			</h4>
			{{if $category->hasChildren()}}
				<ul class="ipsDataItem_subList ipsList_inline">
					{{foreach $category->children() as $subCategory}}
						<li class="{{if $RecordsClass::containerUnread( $subCategory )}}ipsDataItem_unread{{endif}}">
							<a href="{$subCategory->url()}">{$subCategory->_title}</a>
						</li>
					{{endforeach}}
				</ul>
			{{endif}}
			{{if $category->_description}}
				<div class="ipsDataItem_meta ipsType_richText">{$category->_description|raw}</div>
			{{endif}}
		</div>
		{{if $lastPost}}
			<dl class="ipsDataItem_stats ipsDataItem_statsLarge">
				{{$count = $RecordsClass::contentCount( $category, FALSE );}}
				<dt class="ipsDataItem_stats_number">{number="$count"}</dt>
				<dd class="ipsDataItem_stats_type ipsType_light">{expression="\IPS\cms\Databases::load( $category->database_id )->recordWord( $count )"}</dd>
			</dl>
		{{endif}}
		<!--<ul class="ipsDataItem_lastPoster ipsDataItem_withPhoto">
			{{if $lastPost}}
				<li><div class='ipsType_break ipsContained'><a href="{$lastPost['record_url']}" class='ipsTruncate ipsTruncate_line' title='{$lastPost['record_title']}'>{$lastPost['record_title']}</a></div></li>
                {{if $category->last_poster_anon}}
                <li class='ipsType_blendLinks'>{lang="byline_nodate" htmlsprintf="$lastPost['author']->link( NULL, NULL, TRUE )"}</li>
                {{else}}
                <li class='ipsType_blendLinks'>{lang="byline_nodate" htmlsprintf="$lastPost['author']->link()"}</li>
                {{endif}}
				<li data-short="1 dy" class="ipsType_light"><a href='{$lastPost['record_url']->setQueryString( 'do', 'getLastComment' )}' title='{lang="get_last_post"}' class='ipsType_blendLinks'>{datetime="$lastPost['date']"}</a></li>
			{{else}}
				<li class='ipsType_light ipsResponsive_showDesktop'>{lang="content_categories_index_no_records" sprintf="\IPS\cms\Databases::load( $category->database_id )->recordWord()"}</li>
			{{endif}}
		</ul>-->
	</li>
{{endif}}

The information that I hid, disappear on the "Category", but didn't disappear on the "Sub Category"

Hi everybody,

Can you help me for this ?

I don't understand how can I change template for a Sub-catagory database.

In the template "Listing" I see

{{foreach $category->children() as $cat}}
				{template="categoryRow" group="category_index" location="database" app="cms" params="$cat"}
			{{endforeach}}

Then, the template "Category" is the same for "Sub-Category" ?

But When I change the Category Template, the changes doesn't appear for Sub-category.

Why ?

See Categories

See Sub-categories

Thanks

On 11/2/2022 at 11:54 AM, Marc Stridgen said:

Before we continue, please visit support within your admin CP and address the mysql items shown

I make a copy of my database. After the copy, the problem with 'Compact' table type was resolved.
 

Then I use this process to convert MyISAM tables to InnoDB

From now, this seems to have solved my original problem. But I haven't finished testing in all the apps

On 11/2/2022 at 12:58 PM, Miss_B said:

Can you run this sql query?

SELECT * FROM ibf_core_permission_index WHERE perm_id = 1971;

Hi, here is what I get

On 11/2/2022 at 12:58 PM, Miss_B said:

Another thing to check is if the perm_id field is set as AUTO_INCREMENT.

 

Yes.

On 11/2/2022 at 11:54 AM, Marc Stridgen said:

Before we continue, please visit support within your admin CP and address the mysql items shown

I assume you are talking about that?

I guess it's better to pass the tables to InnoDB first and then proceed to the "Compact" step

56 minutes ago, Adriano Faria said:

Do you have this every time you try to create a  forum? Does it happen with other apps too (Gallery, Downloads, Blogs, Pages, 3rd-party, etc.)?

Yes, every time, and all app (I try on Forums, Pages, Gallery)

Just try on Dowload App, same error

On 10/20/2022 at 1:40 AM, PersonalMode said:

No chance. The problem was not fixed with the 4.7.3 update. 

49 minutes ago, Marc Stridgen said:

At this point, you are really at a crossroad where you need to get your site upgraded. It may well be you are hitting a bug that is causing the duplicated items there. 

For context, you are 44 releases behind, which is 5 years behind. In addition to this, 10 of those were security related, so you are running software with known security flaws

Hi @Marc Stridgen
Like I said, I finally decided to update. I have the latest version (4.7.3).

But the update did not fix the problem (except for the Gallery app apparently)

Just try to add a new forums

INSERT INTO `ibf_core_permission_index` ( `app`, `perm_type`, `perm_type_id`, `perm_view`, `perm_2`, `perm_3`, `perm_4`, `perm_5` ) VALUES ( 'forums', 'forum', 167, '*', '*', '11,4,7,12,10,3,13,6,9,8', '11,4,7,12,10,3,13,6,9,8', '11,4,7,12,10,3,13,6,9,8' )
IPS\Db\Exception: Duplicate entry '1971' for key 'PRIMARY' (1062)
#0 /home3/depechem/public_html/system/Db/Db.php(941): IPS\_Db->preparedQuery()
#1 /home3/depechem/public_html/system/Node/Model.php(1898): IPS\_Db->insert()
#2 /home3/depechem/public_html/system/Node/Controller.php(1246): IPS\Node\_Model->setPermissions()
#3 /home3/depechem/public_html/applications/forums/modules/admin/forums/forums.php(122): IPS\Node\_Controller->permissions()
#4 /home3/depechem/public_html/system/Dispatcher/Controller.php(107): IPS\forums\modules\admin\forums\_forums->permissions()
#5 /home3/depechem/public_html/system/Node/Controller.php(69): IPS\Dispatcher\_Controller->execute()
#6 /home3/depechem/public_html/applications/forums/modules/admin/forums/forums.php(44): IPS\Node\_Controller->execute()
#7 /home3/depechem/public_html/system/Dispatcher/Dispatcher.php(153): IPS\forums\modules\admin\forums\_forums->execute()
#8 /home3/depechem/public_html/admin/index.php(13): IPS\_Dispatcher->run()
#9 {main}

Just now, PersonalMode said:

Just try to add a new forums

The new forums appears in the AdminPC

But not in the public area

On 10/11/2022 at 9:59 PM, Randy Calvert said:

Sounds like you need to just remove the extra duplicate entry noted in the ipb_core_permission_index table. 

I'm not an expert in MySQL. I don't see in this table, where there is extra duplicate entry.

10 hours ago, Marc Stridgen said:

This would indicate you have custom pages templates which are no longer compatible with the latest release. You would need to switch to default templated, or update those to be compatible.

Thanks @Marc Stridgen
But I don't understand why this page work : http://www.depeche-mode.be/magazines/1980-1989/best-r967/

But this page doesn't work : http://www.depeche-mode.be/magazines/2020-2021/classic-pop-r1855/

The same database, with the same template (other category)

It's the same with other database

work : http://www.depeche-mode.be/tour/1980-tour/londres-r14/

doesn't work : http://www.depeche-mode.be/tour/global-spirit-tour/07052017-amsterdam/

Hi

Since I upgrade from 4.2.6 to 4.7.3 I have a lot of problems.

One of them, is from Pages, when I try to go on a record.

Exemple :

http://www.depeche-mode.be/tour/global-spirit-tour/07052017-amsterdam/
http://www.depeche-mode.be/magazines/2020-2021/classic-pop-r1824/

receive this error :

Error: Call to a member function url() on bool (0)
#0 /home3/depechem/public_html/applications/cms/modules/front/database/record.php(341): IPS\Theme\class_cms_database_magazines_display->record()
#1 /home3/depechem/public_html/system/Dispatcher/Controller.php(118): IPS\cms\modules\front\database\_record->manage()
#2 /home3/depechem/public_html/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute()
#3 /home3/depechem/public_html/applications/cms/sources/Databases/Dispatcher.php(343): IPS\Content\_Controller->execute()
#4 /home3/depechem/public_html/applications/cms/widgets/Database.php(128): IPS\cms\Databases\_Dispatcher->run()
#5 /home3/depechem/public_html/applications/cms/sources/Pages/Page.php(1289): IPS\cms\widgets\_Database->render()
#6 /home3/depechem/public_html/applications/cms/sources/Pages/Page.php(2269): IPS\cms\Pages\_Page->getWidgets()
#7 /home3/depechem/public_html/applications/cms/modules/front/pages/page.php(116): IPS\cms\Pages\_Page->output()
#8 /home3/depechem/public_html/applications/cms/modules/front/pages/page.php(43): IPS\cms\modules\front\pages\_page->view()
#9 /home3/depechem/public_html/system/Dispatcher/Controller.php(118): IPS\cms\modules\front\pages\_page->manage()
#10 /home3/depechem/public_html/applications/cms/modules/front/pages/page.php(33): IPS\Dispatcher\_Controller->execute()
#11 /home3/depechem/public_html/system/Dispatcher/Dispatcher.php(153): IPS\cms\modules\front\pages\_page->execute()
#12 /home3/depechem/public_html/index.php(13): IPS\_Dispatcher->run()
#13 {main}

How Can I solved that ?

Thanks

Same problem with database in Pages.

No chance. The problem was not fixed with the 4.7.3 update. At least with the forum, because in the gallery it seems that it works again.

INSERT INTO `ibf_core_permission_index` ( `app`, `perm_type`, `perm_type_id`, `perm_view`, `perm_2`, `perm_3`, `perm_4`, `perm_5` ) VALUES ( 'forums', 'forum', 165, '*', '*', '', '11,4,7,12,10,3,13,6,9,8', '11,4,7,12,10,3,13,6,9,8' )
IPS\Db\Exception: Duplicate entry '1957' for key 'PRIMARY' (1062)

Hi

After 5 years without updates, I'm finally getting back on my feet.... 😅

I see a change in the folder architecture, so I'm wondering what I delete and what I keep before sending the new files to the FTP.

I guess I need to keep the folders:

- /downloads/
- /screenshots/
- /uploads/
- /datastore/ maybe?

and the conf_global.php files and the .htaccess ?

I don't see the /admin/ folder in the 4.7.2. Is it normal ?

Thanks

Thanks @Randy Calvert
I think you are right. I waited too long between versions and the ideal is to update.

Hi the community,

Can you help me, because I try to find the solution since few weeks.

With no reasons, when I try to add a new category in gallery, or forum, or in database from Page, I always have an error about the permissions.

Here an example of the last error :

INSERT INTO `ibf_core_permission_index` ( `app`, `perm_type`, `perm_type_id`, `perm_view`, `perm_2`, `perm_3`, `perm_4`, `perm_5` ) VALUES ( 'forums', 'forum', 163, '*', '', '', '', '' )
IPS\Db\Exception: Duplicate entry '1945' for key 'PRIMARY' (1062)

I use Community 4.2.6 and I cannot upgrade now (too much custom), and the news are too hot now to begin a big work of custom.

Thanks a lot

I used a "barbaric" method to display the number

Create a Custom PHP block with this code

$link = mysql_connect("localhost", "user", "pass");
mysql_select_db("base", $link);

$res = mysql_query("SELECT COUNT(1) FROM database-table", $link);
$row = mysql_fetch_row($res);
echo $row[];

I Try to find this to. Add number of records in a database.

I try this but ... no....

{number=$stats"['total_database']"}

Hi,

In "Custom Markers", if I write a "Marker Title" with a letter with an accent (à é è), the "Marker Title" doesn't appear in the infobox on the map.

You would need to define that color with CSS

.def h3 a{</p>
<p>color: #000 !important;</p>
<p>}

Doesn't Work for me

Probably not. Dawpi made one that is better than that.