#008768: The database charset check uses unquoted db names

Description:

The database charset check (setup wizard) uses unquoted db names and therefor fails sometimes when there are any special chars in the db name. See also this topic on the forums: http://ez.no/community/forum/install_configuration/database_install_problem_in_setup_3_8_3_3_8_1url

In lib/ezdb/classes/ezmysqldb, change this code:


function checkCharsetPriv( $charset, &$currentCharset )
{
    $query = "SHOW CREATE DATABASE " . $this->DB;

to:

function checkCharsetPriv( $charset, &$currentCharset )
{
    $query = "SHOW CREATE DATABASE `" . $this->DB . "`";

(note the backticks)

I didn't test this but I think it should work.


Environment:

Version: all
PHP Version:
Webserver:
Database: MySQL


- Attachments

No attachments for this issue.


- Comments

Sorry, I guess this is a duplicate of http://ez.no/bugs/view/6545url

#249441 by Kristof Coomans on August 20th, 2006 [Permanent Link]

- History
Properties
Type Bug
Priority Medium
Component Misc
Affects Unknown
Fix Version -
Reporter Kristof Coomans
Responsible -
Status 0 Closed
Resolution Duplicate
Created August 5th, 2006
Updated August 22nd, 2006
Resolved August 22nd, 2006
 
Navigation [Permanent Link]
Previous Issue
Back to Issues List
Next Issue: #019127
  DB Deadlocks on ezcontentobject_tree when updating subnode