MAMP platform: Database schema update problems

[PtrNrs]

For some years I have been successfully trailing my F2.x sites on a MAMP platform on a Macbook Air.

With F3.0.x, I find that I am experiencing errors when Fabrik tries to make database schema changes. eg:-

• When I create a list, a database table is not created;
• When I change an element type, Fabrik fails to change the field type in the database.

These errors are not notified by Fabrik.
Meanwhile, these functions work perfectly:-

• In F2.x on MAMP;
• In F3.0.x on an externally hosted LAMP website.

Is there anything I should check? Any gotchas? Fabrik does have unrestricted root access to the database.

MAMP MySQL details:-
 
mysql
 
MySQL Support    enabled
Active Persistent Links    0
Active Links    0
Client API version    5.5.9
MYSQL_MODULE_TYPE    external
MYSQL_SOCKET    /Applications/MAMP/tmp/mysql/mysql.sock
MYSQL_INCLUDE    -I/Applications/MAMP/Library/include
MYSQL_LIBS    -L/Applications/MAMP/Library/lib -lmysqlclient
 
Directive    Local Value    Master Value
mysql.allow_local_infile    On    On
mysql.allow_persistent    On    On
mysql.connect_timeout    60    60
mysql.default_host    no value    no value
mysql.default_password    no value    no value
mysql.default_port    no value    no value
mysql.default_socket    /Applications/MAMP/tmp/mysql/mysql.sock    /Applications/MAMP/tmp/mysql/mysql.sock
mysql.default_user    no value    no value
mysql.max_links    Unlimited    Unlimited
mysql.max_persistent    Unlimited    Unlimited
mysql.trace_mode    Off    Off
 
mysqli
 
MysqlI Support    enabled
Client API library version    5.5.9
Active Persistent Links    0
Inactive Persistent Links    0
Active Links    1
Client API header version    5.5.9
MYSQLI_SOCKET    /Applications/MAMP/tmp/mysql/mysql.sock
 
Directive    Local Value    Master Value
mysqli.allow_local_infile    On    On
mysqli.allow_persistent    On    On
mysqli.default_host    no value    no value
mysqli.default_port    3306    3306
mysqli.default_pw    no value    no value
mysqli.default_socket    no value    no value
mysqli.default_user    no value    no value
mysqli.max_links    Unlimited    Unlimited
mysqli.max_persistent    Unlimited    Unlimited
mysqli.reconnect    Off    Off

 

[PtrNrs]

I've checked this problem with the latest from GitHub and it still happens. The problem was failure of the call to iconv() in function iclean() in /components/com_fabrik/string.php line 285

// Replace accented characters with ascii equivalent e.g. ? => e
$str = (str_replace("'", '', @iconv($fromEnc, $toEnc, $str)));

When replaced with the following, it works correctly

$str1 = (@iconv($fromEnc, $toEnc, $str));
if($str1) {
    $str = $str1;
}
$str = (str_replace("'", '', $str));

With great trepidation I have posted a pull request at https://github.com/Fabrik/fabrik/pull/791. I hope I did it right!

Here's the system info:-

System Information
Setting    Value
 
PHP Built On    Darwin Petes-MacBook-Airy.local 11.4.2 Darwin Kernel Version 11.4.2: Thu Aug 23 16:25:48 PDT 2012; root:xnu-1699.32.7~1/RELEASE_X86_64 x86_64
Database Version    5.5.9
Database Collation    utf8_general_ci
PHP Version    5.3.5
Web Server    Apache/2.0.64 (Unix) PHP/5.3.5 DAV/2
WebServer to PHP Interface    apache2handler
Joomla! Version    Joomla! 2.5.11 Stable [ Ember ] 26-April-2013 14:00 GMT
Joomla! Platform Version    Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
User Agent    Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:22.0) Gecko/20100101 Firefox/22.0

 

[PtrNrs]

https://github.com/Fabrik/fabrik/pull/791 merged.

Thanks, Rob

 

[rob]

no thank you Pete