Error with yvcomment import

Error with yvcomment import 15 years 3 months ago #5979

Honorgate
Topic Author
Offline
Fresh Boarder
Posts: 2
Thank you received: 0

Hi !

Thank you very much for your great componement.
Unfortunatly, i've an error message during import my yvcomment tables :

Error: DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fulltext,state,parentid,'','jos_yvcomment' FROM jos_yvcomment AS f ORDER BY f.id' at line 2 SQL=INSERT INTO jos_comment (importid,contentid,userid,date,name,title,comment,published,importparentid,component,importtable) SELECT id,sectionid,created_by,created,created_by_alias,title,fulltext,state,parentid,'','jos_yvcomment' FROM jos_yvcomment AS f ORDER BY f.id

What shall i do ? Preview seems to be correct anyway ...

Thank you for your help !

Error with yvcomment import 15 years 3 months ago #5981

JonusC
Offline
Platinum Boarder
Posts: 785
Thank you received: 48

Hmm, it might be a bug - i've flagged Daniel to take a look. Until he can get back to you, could you kindly provide the following generic info for him to inspect incase it may help:

1. A link to your website if possible (If you'd prefer to wait for Daniel to reply you can PM to him after)
2. Your version of Joomla (make sure you are running the latest Beta2 of JoomlaComment too)
3. Your versions of PHP and MySQL on the webhost
4. The character code set of your MySQL database - if you know what is or have changed it at all (otherwise if your site is English it's probably the default utf8 which is fine)

Thanks!

Error with yvcomment import 15 years 3 months ago #5982

Honorgate Topic Author Offline Fresh Boarder Posts: 2 Thank you received: 0	Thanks, of course i've forgotten infos ... My website : honorgate.net (french) Joomla 1.5.14 - JoomlaComment v. 4.0 beta2 PHP 5.2.10 - MySQL 5.0.51a-log character code utf-8 Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

Error with yvcomment import 15 years 3 months ago #6078

Daniel Dimitrov Offline Administrator Posts: 9618 Karma: 155 Thank you received: 1081	Would you send me the dump of the yvcomment table. I want to test this locally for me. edit: I've sent you a PM with my e-mail address. Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

Error with yvcomment import 15 years 2 weeks ago #7761

Zesus
Offline
Fresh Boarder
Posts: 2
Thank you received: 0

i got the same error , did anybody found a solution yet ?

Error: DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fulltext,'','jos_yvcomment' FROM jos_yvcomment AS f ORDER BY f.id' at line 2 SQL=INSERT INTO jos_comment (importid,contentid,userid,date,name,title,comment,component,importtable) SELECT id,parentid,created_by,alias,created_by_alias,title,fulltext,'','jos_yvcomment' FROM jos_yvcomment AS f ORDER BY f.id
 
Please copy the error message and contact the joomlacomment support

Error with yvcomment import 15 years 2 weeks ago #7763

Daniel Dimitrov Offline Administrator Posts: 9618 Karma: 155 Thank you received: 1081	Hey zesus, I'm rewriting the backend for the new version of joomlacomment. Would you be so kind and send me your dump? I've send you a PM with my e-mail. Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

Error with yvcomment import 15 years 2 weeks ago #7765

Daniel Dimitrov
Offline
Administrator
Posts: 9618
Karma: 155
Thank you received: 1081

Interesting what is the contentid from the yvcomment table?? Is it really parentid?
Anyway. Open administrator/component/com_comment/admin.comment.php.

Find the executeImport function and around line 590 we have this code

			$tolist[] 	= $col->Field;
			$fromlist[] = $param;

change it to this and it should work.

			$tolist[] 	= $database->nameQuote($col->Field);
			$fromlist[] = $database->nameQuote($param);

Error with yvcomment import 15 years 2 weeks ago #7766

Daniel Dimitrov
Offline
Administrator
Posts: 9618
Karma: 155
Thank you received: 1081

I forgot to say what the problem was.
Yvcomment has a column fulltext. This is a reserverd mysql type, so if we want to use it, we should always escape it.
The nameQuote method of the database Object does exactly this. So now instead of ,fulltext we have a , `fulltext` in our query - and this solves the problem.

Error with yvcomment import 15 years 2 weeks ago #7767

Zesus Offline Fresh Boarder Posts: 2 Thank you received: 0	thanks man you are awesome the fix works perfectly.. and yes parentid stands for contentid as the comment could be parented by another comment Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.

Tiles

CMC

CMandrill

FFGate

CUpdater

CNotes

Mydigipass

CSlideshow

Pricing

Joomla! Development

Joomla! Security

App Development

Angular 2

Official releases

Developer releases

Languages

Help Desk

Support policy

Hotspots

Matukio Events

CComment

Ctransifex

CMC

CNotes

CMigrator

CMandrill

MyDigipass

CForms

CForms for WordPress

Video Tutorials

Changelogs

Matukio API Docs

Team

Joomla Commitment

Privacy Policy / Imprint

Notice

TOPIC: Error with yvcomment import