so i wrote a script to import a bunch of csv fields into the database. eveyrthing imports fine from a structure sense (meaning all my documents are in their appropriate locations and with their appropriate tv values. the problem is now my search function hangs when i search for the records i created (the search form calls the ditto snippet to return the search results). I get a 500 internal server error. The search works fine for other records (searching by pagetitle).
after comparing the database tables everything matches identically to records created through the manager. is their a reason that records created with an sql statement would cause a problem on ditto’s results? here’s the code that is created dynamically and writes to the db.
INSERT INTO
site_content
SET
site_content.template = '5',
site_content.parent = 1348,
site_content.pagetitle = 'Amara',
site_content.longtitle = 'Amara',
site_content.menutitle = 'Amara',
site_content.content = 'hello world ',
site_content.alias = 'Amara',
site_content.createdon = 1245712836,
site_content.editedon = 1245712836,
site_content.publishedon = 1245712836,
site_content.cacheable = 0,
site_content.createdby = 1,
site_content.editedby = 1,
site_content.published = 1,
site_content.publishedby = 1,
site_content.isfolder = 1,
site_content.privateweb = 0
is there something else that i should be including as i write to the database? any help would be appreciated.
