Poller[0] ERROR: SQL Row Failed!, Error:'1033'

I have cacti working flawlessly on a centos 7.0 machine but I need it
working on a centos 6.3 machine.

I download the same version as what is on the 7.0, I installed rrdtool from
yum.

After performing a successful base installation of cacti and confirm it
works. 

I then copy over the database and restart mysqld 

I see my data but 'none of the charts appear' and I get this error in my
cacti.log

 

10/01/2014 04:12:31 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!,
Error:'1033', SQL:"select  host.id,  host.hostname,  host.snmp_community,
host.snmp_version,  host.snmp_username,  host.snmp_password,
host.snmp_auth_protocol,  host.snmp_priv_passphrase,
host.snmp_priv_protocol,  host.snmp_context,  host.snmp_port,
host.snmp_timeout,  host.disabled  from host  where host.id=1"

 

I have upgraded MySQL to 5.4 and rddtool  to 1.4.8 and tried a different
cacti versions

I have also tried every script in cli/

Mysqlcheck say the database is just fine

Same error

 

 

How do I get my charts to work?

 

 

Brad 

 

------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk