Database saving issue //////// /

Help with getting the CMS CORE package up and running. This does not include 3rd party modules, PHP scripts, anything downloaded via module manager or from any external source.
Locked
pianoku
Forum Members
Forum Members
Posts: 15
Joined: Tue Dec 11, 2007 4:58 am

Database saving issue //////// /

Post by pianoku »

Dear CMS Made Simple,

I have installed the latest CMSMS v1.9.4 and injected the database from my previous CMSMS version 1.6.1.

Any templates that modified and saved into "cms_module_templates" db table, will be added a forward slash character before a "single comma" and/or "double comma".

For example:

Code: Select all

<div{if $css_class != ''} class="{$css_class}"{/if}>
after saved via admin area, it becomes:

Code: Select all

<div{if $css_class != \'\'} class=\"{$css_class}\"{/if}>
the more I clicked the save button, the slash character is added:

Code: Select all

<div{if $css_class != \\\\'\\\\'} class=\\\\"{$css_class}\\\\"{/if}>
At the moment, I can fix this issue by cleaning the slashes and updating the database directly using phpmyadmin to make the website working in generating the HTML page.

Please advice how to solve this saving issue above, So I can modify any templates from the admin area as per normal. Thank you.

Regards,

R
Wishbone
Power Poster
Power Poster
Posts: 1368
Joined: Tue Dec 23, 2008 8:39 pm

Re: Database saving issue //////// /

Post by Wishbone »

pianoku wrote:I have installed the latest CMSMS v1.9.4
?? You got the not-yet-released version from SVN?
pianoku
Forum Members
Forum Members
Posts: 15
Joined: Tue Dec 11, 2007 4:58 am

Re: Database saving issue //////// /

Post by pianoku »

No, I didn't.

I use the latest 1.9.4 downloaded from the CMSMS website.
Jos
Support Guru
Support Guru
Posts: 4020
Joined: Wed Sep 05, 2007 8:03 pm

Re: Database saving issue //////// /

Post by Jos »

1.9.4. is released just an hour ago ::)
Wishbone
Power Poster
Power Poster
Posts: 1368
Joined: Tue Dec 23, 2008 8:39 pm

Re: Database saving issue //////// /

Post by Wishbone »

Oh.. They must have had it on the downloads page before the announcement, and before they updated the home page. I thought he was anticipating bugs to fix. :)
User avatar
Dr.CSS
Moderator
Moderator
Posts: 12711
Joined: Thu Mar 09, 2006 5:32 am

Re: Database saving issue //////// /

Post by Dr.CSS »

As always it helps to know more about the environment this site runs on, server, etc...
pianoku
Forum Members
Forum Members
Posts: 15
Joined: Tue Dec 11, 2007 4:58 am

Re: Database saving issue //////// /

Post by pianoku »

I apologise. it is 1.9.3

CMS Install Information:

CMS Version
1.9.3

Installed Modules

CMSMailer
2.0.1

FileManager
1.1.0

MenuManager
1.7.5

ModuleManager
1.4

News
2.11.1

nuSOAP
1.0.2

Printing
1.1.2

Search
1.6.10

ThemeManager
1.1.4

TinyMCE
2.8.3

FormBuilder
0.6b2

CGExtensions
1.23

SiteMapMadeSimple
1.2.2

youtubeplayer
1.3

FormBuilder
0.7

CGExtensions
1.23

SiteMapMadeSimple
1.2.2

youtubeplayer
1.3

CMSSimplepie
1.0

Captcha
0.4.3

CMSForms
0.0.10

Twitter
1.2.1

Config Information

php_memory_limit:

process_whole_template:

false

output_compression:

false

max_upload_size:

64000000

default_upload_permission:
664

url_rewriting:
mod_rewrite

page_extension:
.html

query_var:
page

image_manipulation_prog:
GD

auto_alias_content:
true

locale:


default_encoding:
utf-8

admin_encoding:
utf-8

set_names:
true

debug:
false

root_url:
http://www.mysite.com

ssl_url:

https://www.mysite.com

root_path:
/home/mysite/public_html/ (0750) Success

previews_path:
/home/mysite/public_html/tmp/cache (0777) Success

uploads_path:
/home/mysite/public_html/uploads (0755) Success

uploads_url:
http://www.mysite.com/uploads

image_uploads_path:
/home/mysite/public_html/uploads/images (0755) Success

image_uploads_url:
http://www.mysite.com/uploads/images

ssl_uploads_url:
/uploads

use_smarty_php_tags:
false

PHP Information:

Current PHP Version (phpversion):
5.2.16 Success

md5 function (md5_function):
On (True) Success

GD version (gd_version):
2 Success

tempnam function (tempnam_function):
On (True) Success

Magic quotes in runtime (magic_quotes_runtime):
Off (False) Success

Is E_STRICT disabled in error_reporting (E_STRICT):
Success

PHP Effective Memory Limit (memory_limit):
128M Success

Maximum Execution Time (max_execution_time):
240 Success

PHP output_buffering (output_buffering):
On Success

PHP Safe Mode (safe_mode):
Off (False) Success

File uploads (file_uploads):
On (True) Success

Maximum Post Size (post_max_size):
8M Caution ?

Maximum Upload Size (upload_max_filesize):
64M Success

Session Save Path (session_save_path):
/tmp (1777) Success

Sessions are allowed to use Cookies (session_use_cookies):
On (True) Success

Basic XML (expat) support (xml_function):
On (True) Success

Checking if the httpd process can create a file inside of a directory it created (create_dir_and_file):
Success

PHP register_globals (register_globals):
Off (False) Success

disable_functions in PHP (disable_functions):
Success

PHP Open Basedir (open_basedir):
Success

Test for remote URL (test_remote_url):
Success
fsockopen: Connection ok! Success
fopen: Connection ok! Success

Test ini_set (check_ini_set):
On (True) Success

Server Information:

Server API (server_api):
cgi

Server Database (server_db_type):
MySQL (mysql)

Server Database Version (server_db_version):
5.0.91 Success

Server Software (server_software):
Apache

Server Operating System (server_os):
Linux 2.6.18-194.32.1.el5 On x86_64

Permission Information

tmp:
/home/mysite/public_html//tmp (0777) Success

templates_c:
/home/mysite/public_html/tmp/templates_c (0777) Success

modules:
/home/mysite/public_html//modules (0755) Success

File Creation Mask (umask):
/home/mysite/public_html/tmp/cache (0777) Success

config_file:
0644 Failure
config.php writable. It is more safe if you change permission to read-only

Thank you for your help in advanced.
User avatar
Dr.CSS
Moderator
Moderator
Posts: 12711
Joined: Thu Mar 09, 2006 5:32 am

Re: Database saving issue //////// /

Post by Dr.CSS »

I see a couple of double // in your path, I would look at the config.php to make sure it doesn't have them also...
pianoku
Forum Members
Forum Members
Posts: 15
Joined: Tue Dec 11, 2007 4:58 am

Re: Database saving issue //////// /

Post by pianoku »

I have checked the config.php and I have fixed the root path.

Removed the / at the end.

So it becomes: $config['root_path'] = '/home/mysite/public_html';

Thank you.
Locked

Return to “[locked] Installation, Setup and Upgrade”