[Phpmyadmin-devel] PBXT table type
Does anyone have the PBXT engine installed? I was unable to get it working on my system to test this -- an IRC user reports: "Attempting to drop columns on a table using PBXT fails with "#1598 - Binary logging not possible. Message: Statement-based format required for this statement, but not allowed by this combination of engines" I can't determine if this is user error or really represents a problem as neither I nor the demo server have PBXT available. Any thoughts?
Hi Isaac, 2010/9/12 Isaac Bennetch <bennetch@gmail.com>:
Does anyone have the PBXT engine installed? I was unable to get it working on my system to test this -- an IRC user reports: "Attempting to drop columns on a table using PBXT fails with "#1598 - Binary logging not possible. Message: Statement-based format required for this statement, but not allowed by this combination of engines"
I can't determine if this is user error or really represents a problem as neither I nor the demo server have PBXT available. Any thoughts?
I don't have the PBXT Engine installed, but according to what I've read it should be easy to install the plugin on a MySQL 5.1 server : [0] You can find the compiled binaries here [1], or if it was not compiled for your setup (OS/MySQL), you can compile it yourself : [2] [0] : http://dev.mysql.com/tech-resources/articles/pbxt-storage-engine.html , scroll down to 'Plugged in and Ready to go' [1] : http://www.primebase.com/xt/download/pbxt-0.9.8-plugins.tar.gz [2] : http://www.primebase.org/download/index.php Greets, Dieter
Hi Dne Sat, 11 Sep 2010 23:51:43 -0400 Isaac Bennetch <bennetch@gmail.com> napsal(a):
Does anyone have the PBXT engine installed? I was unable to get it working on my system to test this -- an IRC user reports: "Attempting to drop columns on a table using PBXT fails with "#1598 - Binary logging not possible. Message: Statement-based format required for this statement, but not allowed by this combination of engines"
I can't determine if this is user error or really represents a problem as neither I nor the demo server have PBXT available. Any thoughts?
Demo server has PBXT, but only on MariaDB, not in MySQL, so just choose another server :-). -- Michal Čihař | http://cihar.com | http://blog.cihar.com
Isaac Bennetch a écrit :
Does anyone have the PBXT engine installed? I was unable to get it working on my system to test this -- an IRC user reports: "Attempting to drop columns on a table using PBXT fails with "#1598 - Binary logging not possible. Message: Statement-based format required for this statement, but not allowed by this combination of engines"
I can't determine if this is user error or really represents a problem as neither I nor the demo server have PBXT available. Any thoughts?
With phpMyAdmin 3.3.7, PBXT 1.0.11-6 under MySQL 5.1.49 running with log-bin=mysql-bin binlog_format=mixed I cannot reproduce this problem. -- Marc Delisle http://infomarc.info
On Sep 12, 2010, at 7:16 AM, Marc Delisle <marc@infomarc.info> wrote:
Isaac Bennetch a écrit :
Does anyone have the PBXT engine installed? I was unable to get it working on my system to test this -- an IRC user reports: "Attempting to drop columns on a table using PBXT fails with "#1598 - Binary logging not possible. Message: Statement-based format required for this statement, but not allowed by this combination of engines"
I can't determine if this is user error or really represents a problem as neither I nor the demo server have PBXT available. Any thoughts?
With phpMyAdmin 3.3.7, PBXT 1.0.11-6 under MySQL 5.1.49 running with
log-bin=mysql-bin binlog_format=mixed
I cannot reproduce this problem.
Thanks Marc! Since the user left before I was able to get any more information, I consider this the end of it. -isaac
Hi Isaac, 2010/9/12 Isaac Bennetch <bennetch@gmail.com>:
Does anyone have the PBXT engine installed? I was unable to get it working on my system to test this -- an IRC user reports: "Attempting to drop columns on a table using PBXT fails with "#1598 - Binary logging not possible. Message: Statement-based format required for this statement, but not allowed by this combination of engines"
I got the same error-message when inserting a row into a PBXT-table. Creating the table was no problem. (PHP 5.2.9, MySQL 5.1.50, pbxt-1.0.11-6-pre-ga) I'm busy compiling PHP 5.3.3 and upgrading my libmysql, so I'll do more digging later. Greets, Dieter
Dieter Adriaenssens a écrit :
Hi Isaac,
2010/9/12 Isaac Bennetch <bennetch@gmail.com>:
Does anyone have the PBXT engine installed? I was unable to get it working on my system to test this -- an IRC user reports: "Attempting to drop columns on a table using PBXT fails with "#1598 - Binary logging not possible. Message: Statement-based format required for this statement, but not allowed by this combination of engines"
I got the same error-message when inserting a row into a PBXT-table. Creating the table was no problem. (PHP 5.2.9, MySQL 5.1.50, pbxt-1.0.11-6-pre-ga)
I'm busy compiling PHP 5.3.3 and upgrading my libmysql, so I'll do more digging later.
Dieter, I tested with mysqlnd so I don't have to care about libmysql. Unfortunately Isaac could not get much details on IRC from this user. -- Marc Delisle http://infomarc.info
participants (4)
-
Dieter Adriaenssens -
Isaac Bennetch -
Marc Delisle -
Michal Čihař