export from Joomla 2.5 to Joomla 3.3

[mrizwan]

Hello

I exported alexandria 2.04 (joomla 2.5) table using phpmyadmin and imported in joomla 3.3 book library version 3 but i am having this error

1054 Unknown column 'state' in 'where clause' SQL=SELECT count(*) FROM jos_abbook WHERE state = 1 when i run alexandria book library in joomla 3.3 backend.

Any suggestions how to export data from book library in Joomla 2.5 to Joomla 3.3

Thanks

[mrizwan]

I am willing to pay to transfer my alexandria book library from joomla 2.5 to joomla 3. Thanks for the help

[federica]

Hi mrizwan,
try to export and import using sql import/export tool (components->Alexandria book library->import/export).

[mrizwan]

I even tried using mysql using alexandria book library

i get this error

<br />
<b>Warning</b>:  mysql_real_escape_string() [<a href='function.mysql-real-escape-string'>function.mysql-real-escape-string</a>]: Access denied for user 'xyz'@'localhost' (using password: NO) in <b>/home3/public_html/administrator/components/com_abook/models/importexport.php</b> on line <b>133</b><br />

Thanks for your help.

[federica]

Hi mrizwan,
go to 2.5 installation then change the file administrator/components/com_abook/admin/models/importexport.php line 133 and 108
from
$resrt .= mysql_real_escape_string($value)."','";
to:
$resrt .= $this->_db->getEscaped($value)."','";