×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Error with yvcomment import

Error with yvcomment import 10 years 1 month ago #5979

  • Honorgate
  • Honorgate's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • 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 ... :unsure:

Thank you for your help !

Error with yvcomment import 10 years 1 month ago #5981

  • JonusC
  • JonusC's Avatar
  • Offline
  • Platinum Boarder
  • 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 10 years 1 month ago #5982

  • Honorgate
  • Honorgate's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 0
Thanks, of course i've forgotten infos ... :blush:

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

Error with yvcomment import 10 years 1 month ago #6078

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • 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.

Error with yvcomment import 9 years 10 months ago #7761

  • Zesus
  • Zesus's Avatar
  • Offline
  • Fresh Boarder
  • 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 9 years 10 months ago #7763

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • 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.

Error with yvcomment import 9 years 10 months ago #7765

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • 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 9 years 10 months ago #7766

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • 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 9 years 10 months ago #7767

  • Zesus
  • Zesus's Avatar
  • Offline
  • Fresh Boarder
  • 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
  • Page:
  • 1
Time to create page: 0.103 seconds