Again, I am really NOT a coder, so am way over my head. I have studied all of the files referenced in the error log, and still wonder if it has something to do with the db prefix? The trigger_error begins with line 59 on the functions-db-MySQL.php file, which refers to the prefix:
if($errorstop) {
$sql = str_replace($_zp_conf_vars['mysql_prefix'], '['.gettext('prefix').']',$sql);
$sql = str_replace($_zp_conf_vars['mysql_database'], '['.gettext('DB').']',$sql);
trigger_error(sprintf(gettext('%1$s Error: ( [i]%2$s[/i] ) failed. %1$s returned the error [i]%3$s[/i]'),DATABASE_SOFTWARE,$sql,db_error()), E_USER_ERROR);
}
Again, ANY assistance would be greatly appreciated!