explanation of a few of the SQL fields?

dax702 · Post by **dax702** » 13 May 2008, 05:41

I'm preparing my CSV for the big import into the guestbook. I am unclear on a few of the fields though, hope you can explain them a little?

catid: I think this is used to identify which guestbook the entry is for?

sid: I don't know what this is

userid: I don't know what this is

homesite: I am guessing this is for the user to enter his website address, but I don't see that field on the front end of the guestbook.

params: Don't know this one either..

Post by **Jan** » 13 May 2008, 09:41

table: jos_phocaguestbook_items:

catid: id of guestbooks (guestbook you have created in Phoca Guestbook - Guestbooks. mostly the value is '1' - int)

sid: session id - not used in Phoca Guestbook, so you can leave it with '0' int

userid - not set yet, so leave with '0' - int
homesite - yes, you right, not set yet, leave with ''
params - leave with ''

Jan

dax702 · Post by **dax702** » 13 May 2008, 09:49

when you say leave with " do you mean to put an actual quotation mark in the field? Or to leave it completely blank? For some reason after a few tries to import, I got some error in phpmyadmin and could no longer import, so i called my web host so they're going to mess with it.

Before that happened, I did have success, except the date was wrong but it might have been my fault, I think the spreadsheet added AM/PM to the end of the date field and according to the field in the table, it's just YYYY/MM/DD HH:MM:SS I was using Calc in OpenOffice.org to prepare the csv file.

The other thing I noticed is that it ordered them backwards. I wanted the entries to be in order from newest to oldest, so I set the ordering field that way, but when I looked at the front end of the guestbook, it was backwards. I did not see an option in the admin about displaying newest first, or oldest first.

Post by **Jan** » 13 May 2008, 09:56

leave it with '' means leave it completely blank, but I don't know CSV import , if you want to leave some field completely blank in SQL import, you set it to ''.

The posts are saved in database forwards but in the frontend are displayed backwards (the last is first - this is usual and can be changed in SQL command in php code)

Jan

dax702 · Post by **dax702** » 13 May 2008, 09:59

Ok, thank you.....One last question I forgot. Is there a limit to the length of an entry? I noticed one of my longer entries did not import the whole text. If there is a limit, where can I change this?

Post by **Jan** » 13 May 2008, 10:12

you can see the install.bak file in the ZIP file:

`content` text NOT NULL default - no limit there, but you can set the limit in Parameters (because of security reasons) for adding new posts via frontend form

dax702 · Post by **dax702** » 13 May 2008, 10:17

Jan, thank you again. You are very helpful and kind. I just made a small donation for your efforts!!

Mike

Post by **Jan** » 13 May 2008, 10:22

Thank you. Jan