config sql query utf8 error
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
PHPDevShell |
Invalid
|
Undecided
|
Unassigned |
Bug Description
While trying to setup a query within the plugin.config.xml file for my new plugin, I came across the following error with respect to UTF8 which says "Input is not proper UTF-8" (see full error below).
I exported the sql query from my db using phpMyAdmin. The table in question is InnoDB and the Collation is utf8_general_ci.
The line in question is probably the last letter of this query which is an e with two dots on top:
INSERT INTO `_db_my_
Here is the full error message that I copied and pasted from my screen:
-------
Uncaught Exception while running
This page will try to provide as much information as possible so you can track down (and hopefully fix) the problem.
The error
The message of the error is as follow:
simplexml_
The error occurred in file /home/public_
116 <?php
117 <?php
118 <?php
119 <?php
120 <?php
121 <?php
122 <?php
123 <?php
124 <?php
125 <?php
126 <?php
127 <?php
128 <?php
129 <?php
The configuration
Configuration files actually used:
* [ 0 ] => /home/public_
* [ 1 ] => /home/public_
* [ 2 ] => /home/public_
* [ 3 ] => /home/public_
* [ 4 ] => /home/public_
Configuration files which would have been used if they were present:
* [ 0 ] => /home/public_
* [ 1 ] => /home/public_
* [ 2 ] => /home/public_
The Backtrace:
All relative file pathes are relative to the server root (namely /home/public_html/ )
Click on the Book icon to access online documentation.
File path (relative) Line Call (with arguments)
...phpds/
simplexml_
116 <?php
117 <?php
118 <?php
119 <?php
120 <?php
121 <?php
122 <?php
123 <?php
124 <?php
125 <?php
126 <?php
127 <?php
128 <?php
129 <?php
...phpds/
PHPDS_readPlugi
151 <?php
*/
152 <?php
public function invokeQueryWith
153 <?php
{
154 <?php
$query = $this->
155 <?php
if (!is_a($query, 'PHPDS_query'))
156 <?php
157 <?php
return $query-
158 <?php
}
159 <?php
160 <?php
/**
161 <?php
* Locates the query class of the given name, loads it, intantiate it, and returns the query object
162 <?php
*
163 <?php
* @date 20100219
164 <?php
* @version 1.1
...phpds/
PHPDS_db:
133 <?php
* @return array (usually), the result data of the query
134 <?php
*/
135 <?php
public function invokeQuery(
136 <?php
{
137 <?php
$params = func_get_args();
138 <?php
139 <?php
return $this->
140 <?php
}
141 <?php
142 <?php
/**
143 <?php
* Locates the query class of the given name, loads it, intantiate it, send the query to the DB, and return the result
144 <?php
*
145 <?php
* @date 20100922 (1.0) (greg) added
146 <?php
* @version 1.0
...phpds/
PHPDS_db:
94 <?php
95 <?php
}
96 <?php
97 <?php
// Call current plugins status from database. ///
98 <?php
99 <?php
// Read plugin directory.
100 <?php
$RESULTS = $this->
101 <?php
102 <?php
// Load views.
103 <?php
$view = $this->
104 <?php
105 <?php
// Set Array.
106 <?php
107 <?php
...phpds/
PluginActivatio
83 <?php
public function run()
84 <?php
{
85 <?php
86 <?php
if (PU_isAJAX ()) {
87 <?php
88 <?php
} else {
89 <?php
90 <?php
}
91 <?php
}
92 <?php
93 <?php
/**
94 <?php
* This method is meant to be the entry point of your class. Most checks and cleanup should have been done by the time its executed
95 <?php
*
96 <?php
* @return whatever
...phpds/
PHPDS_controlle
510 <?php
}
511 <?php
} else {
512 <?php
if ($required) throw new PHPDS_exception
513 <?php
}
514 <?php
if (is_string($result) && class_exists(
515 <?php
$result = $this->
516 <?php
517 <?php
}
518 <?php
519 <?php
// we don't use $debug as it can have been tampered with
520 <?php
521 <?php
522 <?php
return $result;
523 <?php
}
...phpds/
PHPDS_core:
1245 <?php
if ($include_model === true) $include_model = 'query';
1246 <?php
1247 <?php
}
1248 <?php
// Set active script directory.
1249 <?php
1250 <?php
// Require script.
1251 <?php
if ($core-
1252 <?php
if ($core-
1253 <?php
}
1254 <?php
1255 <?php
return false;
1256 <?php
}
1257 <?php
1258 <?php
...phpds/
PHPDS_template:
1146 <?php
}
1147 <?php
}
1148 <?php
// Execute repeated menu cases.
1149 <?php
switch ($menu_case) {
1150 <?php
// Plugin Script.
1151 <?php
1152 <?php
1153 <?php
1154 <?php
// Link, Jump, Placeholder.
1155 <?php
1156 <?php
1157 <?php
1158 <?php
1159 <?php
...phpds/
PHPDS_template:
142 <?php
if (!empty(
143 <?php
144 <?php
}
145 <?php
146 <?php
if (empty(
147 <?php
// This will pre-load the controller and save it.
148 <?php
149 <?php
} else {
150 <?php
151 <?php
}
152 <?php
153 <?php
// There should be a template available here...
154 <?php
if (! $this->
155 <?php
if (!$this-
...phpds/
PHPDS_template:
528 <?php
{
529 <?php
530 <?php
try {
531 <?php
//TODO: check we don't run an embebbed instance
532 <?php
// We require templating system for final output
533 <?php
// Run template as required.
534 <?php
535 <?php
// Lets log access to menu item if so required.
536 <?php
537 <?php
// Write collected logs to database.
538 <?php
539 <?php
// Print queries used, when required.
540 <?php
541 <?php
} catch (Exception $e) {
...phpds/index.php 34 <?php
PHPDS::run()
Changed in phpdevshell: | |
status: | New → Invalid |
As an additional note, the SQL query below works fine if I import the .sql file back into database thru phpMyAdmin
INSERT INTO `_db_my_ setup_state_ province` (`id`, `country_id`, `code`, `name`) VALUES (340, 20, 'BU', 'Bulqizë');