[SOLVED] - Content submit error - 2.0.1.1

[system9866]

Hello all. I have 13 installs of 2.0.1.1 on a VPS. Of these 13 sites 3 of them are not functioning correctly. When you click 'submit' after editing a content page the site errors with the following (I have replaced the contents with XXX's),

======================

Debug: (0.257616) - (usage: 6826712) - (peak: 6864236)

15

Debug: (0.260161) - (usage: 6870204) - (peak: 6898896)

UPDATE cms_content SET content_name = 'xxxx', owner_id = 1, type = 'content', template_id = '3', parent_id = '-1', active = 1, default_content = 1, show_in_menu = 1, cachable = 1, secure = '1', page_url = '', menu_text = 'Home', content_alias = 'home', metadata = '<meta name=\"description\" content=\"xxxxx">', titleattribute = 'Home Page, shortcut key=1', accesskey = '1', tabindex = '', modified_date = '2015-10-13 14:11:29', item_order = '1', last_modified_by = 1 WHERE content_id = 15
======================

I assume this must be some kind of database problem as the other 10 sites work as expected.

I have tried emptying cache and using the db repair buttons under system maintenance.

Any ideas where I can start to look?

Thank you!

[JohnnyB]

The only thing that jumps out at me with a quick look is
<meta name=\"description\" content=\"xxxxx">
no escaping \ before the closing " at the end. Which isn't something you would directly control. But, just in case, check your content="" value in the page's metadata section or in your global settings to be sure there isn't some type of error that could cause the characters to get out of sorts. Some folks use tags and smarty to generate the content inside of their meta description, so I would start there.
Also, is there anything in the PHP error log?

[system9866]

Thank you for a very prompt reply!

The last one was escaped, this was a typo, should have read

=========================
Debug: (0.259306) - (usage: 6826712) - (peak: 6864236)

15

Debug: (0.262121) - (usage: 6870204) - (peak: 6898896)

UPDATE cms_content SET content_name = 'xxxxxx', owner_id = 1, type = 'content', template_id = '3', parent_id = '-1', active = 1, default_content = 1, show_in_menu = 1, cachable = 1, secure = '1', page_url = '', menu_text = 'Home', content_alias = 'home', metadata = '<meta name=\"description\" content=\"xxxxxxx\">', titleattribute = 'Home Page, shortcut key=1', accesskey = '1', tabindex = '', modified_date = '2015-10-13 14:48:19', item_order = '1', last_modified_by = 1 WHERE content_id = 15

=========================

The error log looks like this,


[13-Oct-2015 14:48:19 Europe/London] PHP Fatal error: Call to a member function fetch() on a non-object in /home/xxxxxx/public_html/xxxxxxxxxxx.co.uk/lib/classes/internal/module_support/modtemplates.inc.php on line 173

[JohnnyB]

Can you post your system information for the install showing the error? Someone might see something there that can be helpful.

[system9866]

sure



----------------------------------------------

Cms Version: 2.0.1.1

Installed Modules:

CMSMailer: 5.2.4
AdminSearch: 1.0
FileManager: 1.5.1
MenuManager: 1.50.1
MicroTiny: 2.0
ModuleManager: 2.0
Search: 1.50.1
ThemeManager: 1.1.8
FormBuilder: 0.8.1.2
CGExtensions: 1.49.9
SiteMapMadeSimple: 1.2.8
CMSContentManager: 1.0.1
DesignManager: 1.0.1
Navigator: 1.0.1
News: 2.50.1


Config Information:

php_memory_limit:
max_upload_size: 2000000
url_rewriting: mod_rewrite
page_extension: .html
query_var: page
auto_alias_content: true
locale:
set_names: true
timezone: Europe/London
permissive_smarty: false


Php Information:

phpversion: 5.4.24
md5_function: On (True)
json_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_STRICT: 2048
E_DEPRECATED: 0
test_file_timedifference:
test_db_timedifference:
memory_limit: 128M
max_execution_time: 30
output_buffering: On
file_uploads: On (True)
post_max_size: 8M
upload_max_filesize: 2M
session_save_path: /tmp (1777)
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)


Performance Information:

allow_browser_cache: Off (False)
browser_cache_expiry: 60
php_opcache: Off (False)
smarty_cache: On (True)
smarty_compilecheck: Off (False)
smarty_cache_udt: On (True)
auto_clear_cache_age: Off (False)

Server Information:

Server Api: cgi-fcgi
Server Db Type: MySQL (mysqli)
Server Db Version: 5.1.73
Server Db Grants: Found a "GRANT ALL" statement that appears to be suitable
Server Time Diff: No file system time difference found


----------------------------------------------

[system9866]

OK Solved!

After pasting my installed modules I can see 'SiteMapMadeSimple: 1.2.8' is installed. This appears to have caused the issue!

SiteMapMadeSimple is obviously not ready for version 2 of CMSMS. When you submit the content page after an edit I assume it was trying to rewrite the sitemap and erroring.

My fault for not checking all of the installed modules for compatibility.

Thank you for your help and helping me see the error!

[Rolf]

http://www.cmscanbesimple.org/blog/crea ... robots-txt

[system9866]

http://www.cmscanbesimple.org/blog/crea ... robots-txt

Interesting read - Thank you Rolf. I may look at setting this up.