Incompatibilities with MySQL Version:MySQL 5.1.46

[zoemu]

Are there any incompatibilities on the last version of Mysql in comparision with previous ones....

a couple off samples:

Code: Select all

Engine=MyISAM ann no longer TYPE = MyISAM,

you cannot specify default ' ' for text fields
.....`Description` text NOT NULL default '';

instead ....`Description` text NOT NULL;

the above mention did cause errors in my table creation un less I changed them

[gandalf]

This is which version of cacti? I can't find TEXT with a default in 087g code
R.

[zoemu]

Cacti Version 0.8.7g
Plugin Architecture 2.8
Poller Type Cactid v
Server Info Windows NT 5.1
Web Server Microsoft-IIS/5.1
PHP Version 5.2.13


I have a problem with a few plugins at time of installation

[gandalf]

Please post the lines of cacti.sql, that show a data type TEXT using a default value. I can't find any on current SVN of that branch
R.

[zoemu]

I was not refering to Cacti or PIA specifically, but to a few plugins that I was able to correct manually . Nothing too bad!...

My only question was that, if there was some or a few changes to the syntax in the latest version of MySql

Thanks

LA

[TheWitness]

I have been using MySQL 5.1.48 for a while on Cacti 0.8.7g. No issues.

TheWitness

[TheWitness]

Roddie, can you please create a bug report.

Thanks,

Larry

[gandalf]

Fixed, but for 088 only.
Will still have to search the plugins ...
R.

[zoemu]

also, AS I Posted Originally, the following does not seems to valid for text fields anymore

.....`Description` text NOT NULL default '';

instead ....`Description` text NOT NULL;

[gandalf]

Thanks, gandalf.

The cacti.sql one was an easy one to spot, but I imagine the plugins will be more of a pain.

Done. But against trunk only. I won't publish any plugin that I'm not (co-)author of.
R.

[zoemu]

I've got them on my 5.1.46-community on a couple plugins...

LA

[gandalf]

Mac Track's database_upgrade.php is still throwing a ton of errors, too. Yuck.

Please report in the MACTRACK forum; better: file a bug against that plugin.
R.

[gandalf]

also, AS I Posted Originally, the following does not seems to valid for text fields anymore

.....`Description` text NOT NULL default '';

instead ....`Description` text NOT NULL;

Also, as I posted originally:

Please post the lines of cacti.sql, that show a data type TEXT using a default value. I can't find any on current SVN of that branch
R.

R.

[gandalf]

I've got them on my 5.1.46-community on a couple plugins...

LA

them??? WHich plugins? If you want us/me to fix, please post precise pointers; better: file a bug report against each plugin seperately (helps tracking them)
R.

[edkv]

sed -i 's/TYPE/ENGINE/g' cacti.sql