Jump to content

ClearVue

Members
  • Content count

    2
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Manuel Herrera
  1. I was able to troubleshoot #1, #2 and #3 (in previous post) ... I removed "@@lc_time_names" from the FORMAT method, but ended up with the "fetch_all() undefined" error in my logs. I have a support ticket into my web host ... the shared web host phpinfo() is using PHP v5.4.10 and shows mysqli and mysqlnd installed, but for some reason it still doesn't work. I also cannot find a backwards compatibility anywhere for the "fetch_all()" method. I have been thru every page of this topic as well as the Advanced Statistics topics, tried everything possible, but no luck. ... I even tried setting flag for "register_globals" and "magic_quotes_gpc" to "off", but still no luck. ... Where/what is the code supposed to be for the fallback to tep_fetch_all ??? I cannot find it anywhere.
  2. Having some problems that I can't figure out ... Installed Rev4 from scratch, running into the following issues: 1. 'Math' doesn't work ... the following error is produced: FORMAT((AVG(FLOOR((DATEDIFF(CURDATE(), c.customers_dob) / 365)))), 2, @@lc_time_names) AS customers_mean_age FROM customers c WHERE (FLOOR((DATEDIFF(CURDATE(), c.customers_dob) / 365))) > 0 ' failed: Incorrect parameter count in the call to native function 'FORMAT' 2. Statistics works with a problem where "Customer Age" always returns "0" (I verified that DOB does exist for all orders) 3. Advanced Statistics: ONLY "Table Data" tab shows results. Tabs for "Map" and "Color Map" return error "500: Internal Server Error" ... Tabs for "Yearly", "Monthly", "Daily" and "Hourly" return similar errors like: FROM_UNIXTIME(SUM(UNIX_TIMESTAMP(ci.customers_info_date_account_created)) / COUNT(*), '%Y-%m-%d %H:%i:%s') AS date, FORMAT((AVG(FLOOR((DATEDIFF(CURDATE(), c.customers_dob) / 365)))), 2, @@lc_time_names) AS customers_mean_age FROM customers c LEFT JOIN customers_info ci ON (c.customers_id = ci.customers_info_id) WHERE (FLOOR((DATEDIFF(CURDATE(), c.customers_dob) / 365))) > 0 GROUP BY YEAR(ci.customers_info_date_account_created), MONTH(ci.customers_info_date_account_created), DAY(ci.customers_info_date_account_created), HOUR(ci.customers_info_date_account_created) ORDER BY date' failed: Incorrect parameter count in the call to native function 'FORMAT' 4. When clicking "Edit Record" icon at right of a single row, all data is populated into the dialog correctly, however, upon clicking "SAVE" button all data for that record is wiped out with Null values (as if the cID is not being sent) AND the result says "New Account created for undefined undefined". Any clues or help would be greatly appreciated!
×