Problem with News module [Solved]

[master3395]

Hi. I'm running CMS Made Simple 2.1.2 I'm using PHP Version 5.6.18, and MySQL 5.1.61 Including MySQL Cluster NDB 7.2.
phpMyAdmin 3.5.2.2
This is all working with Apache/2.4.10 running on Linux
WEB SERVER LOAD 11.79
MYSQL SERVER LOAD 1.1

Here's my problem.
When i publish a new's post, it takes around 5 min and up to 15 min before it goes on the front page, even if i clear the cache.
I would be really happy if i got it to be instant


Below is a list of all the info on the site.

----------------------------------------------
Cms Version: 2.1.2
Installed Modules:
AComments: 1.2
AJAXStarRatingBar: 0.9.2
AceEditor2: 1.05
AdminIPLock: 1.0
AdminSearch: 1.0
AjaxMadeSimple: 0.4.0
Archiver: 0.2.6
Articles: 0.2.1
BanckleChat: 0.1
Banners: 2.7.6
BirthdayListing: 2.0
CGActionBar: 0.5.2
CGBlog: 1.13.3
CGCalendar: 1.15.8
CGClientTickets: 1.1.4
CGContentUtils: 2.1
CGExtensions: 1.52.2
CGFeedMaker: 1.0.20
CGFeedback: 1.7.5
CGGoogleMaps2: 0.99.3
CGHeadMaster: 1.0.9.2
CGJobMgr: 1.3.4
CGSimpleSmarty: 2.0.5
CGSmartImage: 1.21
CGSnapshot: 1.0
CGSocialBlaster: 1.0.3
CGStaticMaps: 1.0.0
CGTiny: 1.2.7
CMSContentManager: 1.1
CMSMailer: 6.2.14
CSSPreprocessor: 2.0
Captcha: 0.5.2
Cataloger: 0.11.3
Chat: 0.3.0
CompanyDirectory: 1.22.12
Cron: 0.2
CustomContent: 1.10
DesignManager: 1.1.1
Diagnostics: 0.2
EasyList: 1.1-beta1
EventsListing: 2.0.2
ExaCSS: 2.0.2
ExaExternalizer: 0.5
ExaLang: 0.1
FAQ: 2.0.1
FEU_PMs: 1.0.0
FEupload: 0.3.1
FileManager: 1.5.2
FormBrowser: 0.4.2
FormBuilder: 0.8.1.3
FrontEndUsers: 1.31.1
Gallery: 2.1
Gbook: 2.0.3
HitCounter: 2.0
InstaFeed: 3.0
JMDownMan: 1.RC.1
JMFilePicker: 1.0
JM_Forum: 1.0.0
JM_NBBCode: 1.0.1
JQueryTools: 1.3.8
LISE: 1.1
LdapUsers: 1.3
LinkMgr: 2.1
MBVFaq: 1.2
MenuManager: 1.50.2
MetaMax: 2.1.5
MicroTiny: 2.0.3
ModuleManager: 2.0.2
NMS: 2.10
Navigator: 1.0.2
NeoDataStorage: 0.4.0
NeoModule: 0.6.0
News: 2.50.4
Outsourcer: 1.3.1
Parser: 1.0.0
Ping: 0.4.3
Pixlr: 0.2.0
SQLReport: 1.0
Search: 1.50.2
SelfRegistration: 1.9.6
Servermanager: 0.0.1
Showtime: 3.4
SimpleGoogleMap: 1.1
SimplePortal: 1.0
SimpleSiteInfo: 3.1
SimpleSiteMgr: 3.1.1
SimpleSlider: 1.3.2
SiteMapMadeSimple: 1.2.8
Skeleton: 1.8.1
Smileys: 0.9.0
Statistics: 1.1.3
StripeGate: 0.8.1
SystemInfo: 1.0
TagCloud: 1.1.0
ThemeManager: 1.1.8
TinyMCE: 3.1.2
Uploads: 1.21
UsersGuide: 2.0
YahooWeather: 1.1
avplayer: 1.7
btAdminer: 4.2.2

Config Information:
php_memory_limit:
max_upload_size: 128000000
url_rewriting: mod_rewrite
page_extension:
query_var: page
auto_alias_content: true
locale:
set_names: true
timezone: Europe/Oslo
permissive_smarty: false

Php Information:
phpversion: 5.6.18
md5_function: On (True)
json_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_ALL: 1
E_STRICT: 0
E_DEPRECATED: 0
test_file_timedifference: No time difference found
test_db_timedifference: A discrepency in time with the PHP environment was detected. This may cause problems when publishing i.e. news articles.
create_dir_and_file: 1
memory_limit: 256M
max_execution_time: 120
register_globals: Off (False)
output_buffering: 1
disable_functions: system, exec, shell_exec, proc_open, passthru, ini_restore, mysql_list_dbs, ini_alter, dl, openlog, syslog, symlink, link, chgrp, leak, popen, escapeshellcmd, apache_child_terminate, apache_get_modules, apache_get_version, apache_getenv, apache_note, apache_setenv, virtual, mb_send_mail
open_basedir: /home/u227622376:/tmp:/var/tmp:/opt/php-5.6/pear
test_remote_url: Success
file_uploads: On (True)
post_max_size: 128M
upload_max_filesize: 128M
session_save_path: No check because open basedir active
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)
check_ini_set: On (True)
curl: On

Performance Information:
allow_browser_cache: Off (False)
browser_cache_expiry: 60
php_opcache: Off (False)
smarty_cache: Off (False)
smarty_compilecheck: Off (False)
smarty_cache_udt: Off (False)
auto_clear_cache_age: Off (False)
Server Information:
Server Software: Apache
Server Api: cgi-fcgi
Server Os: Linux 2.6.32-673.8.1.lve1.4.3.el6.x86_64 On x86_64
Server Db Type: MySQL (mysqli)
Server Db Version: 10.0.20
Server Db Grants: Found a "GRANT ALL" statement that appears to be suitable

Permission Information:
tmp: /home/u227622376/public_html/tmp (0755)
tmp_cache: /home/u227622376/public_html/tmp/cache (0755)
templates_c: /home/u227622376/public_html/tmp/templates_c (0755)
modules: /home/u227622376/public_html/modules (0755)
uploads: /home/u227622376/public_html/uploads (0755)
File Creation Mask (umask): /home/u227622376/public_html/tmp/cache (0755)
config_file: 0644
----------------------------------------------

[calguy1000]

Testing for time difference in the file system (test_file_timedifference) Success No time difference found
Testing for time difference in the database (test_db_timedifference) Failure A discrepency in time with the PHP environment was detected. This may cause problems when publishing i.e. news articles.

The time of the mysql server and the HTTP server are different. that will cause your problems.

[master3395]

So i will have to talk with my host to sync the time between HTTP server and mysql to solve this?

[calguy1000]

Yes.

I am willing to bet your mysql server is on a separate host (prolly a bad thing in and of itself)... and that separate host has a different time than your http server.

[paulbaker]

Installed Modules

Wo! 101 modules there. That's the most I've ever seen on a site. Unused modules will at minimum be using unnecessary disc space, both on your file system and in your database. Perhaps causing other issues too?

[master3395]

Installed Modules

Wo! 101 modules there. That's the most I've ever seen on a site. Unused modules will at minimum be using unnecessary disc space, both on your file system and in your database. Perhaps causing other issues too?

I like to test them, then remove them, i use most of them, in different ways.
My site is mostly a new's/blog site, so i am using image hosting, stats, self registration, the rest is mostly core or un used/testing modules.
Because 2.1.2 doesn't have all the modules working 100%

[master3395]

Could it be the config.php timezone?
or is there a news time setting in the admin panel?

$config['timezone'] = 'Europe/Oslo';

[Rolf]

$config['set_db_timezone'] = 'Europe/Oslo';

[master3395]

$config['set_db_timezone'] = 'Europe/Oslo';

Just tried it, it didn't work.

[Edit]
Seems like it helped some, but i found another way to fix it also.

This is the only way to fix it.

#$config['set_db_timezone'] = 1;