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
I am willing to pay to transfer my alexandria book library from joomla 2.5 to joomla 3. Thanks for the help
Hi mrizwan,
try to export and import using sql import/export tool (components->Alexandria book library->import/export).
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.
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)."','";