Joomla Extensions Club 20,483 posts

[vitopian Friend vitopianJoin date: January 2012Posts: 19Downloads:0Uploads:1 Thanks: 3]

#200097

Hello,

I just upgraded my site from J2.5.8 to J3.3.3. In order to complete the install, I had to uninstall JA Comment.

Today I renewed my license with Joomlart and downloaded the latest version of JA Comment which says it is compatible with Joomla 3.

When I try to install JA Comment, the following message is received:

Unknown column ‘p0’ in ‘xds84_jacomment_items’ SQL=ALTER TABLE `xds84_jacomment_items` ADD `latitude` CHAR(255) COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `p0`

JA Comments shows under the Component list however a similar message appears on the admin panel:

Unknown column ‘c.p0’ in ‘field list’ SQL=SELECT c.id, c.parentid, c.contentid, c.ip, c.name, c.contenttitle, c.comment, c.date, c.published, c.locked, c.ordering, c.email, c.website, c.star, c.userid, c.usertype, c.option, c.voted, c.report, c.subscription_type, c.referer, c.source, c.type, c.date_active, c.active_children, c.p0 FROM xds84_jacomment_items as c WHERE 1=1 ORDER BY c.id DESC

[Thanh Nguyen Viet Friend Thanh Nguyen VietJoin date: September 2014Posts: 1461Downloads:0Uploads:44 Thanked: 258 times in 217 posts]

#543876

Hello,

Please send me PM for Administrator account and FTP credentials for further checking. I’ll help you to resolve this issue.

[robbenr Friend robbenrJoin date: June 2014Posts: 44Downloads:54Uploads:0 Thanks: 16 Thanked: 1 times in 1 posts]

#544649

I receive an error to when I’m trying to install the package: com_jacomment.v2.5.3 into Joomla! 3.3.3 Stable
it’s your Decor template.

An error has occurred.

1054 Unknown column ‘p0’ in ‘deu42_jacomment_items’ SQL=ALTER TABLE `deu42_jacomment_items` ADD `latitude` CHAR(255) COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `p0`

[Thanh Nguyen Viet Friend Thanh Nguyen VietJoin date: September 2014Posts: 1461Downloads:0Uploads:44 Thanked: 258 times in 217 posts]

#544996

Hello Robbenr,

I have just install JA comment version 2.5.3 on JA Decor for Joomla 3.3 on our dev server, and everything still work properly.

Please send me FTP credential and Administrator account of your site, I’ll help you to install JA comment.

[Thanh Nguyen Viet Friend Thanh Nguyen VietJoin date: September 2014Posts: 1461Downloads:0Uploads:44 Thanked: 258 times in 217 posts]

#545391

Hello,

I have found a cause of this issue, and solution to resolve it has been posted here, please have a look.

[robbenr Friend robbenrJoin date: June 2014Posts: 44Downloads:54Uploads:0 Thanks: 16 Thanked: 1 times in 1 posts]

#545837

sorry was on Holiday.. I’m going to test it tonight.
thx for the reply 🙂

<em>@Dead Code 440597 wrote:</em><blockquote>Hello,

I have found a cause of this issue, and solution to resolve it has been posted here, please have a look.</blockquote>

[Author]

Posts