CMS and database

Issues related to the CMS tools of WYSIWYG Web Builder.
Forum rules
PLEASE READ THE FORUM RULES BEFORE YOU POST:
viewtopic.php?f=12&t=1901

MUST READ:
http://www.wysiwygwebbuilder.com/cms_tools.html
A lot of information about the Content Manager System can be found in the help/manual. Please read this first before posting any questions! Also check out the demo template that is include with the software.

CMS trouble shooting / FAQ:
viewtopic.php?f=10&t=43245
Post Reply
mark_borman
 
 
Posts: 4
Joined: Wed Mar 19, 2014 11:23 am

CMS and database

Post by mark_borman »

Pable I wrote to you about table names in database created in CMS scripts and CMS plugins(about some OS not being able to tell the difference between uppercase and lowercase letters)
In this arangement as this is done moving working CMS with database is hard.
While everything worked fine with plugins before (changed manually) after next export sites don't work.
I don't want to rework everything manually again.
More about this https://dev.mysql.com/doc/refman/5.7/en ... ivity.html

I especially recomend you to pay attention to this:
"To avoid problems caused by such differences, it is best to adopt a consistent convention, such as always creating and referring to databases and tables using lowercase names. This convention is recommended for maximum portability and ease of use.

Whats the problem to configure the program to always create tables wrote with lowercase letters and not depending on the system which server uses for example "cms_pages","cms_PAGES","CMS_PAGES" because they are three different tables and if CMS worked fine previously on windows after moving it it doesn't and new tables are created for example instead of "cms_pages" will be created "CMS_PAGES"

PS
Additionally something like this appears in code of my site for object Administrator after line: "mysql_select_db($mysql_database, $db) or die('Failed to select database<br>'.mysql_error());"

I need to add:
mysql_query('SET NAMES "UTF8"', $db);
mysql_query("SET collation_connection='utf8_general_ci'", $db);
mysql_query("SET collation_server='utf8_general_ci'", $db);
mysql_query("SET character_set_client='utf8'", $db);
mysql_query("SET character_set_connection='utf8'", $db);
mysql_query("SET character_set_results='utf8'", $db);
mysql_query("SET character_set_server='utf8'", $db);
mysql_set_charset('utf8', $db);

I'm not going to dig into what this actually does but it works and polish characters show up fine after editing and saving the site.
As editor CKEditor, UTF-8 Unicode encoding (utf8) in program WWB character encoding for site Unicode(UTF-8).
User avatar
Pablo
 
Posts: 21571
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: CMS and database

Post by Pablo »

The tables created by the scripts are always uppercase.
All references in the code are also uppercase. So, there should not be any issues unless you have changed the casing yourself.

I need to add:
mysql_query('SET NAMES "UTF8"', $db);
mysql_query("SET collation_connection='utf8_general_ci'", $db);
mysql_query("SET collation_server='utf8_general_ci'", $db);
mysql_query("SET character_set_client='utf8'", $db);
mysql_query("SET character_set_connection='utf8'", $db);
mysql_query("SET character_set_results='utf8'", $db);
mysql_query("SET character_set_server='utf8'", $db);
mysql_set_charset('utf8', $db);
If you enable Unicode support then this code will be automatically added for you...
Post Reply