1054 Unknown column ‘c.p0’ in ‘field list’

Same thing here.

I think this is a bug – there is NO ‘p0’ column in the table ‘#___jacomment_items’.

I have the same problem =(

Hi Andrey,

It’s fixed, pls check again.

<blockquote>
I looked into it, the ‘p0’ was added in update to version v1.2.1. I don’t know how that works, but when you do an fresh installation of the ja_comment, the upgrade script v1.2.1 was not executed before v2.5.1.

I took out after ‘p0’ in the v2.5.1 update my scritp, and it went through.
</blockquote>

Yes, the fix will be updated in the next version. With your site,pls send PM to me with admin login info, I will fix it for you.

Regards

Hi obliat,

You can PM me URL and admin account of your site then I shall check it for you.

Regards

Hi mnisifilos,

Pls PM me admin login info and url of your site, I’ll fix it for you.

Regards

Hi vskamme,

Please PM me url, admin and ftp credentials of your site, I will find a fix for you.

Hello,

To resolve this issue, please follow steps below:
– extract the installation package
– Open the file in the folder that you just extracted:
site/helpers/jahelper.php

– Find the code snippet:
[PHP]$lis_sql_path = JPATH_ADMINISTRATOR . DS . ‘components’ . DS . ‘com_jacomment’ . DS . ‘installer’ . DS . ‘sql’;

$regex = ‘/upgrade_(.*?)(.sql)$/i’;
$dk = opendir($lis_sql_path);
while (false !== ($filename = readdir($dk))) {
var_dump($filename);
if (preg_match($regex, $filename)) {
if (JACommentHelpers::table_exists(‘#__jacomment_items’) && $filename == ‘upgrade_v1.2.0.sql’) {
if (! JACommentHelpers::checkField_inserted(‘jacomment_items’, ‘children’) && ! JACommentHelpers::checkField_inserted(‘jacomment_items’, ‘active_children’)) {
JACommentHelpers::populateDB(JPATH_ADMINISTRATOR . DS . ‘components’ . DS . ‘com_jacomment’ . DS . ‘installer’ . DS . ‘sql’ . DS . $filename, $db, $error);
}
}
if (JACommentHelpers::table_exists(‘#__jacomment_items’) && $filename == ‘upgrade_v1.2.1.sql’) {
if (! JACommentHelpers::checkField_inserted(‘jacomment_items’, ‘p0’)) {
JACommentHelpers::populateDB(JPATH_ADMINISTRATOR . DS . ‘components’ . DS . ‘com_jacomment’ . DS . ‘installer’ . DS . ‘sql’ . DS . $filename, $db, $error);
}
}
if (JACommentHelpers::table_exists(‘#__jacomment_items’) && $filename == ‘upgrade_v1.3.0.sql’) {
if (JACommentHelpers::checkField_inserted(‘jacomment_items’, ‘referer’)) {
JACommentHelpers::populateDB(JPATH_ADMINISTRATOR . DS . ‘components’ . DS . ‘com_jacomment’ . DS . ‘installer’ . DS . ‘sql’ . DS . $filename, $db, $error);
}
}
if (JACommentHelpers::table_exists(‘#__jacomment_items’) && $filename == ‘upgrade_v2.5.1.sql’) {
if (! JACommentHelpers::checkField_inserted(‘jacomment_items’, ‘latitude’) &&
! JACommentHelpers::checkField_inserted(‘jacomment_items’, ‘longitude’) &&
! JACommentHelpers::checkField_inserted(‘jacomment_items’, ‘address’)
) {
JACommentHelpers::populateDB(JPATH_ADMINISTRATOR . DS . ‘components’ . DS . ‘com_jacomment’ . DS . ‘installer’ . DS . ‘sql’ . DS . $filename, $db, $error);
}
}
}
}[/PHP]

– And replace it with:
[PHP]$lis_sql_path = JPATH_ADMINISTRATOR . DS . ‘components’ . DS . ‘com_jacomment’ . DS . ‘installer’ . DS . ‘sql’;
$versions = array(‘1.2.0’, ‘1.2.1’, ‘1.3.0’, ‘2.5.1’);

foreach($versions as $version) {
$filename = sprintf(‘upgrade_v%s.sql’, $version);
if (JACommentHelpers::table_exists(‘#__jacomment_items’) && $filename == ‘upgrade_v1.2.0.sql’) {
if (! JACommentHelpers::checkField_inserted(‘jacomment_items’, ‘children’) && ! JACommentHelpers::checkField_inserted(‘jacomment_items’, ‘active_children’)) {
JACommentHelpers::populateDB($lis_sql_path . DS . $filename, $db, $error);
}
}
if (JACommentHelpers::table_exists(‘#__jacomment_items’) && $filename == ‘upgrade_v1.2.1.sql’) {
if (! JACommentHelpers::checkField_inserted(‘jacomment_items’, ‘p0’)) {
JACommentHelpers::populateDB($lis_sql_path . DS . $filename, $db, $error);
}
}
if (JACommentHelpers::table_exists(‘#__jacomment_items’) && $filename == ‘upgrade_v1.3.0.sql’) {
if (JACommentHelpers::checkField_inserted(‘jacomment_items’, ‘referer’)) {
JACommentHelpers::populateDB($lis_sql_path . DS . $filename, $db, $error);
}
}
if (JACommentHelpers::table_exists(‘#__jacomment_items’) && $filename == ‘upgrade_v2.5.1.sql’) {
if (! JACommentHelpers::checkField_inserted(‘jacomment_items’, ‘latitude’) &&
! JACommentHelpers::checkField_inserted(‘jacomment_items’, ‘longitude’) &&
! JACommentHelpers::checkField_inserted(‘jacomment_items’, ‘address’)
) {
JACommentHelpers::populateDB($lis_sql_path . DS . $filename, $db, $error);
}
}
}[/PHP]

– Once done, you need zip this folder to install package, and try again.

FYI: this issue occured because in current upgrade code, it uses readdir function to get a list of sql upgrade file, but this function returns the filenames in the order in which they are stored by the filesystem. So in some case, the version list is not returned with correct order, that’s why upgrading did not worked properly.

I have created issue on our issue tracker system, and we will apply this fix for upcoming version. You can check status of this issue here
http://pm.joomlart.com/browse/JAECCOMCOMMENTJVI-456