I've read the other posts regarding the 1064 error and I get the impression that there's no general rule for determining what issue is triggering the (line 101 in my case) query_factory.php warning. Also, I have the myDebug-backtrace file in the two designated extra-configure folders, and they don't activate.
So, following are the specifics. I'm attempting two fresh installs of zc-v1.50 into two domains not used for my ecommerce site. The domains are webspaces in a Centos 6.x virtual server container. Both fresh installs fail with exactly the same error_log addition:
[Sat Mar 14 00:10:59 2015] [warn] [client 67.190.29.70] mod_fcgid: stderr: PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-configuration WHERE configuration_key = 'CATEGORIES_COUNT_ZERO'' at line 1 :: SELECT count(*) as count FROM spin-configuration WHERE configuration_key = 'CATEGORIES_COUNT_ZERO' in /var/www/vhosts/MyDomain.us/MyDomain.us/includes/classes/db/mysql/query_factory.php on line 101, referer: http:/MyDomain.us/zc_install/index.php?main_page=license
The zc_install "Warning" is generated with this query_factory.php function:
function show_error() {
if ($this->error_number == 0 && $this->error_text == DB_ERROR_NOT_CONNECTED && !headers_sent() && file_exists('nddbc.html') ) include('nddbc.html');
echo '<div class="systemError">';
if (defined('STRICT_ERROR_REPORTING') && STRICT_ERROR_REPORTING == true)
{
echo $this->error_number . ' ' . $this->error_text;
echo '<br />in:<br />[' . (strstr($this->zf_sql, 'db_cache') ? 'db_cache table' : $this->zf_sql) . ']<br />';
} else {
echo 'WARNING: An Error occurred, please refresh the page and try again.';
}
trigger_error($this->error_number . ':' . $this->error_text . ' :: ' . $this->zf_sql, E_USER_ERROR);
if (defined('IS_ADMIN_FLAG') && IS_ADMIN_FLAG==true) echo 'If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.<br />';
echo '</div>';
}
And the data base 412 configuration referenced in the error_log is:
(|412|Categories with 0 Products Status|CATEGORIES_COUNT_ZERO|0|Show Category Count for 0 Products?<br />0= off<br />1= on|19|30|NULL|2015-02-17 08:43:31|NULL|zen_cfg_select_option(array('0', '1'))
I find nothing inappropriate with that db record.
So, I'm stymied.
Any knowledge regarding this problem would be appreciated.
And incidentally, if someone has noticed I have many posts seeking help but none offering help, it's because until I have successfully installed my ecommerce site, I categorically "don't know nothin worth knowing!"
Bookmarks