Hi I am trying to import comments from another comments systtem (Interspire)
i get this when trying to import the data
Import cancelled ! Comments imported from jos_alcomments and for com_content ALREADY EXIST !!
But they dont!

I have attached a dump of the table if that helps!
please help this is urgent! PS your component rocks! jos_alcomments.zip

Check this box to be notified of replies to this topic.
Note: BBcode and smileys are still usable.

Problem Importing Comments 15 years 4 months ago #4632

Daniel Dimitrov Offline Administrator Posts: 9618 Karma: 155 Thank you received: 1081	Hey Craig! There was a bug in alpha3 with this. I fixed it one week ago. If you pm me your e-mail address I can send you an early build of joomlacomment 4.0 beta1 Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

Problem Importing Comments 15 years 4 months ago #4634

Craig Topic Author Offline Fresh Boarder Posts: 6 Thank you received: 0	Hi Daniel, Thanks for the super fast reply! I have Pm'd you Cheers Craig Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

Problem Importing Comments 15 years 4 months ago #4635

Daniel Dimitrov Offline Administrator Posts: 9618 Karma: 155 Thank you received: 1081	I've send you the new version. Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

Problem Importing Comments 15 years 4 months ago #4636

Craig Topic Author Offline Fresh Boarder Posts: 6 Thank you received: 0	Thanks daniel, Got it - will let you know how it goes! Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

Problem Importing Comments 15 years 4 months ago #4637

Craig
Topic Author
Offline
Fresh Boarder
Posts: 6
Thank you received: 0

Hi,
Got this error
Unknown column 'id' in 'order clause' SQL=INSERT INTO jos_comment (importid,contentid,ip,userid,date,name,email,website,comment,importparentid,component,importtable) SELECT CommentID,ContentID,IP,AuthorID,Date,FromName,FromEmail,Website,Details,ParentID,'','jos_alcommnts' FROM jos_alcommnts AS f ORDER BY id

Thinks is just an change in the SQL - where do i change it?

Cheers
Craig

Check this box to be notified of replies to this topic.
Note: BBcode and smileys are still usable.

Problem Importing Comments 15 years 4 months ago #4639

Daniel Dimitrov Offline Administrator Posts: 9618 Karma: 155 Thank you received: 1081	I think it should be ORDER BY importid at the end. Would you send me a dump of your comments table. I would like to try to import your comments. Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

Problem Importing Comments 15 years 4 months ago #4640

Craig Topic Author Offline Fresh Boarder Posts: 6 Thank you received: 0	Hi Daniel, I attached to to the first post in this thread. Cheers Craig Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

Problem Importing Comments 15 years 4 months ago #4642

Daniel Dimitrov Offline Administrator Posts: 9618 Karma: 155 Thank you received: 1081	AH, sorry about that. Ok it is clearly a bug. Tomorrow you will have a fix for this. I'll get a little rest now(23:20 here) Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

Problem Importing Comments 15 years 4 months ago #4643

Craig Topic Author Offline Fresh Boarder Posts: 6 Thank you received: 0	no prob daniel - thanks Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

Problem Importing Comments 15 years 4 months ago #4697

Daniel Dimitrov Offline Administrator Posts: 9618 Karma: 155 Thank you received: 1081	Hey Craig! I've send you a new version. It should now work. Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

Page:
1

Forum

Latest News

Hotspots 6.0 brings Joomla4 compatibilit...

Create a plugin to override Hotspots mar...

SEO Contest Siebtlingsgeburt with Joomla...

Matukio Events 7 RC 1 is out

CForms 2.0 released

IT-Schulungen

Policies

Licensing
Disclaimer
Terms of Usage
Refunds
Terms of service
Privacy Policy / Imprint
Membership F.A.Q.

Others

What is Joomla?
What is MailChimp?
What is Mandrill?
Translators

Support

Documentation
Changelogs
Support Tickets
Support policy

Prices are shown without VAT unless explicitly stated otherwise. If you are an individual who resides in a member state of the European Union taxation territory or a business located in it which does not provide a valid VIES-registered VAT number during the subscription process you will be charged VAT at the main rate of your country in accordance to the European Directive 2011/83/EU and its incorporation into EU member states' local laws. Residents of Germany and German businesses will always be charged 19% VAT.

Compojoom.com is not affiliated with or endorsed by the Joomla! Project. It is not supported or warranted by the Joomla! Project or Open Source Matters. The Joomla! logo is used under a limited license granted by Open Source Matters, the trademark holder in the United States and other countries.