×

Notice

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

TOPIC: Problem importing comments from EasyGuestbook

Problem importing comments from EasyGuestbook 15 years 3 months ago #2298

  • Al
  • Al's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 11
  • Thank you received: 0
First of all let me thank you for a cool tool.
Now, I'm having a problem I think only you could help m with:

When trying to import comments fro Easyguestbook, I ran into a problem. even though I tried many different combination in the settings of the impot I keep on getting the same error:
Import canceled ! Comments imported from jos_easygb and for com_content ALREADY EXIST !!


Also below it I get a long error message which I attach as an image as well, which by the way then also appears when I want to edit comments under MANAGE COMMENTS.

PLEASE HELP :blush:

PS... How are you supposed to attach images here??
HEY... this is the wierd.. I now see one of the images.. anyway.. lets see what happens

let me copy paste the error massage:

Unknown column 'c.importtable' in 'where clause' SQL=SELECT count(*) FROM jos_comment AS c LEFT JOIN jos_content AS ct ON ct.id = c.contentid WHERE c.component = '' AND ( LOWER(c.comment) LIKE '%jos_easygb%' OR LOWER(ct.title) LIKE '%jos_easygb%' OR LOWER(c.name) LIKE '%jos_easygb%' OR LOWER(c.website) LIKE '%jos_easygb%' OR LOWER(c.email) LIKE '%jos_easygb%' OR LOWER(c.ip) LIKE '%jos_easygb%' OR LOWER(c.importtable) LIKE '%jos_easygb%' )DB function failed with error number 1054
Unknown column 'c.importtable' in 'where clause' SQL=SELECT c.*, u.email AS usermail, ct.title AS ctitle FROM jos_comment AS c LEFT JOIN jos_users AS u ON u.id = c.userid LEFT JOIN jos_content AS ct ON ct.id = c.contentid WHERE c.component = '' AND ( LOWER(c.comment) LIKE '%jos_easygb%' OR LOWER(ct.title) LIKE '%jos_easygb%' OR LOWER(c.name) LIKE '%jos_easygb%' OR LOWER(c.website) LIKE '%jos_easygb%' OR LOWER(c.email) LIKE '%jos_easygb%' OR LOWER(c.ip) LIKE '%jos_easygb%' OR LOWER(c.importtable) LIKE '%jos_easygb%' ) ORDER BY c.id DESC LIMIT 0,20

Problem importing comments from EasyGuestbook 15 years 3 months ago #2311

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Hey there! Please search the forum. There are several threads about this. The funciton is generating wrong SQL code for import.

Problem importing comments from EasyGuestbook 15 years 3 months ago #2336

  • Al
  • Al's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 11
  • Thank you received: 0
Dear Daniel,

Thanks for replying.

I, ever since, installed the older version (3.26) and everything works like charm.

I must say, GOOD JOB!!! seriously.

Now If I may ask one more thing.

I'm using your jcomment on my homepage blog AND as the guestbook.
On the homepage blog, I am using the function of "notify upon new comment", but I would like it switched off for the guestbook.
Is there a way to instruct jcomment to apply "Notify - NO" by default for just that section?

Many thanks!

Problem importing comments from EasyGuestbook 15 years 3 months ago #2342

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
No there isn't. Alain Georgette started a function that allows a user to use different templates depending on the user section he is in, but it is not ready and I have to finish it. Perhaps we can use the same principle for the thing you want.

Problem importing comments from EasyGuestbook 15 years 3 months ago #2362

  • Al
  • Al's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 11
  • Thank you received: 0
Yes great :cheer:
  • Page:
  • 1
Time to create page: 0.129 seconds