Author Topic: Chart builder 2 beta not displaying sql data  (Read 6506 times)

johnboy4809

  • Tadpole
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
    • Email
Chart builder 2 beta not displaying sql data
« on: January 18, 2013, 01:47:18 PM »
Just want to say great plugin

have installed the version 2 beta to try the csv and sql imports, the scv import works great but i dont get anything with the sql import

All i see is the button to show hide table, clicking this also does nothing

I've tried your two demo shortcodes as well as my own on a fresh default install of wordpress

can anyone give me pointers on how i can find out whats going wrong

the wordpress site is on my local wamp server running php5

doug@dyerware.com

  • Administrator
  • Sr. Member
  • *****
  • Posts: 456
  • Karma: +15/-0
    • View Profile
    • Email
Re: Chart builder 2 beta not displaying sql data
« Reply #1 on: January 18, 2013, 03:44:50 PM »
What version of wordpress are you using?  Can't imagine its older than 3.x.

This works fine:
[easychart type="line" importsql="wp_posts" valuenames="post_date" groupnames="comment_count"]

in wordpress 3.5 in my test setup (and it should work with older versions too).  I get a bar chart and should get a line chart (its not without its bugs :) )

are you using your own table?  If so what does your shortcode look like
-d

johnboy4809

  • Tadpole
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
    • Email
Re: Chart builder 2 beta not displaying sql data
« Reply #2 on: January 18, 2013, 03:56:12 PM »
thankis for the reply

im running wordpress 3.5

ive pasted your code into a page and done this in code view, the only change I had to make was that my tales are prefixed with wp_stats so my page code is

[easychart type="line" importsql="wp_statsposts" valuenames="post_date" groupnames="comment_count"]

this still wont work

doug@dyerware.com

  • Administrator
  • Sr. Member
  • *****
  • Posts: 456
  • Karma: +15/-0
    • View Profile
    • Email
Re: Chart builder 2 beta not displaying sql data
« Reply #3 on: January 18, 2013, 04:41:49 PM »
I don't have a wp_statsposts table, which is why it does not work in my case.   Do you have such a table and is it off of 'wordpress' database?

thanks.

johnboy4809

  • Tadpole
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
    • Email
Re: Chart builder 2 beta not displaying sql data
« Reply #4 on: January 18, 2013, 04:48:13 PM »
yes it was a wp table, i always change the table prefix when installing wordpress for security, I have however reutrned the prefix bax to wp_ and still the plugin nwont work

doug@dyerware.com

  • Administrator
  • Sr. Member
  • *****
  • Posts: 456
  • Karma: +15/-0
    • View Profile
    • Email
Re: Chart builder 2 beta not displaying sql data
« Reply #5 on: January 18, 2013, 05:07:26 PM »
ok well that was not it.   Would you entertain a test file?

doug@dyerware.com

  • Administrator
  • Sr. Member
  • *****
  • Posts: 456
  • Karma: +15/-0
    • View Profile
    • Email
Re: Chart builder 2 beta not displaying sql data
« Reply #6 on: January 19, 2013, 05:01:36 PM »
oh Im using a deprecated PHP API for some of the SQL stuff!  Perhaps it has been neutered.  Let me migrate to it.  Im using PHP 5.3.6. 

 

anything