ImpressCMS Community :: Forum

Re: 1.2.0 =>1.2.1 upgraded vs. iforum [by aph3x]

Thu, 11 Mar 2010 13:33:08 -2200

Modules Support:: 1.2.0 =>1.2.1 upgraded vs. iforum
but then again..why the hell is working on my main site and not on the subdomain i'm doing the redesign!?

Re: Batch files for Linux servers? [by Madfish]

Thu, 11 Mar 2010 11:42:31 -2200

ImpressCMS Member Lounge:: Batch files for Linux servers?
To edit root's crontab, login as root and try:

crontab -e

The fiddly bit is getting the time settings right.

Re. the shell script, have a look at this example - it checks if Apache is running, and if not, restarts it, includes cron stuff.

Edit: This Monit tool looks pretty interesting - but also more fiddly to set up.

Re: $this->setControl Marcan Videos... [by UnderDog]

Thu, 11 Mar 2010 06:40:39 -2200

Modules Support:: $this->setControl Marcan Videos...
wow.. Steve, thank you for that explanation. It helps alot... Also for other projects :D

I think for the joins part we need another marcan video ;-)

Re: Database modeling software? [by skenow]

Thu, 11 Mar 2010 02:32:48 -2200

Modules Development:: Database modeling software?
Some people are more visual than others - but those that posted about understanding the architecture first and how (and why) to normalize a database (and when not to) are key concepts to good db design.

Another key thing to understand are data types and sizes and how they impact the performance of your database. If you are using an integer field to store a value that will either be yes/no or true/false, you're wasting a lot of storage space and memory when querying on that field. Data integrity can also be compromised if you select an inappropriate data type for the field.

Something to keep in mind is the difference between MySQL data types and sizes and PHP types and sizes. MySQL has tinyint, smallint, mediumint, int and bigint - PHP only has integer. So, to match your data being handled with PHP with how it is being inserted/updated from the db, you'll have to work through validation rules in your PHP scripts.

Some db architects work from the data objects out to the presentation layer, others work backwards from the presentation (reporting) back to the objects. I tend to do some of both.

I did post some basic normalization info in your other post, thomas.

MySQL Workbench can take an SQL CREATE script (found in the sql folders of most modules) and import that to create a visual layout of the database. You can then make changes and export a new create script or an ALTER script for making changes to your db. I used this during my db optimization blog series. (on our old blog, many of the posts haven't been updated here - I need to polish them and find the images I used for them )

Another part of all this is to understand what queries will be run against your database. This will help you understand what indexes will help and which don't.

Re: @Aphex - per your request [by MrTheme]

Wed, 10 Mar 2010 23:34:01 -2200

Development Discussions:: @Aphex - per your request
No problem gents. Turned out to be a very simple addition.

I will up it in once Reflex has been merged into the trunk.

Re: Help with CSS optimization [by MrTheme]

Wed, 10 Mar 2010 23:32:42 -2200

Themes and Templates:: Help with CSS optimization
I run it live all the time, I just wrap it in admin tags so only I see it.

<{if $xoops_isadmin}>
<script type="text/javascript" src="<{$xoops_imageurl}>/js/script.js"></script>
<{/if}>

Re: icms_version IPF & SQL - A Little Different? [by Tom]

Wed, 10 Mar 2010 20:01:09 -2200

Modules Development:: icms_version IPF & SQL - A Little Different?
Well I did think that had something to do with it but after my questions and your answers I presumed this was optional only if you required something additional doing to the DB upon install or update.

What further made be believe was that the module tries to remove the tables on uninstall. so I though naturally that install would be the opposite and not require another file.

This is why I asked for a basic walk through as that would have then confirmed to me I was missing something.

If quote from #8

Which you pointed out I'd missed, then you will note that you never mentioned anything of of the said oninstall and onupdate code. I realise from our conversation in MSN that you wasn't aware of this yourself.

It was only in #10, #11 and #12 we discussed the file but it appeared this was more of an after install or update, seems our assumptions were wrong.

Thank you for all your help, you've been great, I'll give this a try now.

Re: Theme opmization / html file [by UnderDog]

Wed, 10 Mar 2010 06:13:52 -2200

Themes and Templates:: Theme opmization / html file
Debianus is right.
This is the framework I use.
http://community.impresscms.org/mod ... itemid=472
In the weekend, I'll copy your theme over to this framework and post an example.
It's better to adjust using your images and stuff, like debianus says.

Re: Messy characters after upgrading to 1.2 [by UnderDog]

Tue, 09 Mar 2010 17:44:30 -2200

Installation, Upgrade and Migration:: Messy characters after upgrading to 1.2
Hi Claudiano,

I think that it might just be a bug with SmartSection.
Please check everything else regarding your site. Let our other guys help you too, of course, since I see skenow is on the case :D

If everything else seems to be working, let's focus on SmartSection.
If I can reproduce the bug, I will try and fix it (if it's fixable in SmartSection) good deal?

Re: Man, Paypal Sucks! [by Tom]

Tue, 09 Mar 2010 17:23:27 -2200

ImpressCMS Member Lounge:: Man, Paypal Sucks!
Your right, I think a lot of it boils down to luck. Royal Mail have misplaced a few things over the years. Occasionally I get the neighbours mail also but thats normally when newer postmen are on the round.